-
Level 1 0/5
-
Excel Basics 16 minLecture1.1
-
Excel as a Calculator 07 minLecture1.2
-
Error 13 minLecture1.3
-
Sort and Filter 10 minLecture1.4
-
Charts 17 minLecture1.5
-
Formatting 06 minLecture1.6
-
-
Level 2 0/12
-
Aggregate 16 minLecture2.1
-
Function Wizard 18 minLecture2.2
-
Cell Referencing 11 minLecture2.3
-
Logical Functions 13 minLecture2.4
-
Lookup Functions 13 minLecture2.5
-
Index Match Function 24 minLecture2.6
-
Date Time text functions 38 minLecture2.7
-
Nested Functions 18 minLecture2.8
-
Annotating Formulae 07 minLecture2.9
-
Conditional Formatting 10 minLecture2.10
-
Custom Number Formatting 09 minLecture2.11
-
Hyperlink 10 minLecture2.12
-
-
Level 3 0/15
-
Auto Filter 07 minLecture3.1
-
Subtotal 04 minLecture3.2
-
Data Consolidation 08 minLecture3.3
-
Data Validation 11 minLecture3.4
-
Age Calculator 10 minLecture3.5
-
Nested IF 11 minLecture3.6
-
Pivot Tables and Charts 14 minLecture3.7
-
Goal Seek 08 minLecture3.8
-
What If – Scenario Manager 12 minLecture3.9
-
Password Protection 09 minLecture3.10
-
Import Export Data 13 minLecture3.11
-
Amortization of Loan 11 minLecture3.12
-
Sparkline, Trendline, Candlestick Charts 26 minLecture3.13
-
Macros 20 minLecture3.14
-
VBA 25 minLecture3.15
-
SUMIF COUNTIF Functions 31 minLecture3.16
-
This content is protected, please login and enroll course to view this content!
Prev
Goal Seek
Next
Password Protection