Certification Course Microsoft Advanced Excel Certification Course to Become Zero to Hero In Your Organisation by Deepak Gupta

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

Course Content

Day 1 - Advanced Excel Functions :

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

Day 2 - Advanced Excel Functions :

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

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.