Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) /

Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables. Use Excel 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 pivo...

Full description

Bibliographic Details
Main Author: Jelen, Bill (Author)
Corporate Author: Safari, an O'Reilly Media Company
Format: eBook
Language:English
Published: Microsoft Press, 2021.
Edition:1st edition
Subjects:
Online Access:Connect to this electronic resource

MARC

Tag First Indicator Second Indicator Subfields
LEADER 00000nam a2200000 a 4500
001 in00004560607
006 m o d
007 cr cn
008 161221s2021 xx o eng
005 20260128183047.7
020 |z 9780137521821 
020 |z 9780137521838 
020 |z 9780137521821 
024 8 |a 9780137521821 
035 |a (CaSebORM)9780137521821 
041 0 |a eng 
100 1 |a Jelen, Bill,  |e author. 
245 1 0 |a Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) /  |c Jelen, Bill. 
250 |a 1st edition 
264 1 |b Microsoft Press,  |c 2021. 
300 |a 1 online resource (544 pages) 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file 
520 |a Renowned Excel expert Bill Jelen (MrExcel) helps you crunch data from any source with Excel pivot tables. Use Excel 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 powerincluding valuable improvements in Excel and Excel in Office 365. Drawing on years of Excel experience, Bill Jelen offers practical "recipes" for solving real business problems, helps you avoid common mistakes, and presents 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 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 
533 |a Electronic reproduction.  |b Boston, MA :  |c Safari,  |n Available via World Wide Web. 
538 |a Mode of access: World Wide Web. 
542 |f Copyright © Microsoft Press 
550 |a Made available through: Safari, an O'Reilly Media Company. 
588 0 |a Online resource; Title from title page (viewed December 28, 2021) 
655 7 |a Electronic books.  |2 local 
710 2 |a Safari, an O'Reilly Media Company. 
856 4 0 |u https://proxy.library.tamu.edu/login?url=https://go.oreilly.com/TAMU/library/view/-/9780137521821/?ar  |z Connect to this electronic resource  |t 0 
999 f f |s a672d085-afe7-4432-80b5-918eb7f6bb31  |i a672d085-afe7-4432-80b5-918eb7f6bb31  |t 0 
952 f f |a Texas A&M University  |b College Station  |c Electronic Resources  |s www_evans  |d Available Online  |t 0  |h Library of Congress classification 
998 f f |t 0  |l Available Online