About Course
Are you ready to take your Excel skills to the next level?
Are you finding that employers these days want ‘Advanced Excel Skills’?
Or maybe you’ve started a new job that requires more advanced Excel skills.
Are you tired spending hours online trying to get “RIGHT” help?
When asked to make a dashboard or report, not sure where to start?
Join this course from Basic to Advanced Level!
Module L – 15 Excel Functions Refresher, Module K – 24 Excel Tips in 24 Minutes, Module J – Exclusive Templates, Module I – Bonus 2 – Advanced Excel – More Scenario Examples, Module H – Bonus 1 – Dashboard Reporting in Excel with Tips, Module G – Modern Excel – DAX and Power Query, Module F – Pivot Table, Module E – Excel Charts and Visualizations, Module D – Data Analysis, Module C – Excel Formulas and Functions, Module B – Excel Essentials, Module A – Excel Basics (for Beginners)
Course Content
01 – Introduction to Excel – Module A – Excel Basics (for Beginners)
02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)
03 – Formatting Paste Special – Module B – Excel Essentials
04 – Excel Tables – Module B – Excel Essentials
05 – Data Filters and Sorting – Module B – Excel Essentials
06 – Data Validation Tips & Tricks – Module B – Excel Essentials
07 – Named Ranges – Module B – Excel Essentials
08 – Worksheet and Workbook Protection – Module B – Excel Essentials
09 – Printing and Page Layout Tab – Module B – Excel Essentials
10 – Handle Formula Errors – Module B – Excel Essentials
11 – Using IF Formula, Nesting IF Formulas – Module C – Excel Formulas and Functions
12 – Using IF with AND OR Formulas – Module C – Excel Formulas and Functions
13 – COUNTIFS, SUMIFS, AVERAGEIFS Formulas – Module C – Excel Formulas and Functions
14 – Excel TEXT Functions – Module C – Excel Formulas and Functions
15.1 – VLOOKUP Function, INDEX, MATCH Function – Module C – Excel Formulas and Functions
15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel
15.3 – Module C – 15 – INDEX and MATCH Function
16 – XLOOKUP, XMATCH Function – Module C – Excel Formulas and Functions
17 – Indirect Function – Module C – Excel Formulas and Functions
18 – Offset Function – Module C – Excel Formulas and Functions
19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions
20 – Date and Time Functions – Module C – Excel Formulas and Functions
21 – Maths Functions – Module C – Excel Formulas and Functions
22 – Dynamic Array Formulas – Module C – Excel Formulas and Functions
23 – Conditional Formatting – Module D – Data Analysis
24.1 – WHAT IF Analysis – Module D – Data Analysis
24.2 – Module D – 24 – WHAT IF Analysis – Data Table
24.3 – Module D – 24 – WHAT IF Analysis – Scenario Manager
25 – Linear Regression – Module D – Data Analysis
26 – Data Analysis Feature – Module D – Data Analysis
27 – Data Storytelling Tips – Module D – Data Analysis
28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations
30 – Pivot Table with Dashboard – Module F – Pivot Table
31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table
32 – Top 10 Power Query Tips – Module G – Modern Excel – DAX and Power Query
33 – Introduction to Power Pivot – Module G – Modern Excel – DAX and Power Query
34 – Apply DAX in Power Pivot for Analysis – Module G – Modern Excel – DAX and Power Query
35 – Dashboard Reporting in Excel with Tips – Module H – Bonus 1 – Dashboard Reporting in Excel
36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I
37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I
38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY
39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I
40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel
41 – Wildcard Search in Excel – Module I
$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI
Student Ratings & Reviews
very very informative
Instructor chronologically explained everything regarding MS excel. Highly recommended
Excellent
It was a good match, but there was a complete class that only Indian was spoken, and I was not able to learn much; I was only able to follow through the screen.
Amazing and very informative course...
Great learning program for beginners to advance I like this
This course is amazing and full of knowledge
Super
I'm an intermediate excel user but still there was a lot of new tips and tricks for me in this course.
Recommended
Recommended
Jazakallah, I have learned alot from you sir.
excellent
Insightful course
This course is Brilliant and helped me to learn the Excel from basic to advance. This course help me to enhance the analytical skills, and advance functions of the Excel.
very very interesting and educative.
Very Informative!
Very interesting topics, i have really learnt a lot from this course.
Thank you for this education. I would recommend this course to my friends and colleagues.
Thank you for this education. I would recommend this course to my friends and colleagues.
Very much informative and very advanced Excel skills development course.
Yeah!
I Learned a lot from this course
thank you so much
I Learned a lot from this course
thank you so much
