Microsoft Advanced Excel Certification Course

Course Discontinued

This course is no longer available and has been discontinued

Course Description

Are you looking to take your Excel skills to the next level? If so, then the Microsoft Advanced Excel Certification Course is for you! This course will teach you the most advanced features of Excel, including PivotTables, macros, and VBA. By the end of this course, you will be able to create complex reports, automate tasks, and develop custom functions.

Course Curriculum

Day 1 : Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, Macro of Spell Number, etc.

Day 2 : Advance Table, Vlookup, X Lookup, Advance Pivot Table Features, Pivot Charts, Sparkline Chart, Macro Import Data from Tally and Web

�

Learn how to use advanced Excel features to analyze data
Create dynamic reports with pivot tables
Automate tasks with macros
Develop custom functions with VBA

What you'll learn

Master Microsoft Excel by Using Advanced Excel Features
Learn the most common Excel functions used in the Office
Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
Create dynamic reports by mastering one of the most popular tools, PivotTables
Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed
Become Master in using Advance Features Like Slicer, Flash Fill, Sparkline charts
How to Import Data from Web, Tally ODBC Server
How to Record Macro and how VBA Works

Frequently Asked Questions(FAQ)

You may call us on: 011-411-70713 or Drop us an email at contact@caclubindia.com

It will be an online live (Live Stream) class, so you can attend this class from any geographical location. It will be an interactive live session, where you can ask your doubts to the instructor (similar to our offline classroom program). You just need to have working internet and a PC/Laptop.

Recording will be available for a period of 2 Months with Unlimited View.

Meet Your Instructor

Deepak Gupta

Deepak Gupta is a Chartered Accountant having Vast Experience in the Field of Taxation, Advance Excel, Tally. He has previously worked with organisations Like Wipro, Ericsson, and Hero etc. He has written more than 1000 Articles and Delivered many sessions on the Topics like Advance Excel, Advance Tally, and Advance Dashboard. He has taken Sessions with NIRC of ICAI and Various Branches of NIRC of ICAI.