Course Details

Top Advanced Microsoft Excel Course 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
  • 3-D References Formula

• Functions

  • PMT (Payment)
  • FV (Future Value)
  • IF, AND, & OR

• Looking Up Functions

  • VLOOKUP
  • HLOOKUP

• What-If Analysis

  • Data Tables
  • Goal Seek

• Pivot Tables and Pivot Charts

  • Data Slicer with a Pivot Table

• Advanced Charting Features