Why learn Microsoft Excel Formulas: Today, Ms Excel is becoming the tool of choice in companies (in the USA alone, more than 500,000 companies actively use Excel) to be able to perform analysis and present data in a Quick way. 90%+ of the work would not require complicated models. In addition, Excel is becoming more and more similar to tools such as Power BI, albeit with lower computing power. Learning (advanced level) Excel will help you learn the other tools quickly!

Work Smarter not Harder: With the advance of technology and information, jobs are becoming more and more challenging. In addition, data and analysis are becoming more and more accessible with time. The difference in productivity between a NOOB in Excel and an advanced User is more than 10X. Imagine completing a task in 1 h vs 10h!
Why this course:
Formulas are the bread and butter of everything you do in Excel. You need them to perform your analysis
Unlike many courses, this course teaches you how to use formulas in real life : You will see examples you can relate to in addition to a selection of the most important formulas you will require
This course teaches you how to understand formulas and not memorize them : This will enable you to use any formula in the future
Course is designed for all levels: Whether you want to learn from scratch or deepen your understand in Excel with new Office 365 formulas, you are at the right place!
4. Curriculum Practical Hands on Excel formulas & functions training:
Formula structure, shortcuts, cell referencing and formula auditing tools
Conditional operators such as IF, IFs, multiple ifs, and, Or
Statistical formulas such as Sumif, averageif, random numbers
Lookup such as Vlookup, Hlookup, Xlookup, Offset, Choose and named ranges
Text manipulation functions
Date and Time functions such as Today, Now and Networkdays
Formatting in Conditional formatting with a function
New Dynamic Array formulas for Excel 2021 and Office 365! That will revolutionize how Excel works
Many tricks such as transposing data, and building dynamic graphs and reports
5. What you will learn:
How to use the most common formulas in Excel in a practical way
How to save time while performing your data analysis
How to build dynamic reports
New Dynamic Array formulas
How to use formulas such as Sumproduct in unconventional ways
How to become a pro at lookups with tricks such as reversed lookup, advanced lookups combining the basic index and match concepts
How to Manipulate text like a pro which is key in data cleansing
How to play with dates to extract metrics such as Turnaround Time
How to automate repetitive tasks with no VBA (and multiple other tricks)
How to troubleshoot and fix your formulas
6. About me:
Harvard MBA
Extensive consulting experience with McKinsey and Co, having learned the ability to dissect problems and perform complex analysis in no time
11+ years as a Vice President in a bank heading analytical and strategy teams
Built the whole analytics department of a 3500+ employee share services subsidiary
Degree in Computational Sciences among others
Well versed in Data and Artificial intelligence, having built chatbots
Passion for teaching Excel as a backbone to increasing productivity
–
SKILLS YOU WILL GAIN
Ability to combine multiple formulas to perform detailed analysis very fast
Tools to be able to build interactive dashboard
Tools to build dynamic charts
WHAT YOU WILL LEARN
Basics about formulas to become more efficient (e.g., formula auditing, shortcuts)
Conditional formulas and logical operators (e.g., if, nested if, ifs)
Statistical formulas (e.g., sumifs, count, countifs, sumproduct with conditions, percentile, ranking)
Lookups (e.g., Vlookup, Hlookup, index, match, offset, choose)