Introducing the new Excel user interface
• Review components of the new interface:
• Review changes to other interface     components
• Process a Document Using the Office Button’s Prepare Commands
• Add Commands to the Quick Access Toolbar
• Arrange Commands on the Quick Access Toolbar
• Reset the Quick Access Toolbar
• Perform Keyboard-only Actions

Create, Sort and Filter a Table
• Distinguishing between Lists, Ranges, Named Ranges and Tables
• Attributes of a Table
• Prepare data for conversion to a Table
• Convert a data range to a Table
• Format the Table using the Table Style options and Table Styles Gallery
• Sort the table
• Filter the table
• Extend the table and add additional rows of data

Create a Chart
• Basic functionality is unchanged
• More formatting options available, including 3-D and new chart types
• Walk through the Chart Tools Contextual Tabs
• Create a Pie Chart using Charts Gallery
• Modify the Gallery Chart default settings
Lesson 3 – Create a Chart
• Basic functionality is unchanged
• More formatting options available, including 3-D and new chart types
• Walk through the Chart Tools Contextual Tabs
• Create a Pie Chart using Charts Gallery
• Modify the Gallery Chart default settings

Work with Functions and Formulas
• The Formula Ribbon
• New Conditional Sum Functions
• New IFERROR function
• Formula AutoComplete
• The Name Manager
• Use conditional sum formulas
• Use Formula AutoComplete to enter a VLOOKUP formula
• Add IFERROR Function to VLOOKUP

Format a Report for Printing
• Margins Gallery
• The New Page Layout View
• Headers and Footers
• Apply margins to a report
• Add a custom Header to a report
• Add a preset Footer to a report
• Fit the report to one page width
• Repeat column headings on multiple pages
Apply Conditional Formatting to a Table
• What’s new about Conditional Formatting
• Apply Conditional Formats to Text Values
• Apply data bars, color scales and icon sets to tables of numbers
• Modify a preset Color Scale conditional format