Excel 2007:
Intermediate

Topic-Level Outline

                         Days:  1

         Prerequisites:  Excel 2007: Basic or equivalent experience

                         Unit 1 :  Using multiple worksheets and workbooks

                               Topic A: 0  Using multiple workbooks

                               A-1:                               Switching between workbooks

                               A-2:                               Copying a worksheet to another workbook

                               Topic B: 0  Linking worksheets with 3-D formulas

                               B-1:                               Creating 3-D formulas

                               B-2:                               Adding a Watch window

                               Topic C: 0  Linking workbooks

                               C-1:                               Examining external links in a worksheet

                               C-2:                               Creating external links in a worksheet

                               C-3:                               Editing links

                               Topic D: 0  Managing workbooks

                         D-1:                         Creating a workspace

                         Unit 2 :  Advanced formatting

                               Topic A: 0  Using special number formats

                               A-1:                               Applying special formats

                               A-2:                               Controlling the display of zero values

                               A-3:                               Creating custom formats

                               Topic B: 0  Using functions to format text

                               B-1:                               Using PROPER, UPPER, and LOWER

                               B-2:                               Using SUBSTITUTE

                               Topic C: 0  Working with styles

                               C-1:                               Creating and applying styles

                               C-2:                               Modifying styles

                               Topic D: 0  Working with themes

                               D-1:                               Changing to a different theme

                               D-2:                               Saving new colors and themes

                               Topic E: 0  Other advanced formatting

                         E-1:                         Merging cells

                         E-2:                         Changing the orientation of text in a cell

                         E-3:                         Splitting cells

                         E-4:                         Transposing data during a paste

                         E-5:                         Adding and deleting backgrounds

                         E-6:                         Adding a watermark

                         Unit 3 :  Outlining and subtotals

                               Topic A: 0  Outlining and consolidating data

                               A-1:                               Creating an outline

                               A-2:                               Using the Consolidate command

                               Topic B: 0  Creating subtotals

                         B-1:                         Creating subtotals in a list

                         B-2:                         Using multiple subtotal functions

                         Unit 4 :  Cell and range names

                               Topic A: 0  Creating and using names

                               A-1:                               Naming and selecting ranges

                               A-2:                               Using names in formulas

                               A-3:                               Using the Create from Selection command

                               A-4:                               Applying names to existing formulas

                               Topic B: 0  Managing names

                         B-1:                         Modifying and deleting named ranges

                         B-2:                         Defining and applying 3-D names

                         Unit 5 :  Lists and tables

                               Topic A: 0  Examining lists

                               A-1:                               Examining the structure of a list

                               Topic B: 0  Sorting and filtering lists

                               B-1:                               Sorting a list

                               B-2:                               Filtering a list by using AutoFilter

                               B-3:                               Using cell color and attributes to sort and filter data

                               Topic C: 0  Advanced filtering

                               C-1:                               Using Custom AutoFilter criteria

                               C-2:                               Using the Advanced Filter dialog box

                               C-3:                               Copying filtered results to another range

                               Topic D: 0  Working with tables

                         D-1:                         Creating a table

                         D-2:                         Formatting a table

                         D-3:                         Adding and deleting rows and columns

                         D-4:                         Applying structured referencing

                         D-5:                         Naming tables

                         D-6:                         Creating functions with [#This row]

                         Unit 6 :  Web and Internet features

                               Topic A: 0  Saving workbooks as Web pages

                               A-1:                               Making Web commands available

                               A-2:                               Saving a workbook as a Web page

                               A-3:                               Using the Publish as Web Page dialog box

                               Topic B: 0  Using hyperlinks

                               B-1:                               Inserting and editing hyperlinks

                               Topic C: 0  Distributing workbooks

                         C-1:                         Saving a workbook as a PDF file

                         C-2:                         Using e-mail to share a workbook

                         Unit 7 :  Advanced charting

                               Topic A: 0  Chart formatting options

                               A-1:                               Adjusting the scale of a chart

                               A-2:                               Formatting a data point

                               Topic B: 0  Combination charts

                               B-1:                               Creating a combination chart

                               B-2:                               Creating a trendline

                               Topic C: 0  Graphic elements

                         C-1:                         Adding graphic elements

                         C-2:                         Formatting a graphic element

                         C-3:                         Adding a picture to a worksheet

                         Unit 8 :  Documenting and auditing

                               Topic A: 0  Auditing features

                               A-1:                               Tracing precedent and dependent cells

                               A-2:                               Tracing errors

                               Topic B: 0  Comments in cells and workbooks

                               B-1:                               Viewing comments in a worksheet

                               B-2:                               Adding a comment to a cell

                               B-3:                               Adding comments to a workbook

                               Topic C: 0  Protection

                               C-1:                               Password-protecting a worksheet

                               C-2:                               Protecting part of a worksheet by unlocking cells

                               C-3:                               Restricting permissions to a workbook

                               C-4:                               Discussing digital signatures

                               Topic D: 0  Workgroup collaboration

                         D-1:                         Sharing a workbook

                         D-2:                         Merging workbooks

                         D-3:                         Tracking changes in a workbook

                         D-4:                         Using the Document Inspector

                         D-5:                         Marking a workbook as final

                         Unit 9 :  Templates and settings

                               Topic A: 0  Application settings

                               A-1:                               Exploring application settings

                               Topic B: 0  Built-in templates

                               B-1:                               Using a downloaded template

                               Topic C: 0  Creating and managing templates

  C-1:  Creating a template

  C-2:  Modifying a template

  C-3:  Specifying an alternate template location