Excel Expert Certification Book for Excel Expert

Chapter 1: Manage Workbook options and settings

1.1: Manage Workbooks (9 videos)
1.2: Manage workbook review (9 videos)

Total Sections: 2
|
Total Videos: 18

View more
Practice Test

Chapter 2: Apply custom data formats and layouts

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)

Total Sections: 4
|
Total Videos: 17

View more
Practice Test

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)

. . .

Total Sections: 6
|
Total Videos: 30

View more
Practice Test

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)

Total Sections: 3
|
Total Videos: 8

View more
Practice Test

© Sabaq Foundation. All rights reserved.
Free now and forever thru Sabaq.pk website.
Not allowed to copy videos without a written permission from Sabaq Foundation
Schools can link to our website free of cost at subject & grade level. Video level linking not allowed.

Home | Sitemap