Microsoft Excel 2010 Training Course

Demonstration of using Pivot Tables
(demo is in lower resolution than actual training course)

Microsoft Excel 2010 Training: Level 1
Get Up and Running Quickly

• Excel 2010 Interface and File Types
• Experience the New Microsoft Office Excel 2010 Interface
• Go Backstage via the File Tab
• Customize the Quick Access Toolbar
• Customize the Ribbon
• Excel File Types and What They Mean to You
• Need Help? It's Local and Online

• Create a New Workbook
• Create a New Workbook Based on a Template
• Fill in Your Spreadsheet
• Get Around in a Worksheet
• Use AutoFill to Quickly Add Standard Lists to Your Worksheet
• Take Advantage of AutoComplete when Working with Long Lists of Data
• Undo and Redo
• File Recovery Options

• Introduction to Formulas in Excel 2010
• Anatomy of a Formula
• AutoSum
• Status Bar Calculations
• Copying Formulas
• Use Cell References in a Formula

• Formatting Your Spreadsheet
• Text Editing Techniques
• Use Format Painter to Copy Applied Formatting
• Apply Number Formats
• Create a Custom Number Format
• Merge and Split Cells
• Rotate Text in a Cell
• Wrap Text in a Cell

• Review Your Spreadsheet
• AutoCorrect
• Use Spell Check... Please
• The Research Pane
• Find and Replace

• Change a Worksheet's Layout in Excel 2010
• Insert and Delete Rows and Columns
• Insert and Delete Cells
• Adjust the Width of a Column
• Adjust the Height of a Row
• Move and Copy Text
• Hide Columns and Rows

• Manage and Edit Workbooks
• Rename Worksheet Tabs
• Add New Worksheets to a Workbook
• Remove Worksheets from a Workbook
• Move and Copy Worksheet Tabs
• Hide Worksheets
• Split Your Worksheet View
• Freeze Rows and Columns to Anchor Data on Your Screen

• Print Options
• Change Worksheet Margins
• Change a Worksheet's Page Orientation to Portrait or Landscape
• Add Print Titles to a Worksheet
• Set or Clear a Worksheet's Print Area
• View and Set Page Breaks on a Worksheet
• Add a Worksheet Header or Footer

• Office 2010 Training for Excel 2010: Resources
• Excel 2010 Level 1 Exercises
• Excel 2010 Level 1 Sample Files
• Excel 2010 Level 1 Knowledge Checks
• Excel 2010 Level 1 Training KeyNotes

Microsoft Excel 2010 Training : Level 2
Working with Objects, Themes and a Team in Excel 2010

• ClipArt, Images, Shapes, Equations and Symbols in Excel 2010
• Insert ClipArt and Pictures
• Insert a Screenshot
• Insert a WordArt Object
• Insert a Symbol
• Insert an Equation
• Remove an Image's Background
• Apply a Picture Style
• Apply a Picture Border
• Apply Picture Effects
• Apply a Picture Layout
• Work with Image Corrections, Color and Artistic Effects
• Create AutoShapes

• Work with SmartArt
• About SmartArt
• Create a SmartArt Object
• Edit SmartArt Text
• Modify the SmartArt Layout
• Apply a SmartArt Style
• Change the Colors Applied to a SmartArt Graphic
• Convert a SmartArt Object to Text or Shapes

• Charts in Excel 2010
• Add an Embedded Chart to an Excel Spreadsheet
• Add a Chart Sheet to an Excel Workbook
• Add a Sparkline
• Change the Chart Type
• Edit, Add, and Remove Chart Data
• Change a Chart's Data Range
• Apply a Chart Layout
• Apply a Chart Style
• Chart Labels
• Adjust a Chart's Axes and Gridlines
• Change a Chart's Background
• Add Trendlines and Error Bars to a Chart
• Change the Size of a Chart

