Learn advanced Excel: XLOOKUP, nested functions, PivotTables, what-if analysis, macros and advanced charts.
Talk to our counsellor — choose the right course, batch time and mode.
Join at a CADD centre near you or online. You get your student login and ID card.
24 Hours of hands-on MOS: Microsoft Office Excel Expert classes — in the classroom or live online.
Exercises in every class and a final project, checked by your trainer.
Finish the course and get your course-completion certificate and a digital completion badge with your name.
Take the certification exam: a theory test and a practical task — at the centre or online.
Pass the exam and get the certified certificate with your marksheet. Anyone can check it online with its QR code.
Your certified badge — add it to LinkedIn and share it anywhere; it opens its own verify page.
Make your CV in your student panel (Career → My CV) — your course, certificates and projects are added for you. Send it as a link with a preview picture, and apply to jobs and Hire Me requests from companies.
Microsoft Excel is the standard tool for working with numbers in business. Accountants, analysts, MIS teams, engineers and managers use its advanced features to clean large data sets, build reports, compare scenarios and automate repetitive work, which makes advanced Excel one of the most requested office skills.
This 24-hour MOS Excel Expert course builds on Excel Associate skills and follows the skill areas of the Microsoft Office Specialist Excel Expert objectives. You learn workbook options, protection and links between workbooks; custom number formats, advanced conditional formatting and data validation; and logical and lookup functions such as IFS, SWITCH, SUMIFS, COUNTIFS, MAXIFS, XLOOKUP, INDEX and MATCH. You then use Goal Seek, Scenario Manager, Consolidate and financial functions such as PMT, audit formulas with Trace Precedents, Evaluate Formula and the Watch Window, record simple macros, and build PivotTables, PivotCharts with slicers, and advanced charts such as combo, waterfall and histogram. Training is hands-on with business data, in the classroom at CADD centres or in live online classes.
These skills support MIS executive, data analyst, accounts and finance roles. Your counsellor can advise on taking the Microsoft Office Specialist exam.
Students rate the course after they finish it — their ratings appear here.
The course covers workbook management and protection, advanced data formatting and validation, nested and lookup functions, what-if analysis, formula auditing, macros, PivotTables, PivotCharts and advanced chart types.
Yes. Excel Expert assumes you already handle formulas, tables and charts confidently. If you are new to Excel, start with MOS Excel Associate.
The MOS Excel Expert course is 24 hours long and is built around exercises on real business data such as sales, payroll-style and inventory sheets.
Yes. Besides classroom training at CADD centres, MOS Excel Expert runs as live online classes in which you practise on business data on your own computer with trainer support.
Yes. A CADD Training Centre certificate is issued when you finish the MOS Excel Expert course, and an MIS or finance employer can check it online by scanning its QR code. The counsellor can also guide you on the Microsoft Office Specialist exam.
Advanced Excel is expected for MIS executive, data analyst, financial analyst, accounts executive, operations coordinator and reporting roles in almost every industry.
VLOOKUP searches only the first column of a range and returns a value to its right. XLOOKUP can look in any direction, returns exact matches by default and handles missing values neatly, so it is more flexible.
More questions? Ask our counsellor or read the general FAQ.
Azure Fundamentals
MCE: Microsoft Certified Educator
Microsoft 365 Fundamentals
Microsoft Dynamics 365 Fundamentals
MOS: Microsoft Office Access Associate
MOS: Microsoft Office Access Expert
MOS: Microsoft Office Excel Associate
MOS: Microsoft Office Outlook Associate
