Faculty: CA Deepak Gupta
Duration: 6 hours
Validity: 2 months & Unlimited Views
Buy NowMaster Microsoft Excel by Using Advanced FeaturesLearn the most common Excel functions used in the OfficeWow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many moreCreate dynamic reports by mastering one of the most popular tools, PivotTablesMaster unique tips, tools and case studies that you won't find in ANY other course, guaranteedBecome Master in using Advanced Features Like Slicer, Flash Fill, Sparkline chartsHow to Import Data from Web, Tally ODBC ServerHow to Record Macro and how VBA Works
In our continuous endeavor to empower more and more finance professionals,this Microsoft Excel certification course has been designed for you. A Detailed 3 Days Advance Excel course has been designed where daily more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Excel Files.
Class 1
Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, Goto Special, Macro of Spell Number, etc.
Class 2
Advance Table, Vlookup, X Lookup, Advance Pivot Table Features, Pivot Charts, Sparkline Chart, Concatenate & Text Join, Giving password to excel and back up, Advanced Find & Replace, Smart Sorting, Skip Blank.
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.