Work smarter

Formatting Tables

• Format information as a table
• Add rows or columns
• Change the table style

Reviewing and sharing workbooks

• Turn Track Changes on and off
• Add, edit and delete a comment
• Accept or reject changes
• List changes on a separate worksheet
• Show or hide comments
• Check spelling
• Use the Document Inspector
• Protect your workbook

Using Templates

• Create a new workbook using a template

Working with Charts

• Types of charts
• Create a chart
• Change the chart type
• Switch row and column data
• Change the chart layout
• Change the chart style
• Move a chart to a different worksheet

Working with Sparklines

• Create sparklines
• Show points on the sparkline
• Change the sparkline style
• Change the sparkline type
• Change the display range

Using Conditional Formatting

• Create a conditional formatting rule
• Use preset conditional formatting
• Remove conditional formatting rules

Creating PivotTables

• Use PivotTables to answer questions
• Create a PivotTable
• Add fields to the PivotTable
• Change the row labels
• Add column labels
• Add a report filter
• Add and use a slicer
• Create a PivotChart

Using What-If Analysis

• Use Goal Seek
• Use Scenarios
• Use Data Tables

Excel Intermediate (login required)

• Relative and Absolute References
• Using Functions
• Formatting Menu Options
• Additional Formatting Features
• 3D Workbooks
• Splitting, Freezing and Hiding
• Creating Charts
• Formatting Charts
• Worksheet Design