Product Description & Reviews
Excel 2013 Pivot Tables Including the "Data Model" 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 o Select data from the current file o Selec data from another Excel file o Change the data source o Create a pivot table based on a dynamic data table Perform Calculations: o Use sum, average, minimum, maximum and count o Show Percentage of a column total, row total and Grand total o Display the running total o Group numeric and date data o Use calculated field and calculated item Change The Report Structure o Switching columns and rows o Adding columns or rows o Adding a page break between items Format your Pivot Tables o Add totals and Subtotals o Sort o 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!
Features & Highlights
|Manufacturer:||CreateSpace Independent Publishing Platform|
|Part Number:||black & white illustrations|
|Publisher:||CreateSpace Independent Publishing Platform|
|Studio:||CreateSpace Independent Publishing Platform|
|MPN:||black & white illustrations|
|Item Weight:||0.6 pounds|
|Item Size:||0.45 x 9 x 9 inches|
|Package Weight:||0.73 pounds|
|Package Size:||6 x 0.45 x 0.45 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
By O Reilly Media
mpn: 35561483, ean: 9781449316952, isbn: 9781449316952,
This practical guide provides more than 150 recipes to help you generate high-quality graphs quickly, without having to comb through all the details o...
By O'Reilly Media
mpn: 37600747, ean: 9781449357108, isbn: 1449357105,
Learn how to perform data analysis with the R language and software environment, even if you have little or no programming experience. With the tutori...
By Packt Publishing
mpn: black & white illustrations, ean: 9781849514767, isbn: 9781849514767,
With over 60 recipes, this Cookbook will teach you both the elementary and finer points of the OpenGL Shading Language, and get you familiar with the ...