- Description
- Curriculum
- Reviews
Module 0: Course Introduction
Module 1: Starting Excel
Module 2: What You Can Enter
Module 3: Sheets, Rows and Columns
Module 4: Functions, Ranges and Shortcuts
Module 5: Formatting and Conditional Formatting
Module 6: Printing
Module 7: Managing Data
Module 8: Managing Text and Working with Formulas and Functions
-
42
8.1 Relative and Absolute Referencing -
43
8.2 VLOOKUP
-
44
8.3 Index Match
-
45
8.4 IF Statement
-
46
8.5 Nested IF Statements
-
47
8.6 COUNTIF and COUNTIFS
-
48
8.7 SUMIF and SUMIFS
-
49
8.8 LEN Function
-
50
8.9 RIGHT, LEFT and MID Functions
-
51
8.10 SEARCH Function
-
52
8.11 Common Error Types
-
53
8.12 IFERROR Function
Module 9: Charts
Module 10: Pivot tables, Power Query and Dashboards
-
59
10.1 Power Query Intro
-
60
10.2 Power Query Consolidation
-
61
10.3 Pivot Tables
-
62
10.4 Setting up a Pivot Table
-
63
10.5 Pivot Table Field Settings
-
64
10.6 Pivot Table Calculated Fields
-
65
10.7 Pivot Table Groupings
-
66
10.8 Pivot Table Slicers and Timelines
-
67
10.9.1 Dashboards Part 1
-
68
10.9.2 Dashboards Part 2
Module 11: Macros
Module 12: Intro to VBE and VBA
-
72
12.1 Introduction to VBE
-
73
12.2 Object Model
-
74
12.3 Modules, Worksheets and Classes
-
75
12.4 Variables and Constants
-
76
12.5 VBA Formatting
-
77
12.6a If Statement
-
78
12.6b Select Case
-
79
12.7a For Loop
-
80
12.7b DoWhile DoUntil Loop
-
81
12.7c ForEach Loop
-
82
12.8a Errors
-
83
12.8b Error Handling
-
84
12.9 Consolidation and Conclusion
Module 13: Course Conclusion
Please, login to leave a review
