Hello, everybody. Welcome back to the dashboard course. Now in the previous section, we learned how to create a dashboard using simple functions provided by Excel directly like pivot and slicer. In the current sections, we will see how to create a dashboard using functions provided by Excel, something like these. Let's see what we will be doing. So I made two separate files.

One is the raw data, and the other is the final output. And what we plan to teach you in this video is how to convert this simple raw sample raw data which is for five years that is from 2012 1314 1516 and convert this data into a final dashboard which looks something like this, where we can select which currency format we want to see. And based on that the relevant data appears if we change the trend over here So based on the selection that we make, automatically the relevant line chart reacts. Now if we're looking for average max min, the result changes accordingly based on my selection. Last but not least, is based on which country I select, say for example, USA, it automatically highlights the country. And we will see how to get these things done using formulas provided by Excel.

So, let's get started. Until then, keep practicing. I'll see you in the next video. Thank you.