Excel 2016 Advanced Features: Support Excel 2010, 2013, And 2016 (Excel 2016 Level 3) (Volume 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.