- Independently Published
Excel 2016 Formulas, Charts And PivotTables: Supports Excel 2010, 2013 and 2016
Key Metrics
- Jeff Hutchinson
- Independently Published
- Paperback
- 9781081707316
- 11.02 X 8.5 X 0.28 inches
- 0.71 pounds
- Computers > Business & Productivity Software - Spreadsheets
- English
Book Description
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.
This Step-By-Step Workbook will cover four major Excel categories including Intermediate Formulas, Table/Range, Charts, and PivotTables. The following concepts will be covered:
Intermediate Formulas
The primary skills covered in this group of chapters are Formulas and Functions. Often, 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 can discover the perfect function for their intended purpose. The following functions are covered:
- Range Names
- Statistical
- Text
- Date/Time
- Financial
- Informational
- Math/Trig
- Logical IF Statements
- Lookup
- Database Functions
The three major components of Excel (in this group) include Tables, Charts, and PivotTables.
- Table/Range - This will compare the differences between a Table and a Normal Range.
- Charts - This will reorganize the data source and cover various Chart types to demonstrate how to modify Chart elements for enhanced capabilities. (Also, since the Charting layout ribbon was changed in Excel 2013, new and additional Chart types that have been added in Excel will be covered, as well).
- PivotTables - First, the Workbook will focus on understanding the value and need to analyze data using a PivotTable. Then, it will cover how to use Filtering, Formatting, PivotCharts, Label Adjustments, and Calculation Capability to manipulate a PivotTable.
Enter one of the following keywords: Chart, PivotTable, Vlookup, If Logic, Text Functions, etc.
How the Workbook is Designed
This Workbook contains over 200+ 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
Videos
No Videos
Community reviews
Write a ReviewNo Community reviews