Hello, everybody, welcome to the final video. So this is the conclusion video where I will be reviewing what we have learned. So in the first dashboard, we learned how to convert raw data into dynamic and prepare multiple charts using the same dynamic data in such a way that in the future, if data gets updated, you just have to right click in the pivot and refresh, automatically the chart gets updated. Once done, you have created the dashboard, which is created by slicers. And then we learn how to connect all these slicers multiple charts and sheets where we can control them and get the relevant outputs needed. So as far as selections, whatever is done on the slicer, the charts reflects the data.

So that was the first dashboard we did. In the second dashboard. We learned how to use the formulas and functions to get the relevant output. So we have created sorry, we had five sheets. Starting from 2012 to 2016, which have data in them and we created mapping. So we created a mapping sheet from where the data is captured from the internet.

Later a table was created, which actually convert all the currency into tabular format for our V lookup and match and index. Then we created a slab. And then finally we created a drop down which helps us to create a number of sheets. So in the future when the sheets, new sheets get added, we can simply put up a new number in and automatically capture the data from the sheet 2017. Now after we also created data, which is actually used to create all the dashboards that we've done, and this is all the formulas the average if max if min if and also map attributes that is longitude and latitude to arrange the data Then once done, we have created a map. We've also learned how to create a slider and how to create a chart.

Also, how to use the spark lines to create a drop down in such a way that automatically the data gets retrieved, where we have actually used an advanced version of indexing and so on. In the last dashboard, we did learn how to use the macros and to get our workout faster. So we have created a drop down where if we select a particular job type, it shows the trend, it also the overall trend. It's at the bottom we also saw a small drop down which actually provides world salary status of the country that we have selected. So if we have selected India, we get records for India and to the right we also see what is the key skill that is needed. What are the trends that follows.

So if we select the entire data, we get the overall results. So this is the conclusion of what we have learned. And in the first dashboard, we learned how to use the existing data and existing tool. Secondly is when we learn how to use formulas and functions to get the work done faster with a better dashboard, and in the last we use macros to get resolved faster, and you try these tricks and tips in your corporate world. Have a great day. Take care bye bye