Excel 2013:

Intermediate

Topic-Level Outline

                         Days:  1

          Prerequisites:  Excel 2013: Basic or equivalent experience

                         Unit 1 :  Managing workbooks and worksheets

                               Topic A: 0  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: 0  Printing large worksheets

                               B-1:                               Setting print titles

                               B-2:                               Adjusting page breaks

                               Topic C: 0  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: 0  Linking worksheets with 3-D formulas

                               D-1:                               Creating formulas with 3-D references

                               D-2:                               Adding a Watch window

                               Topic E: 0  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: 0  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 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  Working with themes

                               B-1:                               Changing to a different theme

                               B-2:                               Saving new colors and themes

                               Topic C: 0  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 subtotals

                               Topic A: 0  Outlining and consolidating data

                               A-1:                               Creating an outline

                               A-2:                               Creating custom views

                               A-3:                               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

                         Unit 5 :  Data structure and tables

                               Topic A: 0  Sorting and filtering data

                               A-1:                               Examining the structure of data

                               A-2:                               Sorting data

                               A-3:                               Filtering data by using AutoFilter

                               Topic B: 0  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 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 a hyperlink

                         B-2:                         Modifying and deleting a hyperlink

                         Unit 7 :  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 and properties to a workbook

                               Topic C: 0  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: 0  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 templates

                               Topic A: 0  Application settings

                               A-1:                               Changing application settings

                               A-2:                               Customizing the ribbon

                               Topic B: 0  Working with templates

  B-1:  Creating a template

  B-2:  Modifying a template