Excel 365 - Advanced Features: Supports Excel 2010, 2013, 2016, And 2019

By Jeff Hutchinson

Excel is a very powerful tool to manipulate and calculate data. Most of this Workbook will cover valuable capabilities needed daily, but there are also some advanced analysis tools that are useful under specific circumstances. It is extremely useful to Protect Cells, Protect Workbooks, perform Conditional Formatting, validate cells using Data Validation, and using Macros to automate day-to-day tasks.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt.

Advanced Excel Features
The following Advance Excel topics will be coveredHow 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 Array and Iterative Formulas 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 PowerQuery (Get Data) How to consolidate Worksheets. Advanced Power Add-Ins - Power Pivot
Power Pivot Add-Ins have been created by the Business Intelligence organization within Microsoft. They have been automatically added in Excel 2016 and 2019 which means they are available to use through the options menu. Power Pivot is a technique used to create relationships between sheets similar to Access databases.

What's in the Workbook? Click on the left side of the screen: Look Inside
Enter one of the following keywords: Protection, Data Validation, conditional format, PowerPivot, etc.

How the Workbook is Designed
This Workbook contains over 180+ step-by-step practice exercises to help you get up to speed quickly and understand each concept. The commands and features are very similar to previous versions and differences are documented where appropriate. The following link is a Video Clip explaining how the courseware has been designed and how to use it most effectively.
www.elearnlogic.com/media/coursewareexplanation.mp4

• Format: Paperback
• Language: English
• ISBN: 1660224934
• ISBN13: 9781660224937
• Release Date: January 2020
• Publisher: Independently Published
• Length: 174 Pages
• Weight: 0.92 lbs.
• Dimensions: 0.4" x 8.5" x 11.0"