Jelen, Bill
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot (Business Skills)
- ISBN 13:
- 9780135408797
- author:
- Jelen, Bill
- format:
- Paperback
- publisher:
- Addison Wesley
- language:
- English
- Publication Year:
- 2013
- Pages:
- 608
- Dimensions:
- 23.1 x 18.8 x 3.2 centimetres (1
- Genre:
- Computers, Applications, Microsoft Excel,
- Condition:
- New
- Availability:
- Item usually sent within 10 working days
Description
Mastering Microsoft Excel's Pivot Table Power Learn to create powerful, dynamic reports in minutes with pivot tables and pivot charts. This comprehensive guide helps you leverage their flexibility and analytical power to take control of your data and business. With over 30 years of cutting-edge Excel experience, Bill Jelen shares practical "recipes" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else. Discover how to use Copilot and Analyze Data features, dynamic arrays, Power Query, and more to transform huge datasets into clear summary reports. By mastering these techniques, you can instantly highlight your most profitable customers, products, or regions, build geographical pivot tables with 3D Maps, construct and share state-of-the-art dynamic dashboards, and revamp analyses on the fly.
Related Products
Related Products
Excel Power Pivot and Power Query For Dummies, 2nd Edition
Alexander, M
Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
Singh, Avichal
Excel Pivot Table Champion: How to Easily Manage and Analyze Giant Databases with Microsoft Excel Pivot Tables (Excel Champions)
Mejia, Henry E
Analyzing Data with Power BI and Power Pivot for Excel
Ferrari, Alberto
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)
Jelen, Bill