Excel 2010 Intermediate Course

1) Introduction - Introduction (00:00)

2) Using Workbooks
- Navigating a workbook (00:00)
- Renaming sheets (00:10)
- Applying tab color (00:20)
- Inserting and deleting sheets (00:30)
- Moving and copying sheets (00:40)
- Moving a sheet to another workbook (00:50)
- Grouping worksheets (01:00)
- Creating Formulas Between Worksheets (01:10)
- Using the Watch Window (01:20)

3) Working with Range Names
- Assigning a Range Name (00:00)
- Creating a Range Name from headings (00:10)
- Moving to and deleting Range Names (00:20)
- Creating 3D Range Names (00:30)
- Inserting hyperlinks to Range Names (00:40)

4) Applying Outlines and Subtotals
- Applying an outline manually (00:00)
- Expanding and collapsing an outline (00:10)
- Applying an automatic outline (00:20)
- Modifying outline settings (00:30)
- Creating subtotals (00:40)
- Clearing subtotals (00:50)
- Changing the function used in subtotals (01:00)

5) Working with Templates
- Using an existing template (00:00)
- Creating and saving a template (00:10)
- Opening and modifying a template (00:20)

6) Collaborating
- Adding comments (00:00)
- Sharing a workbook (00:10)
- Tracking changes in a workbook (00:20)
- Comparing and merging workbooks (00:30)
- Using the document inspector (00:40)
- Saving a workbook as a PDF (00:50)
- Emailing a workbook (01:00)

7) Creating Charts
- Creating an embedded chart (00:00)
- Creating a chart on a separate sheet (00:10)
- Moving and resizing a chart (00:20)
- Switching row/column data (00:30)
- Changing the chart range (00:40)
- Changing the chart type (00:50)
- Printing a chart (01:00)

8) Formatting a Chart
- Applying Quick Layouts and Quick Styles (00:00)
- Adding chart elements (00:10)
- Formatting chart elements (00:20)
- Customizing 3D effects on a chart (00:30)
- Creating a picture chart (00:40)

9) Drawing Objects
- Adding a text box (00:00)
- Drawing a line or arrow (00:10)
- Drawing a rectangle or oval (00:20)
- Modifying objects (00:30)
- Formatting objects (00:40)
- Inserting SmartArt (00:50)

10) Conclusion - Conclusion (00:00)

The courses work well with Internet Explorer (v 8 - higher), Firefox, and Google Chrome. Please make sure you have Adobe Flash Player installed and that you are running the latest version of Flash Player, go to http://www.adobe.com/software/flash/about to check your version or get Flash http://www.adobe.com/go/getflash. We highly recommend at least 2-3 Mbps connection speed.