Pivots, lookups and charts
Summarise, combine and present data clearly with pivot tables, lookup functions and charts.
Work faster in Excel with lookups, pivot tables, validation, what-if tools and macros that take the repetition out of reports.
01Advanced Excel in Vellore
In Vellore's hospitals, colleges, shops, banks and offices, Excel is the tool people open first every morning – for attendance, billing, stock, fee collection and reports. Yet most people use only a fraction of what it can do. Our Advanced Excel course in Vellore is for office staff, accountants, administrators, teachers and graduates who want to save time and produce reports their managers trust. It is taught at the Anna Salai centre near Raja Theatre, with short, focused sessions that fit around a working day.
You start with custom and conditional formatting and data validation, so sheets stay clean and error-free. Then you use sorting, filtering, subtotals and text and date functions to organise data. Lookup functions help you pull information between sheets, and pivot tables and charts summarise it clearly. What-if analysis tools such as Goal Seek and Scenario Manager support planning, and sheet protection keeps important files safe. Finally, an introduction to macros shows how a repeated task can be done with a single click. You leave with templates you can use at work straight away.
Summarise, combine and present data clearly with pivot tables, lookup functions and charts.
Anna Salai is one of the main roads of the district headquarters, so the centre is easy to reach from almost any part of Vellore.
Vellore has arts, science, engineering and medical colleges; our batches welcome freshers, graduates and working people alike.
Pick the mode that suits you – classroom, online or a hybrid of both, depending on trainer availability for your batch.
02Visit
CareerKraft Vellore runs Livewire – Vellore and SynergySBS – Vellore (our flagship Livewire and Synergy School of Business Skills centre), plus CADD Centre – Vellore, near Raja Theatre.
The brand on the board is only the franchise name. Every CareerKraft course – CADD Centre, Livewire and SynergySBS programmes alike – is taught at all three centres, in classroom, online or hybrid mode.
No. 3/1, CSI Complex, 3rd Floor, Anna Salai, Near Raja Theatre, Vellore, Tamil Nadu 632001CADD Centre – Vellore on GoogleLivewire – Vellore on GoogleSynergy School of Business – Vellore on GoogleInstagramFacebooklivewireindia.com
03Levels
The same programmes run at every CareerKraft centre.
| Programme | Level | Hours | Syllabus |
|---|---|---|---|
| Certificate in Advanced Excel | Foundation | 24 h | 12 modules · 79 topics |
04Around Vellore
Vellore’s retailers, healthcare administrators and traders need dependable accounts, GST and reporting skills, and the city’s large student population looks for office-ready certificates. The centre’s position near the main bus stands makes weekday evening classes practical.
MIS Executive · Data Entry / Back-Office Executive · Accounts Assistant · HR Executive
05FAQ
Still have a question? The counsellor at the centre you prefer replies on WhatsApp.
Ask on WhatsAppThe centre is at No. 3/1, CSI Complex, 3rd Floor, Anna Salai, Near Raja Theatre, Vellore 632001. Call or WhatsApp 8111 029 100 before you visit and the counsellor will be ready for you.
Our Vellore centre runs the Certificate in Advanced Excel (24 hours). The counsellor will look at your background and suggest where to start.
Most working users know basic formulas. This course adds lookups, pivot tables, conditional formatting, data validation, what-if analysis and macros, which can cut the time you spend on regular reports.
Fees depend on the programme and mode you choose. The counsellor at our Vellore centre shares the current fee, any running offers and EMI options on WhatsApp at 8111 029 100.
Yes, we offer placement support – resume and portfolio help, mock interviews and job leads. We do not promise or guarantee a job; your skills and effort make the difference.
Also available at: Advanced Excel course in Katpadi · Advanced Excel course in Ranipet · Advanced Excel course overview
Start today
Fill this in and WhatsApp opens with your details, addressed to the centre you choose. The counsellor replies with the full syllabus, current fee, offers and the next batch.
Free counselling
Every course runs at all three centres.
Free
Tell us your name and we'll send the complete syllabus, fee and next batch date for your course.