CCI-Computer Educational Institute

A Diploma in Advanced Excel is a short-term, skill-based course designed to teach learners how to use Microsoft Excel at a professional and advanced level.

✓

It's widely pursued by people in fields like accounting, finance, business analysis, data management, HR, and administration.

✓

Advanced Functions & Formulas: VLOOKUP, HLOOKUP, INDEX & MATCH IF, AND, OR, IFERROR, nested formulas Data Analysis Tools: PivotTables and PivotCharts Conditional Formatting Data Validation What-If Analysis (Goal Seek, Scenario Manager) Charts & Dashboards: Creating interactive and dynamic dashboards Using form controls (sliders, checkboxes).

✓

Macros & VBA (Visual Basic for Applications): Automating tasks with simple VBA scripts Power Query & Power Pivot (in more advanced diplomas) Data Cleaning & Reporting.

Java Full Stack Development workspace with computer screens showing code

Course Content

1. Introduction to MS EXCEL

2. Formating Worksheet with Formular

3. Conditional Formating

4. Programming Loops & arrys

5. Date Storing and Filtering

6. Pivot tables & Chats

7. VBA Programming variables

8. Conditional Logic

9. Excel VBA Error Handling & All Excel Programing

Diploma in Advance Excel

Course Content