Salary and attendance sheet
Calculate days present, leave and net pay with IF, COUNTIFS and lookups from an employee master.
Advanced Excel Course Online from India
Work faster in Excel with lookups, pivot tables, validation, what-if tools and macros that take the repetition out of reports. Live trainer-led classes for learners worldwide, with hybrid and 100% offline options in India.
Live online1 level24 hYour time zone
01About the course
What you will learn in Advanced Excel
Microsoft Excel is the spreadsheet program in Microsoft 365 and Office. Most people know how to type data and add a column, but Advanced Excel is about the features that do real work: conditional and array formulas, VLOOKUP, XLOOKUP and INDEX-MATCH, data validation lists, pivot tables and charts, Goal Seek, Scenario Manager and Solver, and macros that record repeated steps. With these, a report that took a day can be built once and refreshed in minutes.
This page is for learners outside Vellore, Katpadi and Ranipet – NRIs, professionals in the Gulf and other countries, and students elsewhere in India who want Advanced Excel taught live by a trainer.
You should be able to use a computer and open, type into and save an Excel file. The Certificate course starts with a refresher of basics, so you do not need to be an everyday Excel user to join.
At a glance
- 1 programme level: 24 h
- Live online, hybrid or offline in India
- Projects assessed before certification
- Certificate from the SynergySBS network
- Batches fixed around your time zone
02Outcomes
Skills you will be able to show
- Use absolute, relative and mixed references correctly in formulas
- Apply SUMIFS, COUNTIFS, nested IF, IFERROR and text and date functions
- Look up data with VLOOKUP, XLOOKUP, INDEX-MATCH and INDIRECT
- Build dependent drop-down lists and custom validation rules
- Summarise data with pivot tables, calculated fields, grouping and slicers
- Model decisions with Goal Seek, Data Tables, Scenario Manager and Solver
03Syllabus
Advanced Excel syllabus by level
Every module and topic taught in the classroom batch is covered online. Open a level to see its modules.
Foundation level
Certificate in Advanced Excel
Students, job seekers and office users who want to go from Excel basics to lookups, pivot tables, arrays, Solver and macros in 24 hours.
24 hours12 modules · 79 topicsCertificate: SynergySBS network
01Excel Introduction and Customisation6 topics
Screen Overview, Navigation and Spreadsheet ConceptsSelection TechniquesShortcut KeysCustomising the RibbonUsing and Customising AutoCorrectChanging Excel's Default Options
02Basic Functions and Referencing3 topics
SUM, AVERAGE, MAX, MINCOUNT, COUNTA, COUNTBLANKAbsolute, Mixed and Relative Referencing
03Formatting and Protection8 topics
Currency FormatFormat PainterFormatting DatesCustom and Special FormatsNumber, Font, Alignment and Border FormatsConditional FormattingFile-Level ProtectionWorkbook and Worksheet Protection
04Conditional Maths and Logical Functions7 topics
SUMIF and SUMIFSCOUNTIF and COUNTIFSAVERAGEIF and AVERAGEIFSIF and Nested IFIFERRORAND, OR, NOTComplex IF with AND/OR
05Text and Date Functions10 topics
UPPER, LOWER, PROPERLEFT, MID, RIGHTTRIM, LEN, EXACTCONCATENATEFIND and SUBSTITUTETODAY and NOWDAY, MONTH, YEARDATE and DATEDIFAdding to DatesEOMONTH and WEEKDAY
06Paste Special, Sorting and Filtering6 topics
Paste Formulas and FormatsPaste ValidationsTransposing TablesFiltering on Text, Numbers and ColoursSorting OptionsAdvanced Filters
07Printing Workbooks4 topics
Setting a Print AreaCustom Headers and FootersDesigning a Template StructurePrint Titles: Repeat Rows and Columns
08What-If Analysis4 topics
Goal SeekScenario AnalysisData Tables with the PMT FunctionSolver Tool
09Data Validation4 topics
Number, Date and Time ValidationText and List ValidationCustom Validation Using FormulasDynamic Dependent Drop-down Lists
10Lookup Functions7 topics
VLOOKUP, HLOOKUP and XLOOKUPINDEX and MATCHBuilding a Simple Lookup InterfaceNested VLOOKUPReverse Lookup Using CHOOSELinking Worksheets with INDIRECTVLOOKUP with a Helper Column
11Pivot Tables, Arrays, Charts and Slicers14 topics
Creating Simple Pivot TablesBasic and Advanced Value Field SettingsClassic Pivot Table LayoutChoosing and Filtering FieldsModifying Pivot Table DataGrouping by Numbers and DatesCalculated Fields and Calculated ItemsWhat Array Formulas Are and When to Use ThemBasic Arrays with Ctrl+Shift+EnterArrays with IF, LEN and MIDArrays with Lookup FunctionsBar, Pie and Line ChartsFiltering Data with SlicersPrimary and Secondary Axis
12Macros6 topics
Introduction to MacrosRecording a MacroManaging MacrosRunning a MacroAbsolute vs Relative RecordingDeleting a Macro
04Tools covered
Software and tools you will use
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.
05Projects
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.
06How online works
How the Advanced Excel course runs online
Pick the mode that matches where you are and what you can travel for.
Live online
Trainer-led sessions on your own computer. Same syllabus, project and certificate as classroom batches. Evening, early-morning or weekend slots in your time zone.
Hybrid
Part online, part in the lab. Take lab sessions at Vellore, Katpadi or Ranipet when you visit India, and the rest online. Depends on trainer and lab availability.
100% offline in India
Learn at our centres on any date that suits you and the trainer. Fast-track schedules possible. Partner-centre options in other cities are explored case by case.
07Class timings
Find your class time
Example slots for popular regions. Your exact timing is fixed with the trainer on WhatsApp.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| Dubai · Abu Dhabi | Weekday evening | 7:00 PM–9:00 PM | 8:30 PM–10:30 PM |
| Dubai · Abu Dhabi | Weekday early morning | 6:00 AM–8:00 AM | 7:30 AM–9:30 AM |
| Dubai · Abu Dhabi | Weekend morning | 9:00 AM–11:00 AM | 10:30 AM–12:30 PM |
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.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| London · Manchester · Birmingham | Weekday evening | 7:00 PM–9:00 PM | 12:30 AM–2:30 AM (next day) late night in Indiawinter · summer: 11:30 PM–1:30 AM late night in India |
| London · Manchester · Birmingham | Weekday early morning | 6:00 AM–8:00 AM | 11:30 AM–1:30 PMwinter · summer: 10:30 AM–12:30 PM |
| London · Manchester · Birmingham | Weekend morning | 9:00 AM–11:00 AM | 2:30 PM–4:30 PMwinter · summer: 1:30 PM–3:30 PM |
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.
| City | Slot | Your local time | India time (IST) |
|---|---|---|---|
| Singapore | Weekday evening | 7:00 PM–9:00 PM | 4:30 PM–6:30 PM |
| Singapore | Weekday early morning | 6:00 AM–8:00 AM | 3:30 AM–5:30 AM late night in India |
| Singapore | Weekend morning | 9:00 AM–11:00 AM | 6:30 AM–8:30 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.
08By country
Advanced Excel for learners in your country
09Pair it with
Related online courses
Business Accounting and Taxation
Power BI Course
Turn raw Excel sheets and database tables into clean, interactive Power BI dashboards that managers actually use.
3 levels30–60 h
Online details Office Automation
MS Office / Office Automation Course
Type, format, calculate, present and email like a confident office professional – from your first document to Excel macros.
5 levels24–128 h
Online details Business Accounting and Taxation
Tally Prime Course
Keep books, raise GST invoices, track stock, process payroll and close the year in TallyPrime – the way real offices do it.
3 levels80–110 h
Online details Special Programs
Data Analytics Course
Turn raw Excel, database and cloud data into clear Tableau charts, maps and dashboards that help people make decisions.
1 level40 h
Online details 10FAQ
Advanced Excel online – FAQ
Still have a question? Message us on WhatsApp.
Ask on WhatsAppCan I learn Advanced Excel online from outside India?
Yes. Advanced Excel is taught live online by a trainer, with the same syllabus, hours and project as the classroom batch. Batches are planned around your time zone, subject to trainer availability.
How many hours is the Advanced Excel course?
Advanced Excel is offered at 1 level (24 h): Certificate in Advanced Excel – 24 hours.
Do I need to buy the software?
We teach; we do not supply software. Use your own licence or an educational or trial licence where the maker offers one. Our Software & Licensing Policy explains the rules.
Can I attend some classes in person in India?
Yes. Hybrid and fully offline options are available at our Vellore, Katpadi and Ranipet centres on dates agreed in advance, depending on trainer and lab availability.
What does it cost?
Fees depend on the level and mode. Message +91 8111 029 125 on WhatsApp for the current fee and payment options for your country.
Will I get a certificate?
On completing the course and its project you receive the SynergySBS network certificate. It is a skill-training certificate, not a degree or a professional licence.
Start from anywhere
Get the Advanced Excel syllabus, fee and next batch
Tell us your country and preferred time. We reply on WhatsApp with the syllabus, fee and the next available batch.
- 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