Microsoft Excel 2016: Data Analysis with PivotTables

By Fish Davis

PivotTables will help you analyze, summarize, and pick apart your large spreadsheets fast.

You could sit for hours, pouring over hundreds, or thousands of rows. Filtering, sorting, and calculating like there's no tomorrow. And when you need to alter the data, you can do it all again.

Or you could take a different approach.
You can spend seconds, and create PivotTables.

Microsoft Excel 2016 has many great features to take advantage of like Recommended PivotTables, Slicers, and Timelines.

Are you new to PivotTables? This eBook will walk you through the ins and outs.

Have you been using PivotTables for a while? Learn tips, tricks and the latest features.

Don’t have Microsoft Excel 2016?
No Problem.
Many exercises are applicable to PivotTables in Excel 2013, and 2010 as well.

Learn to create PivotTables in minutes, not days. Then use that knowledge to create user-friendly, interactive reports fast, not in hours!

Whether you are a small business owner looking to better understand sales trends, an assistant creating weekly reports, or you're looking for a way to better track household expenses, if you are using Excel, you need PivotTables!

• Language: English
• Publisher: IFS Harrison
• Release date: Feb 5, 2019
• ISBN: 9780463776636

Book preview

Work Smarter Tips

Microsoft Excel 2016:

Data Analysis with PivotTables

By Fish Davis

Inside:

PivotTables. What’s in it for me?

Create PivotTables

Report Filters

Refresh the PivotTable When Opening a File

View the Details

Format Values

Summarize Data By…

Create Multiple PivotTables from Report Filters

Group Data by Date

Override Row & Column Labels

Find Top and Bottom Values

Slicers

Timelines

Calculated Fields

Clear Deleted Items from a Pivot Table

PivotTable Layouts

PivotTable Styles

PivotCharts

Work Smarter Tips

Microsoft Excel 2016: Data Analysis with PivotTables

Copyright © 2019 by Fish Davis All Rights Reserved

Thank you for purchasing this eBook!

NOT FOR RESALE-

Please Note: This product is not for resale or redistribution. Any reselling, reproducing, redistributing, or copying of this e-Book, its pictures, listing description, or title is strictly prohibited by Local, State, Federal and International Intellectual Copyright laws. Any unauthorized use will be pursued to the fullest extent of the law.

All copyrights, quotations, websites, or registered trademarks listed in this e-Book are merely listed as examples or reference. The author is in no way affiliated with any companies, services, websites, quotations, properties or names mentioned herein, and each individual trademark or copyright listed within this e-Book belongs only to the respective owner and are being used with written permission or under terms of fair use or public domain.