Course Details

Advance Excel training is just what you’ll need to increase your excel training skills confidence and take your current excel skills to the advance level. The excel advance skills you’ll gain in this one Week training is more practical in less time to use at your work place. Excel 2013 Advance training provides you to work with hands-on exercises without wasting your valuable time.Your training manual provides all the exercises to try for practicing later at your convenience. Participants will get course manual and Completion Certificate.

Topics Covered:

• Advanced Filtering - Subtotal - Consolidate data in multiple worksheets by position, by category and 3-D references formula-Functions PMT, FV, IF, AND & OR - Looking up function VLOOKUP & HLOOKUP - What if Analysis - Data Tables - Goal Seek - Pivot Tables and Pivot Charts - Data Slicer with a Pivot Table - Advanced Charting features.