Part 1: Create and format workbooks

1 - Set up a workbook

• Become familiar with new features in Excel 2016
• Create workbooks
• Modify workbooks
• Modify worksheets
• Merge and unmerge cells
• Customize the Excel 2016 app window
• Zoom in on a worksheet
• Arrange multiple workbook windows
• Add buttons to the Quick Access Toolbar
• Customize the ribbon
• Skills review

2- Work with data and Excel tables

• Enter and revise data
• Manage data by using Flash Fill
• Move data within a workbook
• Find and replace data
• Correct and expand upon data
• Define Excel tables
• Skills review
• Practice tasks

3-Perform calculations on data

• Name groups of data
• Create formulas to calculate values
• Sidebar: Operators and Precedence
• Summarize data that meets specific conditions
• Set iterative calculation options and enable or disable automatic calculation
• Use array formulas
• Find and correct errors in calculations
• Skills review
• Practice tasks

4-Change workbook appearance

• Format cells
• Define styles
• Apply workbook themes and Excel table styles
• Make numbers easier to read
• Change the appearance of data based on its value
• Add images to worksheets
• Skills review
• Practice tasks

Part 2: Analyze and present data

5-Manage worksheet data

• Limit data that appears on your screen
• Manipulate worksheet data
• Sidebar: Select list rows at random
• Summarize data in worksheets that have hidden and filtered rows
• Find unique values within a data set
• Define valid sets of values for ranges of cells
• Skills review
• Practice tasks

6-Reorder and summarize data

• Sort worksheet data
• Sort data by using custom lists
• Organize data into levels
• Look up information in a worksheet
• Skills review
• Practice tasks

7-Combine data from multiple sources

• Use workbooks as templates for other workbooks
• Link to data in other worksheets and workbooks
• Consolidate multiple sets of data into a single workbook
• Skills review
• Practice tasks

 8- Create charts and graphics

• Create charts
• Create new types of charts
• Customize chart appearance
• Create diagrams by using SmartArt
• Create shapes and mathematical equations
• Skills review
• Practice tasks

Part 3: Collaborate and share in Excel

9- Print worksheets and charts

• Add headers and footers to printed pages
• Prepare worksheets for printing
• Fit your worksheet contents to the printed page
• Change page breaks in a worksheet
• Change the page printing order for worksheets
• Print worksheets
• Print parts of worksheets
• Print charts
• Skills review
• Practice tasks