Log On/Register  

855.838.5028

Excel 2010: Power Users

Duration: 1 Day, 2 Modules
Module Price: $130

This Excel Power User 2010 training course is designed for the more advanced Excel 2010 user that has attended the standard Day 1-3 trainings and is ready to take a deeper look into the features that make Excel 2010 such a popular application in business. Techniques in Data Mining and Array Functions become easy to understand during this 1 day class. This is a perfect next step for anyone that wants to become an expert Advanced Functions, Pivot Tables and Charting.

 

MODULE 1: Data Mining, Array Functions, & Advanced Conditional Formatting

 Data Mining Techniques

  • Index & Match functions versus VLOOKUP function
  • Using Index & Match functions

Array Functions

  • Entering a function as an Array versus copying
  • Entering Array functions

Creating Dynamic Ranges

How to build a dynamic Named range using the Offset function 

Advanced Conditional Formatting Techniques

  • Creating custom conditional formatting formulas

 

MODULE 2: Advanced Charting, Pivot Tables, Importing Data and Automating with VBA

Advanced Charting Techniques

  • Creating Waterfall charts
  • Creating charts from a dynamic data source
  • Using a spin control to change a chart’s data source

Advanced Pivot Table Techniques

  • Creating calculated fields and items in a Pivot Table
  • Creating Pivot Table templates

Importing Data from a Web Site

Automation Using Custom VBA Scripting

  • Enhancing macros with VBA scripting

This Excel Power User 2010 training course is designed for the more advanced Excel 2010 user that has attended the standard Day 1-3 trainings and is ready to take a deeper look into the features that make Excel 2010 such a popular application in business. Techniques in Data Mining and Array Functions become easy to understand during this 1 day class. This is a perfect next step for anyone that wants to become an expert Advanced Functions, Pivot Tables and Charting.

 

MODULE 1: Data Mining, Array Functions, & Advanced Conditional Formatting

 Data Mining Techniques

  • Index & Match functions versus VLOOKUP function
  • Using Index & Match functions

Array Functions

  • Entering a function as an Array versus copying
  • Entering Array functions

Creating Dynamic Ranges

How to build a dynamic Named range using the Offset function 

Advanced Conditional Formatting Techniques

  • Creating custom conditional formatting formulas

 

MODULE 2: Advanced Charting, Pivot Tables, Importing Data and Automating with VBA

Advanced Charting Techniques

  • Creating Waterfall charts
  • Creating charts from a dynamic data source
  • Using a spin control to change a chart’s data source

Advanced Pivot Table Techniques

  • Creating calculated fields and items in a Pivot Table
  • Creating Pivot Table templates

Importing Data from a Web Site

Automation Using Custom VBA Scripting

  • Enhancing macros with VBA scripting

Knowledge of Microsoft Office Excel, topics covered in Modules 1-6; understanding of financial & statistical formulas.

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):