Consistent tables in Microsoft Excel 2019
Please sign in so that we can notify you about a reply
Use exposure tables and Excel 2019 diagrams to create powerful dynamic reports in a matter of minutes. Even if you have never been engaged in consolidated tables before, after reading the book you can fully use their incredible flexibility and analytical power. The authors will generously share with readers many years of experience in solving applied problems, help to avoid typical mistakes and tell you many professional work techniques that you can’t meet in other books.
The main topics of the book:
Simple ways to create and set up consolidated tables
Task of default settings
The transformation of huge data arrays into compact and understandable summary reports
The rapid identification of the most profitable customers, goods and regions
application Power Query for quick import and analysis of data obtained from various sources
Creation of consolidated tables tied to geographical cards using 3D carts
Building dynamic information panels
The joint use of consolidated tables
Creation of large consolidated tables consisting of millions of lines using Power Pivot
Automation of consolidated tables using macros and VBA
Professional tips and tips for working with consolidated tables
about authors
Bill Jelen - winner of the status of Microsoft Excel MVP, creator of the site mrexcel.com, launched back in 1998.
It has been working with electric tables since 1985. The author of 57 books on Microsoft Excel.
Michael Aleksander - a certified application developer Microsoft (MCAD), holder of Microsoft MVP status. The author of a number of books devoted to data analysis using Microsoft Access and Excel. It has more than 15 years of experience in Microsoft Office-based applications
The main topics of the book:
Simple ways to create and set up consolidated tables
Task of default settings
The transformation of huge data arrays into compact and understandable summary reports
The rapid identification of the most profitable customers, goods and regions
application Power Query for quick import and analysis of data obtained from various sources
Creation of consolidated tables tied to geographical cards using 3D carts
Building dynamic information panels
The joint use of consolidated tables
Creation of large consolidated tables consisting of millions of lines using Power Pivot
Automation of consolidated tables using macros and VBA
Professional tips and tips for working with consolidated tables
about authors
Bill Jelen - winner of the status of Microsoft Excel MVP, creator of the site mrexcel.com, launched back in 1998.
It has been working with electric tables since 1985. The author of 57 books on Microsoft Excel.
Michael Aleksander - a certified application developer Microsoft (MCAD), holder of Microsoft MVP status. The author of a number of books devoted to data analysis using Microsoft Access and Excel. It has more than 15 years of experience in Microsoft Office-based applications
Author:
Author:Jelen Bill
Cover:
Cover:Soft
Category:
- Category:Computer & Technology
ISBN:
ISBN:978-5-907203-42-6
No reviews found