Excel 2013:

Topic-Level Outline

                         Days:  1

          Prerequisites:  Windows 7: Basic or equivalent experience

                         Unit 1 :  Getting started

                               Topic A: 0  Spreadsheet terminology

                               A-1:                               Discussing spreadsheet basics

                               Topic B: 0  The Excel environment

                               B-1:                               Examining Excel window components

                               Topic C: 0  Navigating a worksheet

                               C-1:                               Navigating a worksheet

                               C-2:                               Using Find, Go To, and Go To Special

                               Topic D: 0  Using a template

                         D-1:                         Opening a downloaded template

                         Unit 2 :  Entering and editing data

                               Topic A: 0  Entering and editing text and values

                               A-1:                               Entering text and values

                               A-2:                               Editing cell contents

                               A-3:                               Using AutoFill to fill a series

                               Topic B: 0  Entering and editing formulas

                               B-1:                               Creating a basic formula

                               B-2:                               Entering cell references with the mouse

                               B-3:                               Editing a formula

                               B-4:                               Working with the order of operations

                               Topic C: 0  Saving and updating workbooks

                         C-1:                         Saving a new workbook

                         C-2:                         Saving a file as an Excel 97-2003 workbook

                         C-3:                         Saving a worksheet as a PDF file

                         C-4:                         Editing and updating a workbook

                         Unit 3 :  Modifying a worksheet

                               Topic A: 0  Moving and copying data

                               A-1:                               Moving data in a worksheet

                               A-2:                               Copying data in a worksheet

                               A-3:                               Moving and copying data by using drag-and-drop

                               A-4:                               Using the Clipboard task pane

                               Topic B: 0  Moving, copying, and viewing formulas

                               B-1:                               Moving a formula

                               B-2:                               Copying a formula

                               B-3:                               Using AutoFill to copy a formula

                               B-4:                               Using Paste Link

                               B-5:                               Viewing worksheet formulas

                               Topic C: 0  Absolute and relative references

                               C-1:                               Observing the limitations of relative references

                               C-2:                               Applying absolute references

                               Topic D: 0  Inserting and deleting ranges, rows, and columns

                         D-1:                         Inserting a range of cells

                         D-2:                         Inserting rows

                         D-3:                         Deleting a range of cells

                         Unit 4 :  Functions

                               Topic A: 0  Entering functions

                               A-1:                               Entering a SUM function

                               A-2:                               Using the mouse to enter a function argument

                               A-3:                               Entering a function in the formula bar

                               A-4:                               Inserting a function

                               Topic B: 0  AutoSum

                               B-1:                               Using AutoSum

                               Topic C: 0  Other common functions

                         C-1:                         Using AVERAGE

                         C-2:                         Using MIN

                         C-3:                         Using MAX

                         C-4:                         Using COUNT and COUNTA

                         Unit 5 :  Formatting

                               Topic A: 0  Text formatting

                               A-1:                               Formatting text

                               A-2:                               Formatting a non-contiguous range

                               A-3:                               Using the Format Cells dialog box to format text

                               Topic B: 0  Row and column formatting

                               B-1:                               Changing column width and row height

                               B-2:                               Applying color to a row

                               B-3:                               Setting alignment

                               B-4:                               Applying borders to cell ranges

                               B-5:                               Using the border-drawing pencil

                               B-6:                               Using the Paste Special command

                               B-7:                               Removing a border

                               Topic C: 0  Number formatting

                               C-1:                               Using the Number group to format numbers

                               C-2:                               Exploring the Number tab

                               Topic D: 0  Conditional formatting

                               D-1:                               Creating a conditional format

                               D-2:                               Editing and deleting a conditional format

                               Topic E: 0  Additional formatting options

                         E-1:                         Using the Format Painter

                         E-2:                         Using AutoFill to copy a format

                         E-3:                         Applying cell styles

                         E-4:                         Creating and applying custom cell styles

                         E-5:                         Modifying cell styles

                         Unit 6 :  Charts

                               Topic A: 0  Chart basics

                               A-1:                               Creating a chart

                               A-2:                               Moving a chart within a workbook

                               A-3:                               Examining chart elements

                               A-4:                               Adding a data series to a chart

                               A-5:                               Creating and editing a pie chart

                               Topic B: 0  Formatting charts

                         B-1:                         Applying chart types and chart styles

                         B-2:                         Modifying chart elements

                         Unit 7 :  Graphics

                               Topic A: 0  Working with pictures

                               A-1:                               Inserting and modifying a picture

                               Topic B: 0  Conditional formatting with graphics

                               B-1:                               Creating data bars

                               B-2:                               Using color scales

                               B-3:                               Creating icon sets

                               Topic C: 0  SmartArt graphics

                         C-1:                         Inserting a SmartArt graphic

                         C-2:                         Modifying a SmartArt graphic

                         Unit 8 :  Printing

                               Topic A: 0  Preparing to print

                               A-1:                               Checking spelling in a worksheet

                               A-2:                               Finding and replacing text

                               A-3:                               Previewing a worksheet

                               Topic B: 0  Page Setup options

                               B-1:                               Setting page orientation and scaling

                               B-2:                               Adjusting margins

                               B-3:                               Creating headers and footers

                               B-4:                               Formatting headers and footers

                               B-5:                               Printing gridlines and headings

                               Topic C: 0  Printing worksheets

                                                                                                                                                                                           C-1:                                                                                                                                                                                           Printing a selected range