Microsoft Excel 2024 – Beginner to Advanced in 3 hours

Learn everything about Microsoft Excel, from the basics to the super advanced stuff, in this online course. After taking this class, you’ll become an Excel expert!

Here’s how it works:
We explain Excel in a simple way so it’s easy to understand.
We go through all the tools and features in Excel, paying close attention to details.
We follow a step-by-step approach. So that it’s easier for you to grasp all the concepts.
This course is made for everyone, no matter how much you already know or how little you know.
We practice with real-life examples to make learning fun and useful.

What you’ll learn in this course:
Basic Number Functions
How to calculate percentages
Sorting Data – Single Level, Multi Level, Custom List, Own List, Icons (Colors Coding), How to Unsort Data
Filter – Basic Filter and Advanced Filter (including Regex’s and IF/OR Conditions)
Data Validation – How to create a list, how to create text and date validations, and create a Dynamic List with Excel Tables.
Cell Reference – Relative, Absolute, and Mixed Referencing
IF Functions – SUMIF(S), COUNTIF(S), IF, Nesting IF with AND / OR Function
Lookup Functions – VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP
Text Functions – Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, Text
Flashfill – How to use FlashFill correctly
Custom Number Formatting – How to Format Numbers with your own custom icons and present data efficiently
Pivot Tables – Basics of Pivot Tables including Conditional Formatting
Pivot Tables – Slicers – Intro to creating Dashboards with Pivot Tables and Slicers
SUMIF(S) & COUNTIF(S) – Using custom conditions/criteria. Eg. Regex Match
Lookup – Extract data based on Regex Match, otherwise known as Wildcard Lookup.
Index & Match with Multiple Headers – Use Index & Match when you have more than 1 header in your dataset
Array Formulas – Learn to use formulas like – UNIQUE, FILTER, and SORT

Embark on a journey into the world of Excel with our genuine passion for sharing knowledge. In this Udemy course, we cover everything from basics to advanced topics, offering hands-on practice with spreadsheets. We guarantee to turn you into an advanced Excel user. Suitable for people with all skill levels, we focus on practical learning, emphasizing the importance of practice, a readiness to learn new methods, and the application of skills to real-world scenarios. Take this course to get a head start on your path to becoming an Excel pro!