Best Seller Icon Bestseller

Certificate In Advanced Excel(S-CAE-1832)

  • Last updated Aug, 2026
  • Certified Course
₹5,000 ₹7,000

Course Includes

  • Duration2 Months
  • Enrolled1
  • Lectures45
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

Advanced Excel is a practical, job-oriented 2-month course designed to help students and professionals develop strong skills in Excel data management, advanced formulas, data analysis, reporting, dashboards, Pivot Tables, Power Query, and basic automation.

During the course, learners will work on real-world projects and business reports to gain hands-on experience in creating professional MIS reports, analyzing large datasets, preparing interactive dashboards, and automating repetitive Excel tasks.

Key Skills: Advanced Formulas, VLOOKUP/XLOOKUP, INDEX-MATCH, Pivot Tables, Charts, Dashboards, Data Cleaning, Power Query, Macros, MIS Reporting & Data Analysis.

Show More

Course Syllabus

 Month 1 — Advanced Excel Foundation

Week 1: Excel Basics & Professional Formatting

  • Workbook & Worksheet Management
  • Formatting & Cell Styles
  • Conditional Formatting
  • Data Validation
  • Sort & Filter
  • Freeze Panes
  • Page Setup & Printing

Week 2: Advanced Formulas

  • IF, IFS, AND, OR
  • SUMIF, SUMIFS
  • COUNTIF, COUNTIFS
  • AVERAGEIF, AVERAGEIFS
  • IFERROR
  • LEFT, RIGHT, MID
  • FIND, SEARCH
  • CONCAT, TEXTJOIN
  • Date & Time Functions

Week 3: Lookup Functions

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX + MATCH
  • Multiple Criteria Lookup
  • Dynamic Lookup
  • Error Handling

Week 4: Data Management & Analysis

  • Remove Duplicates
  • Text to Columns
  • Flash Fill
  • Advanced Filter
  • Data Cleaning
  • Duplicate/Missing Data Analysis
  • Basic What-If Analysis

Month 2 — Dashboard, MIS & Automation

Week 5: Pivot Tables

  • Creating Pivot Tables
  • Grouping Data
  • Calculated Fields
  • Slicers
  • Timeline
  • Pivot Charts
  • Interactive Reports

Week 6: Charts & Dashboard

  • Column & Bar Charts
  • Line & Pie Charts
  • Combo Charts
  • Dynamic Charts
  • KPI Reports
  • Interactive Dashboard
  • Professional MIS Reports

Week 7: Power Query

  • Import Excel/CSV Data
  • Data Cleaning
  • Merge Queries
  • Append Queries
  • Transform Data
  • Automatic Refresh
  • Combining Multiple Files

Week 8: Macros + Final Projects

  • Macro Introduction
  • Record Macro
  • VBA Basics
  • Automating Repetitive Tasks
  • Creating Buttons
  • Final Dashboard Project


🏆 Practical Projects

  1. Sales MIS Dashboard
  2. Employee Attendance & Salary Report
  3. Inventory Management Report
  4. Expense & Profit Analysis
  5. Interactive Business Dashboard


Course Fees

Course Fees
:
₹7000/-
Discounted Fees
:
₹ 5000/-
Course Duration
:
2 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%



Call
Text Message
Review
Brochure
Email
CHAT