Short Term
Beginner to Intermediate2 months
Database Management System
The theory and the practice together. ER modelling and normalisation for your university paper, and real SQL against real schemas for the job.
- MySQL
- PostgreSQL
- MySQL Workbench
- +1
Excel remains the most widely used analysis tool in Indian offices. This takes you from formulas through Power Query and pivot modelling to macros.
What you will be able to do
Full syllabus
6 modules · 30 topics · 120 concepts
Navigating fast
References
Structuring a workbook
Tables
Data validation
You can build a workbook that is navigable, auditable and hard to break.
Logical functions
Aggregation
Text functions
Date and time
Auditing
You can nest functions confidently and debug a formula that returns the wrong answer.
VLOOKUP and its problems
XLOOKUP
INDEX and MATCH
Dynamic arrays
Modern helpers
You can look up across tables reliably and return a spilled result.
The query editor
Shaping
Reshaping
Combining
Refreshable pipelines
You can build a repeatable transformation that survives next month's file.
Pivot tables
Pivot presentation
The data model
Power Pivot and DAX
What-if analysis
You can build a multi-table model and write measures against it.
Dashboard layout
Protecting a workbook
Recording macros
Writing VBA
Automation in practice
You can produce a dashboard people can read and automate the repetitive parts.
5 builds you keep
Four departmental files in a folder, inconsistent column names, and a report due on the second. Power Query does the combining; next month you press refresh instead of redoing it.
Receivables, payables and inventory driving a cash position, with best, base and worst cases switchable from one cell. Built so an auditor can trace every number back to an input.
Tiered rates, period cut-offs and claw-backs. The kind of logic that gets nested IFs wrong, rebuilt with lookup tables so the rules can change without rewriting formulas.
Raw punch data with duplicates and missing outs, cleaned in Power Query and summarised by pivot with slicers by department and month.
Loops over a customer list, generates one formatted sheet each, saves them as PDFs into dated folders, and logs what it did. An afternoon of clicking, reduced to a button.
Hands on with
Before you enrol
The first module is deliberately quick. Most working users have never used Power Query, the data model or dynamic arrays, and those three are where the course spends its time. If you have used all three, this is not for you.
XLOOKUP, FILTER and the dynamic array functions need Microsoft 365 or Excel 2021. We teach INDEX-MATCH alongside, so you can still work on an older version, and the Power Query material works from 2016 onwards.
Excel first if your work arrives as spreadsheets, which in most Indian offices it does. The modelling and Power Query skills transfer directly to Power BI afterwards, so nothing is wasted.
For automating Excel itself, yes, and it is still what most offices have. For anything larger, Python is the better tool. The course covers enough VBA to automate a real reporting task and is honest about where the ceiling is.
Excel is rarely the job title but it is on most analyst, accounts and operations job descriptions. What gets noticed is turning a manual monthly task into a refreshable one, which is exactly what the projects are built around.
Where this leads
One skill on a CV is a hobby. These are the courses students take alongside this one, in the order that builds an actual role.
The theory and the practice together. ER modelling and normalisation for your university paper, and real SQL against real schemas for the job.
Five weeks to a dashboard your workplace will actually use. Data modelling and DAX taught properly, because that is where most Power BI users get stuck.
The shortest route from no code at all to a working, employable skill. Sixty hours of live teaching that starts at absolute beginner and ends with five projects and a deployed web application in your portfolio.