Excel 2016 Advanced

Managing Data

• Importing Data into Excel
• Exporting Data from Excel
• Creating Advanced Filters
• Grouping and Ungrouping Data
• Creating an Auto Outline
• Using the Subtotal Feature

Collaborating with Others

• Protecting Worksheets and Workbooks
• Sharing Workbooks
• Reviewing Tracked Revisions
• Turning Off the Workbook Share
• Creating Surveys Using SkyDrive
• Posting Spreadsheets to Social Networks

Working with Data Tools

• Validating Data
• Consolidating Data
• Working with Scenarios and Goal Seek
• Using Solver
• Creating Data Tables

Recording and Using Macros

• Accessing the Developer Tab and Opening Workbooks with Macros
• Recording and Running a Macro
• Viewing and Modifying Macros
• Assigning Macros to the Quick Access Toolbar, Buttons and Shapes
• Creating a Macro to Automatically Run when the Workbook Opens
• Deleting Macros and Saving Workbooks with Macros

Using Functions

• Using Logical Functions
• Combining Cells using Concatenate and Turning Text to Columns
• Using the SUMIF Function
• Utilizing Database Functions
• Nesting the Index and Match Functions
• Creating a Custom Spreadsheet Formula

Analyzing Data with Pivot Tables and Pivot Charts

• Creating and Modifying a PivotTable
• Adding Timelines and Slicers
• Adding Calculated Fields to Pivot Tables
• Utilizing Built-in Data Model Relationships
• Importing Data as a Table or PivotTable Report
• Adding In and Applying PowerPivot Tools
• Establishing Hierarchies using PowerPivot Tools
• Analyzing Data Using Pivot Charts