The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards

by C J Benton

Overview

Learn how to create Pivot Tables quickly and easily with this step-by-step guide!

This book contains several basic, intermediate, and advanced Pivot Table examples with screenshots demonstrating how to:

Organize and summarize data

Format results

Insert Pivot Charts

Display averages & percentages

Group data into predefined ranges

Rank results

Insert calculated fields

In addition to the above, you will also learn how to create and update a basic Dashboard using Pivot Table data.

A great resource for:

Business Analysts

Data Analysts

Financial Analysts

Administrative and Support staff

Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using of Microsoft(R) Excel(R)!

Book 2 in The Microsoft Excel Step-By-Step Training Guide Series

Book 1 - The Step-By-Step Guide To The 25 Most Common Microsoft Excel Formulas & Features

Book 2 - The Step-By-Step Guide To Pivot Tables & Introduction To Dashboards

Book 3 - The Step-By-Step Guide To The VLOOKUP formula in Microsoft Excel

Book 4 - The Microsoft Excel Step-By-Step Training Guide Book Bundle

Product Details

ISBN-13:	9781515313953
Publisher:	CreateSpace Publishing
Publication date:	08/09/2015
Series:	The Microsoft Excel Step-By-Step Training Guide , #2
Pages:	114
Product dimensions:	6.14(w) x 9.21(h) x 0.24(d)