Excel 365 - Formulas, Charts And PivotTables: Supports Excel 2010, 2013, 2016 and 2019 (Excel 365 - Level 2)

By Jeff Hutchinson

This Workbook will help you understand the mysteries and capabilities of Excel. If you are trying to accomplish a task in Excel, and you know the system is capable of solving the problem, having a preparatory knowledge will help immensely, and you can reference the workbook if needed. The features in the Workbook will help you get Excel tasks done more efficiently.
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 NamesStatisticalTextDate/TimeFinancialInformationalMath/Trig Logical IF StatementsLookup Database FunctionsMajor Components - Tables, Charts, and PivotTables
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. What's in the Workbook? Click on the left side of the screen: Look Inside
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

• Format: Paperback
• Language: English
• ISBN: 1660221943
• ISBN13: 9781660221943
• Release Date: January 2020
• Publisher: Independently Published
• Length: 132 Pages
• Weight: 0.71 lbs.
• Dimensions: 0.3" x 8.5" x 11.0"