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
DiscontinuedMaster 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
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
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.