Salary and attendance sheet
Calculate days present, leave and net pay with IF, COUNTIFS and lookups from an employee master.
Advanced Excel Course Online for Sri Lanka
Live online Advanced Excel classes from India for learners in Sri Lanka: 1 level, 24 h, batches in Sri Lanka time.
Sri Lanka1 level24 hLive online · Hybrid · Offline
01Why learners in Sri Lanka choose it
Advanced Excel for work and study in Sri Lanka
Excel, accounting and marketing tools are used in nearly every business. Our accounting syllabus follows Indian practice.
Sri Lanka uses the same clock time as India, so live classes need no time-zone planning at all.
Roles this skill supports: Accounts executive, MIS executive, data entry and reporting roles.
Advanced Excel – at a glance
- 1 level: 24 h
- Live trainer-led online classes
- Hybrid or 100% offline when you visit India
- Project assessed before certification
- Batches planned in Sri Lanka time
02Levels
Which Advanced Excel level to choose
The Certificate in Advanced Excel (24 hours) gives you a complete path from basics to lookups, pivots, Solver and macros, whether you are new to Excel or already use it daily. After it, Power BI is the natural next step.
| Programme | Level | Hours | Best for |
|---|---|---|---|
| Certificate in Advanced Excel | Foundation | 24 h | Students, job seekers and office users who want to go from Excel basics to lookups, pivot tables, arrays, Solver and macros in 24 hours. |
03Tools covered
What you will work with
Microsoft Excel (Microsoft 365 / Office)Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, INDIRECTPivot tables, pivot charts and slicersData validation and dependent listsExcel Tables and named rangesArray formulasGoal Seek, Data Tables, Scenario ManagerSolver add-inMacro recorder
We provide training and instruction only. Software and licences are not included; use your own licence, or an educational or trial licence where the software maker offers one. See our Software & Licensing Policy. Certificates are skill-training certificates, not degrees or professional licences.
04Projects
Practice projects
Sales dashboard with pivots
Summarise a year of sales by region, product and month with pivot tables, charts and slicers.
Invoice template with drop-downs
Build a protected invoice where choosing an item fills the rate and tax automatically.
Loan EMI and scenario model
Use PMT, Data Tables and Scenario Manager to compare loan options.
05Class timings
Advanced Excel class timings in Sri Lanka
Slots in your local time and the matching India time.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| Colombo | Weekday evening | 7:00 PM–9:00 PM | 7:00 PM–9:00 PM |
| Colombo | Weekday early morning | 6:00 AM–8:00 AM | 6:00 AM–8:00 AM |
| Colombo | Weekend morning | 9:00 AM–11:00 AM | 9:00 AM–11:00 AM |
Slots marked “late night in India” need the trainer’s confirmation. Final timings are fixed on WhatsApp based on trainer and student availability; any date and time can be arranged where a trainer is available.
06More for Sri Lanka
Other courses learners in Sri Lanka take
07FAQ
Advanced Excel in Sri Lanka – FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppCan I learn Advanced Excel from Sri Lanka?
Yes. Advanced Excel is taught live online from India, with batches planned in Sri Lanka time subject to trainer availability.
What are the Advanced Excel class timings for Sri Lanka?
Typical slots are weekday evening, weekday early morning and weekend morning in your local time. The planner above shows the matching India time; final timings are fixed on WhatsApp.
What is the fee?
Fees depend on level and mode. WhatsApp +91 8111 029 125 for the current fee and payment options for your country.
Can I attend in person when I visit India?
Yes. Hybrid and offline batches run at Vellore, Katpadi and Ranipet on dates agreed in advance.
Do I need to buy the software?
We do not supply software. Use your own licence or an educational or trial licence where the maker offers one.
Start from anywhere
Advanced Excel for Sri Lanka: syllabus, fee and next batch
Tell us your city and preferred time. We reply on WhatsApp.
- Live online, hybrid or 100% offline in India
- Batches in your time zone, based on trainer availability
- Free counselling and a syllabus on WhatsApp
- One number for everything: +91 8111 029 125