Building Interactive Dashboards in Microsoft 365 Excel (eBook)
420 Seiten
Packt Publishing (Verlag)
978-1-80324-747-2 (ISBN)
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.
Unleash the full potential of Microsoft Excel's latest version and elevate your data-driven prowess with this comprehensive resourceKey FeaturesCreate robust and automated dashboards in Excel for M365Apply data visualization principles and employ dynamic charts and tables to create constantly updated and informative dashboards for your organizationUncover the best practices for effective dashboard creationPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionM365 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.What you will learnUnderstand the importance of dashboards in today's business analytics environmentDelve into the various essential formulae in ExcelUtilize Power Query to shape and transform data to extract insights easilyExplore the power of the new dynamic array functions in M365Employ PivotTable and Power Pivot to automate your dashboardsMaster the setup and optimization of your dashboard canvasDiscover best practices for visualization, charts, and effective dashboard creationConsolidate your knowledge through a hands-on concluding projectWho this book is forThis book is for Microsoft Excel users, especially those tasked with creating dynamic reports and dashboards that require data and help support to decision-makers within an organization with visually engaging and actionable insights. Financial analysts, data analysts, business analysts, and BI professionals will also greatly benefit from this book. Some familiarity with the Microsoft Excel interface is a prerequisite. ]]>
| Erscheint lt. Verlag | 29.2.2024 |
|---|---|
| Vorwort | Olanrewaju Oyinbooke |
| Sprache | englisch |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Office Programme ► Excel | |
| Informatik ► Software Entwicklung ► User Interfaces (HCI) | |
| Mathematik / Informatik ► Informatik ► Theorie / Studium | |
| ISBN-10 | 1-80324-747-9 / 1803247479 |
| ISBN-13 | 978-1-80324-747-2 / 9781803247472 |
| Haben Sie eine Frage zum Produkt? |
EPUB (Ohne DRM)Digital Rights Management: ohne DRM
Dieses eBook enthält kein DRM oder Kopierschutz. Eine Weitergabe an Dritte ist jedoch rechtlich nicht zulässig, weil Sie beim Kauf nur die Rechte an der persönlichen Nutzung erwerben.
Dateiformat: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belletristik und Sachbüchern. Der Fließtext wird dynamisch an die Display- und Schriftgröße angepasst. Auch für mobile Lesegeräte ist EPUB daher gut geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür die kostenlose Software Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür eine kostenlose App.
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
