4.78
(18 Ratings)

Microsoft Excel Course for Data & Business Analytics (Basic to Advanced)

Wishlist Share
Share Course
Page Link
Share On Social Media

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)

Show More

What Will You Learn?

  • 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)
01 - Introduction to Excel - Module A - Excel Basics (for Beginners)

02 – Relative & Absolute Cell References – 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
03 - Formatting Paste Special - Module B - Excel Essentials

04 – Excel Tables – Module B – Excel Essentials
04 - Excel Tables - Module B - Excel Essentials

05 – Data Filters and Sorting – Module B – Excel Essentials
05 - Data Filters and Sorting - Module B - Excel Essentials

06 – Data Validation Tips & Tricks – Module B – Excel Essentials
06 - Data Validation Tips & Tricks - Module B - Excel Essentials

07 – Named Ranges – Module B – Excel Essentials
07 - Named Ranges - Module B - Excel Essentials

08 – Worksheet and Workbook Protection – Module B – Excel Essentials
08 - Worksheet and Workbook Protection - Module B - Excel Essentials

09 – Printing and Page Layout Tab – Module B – Excel Essentials
09 - Printing and Page Layout Tab - Module B - Excel Essentials

10 – Handle Formula Errors – 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
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
12 - Using IF with AND OR Formulas - Module C - Excel Formulas and Functions

13 – COUNTIFS, SUMIFS, AVERAGEIFS 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
14 - Excel TEXT Functions - Module C - Excel Formulas and Functions

15.1 – VLOOKUP Function, INDEX, MATCH Function – 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.2 - Match Type +1 OR 1 in Match Function in Microsoft Excel

15.3 – Module C – 15 – INDEX and MATCH Function
15.3 - Module C - 15 - INDEX and MATCH Function

16 – XLOOKUP, XMATCH Function – Module C – Excel Formulas and Functions
16 - XLOOKUP, XMATCH Function - Module C - Excel Formulas and Functions

17 – Indirect 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
18 - Offset Function - Module C - Excel Formulas and Functions

19 – Formula Editing Tips & Tricks – 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
20 - Date and Time Functions - Module C - Excel Formulas and Functions

21 – Maths 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
22 - Dynamic Array Formulas - Module C - Excel Formulas and Functions

23 – Conditional Formatting – Module D – Data Analysis
23 - Conditional Formatting - Module D - Data Analysis

24.1 – WHAT IF Analysis – Module D – Data Analysis
24.1 - WHAT IF Analysis - Module D - Data Analysis

24.2 – Module D – 24 – WHAT IF Analysis – Data Table
24.2 - Module D - 24 - WHAT IF Analysis - Data Table

24.3 – Module D – 24 – WHAT IF Analysis – Scenario Manager
24.3 - Module D - 24 - WHAT IF Analysis - Scenario Manager

25 – Linear Regression – Module D – Data Analysis
25 - Linear Regression - Module D - Data Analysis

26 – Data Analysis Feature – Module D – Data Analysis
26 - Data Analysis Feature - Module D - Data Analysis

27 – Data Storytelling Tips – 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
28 Introduction to Charts 29 - Dynamic Advanced Charts - Module E - Excel Charts and Visualizations

30 – Pivot Table with Dashboard – Module F – Pivot Table
30 - Pivot Table with Dashboard - Module F - Pivot Table

31 – Advanced Pivot Table Tips & Tricks – 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
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
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
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
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
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
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
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
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
40 - SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel

41 – Wildcard Search in Excel – Module I
41 - Wildcard Search in Excel - Module I

$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI
$4,200 in 15 Months | How to Sell your Skills & Make Money? | Passive Income | Excel / POWER BI

Student Ratings & Reviews

4.8
Total 18 Ratings
5
15 Ratings
4
2 Ratings
3
1 Rating
2
0 Rating
1
0 Rating
Imtiaz Ahmed
3 weeks ago
very very informative
JD
2 months ago
Instructor chronologically explained everything regarding MS excel. Highly recommended
KH
2 months ago
Excellent
HK
2 months ago
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.
Shehroze Khan
2 months ago
Amazing and very informative course...
Muhammad Dilshad
2 months ago
Great learning program for beginners to advance I like this
SS
3 months ago
This course is amazing and full of knowledge
JB
3 months ago
Super
UA
3 months ago
I\'m an intermediate excel user but still there was a lot of new tips and tricks for me in this course. Recommended
ZA
3 months ago
Jazakallah, I have learned alot from you sir.
AV
3 months ago
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.
EA
3 months ago
very very interesting and educative.
RV
3 months ago
Very Informative!
RM
3 months ago
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.
Aarish Yamin
3 months ago
Very much informative and very advanced Excel skills development course.
OA
3 months ago
Yeah! I Learned a lot from this course thank you so much