ADVANCED EXCEL COURSE
Training Duration: 1 Day Course and 2 Day Course
Training Fees: ₹8000 onwards
Pre-requisite: Good knowledge of Excel. The learners should be well versed with features like vlookup and if functions, basic pivot tables, sort and filter, etc. Expert knowledge of Excel is not necessary.

Why walk when we have a car in the garage?
All of us have MS Excel on our machines. But the million dollar question is, are we really using it well? Are we truly unleashing its larger potential or are we only using a small fraction of its capabilities?

Time has come for us to sharpen our skills. We are delighted to present to you a completely action packed one full day’s training on Advanced Excel. Let’s learn how we can finish tasks hitherto taking hours, now within minutes or seconds. Keeping accuracy levels flying high.

Course Outline (1 Day Program)

  • Working with Data and Data Analytics
    • Advanced Pivot Tables: Group pivot table elements, insert calculated fields and calculated items, create report filter pages, insert slicers and timeline, customise pivot table options
    • Flash Fill: Automatically fill values based on data patterns, using sample value provided by the user
  • What-if Analysis
    • Goal seek: Perform trial and error calculations
  • Creating Visualizations
    • Advanced Conditional Formatting: Categorise numerical fields using colour scales, cell icons and data bars
    • New Charts: Insert new varieties of charts like Map chart, Funnel chart, Waterfall chart, Combo chart etc
  • Functions
    • Xlookup: Use the new xlookup function instead of vlookup to perform lookups in a more powerful way
    • Ifs: Use Ifs function instead of if function in the situation of nested-if
    • Textjoin and Concat: Use these functions instead of concatenate function to combine texts in a more efficient way
    • Maxifs and Minifs: Obtain conditional max and min values
    • Array Formulas: Create excel formulas involving arrays instead of individual cells and be more efficient
    • Getpivotdata: Extract values from a Pivot Table. More reliable than Vlookup in the context of Pivot Tables, while building dashboards etc

Course Outline (2 Day Program)

  • Working with Data and Data Analytics
    • Get and Transform Data (aka Power Query): Import data from varied formats and cleanse it neatly before loading the same into the worksheet
    • Introduction to Power Pivot Add-in: Import millions of records spread across multiple tables into Excel’s Data Model. Build customized measures. Finally, summarise with Pivot Tables using fields from different tables and measures.
    • Advanced Pivot Tables: Group pivot table elements, insert calculated fields and calculated items, create report filter pages, insert slicers and timeline, customise pivot table options
    • Flash Fill: Automatically fill values based on data patterns, using sample value provided by the user
  • What-if Analysis
    • Goal seek: Perform trial and error calculations
  • Fuzzy Lookup Addin: Achieve fuzzy matching of values. For example, match Ram Sharma with Mr Sharma, R. Helpful during lookups with similar but not same lookup values.
  • Creating Visualizations
    • Advanced Conditional Formatting: Categorise numerical fields using colour scales, cell icons and data bars
    • New Charts: Insert new varieties of charts like Map chart, Funnel chart, Waterfall chart, Combo chart etc
    • Sparklines: Draw miniature charts fitted in single cells for multiple series of values
  • Functions
    • Xlookup: Use the new xlookup function instead of vlookup to perform lookups in a more powerful way
    • Ifs: Use Ifs function instead of if function in the situation of nested-if
    • Textjoin and Concat: Use these functions instead of concatenate function to combine texts in a more efficient way
    • Maxifs and Minifs: Obtain conditional max and min values
    • Array Formulas: Create excel formulas involving arrays instead of individual cells and be more efficient
    • Getpivotdata: Extract values from a Pivot Table. More reliable than Vlookup in the context of Pivot Tables, while building dashboards etc
    • 3D Lookups: Build more efficient lookup formulas by letting the lookup value, table array and column index, all three to be dynamic
    • Datedif: Compute difference between two dates in terms of completed months, years, etc
    • Eomonth: Derive the month end date for a given date

Advantages:

  • Learn the advanced features and extract more value out of your Excel.
  • Speaker is CA | CFA | CISA qualified Mr Nachiket Pendharkar with 18 years of work-ex. Learn from the master and benefit from his expertise.
  • Create Excel templates. Achieve higher accuracy with less time.
  • Learn handy keyboard shortcuts and work in a flash!
  • Be the most sought after executive with tremendous skill.

TRAINER

Nachiket Pendharkar
(CA, CFA, Microsoft Certified Master Trainer)

Register Today!

Note: Your information will be used to send you this and other relevant offers by email. We will never sell your information to any third parties. You can, of course, unsubscribe at any time.