Logic and formulas
Build reliable models with IFS, IFERROR, named ranges, and conditional formatting that responds to your data.
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.
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.
Build reliable models with IFS, IFERROR, named ranges, and conditional formatting that responds to your data.
Fetch data across sheets with XLOOKUP, INDEX-MATCH, and multi-criteria lookups, and understand when each is appropriate.
Summarise by condition with SUMIFS, COUNTIFS, MAXIFS, and clean text and dates for accurate reporting.
Import, clean, merge, and reshape data from several files, then refresh the whole process in one click.
Create PivotTables and PivotCharts, add slicers and timelines, and use calculated fields and dynamic arrays.
Design interactive dashboards with KPI cards and charts, and automate repetitive steps with simple macros.
Thirty lessons for thirty days, one per day. Open any module to see its lessons and running times.
| Day 1 | Tables, named ranges and structured references | 18 min |
| Day 2 | Logical functions: IF, IFS, AND, OR | 24 min |
| Day 3 | Conditional formatting rules | 15 min |
| Day 4 | Error handling with IFERROR and IFNA | 11 min |
| Day 5 | Assignment: grade and commission calculator | 12 min |
| Day 6 | VLOOKUP: strengths, limits and common errors | 17 min |
| Day 7 | INDEX and MATCH | 20 min |
| Day 8 | XLOOKUP in depth | 22 min |
| Day 9 | Two-way and multi-criteria lookups | 19 min |
| Day 10 | Assignment: employee master lookup | 14 min |
| Day 11 | SUMIFS, COUNTIFS and AVERAGEIFS | 23 min |
| Day 12 | MAXIFS and MINIFS | 10 min |
| Day 13 | Text functions for cleaning data | 21 min |
| Day 14 | Date functions for reporting | 16 min |
| Day 15 | Assignment: monthly sales summary | 13 min |
| Day 16 | Importing data from files and folders | 20 min |
| Day 17 | Cleaning and transforming columns | 22 min |
| Day 18 | Merging and appending tables | 25 min |
| Day 19 | Unpivoting and reshaping data | 18 min |
| Day 20 | Assignment: consolidating twelve monthly files | 15 min |
| Day 21 | PivotTable fundamentals | 24 min |
| Day 22 | PivotCharts, slicers and timelines | 22 min |
| Day 23 | Calculated fields and Show Values As | 20 min |
| Day 24 | FILTER, SORT and UNIQUE | 21 min |
| Day 25 | Data validation and what-if analysis | 18 min |
| Day 26 | Assignment: regional performance report | 14 min |
| Day 27 | Dashboard design principles | 18 min |
| Day 28 | Interactive charts and KPI cards | 28 min |
| Day 29 | Recording simple macros | 20 min |
| Day 30 | Capstone: build an end-to-end dashboard | 1 hr 15 min |
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:
VLOOKUP and basic chartsFor anything not covered here, write to arihant@example.com or message on WhatsApp.
Students and professionals who already use Excel and wish to advance to lookups, Power Query, PivotTables, and dashboards.
Basic familiarity is expected: entering data, simple formulas, and formatting. No programming knowledge is required.
Microsoft Excel 2021 or Microsoft 365, because XLOOKUP, FILTER, and UNIQUE are unavailable in older versions.
Yes. Each module ends with an assignment, and the final lesson is a capstone dashboard built from raw data.
One to two hours daily: the lesson itself plus practice on the supplied workbooks.
Yes. Doubts can be sent on WhatsApp and are answered within 24 hours.
Yes. If you find the course unsuitable, request a refund within seven days of enrolment and the full fee will be returned.
Access is for life, including any lessons added in future.
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.
Join the course today, and begin with a lesson of under half an hour.
Enrol now