Level 1 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 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 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