Microsoft Excel

Excel Professional (2007, 2010 & 2013)


Product Description

​This interactive one-day training course has been designed for delegates with a solid understanding of, and experience with, Microsoft Excel 2007, 2010 or 2013 who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advanced courses.

Enquire Now!

This course covers Microsoft Excel 2007, 2010 and 2013.

Content covered:

Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Using Formulas in Conditional Formatting
  • Using Form Controls and Templates
  • Using Form Controls
  • Creating Templates

Advanced Lookup Functions

  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using Index and Match with Array Formula
  • Using the Indirect Function

Advanced Functions in Excel

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

Advanced Pivot Table Tools

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

Introduction to User Defined Functions Using VBA

  • Creating a User Defined Function
  • Creating an Interactive Procedure
  • Create and Share a Function Add-in


There are no reviews yet.

Be the first to review “Excel Professional (2007, 2010 & 2013)”