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 : 22 & 23 December 2023

Recording Validity: 2 months & Unlimited views

Share on :

Course Key Features

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

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.

Terms and Conditions:

  • The validity: 2 Months with Unlimited Views

Buy Now

Other recommended course