30% off all books with the code: BOOKS
  • check 10+ million books
  • check New arrivals every day
  • check Trusted by 1M+ customers
  • check Great prices & discounts
  • check Shipping across Europe

Excel 2013 Pivot Tables Including the "Data Model" Smart Data Analysis - Maayan Poleg,Sharon Barak

English
2015-04-19
€22.21 €31.73

-30% with code BOOKS

In stock at our supplier

Shipping in 10-16 days

30-day return policy

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 pict ... Full description

You May Also Like

Description

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 Tableo Select data from the current fileo Selec data from another Excel fileo Change the data sourceo Create a pivot table based on a dynamic data tablePerform Calculations:o Use sum, average, minimum, maximum and counto Show Percentage of a column total, row total and Grand totalo Display the running totalo Group numeric and date datao Use calculated field and calculated itemChange The Report Structureo Switching columns and rowso Adding columns or rowso Adding a page break between itemsFormat your Pivot Tableso Add totals and Subtotalso Sorto FilterYou 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!

More Information

Author Maayan Poleg, Sharon Barak
Publisher CreateSpace Independent Publishing Platform
Release year 2015
Cover type Softcover
EAN 9781511820875
Write Your Own Review
You're reviewing: Excel 2013 Pivot Tables Including the "Data Model" Smart Data Analysis
Your Rating:

Goodreads Reviews

€22.21 €31.73