Microsoft Excel - 2010 Professional

This course is a one-day training course structured into 6 modules.

Advanced Conditional Formatting

Learning outcomes

Looking at the more advanced Conditional Formatting features and how to manage them effectively.

• Editing Standard Formatting Rules
• Using Formulas in Conditional Formatting

Using Form Controls and Templates

Learning outcomes

Introducing Form controls and using them to manage user interaction to help ensure they enter/search for information both accurately and effectively.

• Using Form Controls
• Creating Templates

Advanced Lookup Functions

Learning outcomes

An in-depth look into Excel's specialist lookup functions and the concept of arrays.

• 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

Learning outcomes

Effectively using Error, Logical and Rounding functions along with array formulas.

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

Advanced Pivot Table Tools

Learning outcomes

How to import Pivot Table data from external source along with adding custom fields and formulas.

• 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

Learning outcomes

Using VBA to create specialist procedure and to define your own Excel functions.

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