State of Wyoming A&I Human Resources Division

Calendar Event: EXCEL Level 4

• Location:Emerson Building Room B11 Lab 1
• Start Time:5/17/2012 8:30 AM
• End Time:5/17/2012 4:00 PM
• Description:
  LESSON 1 - USING ADVANCED FUNCTIONS
  Using Lookup Functions
  Using the VLOOKUP Function
  Using the HLOOKUP Function
  Using the IF Function
  Using Nested IF Functions
  Using the ISERROR Function
  Using an AND Condition with IF
  Using an OR Condition with IF
  Using the ROUND Function
  Limiting the Precision of Numbers
  LESSON 2 - USING CONDITIONAL AND CUSTOM FORMATS
  Applying Conditional Formats
  Changing a Conditional Format
  Adding a Conditional Format
  Creating a Custom Conditional Format
  Using Data Bars
  Deleting a Conditional Format
  Creating a Custom Number Format
  LESSON 3 - USING WORKSHEET PROTECTION
  Unlocking Cells in a Worksheet
  Protecting a Worksheet
  Unprotecting a Worksheet
  Creating Allow-Editing Ranges
  Deleting Allow-Editing Ranges
  Protecting Workbook Windows
  Unprotecting Workbook Windows
  Assigning a Password
  Opening a Password-protected File
  Removing a Password
  LESSON 4 - USING TEMPLATES
  Working with Templates
  Saving a Workbook as a Template
  Using a Template
  Editing a Template
  Inserting a New Worksheet
  Deleting a Template
  Creating Default Templates
  Finding Online Templates
  LESSON 5 - USING PASTE SPECIAL
  Working with Paste Special
  Copying Values between Worksheets
  Copying Formulas between Worksheets
  Performing Mathematical Operations
  LESSON 6 - USING MULTIPLE WORKBOOKS
  Opening Multiple Workbook Windows
  Cascading Open Workbook Windows
  Activating Cascaded Workbook Windows
  Tiling Open Workbook Windows
  Activating Tiled Workbook Windows
  Comparing Workbooks Side by Side
  Copying Data between Workbooks
  Saving a Workspace
  Closing All Open Workbooks
  Opening a Workspace
  Linking Workbooks
  Opening Linked Workbooks
  LESSON 7 - SHARINGWORKBOOKS
  Using Shared Workbooks
  Saving a Shared Workbook
  Viewing Users Sharing a Workbook
  Viewing Shared Workbook Changes
  Changing the Update Frequency
  Highlighting Changes
  Managing Conflicting Changes
  Resolving Conflicting Changes
  Setting Change History Options
  Adding a History Worksheet
  Reviewing Tracked Changes
  Merging Shared Workbook Files
  LESSON 8 - WORKING WITH DATA SERIES
  Using the Series Command
  Creating a Linear Series
  Creating a Date Series
  Using a Stop Value
  Creating a Growth Trend Series
  LESSON 9 - USING DATA TABLES
  Working with Data Tables
  Placing Formulas in Data Tables
  Creating a One-Variable Table
  Creating a Two-Variable Tab
• Category:Training