Название: Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards
Автор: Dr. Isaac Gottlieb
Издательство: BPB Publications
Год: 2023
Страниц: 230
Язык: английский
Формат: epub (true)
Размер: 13.4 MB

Learn Everything about Excel Charts, PivotTables, Dashboards and Master Analytic Techniques for Decision Making.

Description:
Excel's charts, graphs, and reports are beneficial, so it's time to use them to your advantage. Learn how to execute the most innovative analysis on your preferred data using PivotTables, PivotCharts, What-if-Analysis, descriptive statistics, correlations, histograms, sparklines, animated charts, dashboards, trendlines, and more than 100 other charts and graphs.

This book, Excel 100+ PivotTables, Charts & Reports, will help you transform and enrich your data into better reports and charts to enable you to make superior intelligent decisions. The purpose of this book is to provide guidance and a helping hand in extracting insights from Excel sheets, running various analytical excel tools, creating beautiful Charts, and presenting the results to your team, employer, and clients in the form of a unique report. It will thoroughly cover PivotTables and Dashboards. Additionally, the book provides you with a set of Analytic Techniques for Intelligent Decision Making.

The book has three parts:

Part one, Chapters 1-4, covers Excel Charts comprehensively. When you complete this part, you will possess the knowledge and hands-on tools to create Excel charts to present data in a meaningful fashion. These chapters instruct you on preparing data for the charts, working around the axis, and personalizing the charts, among other things. You will be able to create all the Excel charts, modify them and express the chart in the best way to characterize you or your company.

The second part, Chapters 5-13, is about PivotTables and PivotCharts. Once you become proficient with these two topics, you will be able to demonstrate how several passing datasets via a single PivotTable, constructing charts based on PivotTables, and other techniques will help you learn how to manage your Excel sheet for advanced analysis. This part guides you through creating Dashboards and reports, using convincing charts, maps, graphs, and pivot tables into a meaningful storytelling report.

The last part of the book, Chapters 14-15, is about decision-making tools. The Data Analysis ToolPak of Excel is a statistical Excel Add-in which will quickly and easily analyze data - without using any Excel functions. The second tool, the What-if-analysis, is a set of decision-making tools. These tools enable the user to investigate the impact of input changes on outputs resulting in intelligent decisions.

The book includes the following:
- Try and practice new Excel 2022 Charts and Reports in your Excel 2019, Excel 2021 and Office 365 editions.
- Learn with easy-to-read, step-by-step instructions and screenshots.
- Learn to illustrate your data in a way that is readily digestible at a glance.
- Figure out how to make beautiful infographics that reflect your company's personality or culture.
- Learn the ins and outs of making and editing expert PivotTables and PivotCharts.
- Master PivotTables and PivotCharts to construct dynamic dashboards.
- Utilize Excel's What-If analysis to check your assumptions and theories.
- Create Sensitivity-Analysis tables to check the quality of your decision-making tools.
- Create summaries, cross-tabs, filtering, and other visualizations.
- Conduct in-depth statistical analysis in Excel with minimal effort.

This book's thorough instructions on Excel charts will improve readers' skills in making the most innovative and visually appealing reports. You will be able to make dynamic, eye-catching dashboards once you complete reading this book.

Who this book is for:
No matter what your professional or academic status is, if you often engage in data analysis, summary creation, and report writing, this book is for you. You'll be able to generate relatively strong reports and infographics from your data, thereby allowing you to make more well-informed decisions. There is no need for you to be an Excel expert to use this book.