Course Overview
This course is designed to expand on the skills learned in the Introduction to Excel 2007 training. Specifically, this class will focus on using multiple sheets in a workbook, the advantages of working with range names, creating and applying spreadsheet templates, using the outline features and creating subtotals, and understanding all the options found in Paste Special. A significant amount of the course will be spent covering creating and manipulating charts and using drawing tools to annotate charts and spreadsheets.
Course Objectives
Workbooks, Range Names, Working with Outlines and Subtotals, Using Paste Special, Charts, Drawing Objects, Creating Hyperlinks, Working with Templates
Agenda
1 - Introduction
2 - Workbooks
- Navigate, Name, and Color Worksheets
- Naming Worksheets
- Setting the Tab Color
- Inserting and Deleting Worksheets
- Moving and Copying Worksheets
- Moving a Sheet to Another Workbook
- Grouping Worksheets
- Formatting Grouped Worksheets
- Entering 3D Formulas
- Using the Watch Window
- Anchoring the Watch Window
3 - Range Names
- Viewing Rules for Range Names
- Naming a Range of Cells
- Moving to a Range Name
- Creating a Range Name from Headings
- Name Manager
- Performing Calculations with Range Names
- Creating 3D Range Names
- Using Range Names in 3D Formulas
4 - Working with Outlines and Subtotals
- Applying an Outline Manually
- Applying an Automatic Outline
- Expanding and Collapsing an Outline
- Clearing an Outline
- Creating Subtotals
- Changing the Function Used in Subtotals
- Clearing Subtotals
5 - Using Paste Special
- Pasting with No Borders
- Transposing
- Paste Values
- Linking Worksheets and Workbooks
- Using the Arrange Windows Tool
6 - Charts
- Creating an Embedded Chart
- Moving a Chart to a Separate Sheet
- Selecting Chart Designs and Styles
- Changing the Chart Type
- Switching Row/Column Data
- Selecting a Chart Layout
- Using Chart Titles and Axis Labels
- Creating a Chart Legend, Data Labels, and a Data Table
- Formatting the Chart Axis
7 - Drawing Objects
- Inserting a Text Box
- Adding and Formatting Shapes
- Using Connector Lines
- Adding Shape Effects and Styles
8 - Creating Hyperlinks
- Using Hyperlinks
- Linking to a Named Range
- Linking to a Specific Cell
- Linking to a URL
- Linking to an External File
9 - Working with Templates
- Using an Existing Template
- Modifying a Template
- Saving a Template
- Opening a Template
10 - Conclusion