Office & Digital Productivity
Advanced Excel with Data Analysis
PivotTables, Power Query, dashboards and financial models on real datasets.
- Duration
- 60–80 hrs
- Modules
- 8
- Level
- Degree (UG), PU on request
- Mode
- Online, offline or hybrid
- Certificate
- Skillern course certificate
- Fees
- On request
About this course
An advanced course covering lookups, PivotTables, Power Query, dashboards, financial modelling, MIS reporting and data visualisation, all practised on real datasets. It builds directly into Bookkeeping & Auditing and prepares students for MIS and junior analyst roles.
- 1. Data hygiene and structure — 6h
- 2. Logical and lookup functions — 10h
- 3. PivotTables and Pivot Charts — 10h
- 4. Power Query — 10h
- 5. Data visualisation — 8h
- 6. Dashboards and KPI tracking — 10h
- 7. Financial modelling and scenario analysis — 8h
- 8. MIS reporting and capstone — 8h
Who it's for
- Degree students in Year 2 (Semester 3 of the Skillern UG roadmap)
- Students who have completed Microsoft Office 365 or have equivalent Excel skills
Prerequisites
- Excel basics: formulas, formatting and charts
Curriculum
8 modules, 70 hours standard.
Learning objective
Prepare messy data for analysis.
Hands-on lab
Clean a 2,000-row sales export.
Topics covered
- Excel tables and named ranges
- Text and date functions (TRIM, TEXT, DATE)
- Removing duplicates
- Data types and consistency
What students can do by the end
- Clean, combine and summarise large datasets
- Build interactive dashboards and KPI trackers
- Create financial and scenario models
- Produce automated MIS reports
Career outcomes
- MIS Analyst
- Junior Data Analyst
- Financial Analyst Support
- Reporting Executive
Tools and software
Microsoft Excel (Microsoft 365), Power Query
Signature project
Automated MIS report. A refreshable monthly report and KPI dashboard built from raw business data.
Assessment and certification
Students who pass receive a Skillern course completion certificate. NSDC and EMax certification are available for eligible courses.
Trainer profile
Data analyst or MIS professional with corporate experience
Delivery and scheduling
| Format | Schedule |
|---|---|
| Semester (recommended) | About 20 weeks at 3.5 hours a week |
| Intensive | 12 days at 6 hours a day, or weekend batches |
| School version | Not offered |
| Session length | 2-hour sessions |
Frequently asked questions
Related courses
Office & Digital Productivity
Microsoft Office 365
The office suite every employer expects, taught through real business tasks.
- Duration
- 40–60 hrs
- Modules
- 8
- Level
- PU & Degree (Grade 11 to UG)
Office & Digital Productivity
Google Workspace
Cloud collaboration the way startups and remote teams work.
- Duration
- 40–60 hrs
- Modules
- 8
- Level
- PU & Degree (Grade 11 to UG)