State of Wyoming A&I Human Resources Division

Calendar Event: EXCEL Level 3

• Location:Emerson Building Room B11 Lab 1
• Start Time:5/16/2012 8:30 AM
• End Time:5/16/2012 4:00 PM
• Description:
  LESSON 1 - CREATING CHARTS
  Using Charts
  Creating Charts
  Moving and Resizing Charts
  Identifying Chart Elements
  Changing the Chart Type
  Changing the Plot Direction
  Removing/Adding a Legend
  Moving the Legend
  Charting Non-adjacent Ranges
  Changing the Chart Range
  Changing the Data Source
  Changing the Chart Location
  Printing a Chart
  LESSON 2 - FORMATTING CHARTS
  Formatting Charts
  Adding Chart Titles
  Formatting Chart Elements
  Changing the Text Orientation
  Adding a Data Table
  Creating an Exploded Pie Chart
  Adjusting the 3-D View
  Deleting a Chart
  LESSON 3 - USING ADVANCED CHARTING FEATURES
  Adding and Removing Gridlines
  Formatting Gridlines
  Formatting an Axis
  Changing the Axis Scaling
  Formatting the Data Series
  Adding Data from Different Worksheets
  Using a Secondary Axis
  Changing Data Series Chart Types
  Adding a Trendline
  Creating a Chart Template
  Applying a Chart Template
  LESSON 4 - DRAWING AN OBJECT
  Working with Drawing Objects
  Drawing Enclosed Objects
  Drawing a Line
  Selecting Filled and Unfilled Objects
  Moving an Object
  Adding Text to an Object
  Selecting Text in an Object
  Resizing an Object
  Formatting Lines
  Changing and Removing the Fill Color
  Changing the Font Color
  Deleting an Object
  LESSON 5 - USING ADDITIONAL EFFECTS AND OBJECTS
  Adding a 3-D Effect
  Applying a 3-D Setting
  Adding a Shadow
  Drawing a Text Box
  Drawing an Arrow
  Inserting Pictures
  Formatting Graphics
  LESSON 6 - USING SHAPES AND SMARTART
  Working with Shapes
  Drawing a Callout
  Drawing a Basic Shape
  Working with Connectors
  Drawing a Flowchart Shape
  Drawing a Block Arrow
  Adding SmartArt
  Working with SmartArt
  LESSON 7 - WORKING WITH TABLES
  Using Tables
  Creating a Table from Existing Data
  Changing the Table Name
  Changing the Table Style
  Changing Table Style Options
  Creating a Total Row
  Adding Table Rows and Columns
  Inserting/Deleting Table Rows/Columns
  Creating a Calculated Column
  Selecting Parts of a Table
  Moving a Table
  Sorting Data by Multiple Levels
  Using Text Filters
  Using Number Filters
  Using Data Validation
  Validating Data using a List
  Creating a Custom Error Message
  Removing Data Validation
  LESSON 8 - WORKING WITH ADVANCED FILTERS
  Creating a Criteria Range
  Using a Criteria Range
  Showing All Records
  Using Comparison Criteria
  Using an Advanced And Condition
  Using an Advanced Or Condition
  Copying Filtered Records
  Using Database Functions
  Finding Unique Records
  Removing Duplicates from a Table
  LESSON 9 - EXPORTING AND IMPORTING DATA
  Exporting Data to Other Applications
  Importing Data from Access
  Importing Data from Text Files
  Changing External Data Range Properties
  Importing Data from Other Applications
  Removing the Query Definition
  Importing Dynamic Data from theWeb
  Copying a Table from a Web Page
  LESSON 10 - WORKINGWITH OUTLINES
  Applying an Outline
  Collapsing/Expanding an Outline
  Modifying Outline Settings
  Using Auto Outline
  Clearing an Outline
  Creating Subtotals in a List
  Removing Subtotals from a List
• Category:Training