Microsoft Excel 2019 pivot table data crunching
(eBook)
Author
Contributors
Alexander, Michael, 1972- author.
Published
[Place of publication not identified] : Published with the authorization of Microsoft Corporation by Pearson Education, [2019].
Format
eBook
ISBN
1509307257, 1509308202, 9781509307258, 9781509308200
Physical Desc
1 online resource (1 volume) : illustrations
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
Description
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power-including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else. By reading this book, you will: - Master easy, powerful ways to create, customize, change, and control pivot tables - Control all future pivot tables using new pivot table defaults - Transform huge data sets into clear summary reports - Instantly highlight your most profitable customers, products, or regions - Use Power Query to quickly import, clean, shape, and analyze disparate data sources - Build geographical pivot tables with 3D Map - Construct and share state-of-the-art dynamic dashboards - Revamp analyses on the fly by dragging and dropping fields - Build dynamic self-service reporting systems - Share your pivot tables with colleagues - Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 - Automate pivot tables with macros and VBA - Save time by adapting reports with GetPivotData - Discover today's most useful pivot table tips and shortcuts
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Jelen, B., & Alexander, M. (2019). Microsoft Excel 2019 pivot table data crunching . Published with the authorization of Microsoft Corporation by Pearson Education.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Jelen, Bill and Michael Alexander. 2019. Microsoft Excel 2019 Pivot Table Data Crunching. Published with the authorization of Microsoft Corporation by Pearson Education.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Jelen, Bill and Michael Alexander. Microsoft Excel 2019 Pivot Table Data Crunching Published with the authorization of Microsoft Corporation by Pearson Education, 2019.
MLA Citation, 9th Edition (style guide)Jelen, Bill,, and Michael Alexander. Microsoft Excel 2019 Pivot Table Data Crunching Published with the authorization of Microsoft Corporation by Pearson Education, 2019.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
dadd1893-b46a-39b0-b8dd-d12127456c8d-eng
Grouping Information
| Grouped Work ID | dadd1893-b46a-39b0-b8dd-d12127456c8d-eng |
|---|---|
| Full title | microsoft excel 2019 pivot table data crunching |
| Author | jelen bill |
| Grouping Category | book |
| Last Update | 2024-09-06 16:31:08PM |
| Last Indexed | 2024-09-28 04:26:56AM |
Book Cover Information
| Image Source | syndetics |
|---|---|
| First Loaded | Aug 20, 2024 |
| Last Used | Sep 28, 2024 |
Marc Record
| First Detected | Jul 29, 2024 04:04:13 PM |
|---|---|
| Last File Modification Time | Sep 06, 2024 04:39:25 PM |
MARC Record
| LEADER | 07044cam a2200553 i 4500 | ||
|---|---|---|---|
| 001 | on1086399203 | ||
| 003 | OCoLC | ||
| 005 | 20240830103855.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 190220s2019 xx a o 000 0 eng d | ||
| 019 | |a 1302295838 | ||
| 020 | |a 1509307257 | ||
| 020 | |a 1509308202 | ||
| 020 | |a 9781509307258|q (electronic bk.) | ||
| 020 | |a 9781509308200 | ||
| 020 | |z 9781509307241 | ||
| 035 | |a (OCoLC)1086399203|z (OCoLC)1302295838 | ||
| 037 | |a CL0501000028|b Safari Books Online | ||
| 040 | |a UMI|b eng|e rda|e pn|c UMI|d OCLCF|d UKAHL|d CEF|d C6I|d OCLCO|d OCLCQ|d LVT|d OCLCO|d KSU|d EBLCP|d OCLCQ|d OCLCO|d OCLCL|d N$T|d TYFRS|d N$T | ||
| 049 | |a FMGA | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 005.54|2 23/eng/20240715 |
| 100 | 1 | |a Jelen, Bill,|e author.|0 http://id.loc.gov/authorities/names/n2003117264 | |
| 245 | 1 | 0 | |a Microsoft Excel 2019 pivot table data crunching /|c Bill Jelen, Michael Alexander. |
| 246 | 3 | 0 | |a Excel 2019 pivot table data crunching |
| 264 | 1 | |a [Place of publication not identified] :|b Published with the authorization of Microsoft Corporation by Pearson Education,|c [2019] | |
| 264 | 4 | |c ©2019 | |
| 300 | |a 1 online resource (1 volume) :|b illustrations | ||
| 336 | |a text|b txt|2 rdacontent | ||
| 337 | |a computer|b c|2 rdamedia | ||
| 338 | |a online resource|b cr|2 rdacarrier | ||
| 490 | 1 | |a MrExcel Library. | |
| 505 | 0 | |a Cover Page -- Title Page -- Copyright Page -- Dedication Page -- Contents at a Glance -- Contents -- Acknowledgments -- About the Authors -- Introduction -- Chapter 1 Pivot table fundamentals -- Why you should use a pivot table -- When to use a pivot table -- Anatomy of a pivot table -- Values area -- Rows area -- Columns area -- Filters area -- Pivot tables behind the scenes -- Pivot table backward compatibility -- A word about compatibility -- Next steps -- Chapter 2 Creating a basic pivot table -- Ensuring that data is in a Tabular layout -- Avoiding storing data in section headings | |
| 505 | 8 | |a Avoiding repeating groups as columns -- Eliminating gaps and blank cells in the data source -- Applying appropriate type formatting to fields -- Summary of good data source design -- How to create a basic pivot table -- Adding fields to a report -- Fundamentals of laying out a pivot table report -- Adding layers to a pivot table -- Rearranging a pivot table -- Creating a report filter -- Understanding the Recommended PivotTable and the Ideas features -- Using slicers -- Creating a standard slicer -- Creating a Timeline slicer -- Keeping up with changes in the data source | |
| 505 | 8 | |a Dealing with changes made to the existing data source -- Dealing with an expanded data source range due to the addition of rows or columns -- Sharing the pivot cache -- Side effects of sharing a pivot cache -- Saving time with new PivotTable tools -- Deferring layout updates -- Starting over with one click -- Relocating a pivot table -- Next steps -- Chapter 3 Customizing a pivot table -- Making common cosmetic changes -- Applying a table style to restore gridlines -- Changing the number format to add thousands separators -- Replacing blanks with zeros -- Changing a field name | |
| 505 | 8 | |a Making report layout changes -- Using the Compact layout -- Using the Outline layout -- Using the traditional Tabular layout -- Controlling blank lines, grand totals, and other settings -- Customizing a pivot table's appearance with styles and themes -- Customizing a style -- Modifying styles with document themes -- Changing summary calculations -- The Excel team fixed the Count Of Revenue bug -- Changing the calculation in a value field -- Showing percentage of total -- Using % Of to compare one line to another line -- Showing rank -- Tracking running total and percentage of running total | |
| 505 | 8 | |a Displaying a change from a previous field -- Tracking the percentage of a parent item -- Tracking relative importance with the Index option -- Adding and removing subtotals -- Suppressing subtotals with many row fields -- Adding multiple subtotals for one field -- Formatting one cell is new in Office 365 -- Next steps -- Chapter 4 Grouping, sorting, and filtering pivot data -- Using the PivotTable Fields list -- Docking and undocking the PivotTable Fields list -- Rearranging the PivotTable Fields list -- Using the Areas section drop-downs -- Sorting in a pivot table | |
| 520 | |a Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power-including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else. By reading this book, you will: - Master easy, powerful ways to create, customize, change, and control pivot tables - Control all future pivot tables using new pivot table defaults - Transform huge data sets into clear summary reports - Instantly highlight your most profitable customers, products, or regions - Use Power Query to quickly import, clean, shape, and analyze disparate data sources - Build geographical pivot tables with 3D Map - Construct and share state-of-the-art dynamic dashboards - Revamp analyses on the fly by dragging and dropping fields - Build dynamic self-service reporting systems - Share your pivot tables with colleagues - Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 - Automate pivot tables with macros and VBA - Save time by adapting reports with GetPivotData - Discover today's most useful pivot table tips and shortcuts | ||
| 588 | 0 | |a Online resource; title from title page (Safari, viewed February 20, 2019). | |
| 630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
| 650 | 0 | |a Business|x Computer programs.|0 http://id.loc.gov/authorities/subjects/sh85018263 | |
| 650 | 0 | |a Table manipulation (Computer science)|0 http://id.loc.gov/authorities/subjects/sh85131795 | |
| 700 | 1 | |a Alexander, Michael,|d 1972-|e author.|1 https://id.oclc.org/worldcat/entity/E39PCjvFBYmTVbcjhrfXYFGQHK|0 http://id.loc.gov/authorities/names/n2005074553 | |
| 758 | |i has work:|a Microsoft Excel 2019 pivot table data crunching (Text)|1 https://id.oclc.org/worldcat/entity/E39PCGMwJwhQrvCXWtWXqjPjVK|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version:|t Microsoft excel 2019|w (OCoLC)1043190110|w (DLC) 2018963618 |
| 830 | 0 | |a MrExcel library.|0 http://id.loc.gov/authorities/names/no2010116020 | |
| 856 | 4 | 0 | |u https://www.aclib.us/OReilly |