Sunday, March 1, 2020

Home Excel ebooks [Free ebook]Excel 2016 Advanced Features: Support Excel 2010, 2013, And 2016 (Excel 2016 Level 3)-Jeff Hutchinson

[Free ebook]Excel 2016 Advanced Features: Support Excel 2010, 2013, And 2016 (Excel 2016 Level 3)-Jeff Hutchinson

March 01, 2020 Excel ebooks,

[Free ebook]Excel 2016 Advanced Features: Support Excel 2010, 2013, And 2016 (Excel 2016 Level 3)-Jeff Hutchinson

DOWNLOAD

Description

Product description

This Step-By-Step Workbook will guide you through learning the advanced Excel concepts including Protection, Data Validation, Conditional Format, Import/Export, PivotTable, and PowerPivot. 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. Included are over 170 Practice Exercises that demonstrate how to use Excel concepts. They can also be used as a reference guide to quickly look up specific topics.

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.

Furthermore, they will find that this workbook/guide can often be used as a reference to help them understand concepts quickly and thoroughly. An index is also provided on the last page to reference important topics as necessary. However, if more detail is needed for study, the Internet can be used, as well, to search a concept. Also, if student’s skills are weak due to lack of implementation, they can refresh their knowledge quickly by visually scanning concepts of choice, and then testing them out using the application.

About the Author

Jeff Hutchinson is a computer instructor teaching a variety of classes around the country. He has a BS degree from BYU in Computer-Aided Engineering and has worked in the Information Technology field supporting and maintaining computers for many years. He also previously owned a computer training and consulting firm in San Francisco, California. After selling his business in 2001, he has continued to work as an independent computer instructor/consultant around the country. Jeff Hutchinson lives in Utah and also provides training for Utah Valley University Community Education system, offering valuable computer skills for the general knowledge of students, career development, and career advancement. Understanding the technology and the needs of students has been the basis for developing this material. Jeff Hutchinson can be contacted at jeffhutch@elearnlogic.com or (801) 376-6687.