The goal isn't to teach you how to memorize formulas syntax but to actually think like Excel. We'll start with a quick
|Course Start Date||:||3/10/2023|
|Course End Date||:||4/10/2024|
welcome to Microsoft Excel advanced Excel formulas and functions.
For those of you who don't know me I'm a Microsoft certified expert and a best selling Excel instructor.
In 2014 I founded Excel maven to bring high quality Applied Analytics training to clients around the world.
And I now teach students in over 150 countries in this course.
I'll introduce you to seventy five excels most powerful functions using hands on demos and plain English
crystal clear explanations.
The goal isn't to teach you how to memorize formulas syntax but to actually think like Excel.
We'll start with a quick review of the fundamentals.
Then dive into each formula category and turn from basic stats functions conditional statements to more
advanced topics like named ranges array formulas and even real time data tools like web service and
filter X and now you'll learn how to create custom interactive dashboards blend data together with look
up index and match functions and work with text.
Times dates and arrays.
Listen it's time to start working smarter not harder.
If you're ready to take your analytic skills to the next level and truly unlock the power of Excel formulas
This course is for you.
Thanks for watching.
Hope to see you there.
|1||03 Conditional Statements and Logical Operators|
|2||04 Common Excel Statistical Functions|
|3||05 Lookup and Reference Functions|
|4||06 Text Functions|
|5||07 Date and Time Functions|
|6||08 Formula-Based Formatting|
|7||09 Array Formulas|
|8||10 Extra Bonus Functions|