Building Interactive Dashboards in Microsoft 365 Excel
Harness the new features and formulae in M365 Excel to create dynamic, automated dashboards
Created by Michael Olafusi
Explore the latest features in Microsoft 365 Excel and learn how to build interactive dashboards that automate your data analysis. Discover practical ways to turn raw data into clear, actionable insights for your organization. Gain hands-on experience with tools designed to streamline reporting and visualization.
Packt | Feb 2024 | 420 min
What You Will Learn
You will work through real-world scenarios using step-by-step guidance and practical examples. By applying new Excel tools as you go, you will build dashboards from scratch and refine your skills with hands-on projects. Each concept is introduced in a clear, approachable way to help you master both the technical and design aspects.
Key Features
- Build automated dashboards using Power Query and dynamic array functions
- Create interactive charts and visuals that update with your data
- Apply best practices to design dashboards that drive better business decisions
Target Audience
This learning path is ideal for Excel users who already know the basics and want to create dynamic dashboards for business analysis. It is especially valuable for financial analysts, data analysts, business analysts, and BI professionals looking to automate reporting and deliver insights. Some prior experience with Excel is recommended.
