Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis (In Everyday Language) (Volume 2)

3 avg rating
( 1 ratings by Goodreads )
 
9781511820875: Excel 2013 Pivot Tables: Including the
View all copies of this ISBN edition:
 
 

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!

"synopsis" may belong to another edition of this title.

About the Author:

Maayan Poleg holds an MA in Education Administration. She instructs and develops Excel's applications since 1996. Maayan has an extensive knowledge and experience in the field of VBA training You can contact Maayan at: Maayan@excel-vba.guru

"About this title" may belong to another edition of this title.

Other Popular Editions of the Same Title

9781511954877: Excel 2013 Pivot Tables: Including the

Featured Edition

ISBN 10:  1511954876 ISBN 13:  9781511954877
Publisher: CreateSpace Independent Publishi..., 2015
Softcover

Top Search Results from the AbeBooks Marketplace

1.

Poleg, Maayan
Published by Createspace Independent Publishing Platform (2015)
ISBN 10: 151182087X ISBN 13: 9781511820875
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Createspace Independent Publishing Platform, 2015. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781511820875

More information about this seller | Contact this seller

Buy New
US$ 15.41
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Poleg, Maayan
Published by CreateSpace Independent Publis (2018)
ISBN 10: 151182087X ISBN 13: 9781511820875
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publis, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 151182087X

More information about this seller | Contact this seller

Buy New
US$ 19.63
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Maayan Poleg, Sharon Barak
Published by Createspace Independent Publishing Platform, United States (2015)
ISBN 10: 151182087X ISBN 13: 9781511820875
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Createspace Independent Publishing Platform, United States, 2015. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. 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!. Seller Inventory # APC9781511820875

More information about this seller | Contact this seller

Buy New
US$ 20.18
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Maayan Poleg, Sharon Barak
Published by Createspace Independent Publishing Platform, United States (2015)
ISBN 10: 151182087X ISBN 13: 9781511820875
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Createspace Independent Publishing Platform, United States, 2015. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****.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!. Seller Inventory # APC9781511820875

More information about this seller | Contact this seller

Buy New
US$ 20.82
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Maayan Poleg
Published by CreateSpace Independent Publishing Platform
ISBN 10: 151182087X ISBN 13: 9781511820875
New Paperback Quantity Available: > 20
Print on Demand
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform. Paperback. Condition: New. This item is printed on demand. 180 pages. Dimensions: 9.0in. x 6.0in. x 0.5in.Excel 2013 Pivot Tables Including the Data Model A pivot table is a simple, yet powerful technique, that enables Excels 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! This item ships from La Vergne,TN. Paperback. Seller Inventory # 9781511820875

More information about this seller | Contact this seller

Buy New
US$ 26.33
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

6.

Poleg, Maayan
ISBN 10: 151182087X ISBN 13: 9781511820875
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description 2015. PAP. Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781511820875

More information about this seller | Contact this seller

Buy New
US$ 14.60
Convert Currency

Add to Basket

Shipping: US$ 12.04
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Poleg, Maayan; Barak, Sharon
Published by CreateSpace Independent Publishing Platform
ISBN 10: 151182087X ISBN 13: 9781511820875
New PAPERBACK Quantity Available: > 20
Seller:
Russell Books
(Victoria, BC, Canada)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform. PAPERBACK. Condition: New. 151182087X Special order direct from the distributor. Seller Inventory # ING9781511820875

More information about this seller | Contact this seller

Buy New
US$ 20.19
Convert Currency

Add to Basket

Shipping: US$ 7.00
From Canada to U.S.A.
Destination, Rates & Speeds

8.

Maayan Poleg; Sharon Barak
Published by CreateSpace Independent Publishing Platform (2015)
ISBN 10: 151182087X ISBN 13: 9781511820875
New Softcover First Edition Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform, 2015. Condition: New. book. Seller Inventory # M151182087X

More information about this seller | Contact this seller

Buy New
US$ 32.92
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds