Excel 2013:
Basic
Topic-Level Outline
Days: 1
Prerequisites: Windows 7: Basic or equivalent experience
Unit 1
: Getting startedTopic A: Spreadsheet terminology
A-1: Discussing spreadsheet basics
Topic B: The Excel environment
B-1: Examining Excel window components
Topic C: Navigating a worksheet
C-1: Navigating a worksheet
C-2: Using Find, Go To, and Go To Special
Topic D: Using a template
D-1: Opening a downloaded template
Unit 2
: Entering and editing dataTopic A: 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: 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: 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 worksheetTopic A: 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: 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: Absolute and relative references
C-1: Observing the limitations of relative references
C-2: Applying absolute references
Topic D: 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
: FunctionsTopic A: 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: AutoSum
B-1: Using AutoSum
Topic C: Other common functions
C-1: Using AVERAGE
C-2: Using MIN
C-3: Using MAX
C-4: Using COUNT and COUNTA
Unit 5
: FormattingTopic A: 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: 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: Number formatting
C-1: Using the Number group to format numbers
C-2: Exploring the Number tab
Topic D: Conditional formatting
D-1: Creating a conditional format
D-2: Editing and deleting a conditional format
Topic E: 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
: ChartsTopic A: 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: Formatting charts
B-1: Applying chart types and chart styles
B-2: Modifying chart elements
Unit 7
: GraphicsTopic A: Working with pictures
A-1: Inserting and modifying a picture
Topic B: Conditional formatting with graphics
B-1: Creating data bars
B-2: Using color scales
B-3: Creating icon sets
Topic C: SmartArt graphics
C-1: Inserting a SmartArt graphic
C-2: Modifying a SmartArt graphic
Unit 8
: PrintingTopic A: Preparing to print
A-1: Checking spelling in a worksheet
A-2: Finding and replacing text
A-3: Previewing a worksheet
Topic B: 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: Printing worksheets
C-1: Printing a selected range