Excel 2013 Pivot Tables: Including the “Data Model”
- Length: 180 pages
- Edition: 1
- Language: English
- Publisher: CreateSpace Independent Publishing Platform
- Publication Date: 2015-04-29
- ISBN-10: 1511954876
- ISBN-13: 9781511954877
- Sales Rank: #10220456 (See Top 100 Books)
A pivot table is a simple, yet powerful technique, that enables Excel’s users to transform data overload into meaningful and organized knowledge.
With pivot tables you can:
- See the data in dozens of different ways with a simple mouse drag
- Perform fast calculations with no need for formulas
- Focus on another part of the data each time and get a clear picture
- Show more trends and patterns
- Create dozens of reports and charts to analyze your data
While reading the book and using the practice files, you will know to:
- Create a Pivot Table: Select data from the current file Select data from another Excel file Change the data source Create a pivot table based on a dynamic data table
- Perform Calculations: Use sum, average, minimum, maximum and count Show Percentage of a column total, row total and Grand total Display the running total Group numeric and date data Use calculated field and calculated item
- Change The Report Structure Switching columns and rows Adding columns or rows Adding a page break between items
- Format your Pivot Tables Add totals and Subtotals Sort Filter
You will also know to
- Add slicers and to manipulate then
- Add a timelines and to manipulate it
- Add charts to your pivot tables
- Use the new and innovative feature: “The Data Model” And, of course, You will learn some cool tips and tricks!
Donate to keep this site alive
To access the Link, solve the captcha.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.