POWER QUERY with PIVOT TABLE to create a DASHBOARD in Excel | Free Spreadsheets

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... 🔵DOWNLOAD SPREADSHEETS (zip file): https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we will learn how to use Power Query to help us automate daily tasks and save time. In this free Excel tutorial, we will specifically use Power Query along with pivot tables to create a modern and beautiful dashboard in Excel. In short, and to provide context, what we're going to learn is how to connect all these tables—that is, we'll group them into a single, unified file, placing one report below another—from multiple files, databases, tables, and Excel files. To do this, we'll use Excel's Power Query tool, which is a great tool to help us clean and organize multiple databases. In addition to grouping all the files together into one, we'll create columns with custom formulas. This will automate tasks and save time using Excel. All these actions, edits, and cleaning corrections that we'll perform on the database will also be applied to future databases that we'll place within our Power Query. After we finish processing in Power Query, we just close and load the file, and a consolidated general table will appear in Excel. From this table, we'll create pivot tables. Pivot tables help us perform analyses, summarize information, and organize the data we have. With pivot tables, we can also create dynamic charts and use data segmentation to filter tables interactively and dynamically. With pivot tables, we can build what is called a Dashboard in Excel, which is a visual panel with beautiful and modern charts. This summarizes and displays the information from our database. In the dashboard, we will use some layout and display settings to make it more attractive and modern, such as creating a custom header and a subtitle for our report. Below, we will have a navigation menu or an automatic filter, which is nothing more than data segmentation. Using figures, shapes, and rectangles, we will create a background with a shadow for our charts. And speaking of charts, we will use a column chart, a donut chart, and a line chart to help us better understand the information. Remember that, from a database, we can perform many different analyses. Here I've only given a few examples, but many others could be applied. #ExcellentJoão #Excel #Dashboard