You're reading from Building Interactive Dashboards in Microsoft 365 Excel Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards

Product type Paperback

Published in Feb 2024

Publisher Packt

ISBN-13 9781803237299

Length 420 pages

Edition 1st Edition

Languages

Power Query

Tools

Excel

Concepts

Data Visualization

Author (1):

Michael Olafusi

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1 – Dashboards and Reports in Modern Excel FREE CHAPTER

2. Chapter 1: Dashboards, Reports, and M365 Excel

3. Chapter 2: Common Dashboards in Lsarge Companies

4. Part 2 – Keeping Your Eyes on Automation

5. Chapter 3: The Importance of Connecting Directly to the Primary Data Sources

6. Chapter 4: Power Query: the Ultimate Data Transformation Tool

7. Chapter 5: PivotTable and Power Pivot

8. Chapter 6: Must-Know Legacy Excel Functions

9. Chapter 7: Dynamic Array Functions and Lambda Functions

10. Part 3 – Getting the Visualization Right

11. Chapter 8: Getting Comfortable with the 19 Excel Charts

12. Chapter 9: Non-Chart Visuals

13. Chapter 10: Setting Up the Dashboard's Data Model

14. Chapter 11: Perfecting the Dashboard

15. Chapter 12: Best Practices for Real-World Dashboard Building

16. Index

Why subscribe?

17. Other Books You May Enjoy

The different ways to bring data into Excel

Excel is the world’s most used data analysis tool and that’s in part due to how easily it allows you to bring in data from all types of sources. You can go online and copy a web page and paste it into Excel, and it won’t complain nor give an error. You can even paste an image into Excel; in fact, it is difficult to find what you can’t copy and paste into Excel. The built-in flexibility of Excel makes it a very beginner-friendly tool.

The following screenshot shows an example of copying a table of populations by country from https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations) and pasting it into Excel: