- 18 Sections
- 82 Lessons
- 12 Hours
Expand all sectionsCollapse all sections
- Section 1 - The Basics11
- 1.1MS. Office Setup and Installation Guide1 Minute
- 1.2Excel – The Basics15 Minutes
- 1.3Excel – Create and Close Files4 Minutes
- 1.4Excel – Tabs and Group8 Minutes
- 1.5Excel – Editing Data15 Minutes
- 1.6Excel – Formatting18 Minutes
- 1.7Excel – Characteristics of Cell2 Minutes
- 1.8Excel – Cell Referencing12 Minutes
- 1.9Excel – Speak Cells10 Minutes
- 1.10Excel – Text to Column7 Minutes
- 1.11Excel – Commnets6 Minutes
- Section 2 - Filling4
- Section 3 - Worksheets6
- Section 4 - Logical Functions6
- Section 5 - Functions and Formulas9
- 5.1Excel – Text Functions16 Minutes
- 5.2Excel – Date Functions Pt. I11 Minutes
- 5.3Excel – Date Functions Pt. II10 Minutes
- 5.4Excel – Date Functions Pt. III7 Minutes
- 5.5Excel – Name Range7 Minutes
- 5.6Excel – Name Range with Formulas10 Minutes
- 5.7Excel – Basic Formulas8 Minutes
- 5.8Excel – Count Functions7 Minutes
- 5.9Excel – Statistical Functions12 Minutes
- Section 6 - Lookup8
- Section 7 - Protection4
- Section 8 - Hyperlink3
- Section 9 - Page Setup2
- Section 10 - Sort and Filters3
- Section 11 - Tables and Subtotal3
- Section 12 - Charts7
- Section 13 - Pivot Tables6
- Section 14 - Consolidate2
- Section 15 - Conditional Formatting3
- Section 16 - Data Validation2
- Section 17 - Inserting2
- Section 18 - Shortcuts1