
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!!
learn how the Excel proper function capitalizes the first letter of each name, preserving existing capitals, and how to copy results and paste them as values.
Use the trim formula to remove leading spaces and the proper function to fix capitalization, copy as values, and generalize this approach to large row datasets.
Learn how to use basic Excel formulas, including count, sum, average, minimum, and maximum, to analyze highlighted cells and gain quick data insights.
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.
Master sumif and sumifs to sum values meeting a condition, using a range and optional criteria range, with examples like less than one million and savings.
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.
Learn how to combine index and match to create a dynamic lookup that returns a value at the intersection of a matched name and a selected criterion.
Master the substitute formula to replace text in Excel, such as turning dashes into backslashes. Use instance_num to pick dash to replace, or leave it empty to replace all.
Explore left, right, and mid formulas in Excel to extract specific characters from text, using start positions and the number of characters to return.
Explore how Excel's find and search formulas locate a character's position in text, contrasting case sensitive find with case insensitive search, and using start_num to control where the search begins.
Copy the table, paste it, and use the paste options to transpose, switching headers from rows to columns for quick reformatting.
Master conditional formatting in Excel by highlighting current values in green and savings in yellow, using data bars and color scales to visualize data.
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!!