Home / Courses / Microsoft End User / Excel 2010: Vlookups, PivotTables and Macros

Microsoft End User

 

Excel

Excel 2010: Vlookups, PivotTables and Macros

CREATING VLOOKUPS WITH DATA

  • Configuring your Data List
  • Opening the VLOOKUP dialog box
  • The Lookup Value
  • The Table Array
  • The Column Index Number
  • The Range Lookup
  • Using the VLOOKUP Function
  • Excel VLOOKUP Error Messages
 
CREATING A PIVOT TABLE
  • Defining Correct Data Source Design
  • Preparing Data for PivotTable Reporting
  • Working with Value, Row, Column and Report Filter Areas
  • Limitations of Pivot Table reports Understanding PivotTables Design
  • Understanding the PivotTable Shell
  • PivotTable Layout Options
  • Adding Fields to the PivotTable
  • Changing the Field Layout
  • Using Multiple Fields in Column or Row Layout
 
GROUPING SORTING AND FILTERING PIVOTTABLE DATA
  • Grouping Text Pivot Fields
  • Grouping Date Pivot Fields
  • Sorting in a Pivot Table
  • Filtering the Pivot Table
  • Filtering using the Report Filter Area
  • Using Slicers to Filter Data
 
CREATING MACROS IN EXCEL
  • Defining the Goal of the Macro
  • Documenting the Macro Steps
  • Recording the Macro
  • Saving the Macro – Making it Accessible
  • Running the Macro Safely
  • Editing and Debugging the Macro
  • Creating a Macro Library

 

Course Registration

 

1/2 day
$225.00

 

Course Outline

 

Request