Independently Published
Excel 365 - Advanced Features: Supports Excel 2010, 2013, 2016, And 2019
0
Rate this book
Key Metrics
- Jeff Hutchinson
- Independently Published
- Paperback
- 9781660224937
- 11.02 X 8.5 X 0.37 inches
- 0.92 pounds
- Computers > Business & Productivity Software - Spreadsheets
- English
$0
List Price:
$0
Save:
$0 ($%)
Format:
Paperback
Shipping
$4
Ships from:
-
Estimated Arrival:
-
Available Copies:
0 Copies
Ready To Buy:
Back Order
Secure TransactionSold By:
Readara.com
Add to My Wishlist
Book Description
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.
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.
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 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.
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
Excel 365 - Advanced Features: Supports Excel 2010, 2013, 2016, And 2019
Videos
No Videos
Community reviews
Write a ReviewNo Community reviews