Como Fazer Dashboard Moderno e Bonito no Excel em 15 minutos | Grátis p/ Download
Table of Contents
Introduction
In this tutorial, you will learn how to create a modern and visually appealing dashboard in Excel in just 15 minutes. Dashboards are essential tools for data visualization, helping you monitor key metrics and make informed business decisions. This guide will walk you through the necessary steps, from preparing your data to designing your dashboard.
Step 1: Prepare Your Base of Data
- Start with a clean and organized dataset in Excel.
- Your data should be structured in a way that includes all necessary information for analysis, such as dates, sales, products, and quantities.
- Ensure there are no blank rows or columns that may affect the analysis.
Step 2: Format Your Data as a Table
- Select your dataset.
- Go to the "Home" tab and click on "Format as Table."
- Choose a table style that suits your preference.
- This action allows you to easily manage data and use it in pivot tables.
Step 3: Create a Pivot Table
- With your table selected, navigate to the "Insert" tab and click on "PivotTable."
- Choose where you want the PivotTable to be placed (new worksheet or existing one).
- Drag and drop fields into the Rows, Columns, and Values areas to summarize your data.
Step 4: Add Data Segmentation
- Click on your PivotTable.
- Go to the "PivotTable Analyze" tab and select "Insert Slicer."
- Choose the fields you want to segment your data by (e.g., month, product).
- This makes your dashboard interactive, allowing you to filter data with a simple click.
Step 5: Design the Dashboard Background
- To add a background image, go to the "Page Layout" tab and select "Background."
- Choose an appropriate image or color that complements your dashboard visuals.
- You can also add shapes (rectangles, circles) from the "Insert" tab to enhance the design.
Step 6: Create Dynamic Charts
- Select your PivotTable, then go to the "Insert" tab.
- Choose the chart type that best represents your data (e.g., bar, line, pie).
- With the chart created, it will automatically update when you adjust the data via the slicers or filters.
Conclusion
Creating a modern dashboard in Excel involves preparing your data, utilizing tables and PivotTables, and designing an interactive and visually appealing layout. By following these steps, you will have a functional dashboard that helps track key metrics effectively. For further enhancement, consider exploring additional Excel features, such as conditional formatting and advanced chart types, to elevate your dashboard even more.