Face to Face/ Online Advanced Excel Course with Certificate

The real power of Microsoft Excel lies in the advanced functionality it offers. Having been designated as one of the prerequisites expected from the aspiring candidates aiming to join the industry, Microsoft Advanced Excel course is considered to be an indispensable Management Information Systems (MIS) tool employed by the end-users.

Oxford School of Accounting provides the best basic to advanced Excel course with job opportunities and a certificate. Being a partner in Microsoft Edu-Cloud Program, we are one of the best institutes in Delhi for advanced Excel online or face to face course. If you are looking for the Advance Excel certificate course near me that can get you employed in the industry, or best Advanced Excel institute near me in Delhi or Advanced Excel classes near me, your search surely ends here.

Whether there are basic tasks like entering data, saving and opening sheets, formatting content and creating formulas or advanced tasks like manipulating data with Pivot Tables, handling complex and large calculations, presenting data with charts and drawing up advanced analysis reports, our Advanced Excel Classes will help you THINK in Excel. We offer advanced Excel Course Online or you can join our Excel Classes face to face.

For any kind of Advanced Excel training related query, you can visit our centre or call us on the numbers given on our website.

Course Content

Introduction to Microsoft Excel

User InterfaceEntering DataFormatting Text & DataConditional FormattingValidations

Views and Layout

Pick from Drop-Down ListExcel SlicerSmart LookupZooming and Zoom SelectionPage Layouts

Formula & Functions

Logical FormulasNesting of FormulasMathematical FormulasDate and Time FormulasText Formulas

Advance Functions- Validation

Financial FormulasInformational Formulas with LookupWildcard SearchArrays & Index MatchIndirect Functions

Data Mining-Reporting

Pivot TablesPivot ChartsData ModellingPower PivotWhat if Analysis, Goal Seek, Scenario Manager, Data Table

Automation

MacrosSmart PrintingHeader FooterCustom Page LayoutsSharing and Protecting Workbooks

Certifications**

During this course, students will be trained for the following certifications

Microsoft Office SpecialistOxford Certified Excel Professional

0