Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
[New York] : Pearson Education, Inc., [2022]
Format: Book
Description: xxxii, 508 pages : illustrations ; 24 cm
"Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: 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 flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen ("MrExcel") shares practical "recipes" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else." -- Provided by publisher.
Contents:
Pivot table fundamentals -- Creating a basic pivot table -- Customizing a pivot table -- Grouping, sorting, and filtering pivot data -- Performing calculations in pivot tables -- Using pivot charts and other visualizations -- Analyzing disparate data sources with pivot tables -- Sharing dashboards with Power BI -- Using cube formulas with Data Model or OLAP data -- Unlocking features with Data Model and Power Pivot -- Analyzing geographic data with 3D Map -- Enhancing pivot table reports with macros -- Using VBA or TypeScript to create pivot tables -- Advanced pivot table tips and techniques -- Dr. Jekyll and Mr. GePivotData -- Creating pivot tables in Excel Online -- Pivoting without a pivot table using dynamic arrays or Power Query -- Unpivoting in Power Query.
Subjects:
Microsoft Excel (Computer file)
Business -- Computer programs.
Business intelligence -- Computer programs.
Knowledge management -- Computer programs.
Microsoft Excel (Computer file)
Business -- Computer programs.
Business intelligence -- Computer programs.
Knowledge management -- Computer programs.
ISBN:
0137521839
Availability | |||
---|---|---|---|
Call Number | Location | Shelf Location | Status |
TECH Computer Software Excel Jel | Main (Downtown) | New - First Level, Nonfiction | Out (Due: 6/8/2024) |
"Practice and solution files on the web"--Cover.
Includes index.
Includes index.