10 - Handle Formula Errors - Module B - Excel Essentials

01 – Introduction to Excel – Module A – Excel Basics (for Beginners)

0/1

01 – Introduction to Excel – Module A – Excel Basics (for Beginners)

15:40

02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)

0/1

02 – Relative & Absolute Cell References – Module A – Excel Basics (for Beginners)

11:43

03 – Formatting Paste Special – Module B – Excel Essentials

0/1

03 – Formatting Paste Special – Module B – Excel Essentials

04:15

04 – Excel Tables – Module B – Excel Essentials

0/1

04 – Excel Tables – Module B – Excel Essentials

06:48

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

0/1

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

08:27

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

0/1

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

11:55

07 – Named Ranges – Module B – Excel Essentials

0/1

07 – Named Ranges – Module B – Excel Essentials

13:08

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

0/1

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

05:32

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

0/1

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

06:25

10 – Handle Formula Errors – Module B – Excel Essentials

0/1

10 – Handle Formula Errors – Module B – Excel Essentials

05:39

11 – Using IF Formula, Nesting IF Formulas – Module C – Excel Formulas and Functions

0/1

11 – Using IF Formula, Nesting IF Formulas – Module C – Excel Formulas and Functions

05:54

12 – Using IF with AND OR Formulas – Module C – Excel Formulas and Functions

0/1

12 – Using IF with AND OR Formulas – Module C – Excel Formulas and Functions

05:18

13 – COUNTIFS, SUMIFS, AVERAGEIFS Formulas – Module C – Excel Formulas and Functions

0/1

13 – COUNTIFS, SUMIFS, AVERAGEIFS Formulas – Module C – Excel Formulas and Functions

05:11

14 – Excel TEXT Functions – Module C – Excel Formulas and Functions

0/1

14 – Excel TEXT Functions – Module C – Excel Formulas and Functions

07:15

15.1 – VLOOKUP Function, INDEX, MATCH Function – Module C – Excel Formulas and Functions

0/1

15 – VLOOKUP Function, INDEX, MATCH Function – Module C – Excel Formulas and Functions

14:53

15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel

0/1

15.2 – Match Type +1 OR 1 in Match Function in Microsoft Excel

13:26

15.3 – Module C – 15 – INDEX and MATCH Function

0/1

15.3 – Module C – 15 – INDEX and MATCH Function

01:08:00

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

0/1

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

14:10

17 – Indirect Function – Module C – Excel Formulas and Functions

0/1

17 – Indirect Function – Module C – Excel Formulas and Functions

17:50

18 – Offset Function – Module C – Excel Formulas and Functions

0/1

18 – Offset Function – Module C – Excel Formulas and Functions

22:01

19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions

0/1

19 – Formula Editing Tips & Tricks – Module C – Excel Formulas and Functions

18:48

20 – Date and Time Functions – Module C – Excel Formulas and Functions

0/1

20 – Date and Time Functions – Module C – Excel Formulas and Functions

28:56

21 – Maths Functions – Module C – Excel Formulas and Functions

0/1

21 – Maths Functions – Module C – Excel Formulas and Functions

02:25

22 – Dynamic Array Formulas – Module C – Excel Formulas and Functions

0/1

22 – Dynamic Array Formulas – Module C – Excel Formulas and Functions

01:10:04

23 – Conditional Formatting – Module D – Data Analysis

0/1

23 – Conditional Formatting – Module D – Data Analysis

30:35

24.1 – WHAT IF Analysis – Module D – Data Analysis

0/1

24.1 – WHAT IF Analysis – Module D – Data Analysis

10:08

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

0/1

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

08:07

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

0/1

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

12:16

25 – Linear Regression – Module D – Data Analysis

0/1

25 – Linear Regression – Module D – Data Analysis

27:04

26 – Data Analysis Feature – Module D – Data Analysis

0/1

26 – Data Analysis Feature – Module D – Data Analysis

02:52

27 – Data Storytelling Tips – Module D – Data Analysis

0/1

27 – Data Storytelling Tips – Module D – Data Analysis

26:37

28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations

0/1

28 Introduction to Charts 29 – Dynamic Advanced Charts – Module E – Excel Charts and Visualizations

01:37:00

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

0/1

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

26:09

31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table

0/1

31 – Advanced Pivot Table Tips & Tricks – Module F – Pivot Table

47:45

32 – Top 10 Power Query Tips – Module G – Modern Excel – DAX and Power Query

0/9

32 – Top 10 Power Query Tips – Module G – Modern Excel – DAX and Power Query

15:46

32.1 – How to Split Names and Emails from a List in Microsoft Excel | FORMULA | FLASH FILL | POWER QUERY

10:13

32.2 – Extract Dates from Sentences Located anywhere in a Cell in Excel | Excel Formula OR Power Query?

12:28

32.3 – How to convert Stack Data into Unstack different approaches | Unstack Uneven Data Excel Power Query

26:45

32.4 – Transform Data into Tabular Format – FORMULA or POWER QUERY? You Decide – HR Example

16:42

32.5 – An Introduction on 6 types of Joins in Power Query

12:47

32.6 – Left Outer Join & Right Outer Join in POWER QUERY

09:07

32.7 – Full Outer Join & Inner Join in POWER QUERY

04:47

32.8 – Left Anti Join & Right Anti Join in POWER QUERY

02:47

33 – Introduction to Power Pivot – Module G – Modern Excel – DAX and Power Query

0/1

33 – Introduction to Power Pivot – Module G – Modern Excel – DAX and Power Query

38:03

34 – Apply DAX in Power Pivot for Analysis – Module G – Modern Excel – DAX and Power Query

0/1

34 – Apply DAX in Power Pivot for Analysis – Module G – Modern Excel – DAX and Power Query

50:34

35 – Dashboard Reporting in Excel with Tips – Module H – Bonus 1 – Dashboard Reporting in Excel

0/1

35 – Dashboard Reporting in Excel with Tips – Module H – Bonus 1 – Dashboard Reporting in Excel

37:36

36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I

0/1

36 – Ageing Analysis Report in Microsoft Excel (VLOOKUP & Pivot Table) – MODULE I

08:57

37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I

0/1

37 – Excel Dashboards in Under 15 Minutes! Awesome Secret Tips & Tricks | Module I

17:30

38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY

0/1

38 – How to Split Names and Emails from a List in Microsoft Excel FORMULA FLASH FILL POWER QUERY

10:13

39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I

0/1

39 – NESTED IF, VLOOKUP, XLOOKUP, INDEX+MATCH Risk Rating Criteria in Excel | Module I

11:21

40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel

0/1

40 – SUMIFS Function Multiple Criteria Dates Between with Excluding WEEKENDS & HOLIDAYS in Excel

07:40

41 – Wildcard Search in Excel – Module I

0/1

41 – Wildcard Search in Excel – Module I

08:49

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

0/1

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

10:17

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

Please complete previous Lesson first

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

Back to Lesson

0% Complete