🎓 AI-Powered Learning · Limited Seats

AI-Powered Excel Expert
Micro Course

Learn Excel in 29 Days + 7 Days AI in Excel Bonus.
From a Fresher to an Excel Expert — A to Z

29 Days Course
🤖 AI in Excel Bonus
🏆 Certificate Included
Lifetime Access
Parminder Excel Expert & Trainer

✅ 30-Day Money-Back Guarantee  |  ✅ Instant Access  |  ✅ Lifetime Updates

1,000+
Students Enrolled
15,00+
5-Star Reviews
10+
Years of Experience
40+ Students
Currently Online

What You'll Learn

This comprehensive Excel Micro Course covers everything from the basics to advanced AI-powered techniques used by professionals at top companies.

📊

Excel Data Entry & Formatting

Master professional data entry workflows, cell formatting, number formats, and conditional formatting to build beautiful spreadsheets.

🔢

Smart Formulas & Functions

Learn 50+ essential functions including VLOOKUP, INDEX-MATCH, SUMIF, COUNTIF, and powerful text & date functions.

📈

Data Visualisation & Charts

Create stunning charts and dashboards that tell compelling data stories — bar, pie, combo charts & interactive slicers.

🔄

Pivot Tables & Pivot Charts

Analyse thousands of rows in minutes. Master Pivot Tables, calculated fields, and dynamic Pivot Charts effortlessly.

🤖

AI in Excel (7-Day Bonus)

Harness the power of AI tools inside Excel — write formulas faster, auto-clean data, and generate insights with Copilot.

Macros & Automation

Record and write VBA macros to automate repetitive tasks and save hours of manual work every week.

30-Day Day-by-Day Curriculum

Every single day has a clear topic — just follow the plan and you'll be an Excel Expert in 30 days.

Day 1Welcome to Excel — Interface & Navigation
  • What is Excel and why it matters in 2025
  • Ribbon, Quick Access Toolbar & File menu
  • Rows, Columns, Cells & Worksheets explained
  • Keyboard shortcuts to navigate fast
Day 2Entering & Editing Data Like a Pro
  • Types of data: Text, Numbers, Dates, Booleans
  • AutoFill & Flash Fill magic tricks
  • Find & Replace, Go To Special
  • Undo, Redo & Version history
