Skip to main content
Have a personal or library account? Click to login
Building Interactive Dashboards in Microsoft 365 Excel Cover

Building Interactive Dashboards in Microsoft 365 Excel

Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards

Publisher:Packt Publishing Limited
By: ,   and    
Paid access
|May 2024
Product purchase options
Table of contents

Table of Contents

  1. Dashboards, Reports, and M365 Excel
  2. Common Dashboards in Large Companies
  3. The Importance of Connecting Directly to the Primary Data Sources
  4. Power Query: the Ultimate Data Transformation Tool
  5. PivotTable and Power Pivot
  6. Must-Know Legacy Excel Functions
  7. Dynamic Array Functions and Lambda Functions
  8. Getting Comfortable with the 19 Excel Charts
  9. Non-Chart Visuals
  10. Setting Up the Dashboard's Data Model
  11. Perfecting the Dashboard
  12. Best Practices for Real-World Dashboard Building
PDF ISBN: 978-1-80324-747-2
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 420
Related subjects:
Computer sciences,
Computer sciences, other

People also read

Book

The Absolute Guide to Dashboarding and Reporting with Power BI

MrExcel's Holy Macro! Books, Kasper de Jonge
Book

Building Dashboards with Microsoft Dynamics GP 2016

Belinda Allen, Mark Polino
Book

Power BI for the Excel Analyst

MrExcel's Holy Macro! Books, Wyn Hopkins
Book

Microsoft 365 Excel: The Only App That Matters

MrExcel's Holy Macro! Books, Mike Girvin
Book

Power Pivot and Power BI

MrExcel's Holy Macro! Books, Rob Collie, Avichal Singh
Book

Data Modeling with Microsoft Excel

Bernard Obeng Boateng, Michael Olafusi, Michael Olafusi
Book
Coming soon

Mastering Data Analytics with Excel

Dr. Isaac Gottlieb