CCI Online Learning

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

with CA Deepak Gupta

Course Fees599/-

Including GST

Faculty: CA Deepak Gupta

Duration: 2 Days

Time : 7 PM to 9 PM

Language : Hinglish

Date : 27 & 28 June 2023

Validity: 2 months & Unlimited views

Share on :

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

Experienced Faculty

CA Deepak GuptaDeepak 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.

Frequently Asked Questions(FAQ)

You may call us on: 011-411-70713 or Drop us an email at

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.

Terms and Conditions:

  • The validity: 2 Months with Unlimited Views

Buy Now

Other recommended course