Excel 2016 Formulas, Charts, And PivotTable: Supports Excel 2010, 2013, And 2016

By Jeff Hutchinson

This Step-By-Step Workbook will guide you through learning the Excel program including Advanced Formulas, Tables, Charts, and PivotTables. It can be used by a beginner to understand core concepts as well as an advanced student to learn the "in's and out's" of Excel. Included are over 160 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: bar chart, PivotTable, Sum, Average, Formula, etc.
Take A Class: http: //www.elearnlogic.com/download/schedule.pdf

Intermediate Formulas
The primary skills covered in this group of chapters are Formulas and Functions. Often times, users need to develop a formula using functions in Excel but are unaware of Excel's many capabilities. However, after acquiring a diverse knowledge of the various Excel functions, they are able to discover the perfect function for each intended purpose. The following functions will be covered: Range NamesStatisticald104Date/TimeFinancialInformationalMath/TrigLogical IF StatementsLookupDatabase functionsMajor Components - The following will be covered:
Table - The Table feature will compare differences between a table and a normal range.Chart - This feature will reorganize the data source and cover various Chart types to demonstrate how to modify chart elements for enhanced presentations. (Also, since the Charting layout ribbon was changed in Excel 2013, new and additional Chart types that were added in Excel will be covered, as well). PivotTables - This 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.*****************************************************************************
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.

• Format: Paperback
• Language: English
• ISBN: 1975985990
• ISBN13: 9781975985998
• Release Date: August 2017
• Publisher: Createspace Independent Publishing Platform
• Length: 126 Pages
• Weight: 0.68 lbs.
• Dimensions: 0.3" x 8.5" x 11.0"