Excel Next

Advanced Excel training participants across Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune, Nasik, Ahmedabad etc.

For an experienced professional, its easier to work with different techniques and formulas ofAdvanced Excelin a standalone; mode. E.g. Just V Lookup() formula or Consolidate technique.

However, you will be able to extract the Ninja-level power from the different formulas and techniques. If you can nest different formulas together and combine various techniques. E.g. V Lookup() + Match() with Indirect() and range naming will allow you to build a 3-dimensional lookup with Ninja-level data pull-up power.

Course Details

Highlights

• Essential Shortcuts
• Data Cleaning
• Data Analysis using Pivot Table
• Lookup Functions
• Aggregation Functions
• Use case of important functions
• Leveraging Google to locate readymade Macros code and editing them to automate tasks
• Non-Excel time saver tricks