-
Book Overview & Buying
-
Table Of Contents
Building Interactive Dashboards in Microsoft 365 Excel
By :
Building Interactive Dashboards in Microsoft 365 Excel
By:
Overview of this book
M365 Excel is a modern Excel version that is constantly updated with features that make creating and automating analyses, reports, and dashboards very easy compared with older Excel versions. This book will help you leverage its full capabilities, beginning with a quick overview of what dashboards are and how they are different from other types of reports. Then, you’ll familiarize yourself with the different standard dashboards currently available and what they are meant to accomplish for organizations. As you progress, you’ll get to grips with the use of new powerful tools such as Power Query and dynamic array formulae in the automation of analysis, gaining insights into the right approach to take in building effective dashboards. You’ll equip yourself with not only all the essential formulae, charts, and non-chart visuals but also learn how to set up your dashboard perfectly. Along the way, you’ll build a couple of awesome dashboards from scratch to utilize your newfound knowledge.
By the end of this book, you will be able to carry out an impressive and robust level of analysis on business data that may come from multiple sources or files, using better processes, formulae, and best practices in M365 to create insightful dashboards faster.
Table of Contents (18 chapters)
Preface
Free Chapter
Part 1 – Dashboards and Reports in Modern Excel
Chapter 1: Dashboards, Reports, and M365 Excel
Chapter 2: Common Dashboards in Lsarge Companies
Part 2 – Keeping Your Eyes on Automation
Chapter 3: The Importance of Connecting Directly to the Primary Data Sources
Chapter 4: Power Query: the Ultimate Data Transformation Tool
Chapter 5: PivotTable and Power Pivot
Chapter 6: Must-Know Legacy Excel Functions
Chapter 7: Dynamic Array Functions and Lambda Functions
Part 3 – Getting the Visualization Right
Chapter 8: Getting Comfortable with the 19 Excel Charts
Chapter 9: Non-Chart Visuals
Chapter 10: Setting Up the Dashboard's Data Model
Chapter 11: Perfecting the Dashboard
Chapter 12: Best Practices for Real-World Dashboard Building
Index
