Cargando…
Microsoft Excel 2019 pivot table data crunching /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified] :
Published with the authorization of Microsoft Corporation by Pearson Education,
[2019]
|
| Colección: | MrExcel library.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_on1086399203 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 190220s2019 xx a o 000 0 eng d | ||
| 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 | ||
| 019 | |a 1302295838 | ||
| 020 | |a 9781509308200 | ||
| 020 | |a 1509308202 | ||
| 020 | |z 9781509307241 | ||
| 020 | 0 | |a 9781509307258 |q (online) | |
| 020 | |a 1509307257 | ||
| 035 | |a (OCoLC)1086399203 |z (OCoLC)1302295838 | ||
| 037 | |a CL0501000028 |b Safari Books Online | ||
| 050 | 4 | |a HF5548.4.M523 | |
| 082 | 0 | 4 | |a 005.54 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Jelen, Bill, |e author. | |
| 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. | |
| 588 | 0 | |a Online resource; title from title page (Safari, viewed February 20, 2019). | |
| 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 | ||
| 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 | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
| 650 | 0 | |a Business |x Computer programs. | |
| 650 | 0 | |a Table manipulation (Computer science) | |
| 650 | 7 | |a Business |x Computer programs. |2 fast |0 (OCoLC)fst00842283 | |
| 650 | 7 | |a Table manipulation (Computer science) |2 fast |0 (OCoLC)fst01141743 | |
| 700 | 1 | |a Alexander, Michael, |d 1972- |e author. | |
| 776 | 1 | |t Microsoft excel 2019 |w (OCoLC)on1043190110 |w (DLC)2018963618. | |
| 830 | 0 | |a MrExcel library. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781509308200/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL7117919 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL7048245 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35849740 | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35777951 | ||
| 994 | |a 92 |b IZTAP | ||