State of Wyoming A&I Human Resources Division

Calendar Event: EXCEL Level 2

• Location:Emerson Building Room B11
• Start Time:5/15/2012 8:30 AM
• End Time:5/15/2012 4:00 PM
• Description:
  LESSON 1 - WORKING WITH COLUMNS AND ROWS
  Selecting Columns and Rows
  Using Narrow Column Tooltips
  Changing the Width of Columns
  Changing the Height of Rows
  Adjusting Columns Automatically
  Hiding Columns and Rows
  Unhiding Columns and Rows
  Inserting a Column
  Insert a Row
  Deleting a Column
  Deleting a Row
  LESSON 2 - USING AUTOMATIC FORMATTING AND STYLES
  Using Automatic Formatting Features
  Applying an AutoFormat
  Extending List Formats and Formulas
  Applying a Predefined Style
  Creating a Style by Example
  Applying a Style
  Creating a New Style
  Editing an Existing Style
  Merging Styles
  LESSON 3 - USING LARGE WORKSHEETS
  Increasing the Magnification
  Decreasing the Magnification
  Changing the Magnification of a Range
  Switching to Full Screen View
  Splitting the Window
  Removing Split Windows
  Freezing the Panes
  Unfreezing the Panes
  LESSON 4 - WORKING WITH MULTIPLE WORKSHEETS
  Using Multiple Worksheets
  Navigating between Worksheets
  Selecting Worksheets
  Renaming Worksheets
  Selecting Multiple Worksheets
  Coloring Worksheet Tabs
  Inserting Worksheets
  Deleting Worksheets
  Printing Selected Worksheets
  LESSON 5 - MANAGING WORKSHEETS
  Copying Worksheets
  Moving Worksheets
  Using Grouped Worksheets
  Moving Data between Worksheets
  Copying Data between Worksheets
  Creating 3-D Formulas
  Using 3-D Ranges in Functions
  LESSON 6 - USING RANGE NAMES
  Working with Range Names
  Jumping to a Named Range
  Assigning Names
  Using Range Names in Formulas
  Creating Range Names from Headings
  Applying Range Names
  Deleting Range Names
  Using Range Names in 3-D Formulas
  Creating 3-D Range Names
  Using 3-D Range Names in Formulas
  LESSON 7 - USING OTHER FUNCTIONS
  Using Function Arguments
  Using Financial Functions
  Using Logical Functions
  Using Date Functions
  Formatting Dates
  Revising Formulas
  LESSON 8 - MANAGING DATA
  Sorting Lists
  Sorting in Ascending/Descending Order
  Finding Data
  Replacing Data
  Finding and Replacing Cell Formats
  LESSON 9 - USING AUTOFILTER
  Enabling AutoFilter
  Using AutoFilter to Filter a List
  Clearing AutoFilter Criteria
  Creating a Custom AutoFilter
  Disabling AutoFilter
  LESSON 10 - WORKING WITH COMMENTS
  Creating Comments
  Viewing a Comment
  Reviewing Comments
  Printing Comments
  Responding to Discussion Comments
  
• Category:Training