Master Advanced Excel: from formulas to dashboards in 30 days

Learn one lesson a day: lookups, conditional formulas, Power Query, PivotTables, and interactive dashboards. Every module ends with an assignment, and the course closes with a full capstone dashboard. Suited to students and working professionals who already use Excel.

  • 30 lessons
  • 10.2 hours of video
  • Taught by Arihant Singh
Course preview video
Add your introduction video here

What you will learn

Excel is the most widely used tool for working with data. This course moves from advanced formulas to complete reports, using real business scenarios and practice files throughout.

Logic and formulas

Build reliable models with IFS, IFERROR, named ranges, and conditional formatting that responds to your data.

Lookup and reference

Fetch data across sheets with XLOOKUP, INDEX-MATCH, and multi-criteria lookups, and understand when each is appropriate.

Conditional analysis

Summarise by condition with SUMIFS, COUNTIFS, MAXIFS, and clean text and dates for accurate reporting.

Power Query

Import, clean, merge, and reshape data from several files, then refresh the whole process in one click.

PivotTables

Create PivotTables and PivotCharts, add slicers and timelines, and use calculated fields and dynamic arrays.

Dashboards

Design interactive dashboards with KPI cards and charts, and automate repetitive steps with simple macros.

Detailed course curriculum

Thirty lessons for thirty days, one per day. Open any module to see its lessons and running times.

Module 1: Formula foundations and logicDays 1–55 lessons · 1 hr 20 min
Day 1Tables, named ranges and structured references18 min
Day 2Logical functions: IF, IFS, AND, OR24 min
Day 3Conditional formatting rules15 min
Day 4Error handling with IFERROR and IFNA11 min
Day 5Assignment: grade and commission calculator12 min
Module 2: Lookup and reference formulasDays 6–105 lessons · 1 hr 32 min
Day 6VLOOKUP: strengths, limits and common errors17 min
Day 7INDEX and MATCH20 min
Day 8XLOOKUP in depth22 min
Day 9Two-way and multi-criteria lookups19 min
Day 10Assignment: employee master lookup14 min
Module 3: Conditional, text and date analysisDays 11–155 lessons · 1 hr 23 min
Day 11SUMIFS, COUNTIFS and AVERAGEIFS23 min
Day 12MAXIFS and MINIFS10 min
Day 13Text functions for cleaning data21 min
Day 14Date functions for reporting16 min
Day 15Assignment: monthly sales summary13 min
Module 4: Power Query and data cleaningDays 16–205 lessons · 1 hr 40 min
Day 16Importing data from files and folders20 min
Day 17Cleaning and transforming columns22 min
Day 18Merging and appending tables25 min
Day 19Unpivoting and reshaping data18 min
Day 20Assignment: consolidating twelve monthly files15 min
Module 5: PivotTables and dynamic arraysDays 21–266 lessons · 1 hr 59 min
Day 21PivotTable fundamentals24 min
Day 22PivotCharts, slicers and timelines22 min
Day 23Calculated fields and Show Values As20 min
Day 24FILTER, SORT and UNIQUE21 min
Day 25Data validation and what-if analysis18 min
Day 26Assignment: regional performance report14 min
Module 6: Dashboards and automationDays 27–304 lessons · 2 hr 21 min
Day 27Dashboard design principles18 min
Day 28Interactive charts and KPI cards28 min
Day 29Recording simple macros20 min
Day 30Capstone: build an end-to-end dashboard1 hr 15 min

Is this course right for you?

The course assumes you can already enter data, write a simple formula, and format a sheet. It does not assume any knowledge of Power Query, PivotTables, or macros.

It suits you if you:

  • Clean and merge data by hand every week
  • Want to move beyond VLOOKUP and basic charts
  • Are preparing for roles in accounting, MIS, analytics, or operations
  • Need a finished dashboard to show an employer

Your questions, answered

For anything not covered here, write to arihant@example.com or message on WhatsApp.

Who is this course for?

Students and professionals who already use Excel and wish to advance to lookups, Power Query, PivotTables, and dashboards.

Do I need prior knowledge of Excel?

Basic familiarity is expected: entering data, simple formulas, and formatting. No programming knowledge is required.

Which Excel version do I need?

Microsoft Excel 2021 or Microsoft 365, because XLOOKUP, FILTER, and UNIQUE are unavailable in older versions.

Will I get hands-on practice?

Yes. Each module ends with an assignment, and the final lesson is a capstone dashboard built from raw data.

How much time should I set aside each day?

One to two hours daily: the lesson itself plus practice on the supplied workbooks.

Can I ask questions if I am stuck?

Yes. Doubts can be sent on WhatsApp and are answered within 24 hours.

Is there a refund policy?

Yes. If you find the course unsuitable, request a refund within seven days of enrolment and the full fee will be returned.

What is the course validity?

Access is for life, including any lessons added in future.

About your instructor

I am Arihant Singh, an Excel trainer who teaches data analysis through practical, task-based lessons. Every concept is introduced with a business scenario, such as sales reports, payroll sheets, or inventory tracking, and practised on a dataset until it becomes routine.

Thirty days from now, your reports can build themselves

Join the course today, and begin with a lesson of under half an hour.

Enrol now
Scroll to Top