Overview
About the Advanced Excel course
Advanced Excel is a 1-month certificate course at Krishna Computers Education, taught in person at our branches in Surat, Kadodara, Bardoli and Navsari. Formulas, lookups, pivot tables, charts and MIS reports: the Excel skills office and back-office jobs ask for.
Software you will use:
Microsoft Excel
Syllabus
Week by week
-
Week 1Formulas and functions for office work: IF, COUNTIF, SUMIF, text and date functions
-
Week 1Lookups: VLOOKUP, XLOOKUP and INDEX-MATCH
-
Week 2Sorting, filters, data validation and conditional formatting
-
Week 3Pivot tables and charts
-
Week 4MIS reports and a simple dashboard
Who it's for
Students after 12th, graduates, and working staff who prepare reports or handle data. You should already know basic computer use.
Jobs it leads to
MIS executive
Back-office and data executive
Sales coordinator
Certificate
A certificate employers can check online.
After the practical exam you get a numbered certificate with a QR code. Anyone can confirm it on our Verify certificate page in seconds.
How verification works →Questions
Advanced Excel: common questions
Yes, if you already know basic computer use. The month is daily practice on real office data, from formulas and lookups to pivot tables and MIS reports. If you are new to computers, start with Basic Computer.
Basic Excel covers entering data, simple formulas and formatting. Advanced Excel adds the tools used for reports: lookups such as VLOOKUP and XLOOKUP, pivot tables, conditional formatting, data validation and dashboards.
1 month. Classes run Monday to Saturday in one-hour batches that start every hour through the morning (7:00 – 12:00), afternoon (12:00 – 4:00) and evening (4:00 – 10:00), so you can fit them around school, college or work.
The counsellor shares the current fee and installment plan when you enquire. Every course can be paid in parts, with receipts on WhatsApp.
Yes. After the practical exam you receive a certificate from Krishna Computers Education. It carries a unique number that any employer can check on our Verify certificate page.
Enquire at our Kadodara branch, and we will tell you where and when the next batch starts. You can sit in on a free demo class before you join.
Other courses
Tally Prime with GSTAccounts & office · 3 months
Basic ComputerComputer basics · 2.5 months
CCCComputer basics · 2.5 months
Spoken EnglishSpoken English · 3 months
Textile Mill Print DesignTextile design · 3 months
Digital Print DesignTextile design · 3 months
Position Print DesignTextile design · 3 months
Embroidery DesignTextile design · 6 months
Beads DesignTextile design · 3 months
Jacquard DesignTextile design · 6 months
Graphic DesignGraphic design & AI · 6 months
AI Master CourseGraphic design & AI · 2 months
UI/UX DesignGraphic design & AI · 3 months
Digital Marketing with AIGraphic design & AI · 3 months
C and C++ ProgrammingProgramming & web · 3 months
Python ProgrammingProgramming & web · 3 months
Web DesignProgramming & web · 3 months
Not sure which course fits?
A counsellor from your nearest branch will call you back.