
Explore 36 essential Excel formulas, features, and functions across 20 categories, with a complexity scale and interactive hyperlinks to a bank client data example.
Just a quick heads up, Udemy usually ask for your feedback after roughly the fourth video of any course, you can't imagine how important your feedback is, it will help me improve my courses, will help me rank higher on Udemy and reach more people.
Rest assured, I review and check every one of the feedbacks and ratings I receive to ensure the students satisfaction!!
Stay Productive & Happy Learning!!
Master the if function in Excel, its syntax with the equals sign, and how to nest if statements to return specific values based on logical tests.
Explore count, counta, countif, and countifs, and learn how each handles numbers, text, blanks, and spaces; apply multiple criteria to count values that meet conditions.
Explore how lookup formulas locate values in vertical and horizontal arrays using vlookup and hlookup, with exact-match settings. Discover how index and match can overcome its limitations.
Learn how the match formula finds exact matches in Excel, its limitations requiring a single row or column, and how to combine with index for robust lookups.
Master the Excel filter feature by applying filters to headers, sorting from a to z or by color, and selecting visible rows in a table to focus on key data.
Complete excel project on a movie list, using drop-downs and index and match to retrieve data, copy titles with proper entry, apply conditional formatting, and sort by rating with filter.
Hello there,
Since you are reading this, I have to assume that you already know the importance of Excel and therefore, you are looking for a course that will help you learn Excel and who wants a boring slow teaching method to learn anything!! This course will teach you the most important functions, formulas and features in Excel, it is a great course that will teach Excel step by step in the right way.
This course is created to help you to cut to the point fast and learn what matters the most in Excel as a beginner. It covers 35 most important features, formulas and functions in Excel such as Index, Match, Data Validation, Conditional Formatting, Substitute, Trim, Proper, If, Nestedif, Or, And, Sumif(s), Countif(s), Find, Search, Transpose, and many others.
Those Excel features, formulas and functions are taught in this course using the same Example to help with the consistency, but of course, you will apply them in almost any worksheet you will develop.
The course is mostly none linear, meaning that you can jump right into the topic that interests you directly. However, I strongly recommend to go through the course from beginning to end as you might miss an important information discussed in one of the lectures.
Bottom line is, if you want to learn Excel and looking for a quick start, this is the right course for you!!
This course requires you to have Excel 2016 or more and the well to learn.
Don’t forget to download the material and to practice using the material available in the resources.
I also prepared a quick manual to help you know the main definitions of all the formulas, features & functions taught in the course which is also available in the resources.
See you inside!!
Stay Productive & Happy Learning!!