Publisher's Synopsis
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.
The following Advance Excel 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
- 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 is a technique used to create relationships between sheets similar to Access databases. 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. 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
