Coupon
Excel 2013 Pivot Tables : Including the "data Model" Smart Data Analysis
by Maayan Poleg and Sharon Barak


Overview - 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 oSelect data from the current file oSelec data from another Excel file oChange the data source oCreate a pivot table based on a dynamic data table Perform Calculations: oUse sum, average, minimum, maximum and count oShow Percentage of a column total, row total and Grand total oDisplay the running total oGroup numeric and date data oUse calculated field and calculated item Change The Report Structure oSwitching columns and rows oAdding columns or rows oAdding a page break between items Format your Pivot Tables oAdd totals and Subtotals oSort oFilter 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  Read more...

 
Paperback
  • $17.95
  • 20% off for Members: Get the Club Price
    $ 14.36
Add to Cart
+ Add to Wishlist
In Stock.

This item is Non-Returnable.
FREE Shipping for Club Members
 
> Check In-Store Availability

In-Store pricing may vary

 
 
New & Used Marketplace 5 copies from $16.22
 
 
 
 

More About Excel 2013 Pivot Tables by Maayan Poleg; Sharon Barak
 
 
 
Overview
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 oSelect data from the current file oSelec data from another Excel file oChange the data source oCreate a pivot table based on a dynamic data table Perform Calculations: oUse sum, average, minimum, maximum and count oShow Percentage of a column total, row total and Grand total oDisplay the running total oGroup numeric and date data oUse calculated field and calculated item Change The Report Structure oSwitching columns and rows oAdding columns or rows oAdding a page break between items Format your Pivot Tables oAdd totals and Subtotals oSort oFilter 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


This item is Non-Returnable.

 
Details
  • ISBN-13: 9781511820875
  • ISBN-10: 151182087X
  • Publisher: Createspace Independent Publishing Platform
  • Publish Date: April 2015
  • Page Count: 180
  • Dimensions: 9.02 x 5.98 x 0.41 inches
  • Shipping Weight: 0.6 pounds


Related Categories

Books > Computers > Data Modeling & Design
Books > Computers > Databases - General

 
BAM Customer Reviews