Microsoft Excel 301 – Microsoft Excel Advanced

Module 1: Using Pivot Tables

• Use, edit and format pivot tables to analyze data
• Work with pivot charts and pivot timelines
• Use slicers to filter data including multi-select options

Module 2: Auditing Worksheets

• Show and Audit formulas
• Trace precedents to determine which cells impact a specific cell
• Trace dependents to determine which cells are impacted by a specific cell
• Remove precedent and dependent arrows
• Check for errors frequently found in formulas

Module 3: Data Tools

• Convert text to columns
• Use Data Validation to restrict the type of data that can be entered into a cell
• Consolidate data from a number of different ranges into one new range
• Use Goal Seek to figure out the value to input to obtain a specific result

Module 4: Working with Others

• Password protect a workbook, worksheet, or range in a worksheet
• Use track changes and accept or reject changes
• List all changes on a new sheet

Module 5: Recording and Using Macros

• Run and edit macros
• Add macros to the Quick Access toolbar

Module 6: Sparkines and Office integration

• Insert and customize Sparklines in worksheets
• Prepare a workbook for internationalization and Section 508 accessibility
• Import text files into Microsoft Excel
• Copy cells from a worksheet or charts into Microsoft Word
• Ink Equations and Quick Shape formatting
• Sharing workbooks with SharePoint or OneDrive

Module 8: Microsoft Excel Features New in 2016