Certificate Course in Beginner to Advanced Excel
Four intensive days that take you from the Excel ribbon to PivotTables, Power Query and macros.
Programme snapshot
- Qualification
- Certificate
- Subject
- Data & Analytics
- Duration
- 4 days (12 hours)
- Study mode
- Online live
- Medium
- Sinhala
- Schedule
- Four intensive days, recorded to the LMS
- Entry requirements
- Open to beginners. No prior Excel knowledge assumed.
- Certification
- TVEC-approved skill upgrade Certificate awarded by Starliks Campus
- Course fee
- Rs. 4,500/- (normal fee Rs. 7,500/-)
40% discount for a limited time
What you will learn
- Navigate large datasets efficiently with shortcuts, freeze panes and split windows
- Clean data with TRIM, CLEAN, PROPER, Flash Fill and duplicate removal
- Write core and nested formulas, and handle errors with IFERROR and ISBLANK
- Look up data with VLOOKUP, INDEX + MATCH and XLOOKUP
- Build PivotTables, PivotCharts, slicers and timelines into management dashboards
- Use Goal Seek, Scenario Manager, Power Query and recorded macros
Course structure
Taken from the official programme brochure.
Getting started with Excel
Interface, workbooks and worksheets, data types and efficient navigation. 45 minutes.
Data entry & cleaning
Accurate entry, formatting, cleaning functions, Find & Replace and Flash Fill. 1 hour.
Core formulas & functions
Arithmetic and summary functions, logical formulas, error handling and nesting. 1 hour 15.
Lookup & reference
VLOOKUP, HLOOKUP, INDEX + MATCH, XLOOKUP, named ranges and structured references. 1 hour 15.
Conditional formatting & visualisation
Highlighting rules, custom formulas, data bars, colour scales and icon sets. 1 hour 15.
Data tools
Sorting, multi-level filtering, data validation, text and date functions. 1 hour.
PivotTables & PivotCharts
Creating, grouping, calculated fields, slicers and management summaries. 1 hour 30.
What-if analysis
Goal Seek, Scenario Manager and data tables. 1 hour.
Power Query basics
Importing, merging and appending, transformations and automating recurring reports. 1 hour.
Dashboards & automation
Combining visuals into dashboards, KPI indicators, protection and an introduction to macros. 1 hour 30.
Who this is for
- School leavers
- Working professionals
- Anyone who reports in Excel
Where it can take you
Roles this qualification is designed to prepare you for.
- Executive and administrative roles
- Accounts assistant
- MIS and reporting roles
- Operations coordinator
Your lecturer
Microsoft Excel · Data analysis · Software developmentRelated programmes
Certificate Course in Business Analysis and Power BI
Turn raw business data into decisions using Power Query, data modelling, DAX and Power BI.
Professional Certificate in Power Apps & Power Automate
Build solutions, automate work and drive efficiency on the Microsoft Power Platform.
Certificate in Agentic AI & Machine Learning
From ideas to intelligent solutions — learn, build and automate.
Ready to start your journey?
Apply now, or talk to us first — whichever suits you.