O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel 2007 Intermediate

Video Description

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.

Table of Contents

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