Excel 2016 Advanced Features: Supports Excel 2010, 2013, and 2016 (Excel 2016 Level 3)

This step-by-step workbook will guide you through learning the Excel program. It can be used by a beginner to understand core concepts, and an advanced student to learn the in’s and out’s of Excel. The workbook includes over 170 Practice Exercises that demonstrate how to use Excel concepts, and can also be used as a reference guide to quickly look up a topic.
Advanced Features - Protection, Validation, And Conditional Formatting
In this group of chapters, students will learn the advanced in’s and out’s of Excel. The following topics will be covered:
• How to protect cells.
• How to open a file with protection.
• How to share a workbook on a server folder.
• How to track changes.
• How to format cells based on specific conditions.
• Data Validation
• Data Validation Dropdown Lists
• Macros and how they allow for the automation of routine tasks.
• Formula Troubleshooting Techniques
• How to trace a cell. (Error Checking, Circular Reference, and
Evaluating Formulas).
• How to watch formulas across worksheets and workbooks.
• What-If Analysis
• Scenarios
• Goal-Seek
• Solver
• Comma Delimited File Export and Import
• How to consolidate Worksheets.
Advanced PivotTables
PivotTables will cover Filtering, Formatting, PivotCharts, Label Adjustments, and Calculation Capability. PivotTables are very similar in all versions; however, new features that have been added to Excel 2013 and 2016 will also be covered.
Advanced Power Add-Ins
PowerPivot Add-Ins have been created by the Business Intelligence organization within Microsoft. They are automatically added in Excel 2010/2013 which means they are available to use through the options menu. PowerPivot is a technique to create relationships between sheets similar to Access databases.