Home Courses Advanced Excel
Office & Accounting Popular Course

Advanced Excel

Learn Excel formulas, charts, reports, data cleaning, Pivot Tables, and dashboards.

1.5 Months Duration
Intermediate Level
5 Modules
12 Lessons
AD

Course Overview

Advanced Excel is designed for students, accountants, office users, and data learners who want to build strong reporting and spreadsheet skills.

Skills & Tools Covered

✓ Excel Formulas ✓ Pivot Table ✓ Charts ✓ Data Cleaning ✓ Dashboard ✓ Reporting

What You Will Learn

✓ Students will be able to analyze data
✓ create reports
✓ use formulas
✓ and build simple dashboards in Excel.

Course Syllabus

Click each module to view lessons.

4 Modules
  • SUM, IF and COUNT functions
  • Lookup formulas
  • Date and text formulas
  • Remove duplicates
  • Format and prepare data
  • Pivot Table basics
  • Charts and slicers
  • Reporting layout
  • Dashboard planning
  • Build KPI cards
  • Charts and filters
  • Final dashboard review