Description

Master Excel like a pro and turn data into powerful decisions.
This 6-week advanced course is designed for professionals who already know the basics of Excel and want to unlock its full potential. From advanced formulas to pivot tables and dashboards, you’ll gain the skills to analyze data, automate workflows, and build impressive reports.

Course Duration: 6 Weeks
Skill Level: Intermediate to Advanced
Prerequisites: Basic knowledge of Excel (formulas, formatting, functions)

Syllabus Overview

Week 1: Advanced Formulas & Functions

• Nested formulas

• Lookup functions: VLOOKUP, HLOOKUP, INDEX + MATCH

• Conditional logic: IF, IFS, SUMIFS, COUNTIFS

• Error handling: IFERROR, ISERROR, IFNA

Week 2: Data Cleaning & Preparation

• Removing duplicates, blank cells, and outliers

• Text functions: LEFT, RIGHT, MID, TRIM, CONCAT, TEXTJOIN

• Working with dates and times

• Flash fill and advanced paste special

Week 3: Data Analysis with Pivot Tables

• Creating and customizing Pivot Tables

• Grouping data, calculated fields, and filters

• Slicers and timelines

• Pivot Charts and dynamic reports

Week 4: Data Visualization

• Advanced charting (Combo Charts, Waterfall, Sparklines)

• Conditional formatting tricks

• Interactive dashboards with form controls

• Using Excel’s “Ideas” tool for quick insights

Week 5: Automation with Excel

• Introduction to Macros

• Recording and editing simple VBA scripts

• Automating repetitive tasks

• Intro to Power Query (data import & transformation)

Week 6: Final Project & Presentation

• Analyze a full dataset

• Build an interactive dashboard

• Present insights and findings

• Capstone review and certificate issue

Assessment & Certification

• Weekly Excel challenges

• Final project: Dashboard and analysis

• Certificate of Completion after successful evaluation