Excel Advanced Training

Please respond to all topics you regularly use and for all the corresponding topics rate your level of comfort (5 being extremely comfortable, 3 being mildly comfortable and 1 being not very comfortable). This will enable the instructor to cover the areas where we need help.
Name: 


  1. Unit 1 Advanced functions
    Topic A: Logical functions
    1 2 3 4 5


  1. Unit 1: Advanced functions
    Topic B: Math and statistical functions
    1 2 3 4 5


  1. Unit 1: Advanced functions
    Topic C: Financial functions
    1 2 3 4 5


  1. Unit 1: Advanced functions
    Topic D: Displaying and printing formulas
    1 2 3 4 5


  1. Unit 2: Lookups and data tables
    Topic A: Using lookup functions
    1 2 3 4 5


  1. Unit 2: Lookups and data tables
    Topic B: Using MATCH and INDEX

    1 2 3 4 5


  1. Unit 2: Lookups and data tables
    Topic C: Creating data tables
    1 2 3 4 5


  1. Unit 3 Advanced list management
    Topic A: Validating cell entries
    1 2 3 4 5


  1. Unit 3 Advanced list management
    Topic B: Exploring database functions
    1 2 3 4 5


  1. Unit 4 PivotTables and PivotCharts
    Topic A: Working with PivotTables
    1 2 3 4 5


  1. Unit 4 PivotTables and PivotCharts
    Topic B: Rearranging PivotTables
    1 2 3 4 5


  1. Unit 4 PivotTables and PivotCharts
    Topic C: Formatting PivotTables
    1 2 3 4 5


  1. Unit 4 PivotTables and PivotCharts
    Topic D: PivotCharts
    1 2 3 4 5


  1. Unit 5 Exporting and importing
    Topic A: Exporting and importing text files
    1 2 3 4 5


  1. Unit 5 Exporting and importing
    Topic B: Exporting and importing XML data
    1 2 3 4 5


  1. Unit 5 Exporting and importing
    Topic C: Querying external databases
    1 2 3 4 5


  1. Unit 6 Analytical options
    Topic A: Goal Seek and Solver
    1 2 3 4 5


  1. Unit 6 Analytical options
    Topic B: The Analysis ToolPak
    1 2 3 4 5


  1. Unit 6 Analytical options
    Topic C: Scenarios
    1 2 3 4 5


  1. Unit 6 Analytical options
    Topic D: Views
    1 2 3 4 5


  1. Unit 7 Macros and custom functions
    Topic A: Running and recording a macro

    1 2 3 4 5


  1. Unit 7 Macros and custom functions
    Topic B: Working with VBA code

    1 2 3 4 5


  1. Unit 7 Macros and custom functions
    Topic C: Creating functions

    1 2 3 4 5


  1. Unit 8 Conditional formatting and SmartArt
    Topic A: Conditional formatting with graphics
    1 2 3 4 5


  1. Unit 8 Conditional formatting and SmartArt
    Topic B: SmartArt graphics
    1 2 3 4 5


  1. Select your department.
    Buildings and Grounds
    Business
    Community Relations/Foundation
    Curriculum
    Personnel
    Student Services
    Technology





Cathy Baker