Now since we're creating this report from scratch, you're also learn some useful Excel dashboard tips and tricks like how to link shapes and text boxes to cells. While we set up this logic, you're also going to learn some Power Query tricks like using intermediate steps as helper steps. It'll be there automatically because of the logic you built. You're going to learn to use Power Query to create a logic which allows you to grab the data from the latest month so you can immediately report on the latest information whenever you refresh your query, you don't even have to select the latest month. How to use the data model to create relationships between your data file and the master data. How to import and connect to large text files, CSV files, or other cell phones. Here's what you'll learn while we build this together. The moment new data's available, just click Refresh, sit back, and get the latest insights from your data. In this course, we're going to get hands on, create this interactive, easy to read and best of all, easy to manage dashboard. My name is Lily granny, ME, Microsoft MVP and the founder of Excel plus, where we help people become the go-to Excel expert at their company.
How do you do the calculations? How do you extract what you need from the data and presented in a compelling way? In this course, we're going to use Excel's Power Query data modeling as pivot table tools to get it all set up really fast. Introduction: Creating a dashboard in Excel from scratch can feel overwhelming, especially if you're working with a lot of data.