📘 Microsoft Excel Training – Moderate to Advanced (7-Day Program)

Whether you are a professional, student, or business owner, mastering Excel can save hours of work, enhance decision-making, and unlock career opportunities. This 7-day (90 minutes/day) training is designed to take you from moderate to advanced Excel user with hands-on exercises and a final real-world project.

✅ Learning Outcomes

By the end of this course, you will be able to:

  • Confidently use formulas, references, and functions
  • Import, clean, and transform raw data
  • Build professional reports and dashboards with charts & PivotTables
  • Apply advanced Excel tools like Power Query, Goal Seek, Macros
  • Automate repetitive tasks and improve productivity
💡 Why Join This Program?
  • Practical, hands-on learning (no boring theory)
  • Step-by-step structured approach from moderate → advanced
  • Real-world business datasets used for practice
  • Led by an experienced instructor with industry insights
  • Lifetime Excel skills that directly improve your career & productivity

📅 Course Schedule (7 Days × 90 Minutes)

🔹 Moderate Level (Days 1 – 4)

Day 1 – Workbook & Data Basics
  • Navigating and formatting workbooks
  • Managing worksheets and ranges
  • Formatting cells (alignment, number formats, styles)
  • Hands-on practice
  • Cell references (relative, absolute, mixed)
  • Functions: SUM, AVERAGE, MIN, MAX, COUNT
  • Conditional logic (IF, nested IF)
  • Lookup functions (VLOOKUP, INDEX-MATCH)
  • Hands-on exercises
  • Text functions (RIGHT, LEFT, MID, CONCAT, TEXTJOIN, etc.)
  • Creating & formatting tables
  • Sorting, filtering, and conditional formatting
  • Using Sparklines for quick visuals
  • Importing data from text/online sources
  • Advanced sorting and unique values
  • Creating & modifying charts (layouts, styles, accessibility)
  • Mini project: Build a sales trend chart

🔹 Advanced Level (Days 5 – 7)

Day 5 – Data Validation & Power Query
  • Flash Fill & removing duplicates
  • Custom number formats
  • Data validation with rules and dropdowns
  • Subtotals, grouping/ungrouping data
  • Introduction to Power Query for data cleaning & transformation
  • Advanced conditional formatting
  • Date & time functions (NOW, TODAY, EOMONTH)
  • What-if analysis (Goal Seek, Consolidate)
  • Formula troubleshooting (trace dependents, error checking)
  • Introduction to Macros (recording, editing, naming)
  • Creating and customizing PivotTables
  • Grouping, slicers, calculated fields
  • Creating and styling PivotCharts
  • Final Project: Build an interactive dashboard combining PivotTables & Charts

Fill the Form below to Join Online Excel Classes.