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