Автор: Jelen Bill, Alexander Michael Название: Microsoft Excel 2019 Pivot Table Data Crunching ISBN: 1509307249 ISBN-13(EAN): 9781509307241 Издательство: Pearson Education Цена: 5146.00 р. Наличие на складе: Есть у поставщикаПоставка под заказ. Описание: 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
Описание: 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.
By reading this book, you will:
Master easy, powerful ways to create, customize, change, and control pivot tables
Transform huge datasets into clear summary reports
Instantly highlight your most profitable customers, products, or regions
Use the data model and Power Query to quickly analyze disparate data sources
Create powerful crosstab reports with new dynamic arrays and Power Query
Build geographical pivot tables with 3D Maps
Construct and share state-of-the-art dynamic dashboards
Revamp analyses on the fly by dragging and dropping fi elds
Build dynamic self-service reporting systems
Share your pivot tables with colleagues
Create data mashups using the full Power Pivot capabilities in modern Excel versions
Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online
Save time and avoid formatting problems by adapting reports with GetPivotData
Unpivot source data so it's easier to work with
Use new Analyze Data artificial intelligence to create pivot tables
Автор: Martin, Mg Название: Excel pivot tables ISBN: 1076014380 ISBN-13(EAN): 9781076014382 Издательство: Неизвестно Рейтинг: Цена: 3274.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the worlds foremost PowerPivot blogger and practitioner, the books concepts and approach are introduced in a step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available within the pages of this easy-to-follow guide. This updated edition covers new features introduced with Office 2015.
Описание: Microsoft Excel is one of the most commonly used programs across all industry and geopolitical lines. Despite this fact, many business people, even those who interact with Excel regularly, don`t understand the essentials that can really further their career.
Описание: If you have always wanted to learn how to use Excel but feared that it would be too technical and time-consuming, then keep reading... Microsoft Excel is one of the most commonly used programs across all industry and geopolitical lines. Despite this fact, many business people, even those who interact with Excel regularly, don't understand the essentials that can really further their career. The truth is that most people find the task of learning about Excel overwhelming when confronted with a thousand-page book. Could you be one of them? You see, more information is not always good, especially if you want to save time and effort. The right information expressed in a clearly beneficial way is, however, always good. That's why this book focuses on the basics and what you'll really need on a daily basis. Inside Excel for Beginners: Learn Excel 2016, Including an Introduction to Formulas, Functions, Graphs, Charts, Macros, Modelling, Pivot Tables, Dashboards, Reports, Statistics, Excel Power Query, and More, you'll find tips and tricks for dealing with:
A wide variety of different formulas
An array of functions
Macros for every occasion
Pivot Tables and Power View
The basics of VBA
And Much More
Furthermore, you will find plenty of time-saving tips, like how to switch between absolute and relative cell references with just a few simple keystrokes. Excel is needed in a data-heavy world, so do yourself a favor and make sure you are getting the most out of the time you put into it. So if you have ever wondered how to enter data more efficiently, manipulate cells or worksheets to their full potential, stop wondering and click "add to cart"
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
