State of Wyoming A&I Human Resources Division

Calendar Event: EXCEL Level 5

• Location:Emerson Building Room B11 Lab 1
• Start Time:5/18/2012 8:30 AM
• End Time:5/18/2012 4:00 PM
• Description:
  LESSON 1 - WORKING WITH VIEWS
  Using Views
  Creating a Normal View
  Creating a Custom View
  Displaying a View
  Deleting a Custom View
  LESSON 2 - USING SCENARIOS AND GOAL SEEKING
  Using the Scenario Manager
  Creating a Scenario
  Displaying a Scenario
  Editing a Scenario
  Creating a Scenario Summary Report
  Using Goal Seek
  LESSON 3 - SOLVING PROBLEMS
  Using Solver
  Saving a Solution as a Scenario
  Restoring the Original Values
  Changing a Constraint
  Creating a Solver Report
  Viewing Solutions using Scenarios
  LESSON 4 - USING AUDITING TOOLS
  Showing Formulas
  Displaying/Removing Dependent Arrows
  Displaying/Removing Precedent Arrows
  Using the Trace Error Button
  Tracing Cells Causing Errors
  Using the Evaluate Formula Button
  Using the Error Checking Button
  Using the Watch Window
  LESSON 5 - CREATING/REVISING PIVOT TABLES
  Creating a PivotTable Report
  Adding PivotTable Report Fields
  Selecting a Report Filter Field Item
  Refreshing a PivotTable Report
  Changing the Summary Function
  Adding New Fields to a PivotTable Report
  Moving PivotTable Report Fields
  Using Expand and Collapse Buttons
  Hiding/Unhiding PivotTable Report Items
  Deleting PivotTable Report Fields
  Creating Report Filter Pages
  Formatting a PivotTable Report
  Creating a PivotChart Report
  Publishing PivotTable Reports to the Web
  LESSON 6 - CONSOLIDATING WORKSHEETS
  Using Consolidated Worksheets
  Consolidating by Category
  Consolidating by Position
  LESSON 7 - USING MACROS
  Defining Macros
  Changing Macro Security Settings
  Adding a Folder as a Trusted Location
  Opening a Workbook Containing Macros
  Running a Macro
  Using a Shortcut Key
  Displaying the Developer Tab
  Opening the Visual Basic Editor Window
  Using the Visual Basic Editor Window
  LESSON 8 - RECORDING MACROS
  Recording a Macro
  Assigning a Shortcut Key
  Using Relative References
  Deleting a Macro
  LESSON 9 - EDITING MACROS
  Writing a New Macro
  Entering Macro Comments
  Copying Macro Commands
  Editing Macro Commands
  Typing Macro Commands
  Running a Macro from the Code Window
  LESSON 10 - CREATING MACRO BUTTONS
  Using a Macro Button
  Creating a Macro Button
  Copying a Macro Button
  Formatting a Macro Button
  Moving/Sizing a Macro Button
  Deleting a Macro Button
  Adding a Macro to the Quick Access Toolbar
  Changing a QAT Macro Button Image
  Deleting a Macro Button from the QAT
  LESSON 11 - CUSTOMIZING EXCEL PREFERENCES
  Setting Edit Options
  Setting Display Options
  Setting Manual Calculation
  Resetting Automatic Calculation
  Setting Popular Options
• Category:Training