22-Day Advanced Excel Syllabus

Fast-track your Excel skills from beginner to advanced level in just 22 days.
Join Live Class
Free Demo Class

Who is this course for?

  • Students who want detailed Excel training with enough time to practice and revise concepts
  • Job seekers preparing for accounting, office, MIS, data entry, or analyst roles
  • Working professionals who prefer step-by-step learning instead of a fast-track pace
  • Excel users with basic knowledge who want to move to an advanced level confidently
  • Learners who need extra practice sessions and concept reinforcement
  • Small business owners & accountants who use Excel for reports, records, and analysis

 

What you will achieve in 22 days

  • Master Excel from beginner to expert level.
  • Gain real-world Excel skills applicable in business & personal projects.
  • Learn professional data analysis, automation & dashboard creation.
  • Boost career opportunities by mastering essential Excel tools.

Course Outline – Advanced Excel (22 Days)

 
Excel Fundamentals – Laying the Groundwork

📌 Day 1: Getting Started with Microsoft Excel (📺 Recorded – 1 Hour)

  • Introduction to Excel & its powerful interface.
  • Exploring key features & tools for efficiency.
  • Customizing the Ribbon & Quick Access Toolbar.
  • Understanding Workbooks, Worksheets & Cell Navigation.

📌 Day 2: Auto Fill, Formatting & Invoice Designing (🎥 Live – 1 Hour)

  • Automate data entry with Auto Fill.
  • Professional Text & Number Formatting.
  • Create an Invoice Template step-by-step.
  • Enhance tables for better readability.

📌 Day 3: Cell References & Ledger Accounts (🎥 Live – 1 Hour)

  • Master Absolute, Relative & Mixed Cell References.
  • Using references effectively in formulas.
  • Create Ledger Accounts with Excel Tables.

📌 Day 4: Hands-On Classwork Session (🎥 Live – 1 Hour)

  • Practice all concepts from Days 1 – 3 with guided exercises.
 
Smart Data Handling & Visualization

📌 Day 5: Home Tab, Paste Special & Conditional Formatting (🎥 Live – 1 Hour)

  • Deep dive into Home Tab functions.
  • Paste Special for advanced copy-paste tricks.
  • Conditional Formatting to highlight key data.

📌 Day 6: Classwork & Practical Examples (🎥 Live – 1 Hour)

  • Apply Conditional Formatting & Paste Special in real-world examples.

📌 Day 7: Data Summarization Functions (🎥 Live – 1 Hour)

  • Master key functions: SUM, AVERAGE, COUNT, MIN, MAX, SUBTOTAL, AGGREGATE.
  • Use SUMIF, COUNTIF, AVERAGEIF for advanced summarization.

📌 Day 8: Hands-On Summarization Exercises (🎥 Live – 1 Hour)

  • Solve real-world data analysis problems using summarization functions.

📌 Day 9: Preparing for Printing (📺 Recorded – 1 Hour)

  • Optimize print settings for reports.
  • Set up headers, footers & page numbers.
  • Configure print areas for large datasets.
 
Advanced Formulas & Functions

📌 Day 10: Logical Functions (Nested IF, IFS, SWITCH) (🎥 Live – 1 Hour)

  • Learn IF, AND, OR, Nested IFs with real-world examples.

📌 Day 11: Practical Session on Nested IFs (🎥 Live – 1 Hour)

  • Solve real-world multi-condition logic problems.

📌 Day 12: Lookup & Reference Functions (🎥 Live – 1 Hour)

  • Master VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH.

📌 Day 13: Hands-On Classwork – Lookup Functions (🎥 Live – 1 Hour)

  • Solve real-world lookup problems & dynamic data references.

📌 Day 14: Define Name, Dynamic Ranges & Data Validation (📺 Recorded – 1 Hour)

  • Create Named Ranges for better formula readability.
  • Set up Dynamic Ranges & Data Validation Rules.

📌 Day 15: Advanced Lookup & Dynamic Linking (🎥 Live – 1 Hour)

  • Work with FILTER, UNIQUE, SORT, INDIRECT & HYPERLINK functions.
 
Data Mastery & Automation

📌 Day 16: Mastering Date & Time Functions (26 Functions!) (🎥 Live – 1 Hour)

  • Work with DATEDIF, NETWORKDAYS, WORKDAY, YEAR, MONTH, DAY & more.

📌 Day 17: File Security & 23+ Essential Text Functions (🎥 Live – 1 Hour)

  • Secure your Excel files with passwords & protection.
  • Use text functions like LEFT, RIGHT, MID, TRIM, SEARCH & SUBSTITUTE.

📌 Day 18: Data Analysis with PivotTables (🎥 Live – 1 Hour)

  • Create & customize PivotTables to analyze data efficiently.
  • Apply sorting, filtering & grouping for deeper insights.

📌 Day 19: Hands-On Reports with PivotTables (🎥 Live – 1 Hour)

  • Generate professional business reports using PivotTables.

📌 Day 20: Data Visualization with Charts & Dashboards (🎥 Live – 1 Hour)

  • Create dynamic dashboards with charts & slicers.
  • Design professional-looking dashboards for reporting.

📌 Day 21: Advanced Dashboard Design (🎥 Live – 1 Hour)

  • Use INDEX, MATCH, INDIRECT for powerful dashboard features.

📌 Day 22: Excel Macros & VBA for Automation (📺 Recorded – 1 Hour)

  • Introduction to Macros & their real-world applications.
  • Record, edit & execute Macros to automate repetitive tasks.
  • Basic VBA programming concepts for automating reports & data entry.
Join Live Class
Free Demo Class