Open Daily: 10am - 10pm | Alley door pickup 10am - 7pm 3038 Hennepin Ave Minneapolis, MN
612-822-4611

  • Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis

Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis

Barak, Sharon
Poleg, Maayan

Paperback

Series: In Everyday Language, Book 2

DatabasesGeneral Computers

ISBN10: 1511954876
ISBN13: 9781511954877
Publisher: Createspace
Published: Apr 29 2015
Pages: 180
Weight: 0.75
Height: 0.47 Width: 6.00 Depth: 9.00
Language: English
Excel 2013 Pivot TablesIncluding the Data ModelA 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 dataWhile reading the book and using the practice files, you will know to: Create a Pivot TableoSelect data from the current fileoSelec data from another Excel fileoChange the data sourceoCreate a pivot table based on a dynamic data tablePerform Calculations: oUse sum, average, minimum, maximum and countoShow Percentage of a column total, row total and Grand totaloDisplay the running totaloGroup numeric and date dataoUse calculated field and calculated itemChange The Report StructureoSwitching columns and rowsoAdding columns or rowsoAdding a page break between itemsFormat your Pivot TablesoAdd totals and SubtotalsoSortoFilterYou 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 ModelAnd, of course, You will learn some cool tips and tricks!

1 different editions

Also available

Also in

General Computers

View All