Intermediate
Topic-Level Outline
Days: 1
Prerequisites: Excel 2013: Basic or equivalent experience
Unit 1
: Managing workbooks and worksheetsTopic A: Viewing large worksheets
A-1: Locking rows and columns
A-2: Splitting a worksheet into panes
A-3: Hiding and unhiding columns and worksheets
Topic B: Printing large worksheets
B-1: Setting print titles
B-2: Adjusting page breaks
Topic C: Working with multiple worksheets
C-1: Navigating between worksheets
C-2: Naming worksheets and coloring tabs
C-3: Working with multiple worksheets
C-4: Previewing and printing multiple worksheets
Topic D: Linking worksheets with 3-D formulas
D-1: Creating formulas with 3-D references
D-2: Adding a Watch window
Topic E: Using multiple workbooks
E-1: Switching between workbooks
E-2: Copying a worksheet to another workbook
E-3: Creating a workspace by arranging windows
Topic F: Linking workbooks
F-1: Examining external links in a worksheet
F-2: Creating external links in a worksheet
F-3: Editing links
Unit 2
: Advanced formattingTopic A: Using special number formats
A-1: Applying special formats
A-2: Controlling the display of zero values
A-3: Creating custom formats
Topic B: Working with themes
B-1: Changing to a different theme
B-2: Saving new colors and themes
Topic C: Other advanced formatting
C-1: Merging cells
C-2: Changing the orientation of text in a cell
C-3: Splitting cells
C-4: Transposing data during a paste
C-5: Using Paste Special to add values
C-6: Adding and deleting backgrounds
C-7: Adding a watermark
Unit 3
: Outlining and subtotalsTopic A: Outlining and consolidating data
A-1: Creating an outline
A-2: Creating custom views
A-3: Using the Consolidate command
Topic B: Creating subtotals
B-1: Creating subtotals in a list
B-2: Using multiple subtotal functions
Unit 4
: Cell and range namesTopic A: 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: Managing names
B-1: Modifying and deleting named ranges
Unit 5
: Data structure and tablesTopic A: Sorting and filtering data
A-1: Examining the structure of data
A-2: Sorting data
A-3: Filtering data by using AutoFilter
Topic B: Working with tables
B-1: Creating a table
B-2: Formatting a table
B-3: Adding and deleting rows and columns
B-4: Using structured references
B-5: Naming tables
B-6: Creating functions with the [@] argument
Unit 6
: Web and sharing featuresTopic A: 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: Using hyperlinks
B-1: Inserting a hyperlink
B-2: Modifying and deleting a hyperlink
Unit 7
: Documenting and auditingTopic A: Auditing features
A-1: Tracing precedent and dependent cells
A-2: Tracing errors
Topic B: Comments in cells and workbooks
B-1: Viewing comments in a worksheet
B-2: Adding a comment to a cell
B-3: Adding comments and properties to a workbook
Topic C: Protection
C-1: Password-protecting a worksheet
C-2: Unlocking cells and protecting part of a worksheet
C-3: Protecting the workbook structure
C-4: Discussing digital signatures
Topic D: Workgroup collaboration
D-1: Sharing a workbook for collaboration
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 8
: Application settings and templatesTopic A: Application settings
A-1: Changing application settings
A-2: Customizing the ribbon
Topic B: Working with templates
B-1: Creating a template
B-2: Modifying a template