• Work with Objects on a Excel 2010 Spreadsheet
• Use the Selection Pane to Work with Objects
• Move and Copy Text
• Resize an Object
• Layer Objects
• Group and Ungroup Objects
• Modify Object Styles
• Align Objects

• Apply and Customize Themes and Styles
• About Microsoft Office 2010 Themes
• Change a Theme's Color, Font and Effects
• Create and Save a Custom Theme
• Apply a Background
• Apply a Cell Style
• Create a Custom Cell Style

• Team Collaboration Options
• Add Comments to a Worksheet
• Edit and Delete Comments
• Comment View and Print Options
• Set Password Protection on a Worksheet
• Set Password Protection on a Workbook
• Enable Workbook Security

• Sharing Files
• Share Workbooks
• Save an Excel File to the Web
• Import Data to Excel 2010 from Access
• Import Data to Excel 2010 from a Text File
• Manage a Workbook's Data Connections

• Office 2010 Training for Excel 2010: Resources
• Excel 2010 Level 2 Exercises
• Excel 2010 Level 2 Sample Files
• Excel 2010 Level 2 Knowledge Checks
• Excel 2010 Level 2 Training KeyNotes

Microsoft Excel 2010 Training: Level 3
Advanced Data Management

• Tables and Data Management
• Table Guidelines
• Sort Your Worksheet in Ascending or Descending Order
• Create a Custom Sort Based on Multiple Criteria
• Convert Your List to a Table
• Add a Total Row to a Table
• Remove Duplicates from a Table
• Convert a Table to a List
• Automatic Subtotals

• Highlight Specific Subsets of Data in a Large Worksheet
• Apply Built-In Conditional Formatting to Cells
• Add Data Bars and Color Scales to a Range of Cells
• Convert Your Excel Data to Icon Sets
• Create a Custom Conditional Format
• Use Expressions in a Custom Conditional Format
• AutoFilter
• Find a Unique Entry Using AutoFilter's Search Feature
• Create an Advanced Filter Using Single Criteria
• Create an Advanced Filter Using Multiple Criteria

• A Few Advanced Features and Functions
• Reference Cells in Other Worksheets in a Formula
• Simplify Formulas with Names
• Work with Names in the Name Manager
• Create Basic IF Functions
• Create a Nested IF Function
• Fill in a Sheet using VLOOKUP and HLOOKUP
• General List Totals with DSUM
• Combine Strings with the Concatenate Function

• Consolidate Data and Find Errors in Excel 2010
• About Data Consolidation
• Data Consolidation by Rows
• Data Consolidation by Category
• About Auditing
• Tracing Precedents
• Tracing Dependents
• Tracing Errors

• Create a Template for Future Worksheets
• About Data Validation
• Validate Data Based on a Range of Numbers
• Validate Data Based on a List
• Customize the Data Validation Input Message
• Customize the Data Validation Error Alert
• Create a New Template
• Edit an Existing Template

• Scenarios and the Watch Window
• Create Scenarios to See the Effect of Different Cell Values
• Edit, Display and Remove Scenarios
• Create a Scenario Summary Report
• Use the Watch Window to Keep Track of Changing Data

• Create Robust Analysis with PivotTables and PivotCharts
• PivotTables and PivotCharts
• Create a PivotTable
• Edit a PivotTable's Field Settings
• Redefine a PivotTable's Data Source
• Control a PivotTable's Data Calculations
• Format a PivotTable's Results
• PivotTable Layout and Format Options
• PivotTable Totals and Filters Options
• Customize a PivotTable's Display Options
• PivotTable Printing and Data Options
• Filter Data in a PivotTable with Slicers
• Create a PivotChart

• Office 2010 Training for Excel 2010: Resources
• Excel 2010 Level 3 Exercises
• Excel 2010 Level 3 Sample Files
• Excel 2010 Level 3 Knowledge Checks
• Excel 2010 Level 3 Training KeyNotes

*Outline, Topics, and Resources subject to change