Master Microsoft Excel — the most used business tool in India. From MNC analyst roles to freelance dashboards, Excel skills are always in demand. Pair with SQL and Power BI for maximum impact.
Master the basics: formulas, functions, formatting, charts, and data handling. Build a rock-solid foundation.
By the end, you'll be able to
Mini-project
Create a sales report from raw data: clean the data, calculate totals/averages, create 5 charts, and format it professionally.
Level up: VLOOKUP, INDEX-MATCH, SUMPRODUCT, array formulas, nested IFs, and the new XLOOKUP, FILTER, SORT functions.
By the end, you'll be able to
Mini-project
Build a grade management system: student data, attendance, marks from multiple sheets, weighted grades, and rank.
Pivot tables are Excel's superpower. Master creating, customizing, and analyzing data with pivot tables, slicers, and calculated fields.
By the end, you'll be able to
Mini-project
Analyze an e-commerce dataset with pivot tables: sales by region, product performance, monthly trends, and customer segments.
Build interactive dashboards that impress. Combine charts, pivot tables, slicers, and conditional formatting into professional business dashboards.
By the end, you'll be able to
Mini-project
Build an HR analytics dashboard: headcount, attrition, department-wise analysis, and trend charts with interactive slicers.
Automate repetitive work. Learn VBA programming: recording macros, writing code, creating UserForms, and automating reports.
By the end, you'll be able to
Mini-project
Automate a monthly report: VBA macro that pulls data, cleans it, creates pivot tables, generates charts, and emails the report.
Handle big data in Excel. Power Query for ETL, Power Pivot for data modeling, and DAX formulas for advanced calculations.
By the end, you'll be able to
Mini-project
Build a data model: combine data from 5 Excel files and a database, transform with Power Query, model in Power Pivot.
Complement Excel with SQL for databases and Power BI for professional dashboards. This combination is the most common analyst toolkit in India.
By the end, you'll be able to
Mini-project
Build a complete analytics workflow: query data with SQL, transform in Power Query, model in Power BI, and present insights.
Not sure if this is the right roadmap? Browse all our career paths and find the one that matches your goals.