Day 3Cell Formatting & Number Formats
  • Font, fill, border, alignment formatting
  • Number, Currency, Percentage, Date formats
  • Custom number formats (e.g. ₹#,##0.00)
  • Format Painter & Cell Styles
Day 4Conditional Formatting
  • Highlight cells rules (greater than, duplicate)
  • Data Bars, Color Scales, Icon Sets
  • Custom formula-based conditional rules
  • Managing & clearing formatting rules
Day 5Working with Rows, Columns & Sheets
  • Insert, delete, hide & unhide rows/columns
  • Freeze panes & split view
  • Group & Outline rows/columns
  • Managing multiple sheets efficiently
Day 6Data Validation & Dropdowns
  • Creating dropdown lists in cells
  • Restricting input: numbers, dates, text length
  • Custom validation with formulas
  • Input messages & error alerts
Day 7Week 1 Practice Project — Employee Tracker
  • Build a fully formatted Employee Data Sheet
  • Apply conditional formatting for attendance
  • Use data validation for department dropdowns
  • Review & Quiz — Week 1 concepts
Day 8Basic Formulas & Cell References
  • SUM, AVERAGE, MAX, MIN, COUNT
  • Relative vs Absolute vs Mixed references ($)
  • Formula bar tips & trace precedents
  • Common formula errors & how to fix them
Day 9Logical Functions — IF, AND, OR
  • IF function — single condition logic
  • Nested IF & IFS function
  • AND, OR, NOT for compound conditions
  • IFERROR & IFNA for clean error handling
Day 10Counting & Summing Functions
  • COUNTIF & COUNTIFS with multiple criteria
  • SUMIF & SUMIFS — conditional totals
  • AVERAGEIF & AVERAGEIFS
  • COUNTA, COUNTBLANK, SUBTOTAL
Day 11Lookup Functions — VLOOKUP & HLOOKUP
  • VLOOKUP — exact & approximate match
  • HLOOKUP for horizontal lookups
  • Common VLOOKUP mistakes & fixes
  • Using VLOOKUP across multiple sheets
Day 12Advanced Lookups — INDEX, MATCH & XLOOKUP
  • INDEX + MATCH — the VLOOKUP killer
  • Two-way lookup with INDEX-MATCH
  • XLOOKUP — modern, flexible lookup
  • XMATCH, CHOOSE for dynamic lookups
Day 13Text Functions
  • LEFT, RIGHT, MID, LEN, FIND, SEARCH
  • TRIM, CLEAN, SUBSTITUTE, REPLACE
  • CONCATENATE, CONCAT, TEXTJOIN
  • UPPER, LOWER, PROPER, TEXT formatting
Day 14Week 2 Practice Project — Sales Report
  • Build a Sales Summary using SUMIFS & COUNTIFS
  • Pull product info with VLOOKUP/XLOOKUP
  • Apply IF logic for bonus calculations
  • Review & Quiz — Week 2 concepts
Day 15Date & Time Functions
  • TODAY, NOW, DATE, YEAR, MONTH, DAY
  • DATEDIF — calculate age & tenure
  • EDATE, EOMONTH, WORKDAY, NETWORKDAYS
  • Formatting & displaying dates correctly
Day 16Sorting & Filtering Data
  • Single-level & multi-level sorting
  • AutoFilter — filter by value, color, condition
  • Advanced Filter — complex multi-criteria
  • SORT & FILTER dynamic array functions
Day 17Excel Tables & Named Ranges
  • Convert data range to Excel Table (Ctrl+T)
  • Structured references in formulas
  • Table styles & filtering headers
  • Named Ranges — define & use in formulas
Day 18Pivot Tables — Part 1
  • What is a Pivot Table & when to use it
  • Creating your first Pivot Table
  • Rows, Columns, Values & Filters areas
  • Summarise by Sum, Count, Average, Max
Day 19Pivot Tables — Part 2
  • Grouping by date (month, quarter, year)
  • Calculated Fields & Calculated Items
  • Slicers & Timelines for interactive filtering
  • Refresh & update Pivot Table data
Day 20Charts & Data Visualisation
  • Bar, Column, Line & Pie charts
  • Combo charts — dual axis
  • Sparklines — tiny inline charts
  • Chart design, formatting & titles
Day 21Week 3 Practice Project — KPI Dashboard
  • Build an interactive KPI dashboard
  • Use Pivot Table + Slicer + Charts together
  • Apply Excel Tables for dynamic data range
  • Review & Quiz — Week 3 concepts
Day 22Statistical & Math Functions
  • RANK, PERCENTILE, PERCENTRANK
  • STDEV, VAR, MEDIAN, MODE
  • ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR
  • MOD, INT, ABS, POWER, SQRT
Day 23Dynamic Array Functions
  • FILTER — filter data with formulas
  • SORT & SORTBY — dynamic sorting
  • UNIQUE — extract unique values
  • SEQUENCE, RANDARRAY — generate arrays
Day 24Power Query — Import & Transform Data
  • What is Power Query & why it's powerful
  • Import data from Excel, CSV, Web
  • Transform: filter, sort, split columns
  • Merge & Append queries
Day 25What-If Analysis & Forecasting
  • Goal Seek — find inputs for desired output
  • Data Tables — one-way & two-way
  • Scenario Manager — compare scenarios
  • Forecast Sheet — trend prediction with charts
Day 26Protecting & Auditing Workbooks
  • Lock & protect specific cells/sheets
  • Workbook password protection
  • Trace precedents & dependents
  • Show Formulas & Formula Auditing toolbar
Day 27Macros — Record & Automate Tasks
  • What are Macros & where to find them
  • Record a Macro — step by step
  • Run, edit & delete Macros
  • Assign Macro to a button on the sheet
Day 28VBA Basics — Write Your First Code
  • Opening the VBA Editor (Alt+F11)
  • Variables, loops & basic IF statements
  • MsgBox, InputBox for user interaction
  • Write a VBA macro to automate a report
Day 29Professional Dashboard — Capstone Project
  • Build a complete Business Analytics Dashboard
  • Combine Pivot Tables, Charts & Slicers
  • Add VLOOKUP, SUMIFS & dynamic arrays
  • Apply professional formatting & layout
Day 30🏆 Graduation Day — Certificate & Next Steps
  • Final assessment & course recap
  • Receive your Aptus Academy Excel Certificate
  • Top Excel tips used by professionals daily
  • Your roadmap: Power BI, Python, AI in Excel

7-Days A.I. in Excel Bonus Lessons

🤖

Day 1 — Introduction to AI in Excel

Overview of AI tools, Copilot setup, and first AI-powered formulas

Day 2 — Excel Copilot Deep Dive

Use natural language to generate formulas, analyse data, and create charts instantly

🧹

Day 3 — AI-Powered Data Cleaning

Auto-fix inconsistencies, remove duplicates, and standardize data with one click

📊

Day 4 — Smart Data Analysis with AI

Generate insights, trends, and summaries from raw data using AI

🔮

Day 5 — AI Forecasting & Predictions

Forecast sales, budgets and KPIs using Excel's built-in AI forecast sheet

⚙️

Day 6 — Automating Reports with AI

Build self-updating dashboards with AI automation and smart triggers

🏁

Day 7 — Final AI Project + Certification

Build a complete AI-powered Excel project and receive your certificate

Our Learners Work at Top Companies

Join thousands of students who landed roles at India's and the world's leading organisations.

Amazon
Infosys
TCS
Wipro
Deloitte
KPMG
25+ More

Listen From Our Students

R
Virender Singh
Data Analyst, Bhopal
★★★★★

Parminder's teaching style is exceptional. I went from knowing nothing about Excel to building complex dashboards for my team. The AI bonus module alone was worth the entire course price!

P
Sanskriti
Finance Executive, Faridabad, Haryana
★★★★★

I used to spend hours on manual reports. After completing this course, I automated everything using Macros and Pivot Tables. My manager was amazed at the quality of my work!

A
Ashmit Rana
MBA Graduate, Delhi
★★★★★

The best investment I've made in my career. Parminder explains everything with real-world examples. Got placed with a 40% salary hike after showcasing my Excel skills!

S
Nisha
HR Manager, Ahmedabad
★★★★★

Never thought I could learn Excel this quickly. The structured 29-day approach and lifetime access made it so easy to learn at my own pace. Highly recommend to everyone!

V
Vivek
Business Owner, Palwal Haryana
★★★★★

As a small business owner, Excel was always intimidating. Aptus Academy changed that completely. Now I manage all my accounts and reports myself. Saved ₹15,000/month on outsourcing!

N
Dollsy
Fresher, Faridabad
★★★★★

Just graduated and this course helped me crack my very first job interview! The interviewer was impressed with my pivot table and VLOOKUP knowledge. Thank you Parminder sir!

🏅Excel Expert
Certificate
🤖AI in Excel
Certificate
🎓Aptus Academy
Certificate

Ready to Become an Excel Expert?

Join over 1,00,000 students who have already transformed their careers with this course. Limited time offer!

₹4,999 ₹999 80% OFF
30-Day Money Back
Lifetime Access
Certificate Included
Free Updates Forever

Your Questions, Our Answers

Do I need any prior Excel knowledge to join?
No prior knowledge required! This course starts from absolute basics and takes you step by step to an expert level. Even if you have never opened Excel, you can complete this course successfully.
How long will I have access to the course?
You get lifetime access to all course materials, including future updates. Learn at your own pace — there are no deadlines or expiry dates.
Which version of Excel do I need?
The course works with Excel 2016, 2019, 2021, and Microsoft 365 (recommended). Most lessons are compatible with all modern Excel versions. The AI bonus module requires Microsoft 365 with Copilot.
Is there a certificate after completion?
Yes! You will receive an official Aptus Academy certificate upon completing the course. This certificate is recognised by top employers and can be added to your LinkedIn profile and resume.
What if I am not satisfied with the course?
We offer a full 30-day money-back guarantee, no questions asked. If you are not completely satisfied within 30 days of purchase, simply contact us and we will process a full refund immediately.
Can I access the course on mobile?
Yes! The course is fully mobile-responsive. You can watch lessons on your smartphone, tablet, laptop, or desktop — anytime, anywhere.
How do I contact the instructor if I have doubts?
You can ask questions directly through the course Q&A section and Parminder or the Aptus Academy support team will respond within 24 hours. You also get access to our exclusive student community group.

Meet Your Instructor

P

Parminder

Microsoft Certified Excel Expert & Corporate Trainer
📊 Excel MVP 🏢 15+ Years Experience 👨‍🎓 1,00,000+ Students ⭐ 4.9/5 Rating

Parminder is a Microsoft Certified Excel Expert with over 15 years of experience training professionals at Fortune 500 companies and top Indian corporations. Having worked with firms like Deloitte, KPMG, and TCS, he brings real-world, practical Excel knowledge to every lesson.

He founded Aptus Academy with a simple mission: make world-class Excel education affordable and accessible to every Indian professional. His students have gone on to work at Amazon, Infosys, Wipro, and hundreds of leading companies across India. With a unique blend of simplicity, depth, and AI-forward thinking, Parminder's courses are consistently rated among the best Excel courses available online.