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