by Pam Conway | Released January 2013 | ISBN: 00040COMPUWORKS

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. Show and hide more

1. Introduction
   • Introduction 00:02:37
2. Workbooks
   • Navigate, name, color worksheets 00:02:59
   • Inserting and Deleting Worksheets 00:01:13
   • Group Worksheets 00:01:55
   • Using the Watch Window 00:02:27
   • Naming Worksheets 00:04:16
   • Setting the Tab Color 00:02:16
   • Moving and Copying Worksheets 00:02:30
   • Move Sheet to Another Workbook 00:02:35
   • Formatting Grouped Worksheets 00:07:00
   • Entering 3D Formulas 00:03:52
   • Anchoring the Watch Window 00:02:00
3. Range Names
   • Viewing Rules for Range Names 00:01:02
   • Naming a Range of Cells 00:01:11
   • Moving to a Range Name 00:01:47
   • Creating a Range Name from Headings 00:01:57
   • Name Manager 00:03:24
   • Performing Calculations with Range Names 00:05:10
   • Creating 3D Range Names 00:03:40
   • Using Range Names in 3D Formulas 00:01:33
4. Working with Outlines and Subtotals
   • Applying an Outline Manually 00:03:20
   • Applying an Automatic Outline 00:00:41
   • Expanding and Collapsing an Outline 00:01:58
   • Clearing an Outline 00:00:50
   • Creating Subtotals 00:04:48
   • Changing the Function Used in Subtotals 00:02:27
   • Clearing Subtotals 00:00:38
5. Using Paste Special
   • Pasting with No Borders 00:02:21
   • Transposing 00:02:20
   • Paste Values 00:02:30
   • Linking Worksheets and Workbooks 00:03:27
   • Arrange Windows Tool 00:03:23
6. Charts
   • Creating an Embedded Chart 00:02:40
   • Moving a Chart to a Separate Sheet 00:02:10
   • Selecting Chart Designs and Styles 00:00:22
   • Changing the Chart Type 00:01:36
   • Switching Row/Column Data 00:01:15
   • Selecting a Chart Layout 00:03:25
   • Adding Chart Titles and Axis Labels 00:02:59
   • Creating a Chart Legend, Data Labels, and a Data Table 00:03:55
   • Formatting the Chart Axis 00:13:44
7. Drawing Objects
   • Inserting a Text Box 00:07:50
   • Adding and Formatting Shapes 00:01:14
   • Using Connector Lines 00:01:24
   • Adding Shape Effects and Styles 00:03:24
8. Creating Hyperlinks
   • Using Hyperlinks 00:01:02
   • Linking to a Named Range 00:01:40
   • Linking to a Specific Cell 00:01:05
   • Linking to a URL 00:00:47
   • Linking to an External File 00:01:53
9. Working with Templates
   • Using an existing template 00:02:46
   • Modifying a Template 00:00:31
   • Saving a Template 00:04:14
   • Opening a Template 00:02:13
10. Conclusion
    • Conclusion 00:02:17
Show and hide more