Excel 2010

• Getting Started

• Practice Starting Excel

• Navigating

• McDonalds Cash Register

• Autofit Column Width

• Replace Data

• Accounting Formatting Looks Like Money

• Zooming

• Formulas Should Use Cell Addresses

• More About Formulas

• Copy and Paste Formula

• Additional Arithmetic

• Saving Files

• Open Practice Fields

• Sheet Tabs

• Right Click Sheet Tabs for TOC

• Sum Function

• Ctrl + Enter Stays in the Cell to be Copied

• Sum Down and Autofill Sideways

• Max and Min

• Autofill

• Formula Auditing Tools

• Absolute References

• Evaluate Formula Button

• Interactive 2003 Command Reference Guide

• Course Check List

• Open Excel Day 1 Workfiles

• Insert a Sheet

• Copy and Paste Between Sheets

• Paste Widths

• Pasting Continued

• Insert a Column

• Cut/Paste

• Drag/Drop

• Autofill A Months

• Autofill with Days and Numbers

• Formatting Cell Styles

• Font Size

• Number Formatting

• Templates

• Sheets: Color and Grouping

• Sheets: Ungrouping and Deleting

• Edit Multiple Sheets

• Copy Entire Sheets

• Spell Check

• Freeze Panes

• Unfreeze Panes and Split Screen

• Custom Views

• Page Setup for Printing

• Page Layout View

• Course Check List

• Introduction

• A Well-Defined List

• Sort by One Field

• Sort Multiple Fields

• Custom Sort Lists

• Create a Custom Sort List

• Sorting Numbers, Dates, and Text

• Filtering

• Multi-field Filtering

• Filter for a Range of Values

• Remove One Filter at a Time

• Remove Multiple Filters

• Remove Autofilter Arrows

• Create the Duplicate Record Problem

• Automatic Subtotals

• Sort Before Subtotaling

• Subtotal by Division

• Subtotal by Second Field

• Format Cells as a Table

• Convert to Range

• Charts

• Column Chart

• Modifying Charts

• Themes Affect Chart Colors

• Change Chart Column Colors

• Include a Chart Title

• Add a Gradient Fill to the Plot Area

• Switch Row and Column Order

• Add Data to your Chart

• Change Chart Column Order

• Line Charts

• X Axis for Line Charts

• Pie Charts

• Data Labels

• Create a Chart Template

• Printing Charts

• Sparklines

• Column-Style Sparklines

• Win/Loss Sparklines

• Course Check List

• Introduction and Practice Files

• Start Excel 2010

• Look at the Text Data

• Link to the Text File

• Saving Workbook

• Editing Text Data in Excel

• Edit Data in Notepad

• Refresh the Excel Communication

• Link to Access

• Editing from Excel

• Open Day Two Workfiles

• Export to PDF

• Renaming Worksheets

• Pivot Tables

• Classic Pivot Table Skeleton

• Creating Pivot Table

• Multiple Fields in Pivot Table

• Formatting Totals

• Report Filter and Slicer

• Pivot Chart

• Filter the Table and Chart

• Insert a New Sheet

• Link by Copy/Paste

• Insert Comment

• Show all Comments

• Print with Comments

• Conditional Formatting

• Color Scales

• Data Bars

• Data Validation

• Data Validation Value Boundaries

• Conditional Formatting for DV Rule Breaker

• Protect the Worksheet

• Protect the Workbook

• Protect the File

• Course Check List

• Download Practice Files

• Creating Range Names

• Names in Formulas

• Create Names from Selection

• Logical Functions

• If Functions

• Nesting If Functions

• V Lookup

• Copy and Adjust V Lookup

• V Lookup with TRUE

• Using TRUE

• Nest If Inside V Lookup

• Nest If Inside V Lookup (cont.)

• Sumif

• Averageifs

• Sumifs

• Data Validation List

• Date Functions

• Today Function

• Overview

• Course Check List

• Getting Started

• Consolidate

• Opening a Template

• Goal Seek

• Goal Seek (cont)

• Install Solver Addin

• Practice Constraints 2 and 3

• Constraint 3

• Constraint 4

• The Results

• Absolute References via F4

• Two-Variable Data Table

• Scenario Manager

• Summary Sheet

• Install Developer Tool

• Record Absolute References Macro

• Visual Basic Editor

• Relative Macro References

• Problems Running H3 Relative Macro from F3

• Relative Recorded from H3

• Additional Macros

• Assign KBD Shortcut Later

• Macro with Ribbon

• Excel Speaks

• Course Check List