Log On/Register  

855.838.5028

Excel 2013: Power User

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

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

 

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

 

Prerequisites: 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):