💡Learn how to create a basic interactive dashboard in Excel with filtering functionality
🔍Discover how to use slices to filter data from different angles and dimensions
🎨Explore custom design options, such as gradient color themes and toggle buttons
ℹ️Understand how to add interactive info buttons for additional information on dashboard elements
🌐Learn how to create multiple tabs within one tile to display different content
What version of Excel is required for this tutorial series?
—Microsoft Office 365 is recommended for access to the latest features and functionality demonstrated in this tutorial series.
Where can I download the Excel files for this tutorial series?
—You can download the Excel files for free from the excel-fine.com website, which is dedicated to providing modern and state-of-the-art Excel resources.
Can I use an older version of Excel?
—While some features may not be available in older versions of Excel, you can still follow along and apply the concepts and techniques demonstrated in this tutorial series.
Is there a specific order to follow in this tutorial series?
—This first episode covers the basics of creating an interactive dashboard, while subsequent tutorials dive deeper into specific design topics. It is recommended to follow the series sequentially to build your knowledge and skills.
Is there a cost associated with accessing the excel-fine.com website?
—No, the excel-fine.com website is completely free to access and download Excel files. It aims to provide valuable resources and support the Excel community.
00:00In this first episode of the tutorial series, we learn how to build a basic interactive Excel dashboard with filtering functionality.
02:11The host introduces the excel-fine.com website, where users can download Excel files for free and support the platform.
05:25Using a sample dataset, the host demonstrates how to create a sales revenue line chart and a sales map chart.
11:56The host explains how to create a donut chart to visualize the percentage of on-time deliveries.
13:43The host discusses the availability of certain features in different versions of Excel and encourages users to upgrade to Microsoft Office 365 for the latest functionality.
