Excel 2016 Formulas, Charts, And PivotTable: Supports Excel 2010, 2013, and 2016 (Excel 2016 Level 2)

This step-by-step workbook will guide you through learning the Excel program. 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. The workbook includes over 160 Practice Exercises that demonstrate how to use Excel concepts, and can also be used as a reference guide to quickly look up a topic.

Intermediate Formulas - Text, Date/Time, Logical and Lookup
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 its many capabilities. However, after acquiring a diverse knowledge of the various Excel functions, they are able to discover the perfect function for their intended purpose. These functions include Range Names, Statistical, Text, Date/Time, Financial, Informational, Math/Trig, Logical IF Statements, Lookup, as well as Database functions.

Major Components - Tables, Charts, PivotTables
The three major components of Excel (in this group) include Tables, Charts, and PivotTables. The Table feature will compare differences between a table and a normal range. The Chart 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 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.