Como criar Dashboard no Excel estilo PowerPoint para Apresentação de Relatório 🏆

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵FREE EXCEL SPREADSHEET DOWNLOAD: https://excelentejoao.com.br/wp-conte... Full video on Pivot Tables:    • Tabela Dinâmica e Gráfico Dinâmico com Exe...   In this free Excel video lesson, we will learn how to make a beautiful and modern Excel dashboard in the style of a PowerPoint presentation to help us analyze data and create reports. I hope this Excel video tutorial can help you in your day-to-day to automate tasks, perform analysis from Excel tables and even impress your boss. To create an Excel Dashboard, we will use the formatting as a table, Pivot Table, Pivot Chart, and the navigation menu or system menu or button to change between tabs in Excel. The Dashboard, also known as the control panel, is a visual management tool that presents, in a clear and objective way, everything you need to monitor the evolution of your business results and ensure that your goals are achieved. With the Dashboard, you can analyze the results in a simple and interactive way, in addition to helping with decision-making in your day-to-day life and in the job market. To create a Dashboard in Excel, we can follow the steps below. 1 Have a Database. 2 Transform the Database into a Table with the formatting as Table tool. 3 Create a Pivot Table from the Table. 4 Create Data Segmentation. 5 Create the Dashboard Background Image with Objects or Figures or Icons. 6 Create Pivot Charts and Value Cards. 1 Having a database in Excel is the first step, because we need information so that we can create graphs, tables, pivot tables and pivot charts, etc. A database is necessary to create a Dashboard. 2 Creating a Table in Excel involves using the tool called format as a table. So, let's take our database and transform it into a table with a very important Excel feature. 3 Creating a Pivot Table in Excel can help us a lot in creating a Dashboard, because with the pivot table we can create dynamic graphs, that is, whenever we perform any filtering or data segmentation, the information in the graphs will update automatically. The pivot table is also known as a pivot table and the pivot chart is known as a pivot chart. 4 Data segmentation, or also known as an option box, list of options, filter button, selection buttons, dynamic filter, etc., will be very important to make our spreadsheet interactive in Excel. Every time information is selected from the data segmentation box, all values ​​in the spreadsheet and all values ​​in the Dashboard will be updated automatically. This way, we can make our Excel spreadsheet interactive and dynamic. With just a few clicks, we can filter the information we need to view. 5 Creating the Dashboard background is very important because we can make the dashboard modern and beautiful with just the image we choose for the background of the Excel spreadsheet screen. We can use figures and objects such as rectangles, squares, circles, rectangles with rounded corners, etc. In addition, we can use icons or images from our computer. 6 Dynamic graphs, or pivot charts, will make our dashboard more beautiful and interactive in Excel. Every time any value is filtered and a segmentation of information is made, the graphs update automatically, showing only the selected information. 00:00 - Subscribe to the Channel! 00:22 - Like the video! 00:38 - Having a Database 02:23 - Formatting as a Table 03:10 - Dynamic Table 03:50 - Average Margin by Month 04:39 - Sales by Product 05:46 - Total Sold by Month 06:12 - Quantity by Month 06:43 - Dashboard #ExcelenteJoão #Excel #Dashboard