Createspace Independent Publishing Platform
Excel 2016 Advanced Features: Support Excel 2010, 2013, And 2016
Key Metrics
- Jeff Hutchinson
- Createspace Independent Publishing Platform
- Paperback
- 9781975986599
- 11.02 X 8.5 X 0.3 inches
- 0.76 pounds
- Computers > Business & Productivity Software - Spreadsheets
- English
Secure TransactionBook Description
What's is in the workbook?Click on the left side of the screen: Look Inside!
Enter one of the following keywords: Variables, Range, Input Boxes, VB Editor, etc.
Take A Class: http: //www.elearnlogic.com/download/schedule.pdf
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 in the options menu. PowerPivot is a technique used to create relationships between sheets, similar to Access databases.
*************************************************************************
Design Strategy - This will explain how the workbook/guide was designed.
This workbook is designed in conjunction with an Online-Instructor-Led course (for more information see: www.elearnlogic.com). Unlike other computer guides, students will not need to review lengthy procedures in order to understand a topic. All that is necessary are the brief statements and command paths located within the guide that demonstrate how a concept is used. There are many Step-By-Step Practice Exercises and more comprehensive Student Projects offered to help students better understand concepts. The following is the basic structure of the workbook:
- Concept Name - Each concept contains a short description, a definition how to use it and TIP providing additional help ideas.
- Practice Exercise - Most concepts provide a 2-4 minute step-by-step practice so you can understand how to use it.
Videos
No Videos
Community reviews
Write a ReviewNo Community reviews