MICROSOFT EXCEL 2019 DATA PROCESSING USING PIVOT TABLES

Discover the power of data analysis with Microsoft Excel 2019 thanks to the book by Bill Jelen (MrExcel) and Michael Alexander, well-known Excel experts. Learn how to use pivot tables to process data from various sources and create dynamic reports in just a few minutes. Gain full control over your data and gain valuable business insights.

• Master creating, customizing and modifying pivot tables.
• Ensure the proper properties of future pivot tables with default settings.
• Transform large data sets into readable reports.
• Highlight customers, products and regions with the highest revenues.
• Quickly import, clean and analyze data from various sources using Power Query.
• Create pivot tables with geographic data using 3D Map.
• Build dynamic self-service reporting systems.

Bill Jelen and Michael Alexander, with a combined 45 years of experience working with Excel, share practical tips and tricks that will help you avoid common mistakes and solve real business problems. Thanks to their knowledge, you will quickly master the flexibility and analytical capabilities of pivot tables, including improvements introduced in Excel 2019 and Office 365.

This book is an indispensable guide for anyone who wants to fully exploit the potential of Excel for data analysis. You will learn how to create and share modern dashboards, improve analysis results on the fly, combine data using Power Pivot and automate pivot tables using macros and VBA. You will also learn useful tips and shortcuts that will save you time and increase work efficiency.

APN Promise is a reputable publishing house specializing in publications in the fields of IT and business. Their books are characterized by high quality, a practical approach and up-to-date knowledge. Thanks to cooperation with experienced authors and experts, APN Promise provides readers with valuable tools for personal and professional development.

This book is the key to mastering pivot tables in Excel 2019. Whether you are a beginner or an experienced user, you will find valuable information and practical tips in it that will help you fully exploit the potential of this powerful tool for data analysis and making better business decisions.