Advance Excel (Working with data)

Topics Covered In Advance Excel

• Variable conditional formatting
• Excel data entry forms
• Using scroll bars and spin buttons to facilitate forms creation
• Custom number formatting in excel
• Working with cells and excel ranges
• Introduction to excel tables auto-fill, custom list, flash fill
• Excel formulas Compare Lists, Get Unique List, Get the Closest Match, Get Last Value in the List
• 2 Way and 3 Way Lookup using Index/Match
• Exploring what-if scenarios using Goal Seek
• Learn to develop data models and databases
• Pivot Table (Creating, formatting, grouping, calculation, slicer, pivot charts) Using source data from a table to make your PivotTable more dynamic
• Highlighting PivotTable results with conditional formatting
• Power Pivot
• VLOOKUP, HLOOKUP, XLOOKUP
• Functions like FORMULATEXT, N Function, ISBLANK, COUNTBLANK,
• Consolidate data, transpose data, conditional formatting
• Parsing your data to create unique lists
• Creating dynamic charts with in cell conditional formatting
• Enhancing table filtering with slicers.

Demo Video

Trainer’s Profile

Our Trainer has a unique combination of financial qualification (Chartered Accountant) and technology (Masters in Computer Science). Because of this blend, he can bring a holistic proposition to the table while advising or suggesting solutions. He has himself used technology including excel solutions for various clients with the objective of removing redundancy and creating effectiveness. He has taken many sessions on Advance Excel / PowerPoint / Blockchain / RPA etc. His unique project-driven style of sharing knowledge helps participants take maximum benefit.

He is passionate about learning and implementing new things, tools, technology. He is a regular speaker at various forums like ICAI, ACCA, CII, CMA, and Corporates. His knowledge and experience of 15+ years make him stand apart from other professionals.