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 2010 Intermediate

Video Description

In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets.

Table of Contents

  1. Introduction
    1. Introduction 00:03:42
  2. Using Workbooks
    1. Navigating a workbook 00:05:27
    2. Renaming sheets 00:01:05
    3. Applying tab color 00:02:17
    4. Inserting and deleting sheets 00:03:41
    5. Moving and copying sheets 00:03:29
    6. Moving a sheet to another workbook 00:03:00
    7. Grouping worksheets 00:06:40
    8. Creating Formulas Between Worksheets 00:07:30
    9. Using the Watch Window 00:08:51
  3. Working with Range Names
    1. Assigning a Range Name 00:04:32
    2. Creating a Range Name from headings 00:01:36
    3. Moving to and deleting Range Names 00:04:35
    4. Creating 3D Range Names 00:05:00
    5. Inserting hyperlinks to Range Names 00:02:26
  4. Applying Outlines and Subtotals
    1. Applying an outline manually 00:03:36
    2. Expanding and collapsing an outline 00:01:47
    3. Applying an automatic outline 00:02:22
    4. Modifying outline settings 00:01:03
    5. Creating subtotals 00:02:51
    6. Clearing subtotals 00:00:50
    7. Changing the function used in subtotals 00:01:05
  5. Working with Templates
    1. Using an existing template 00:09:19
    2. Creating and saving a template 00:04:02
    3. Opening and modifying a template 00:02:39
  6. Collaborating
    1. Adding comments 00:05:10
    2. Sharing a workbook 00:01:52
    3. Tracking changes in a workbook 00:05:38
    4. Comparing and merging workbooks 00:03:20
    5. Using the document inspector 00:03:33
    6. Saving a workbook as a PDF 00:01:46
    7. Emailing a workbook 00:01:18
  7. Creating Charts
    1. Creating an embedded chart 00:03:42
    2. Creating a chart on a separate sheet 00:02:13
    3. Moving and resizing a chart 00:01:38
    4. Switching row/column data 00:01:04
    5. Changing the chart range 00:03:03
    6. Changing the chart type 00:01:23
    7. Printing a chart 00:02:04
  8. Formatting a Chart
    1. Applying Quick Layouts and Quick Styles 00:04:10
    2. Adding chart elements 00:18:53
    3. Formatting chart elements 00:28:03
    4. Customizing 3D effects on a chart 00:03:37
    5. Creating a picture chart 00:03:06
  9. Drawing Objects
    1. Adding a text box 00:04:41
    2. Drawing a line or arrow 00:01:53
    3. Drawing a rectangle or oval 00:02:20
    4. Modifying objects 00:06:53
    5. Formatting objects 00:01:43
    6. Inserting SmartArt 00:06:07
  10. Conclusion
    1. Conclusion 00:01:50