Advanced Excel Certification in Saudi Arabia

• Sl. No.
• Chapter

• Chapter - 1
• Introduction of Excel

• Chapter - 2
• Working with Workbook and Worksheets

• Chapter - 3
• Introducing Excel Tables Formulas and References

• Chapter - 4
• Formatting Data

• Chapter - 5
• Inserting Objects in Worksheets

• Chapter - 6
• Managing Data in Excel

• Chapter - 7
• Excel Formulas and Functions

• Chapter - 8
• References and LOOKUPs

• Chapter - 9
• Excel Tables

• Chapter - 10
• Working with Charts

• Chapter - 11
• Working with Pivot Table

• Chapter - 12
• What If Analysis - Goal Seek and Scenario Manager

• Chapter - 13
• Data Analysis and Validation

• Chapter - 14
• Macros

• Chapter - 15
• Printing Excel Workbooks

• Chapter - 16
• Managing Excel Files

• Chapter - 17
• Visual Basic for Application

• Chapter - 18
• Case Study 1 - Editing an Excel Macro in VBA

• Chapter - 19
• Case Study 2 – Creating User Forms in VBA

• Chapter - 20
• Case Study 3 – Custom Excel Functions

• Chapter - 21
• Case Study 4 – Conditional Logic in VBA

• Chapter - 22
• Case Study 5 – Create Dynamic Dashboard