Excel Expert Certification Book for Excel Expert
Table of Content for: Sabaq Skills Board > Excel Expert > Excel Expert Certification (Total Videos: 43 )
Chapter 1: Manage Workbook options and settings
- 1.1: Manage Workbooks (6 videos)
- 1.2: Manage workbook review (5 videos)
Total Sections: 2 | Total Videos: 11
Chapter 2: Apply custom data formats and layou
- 2.1: Apply custom data formats and validation (4 videos)
- 2.2: Apply advanced conditional formatting a (3 videos)
- 2.3: Create and modify custom workbook eleme (2 videos)
- 2.4: Prepare a workbook for internationaliza (1 videos)
Total Sections: 4 | Total Videos: 10
Chapter 3: Create advanced formulas
- 3.1: Apply functions in formulas (4 videos)
- 3.2: Lookup data using functions (3 videos)
- 3.3: Apply advanced date and time functions (3 videos)
- 3.4: Perform data analysis and business inte (8 videos)
- 3.5: Troubleshoot formulas (1 videos) . . .
Total Sections: 6 | Total Videos: 20
Chapter 4: Create advanced charts and tables
- 4.1: Create and manage PivotTables (2 videos)
Total Sections: 1 | Total Videos: 2
