How to create an Excel Dashboard - Malayalam Tutorial 

Glad to hear that. Thank you :)

You are Welcome 😊

Glad to hear that :) Thank you

😀👍

Thank you! Cheers!

Thank you! Cheers!

Glad you think so!

😀👍

For extracting data, Yes. Power Query can be used. It's neat and clean. But keep in mind that Wikipedia pages are always being edited. Maybe more tables can be added in the future. So, maintaining the connection with the source data is risky.

😀👍

Thank you :)

😀🙌

VLOOKUP formula shouldn't be a problem in generating charts. I suggest to watch more videos on Excel charts and get familiar with the option for selecting the Data Series. Generate a few charts, play with the different options, interchanging the rows and columns, data series and finally you will be able to solve this problem.

@@XLnCADMalayalam : Is it mandatory to convert all datas into tables?

When data is converted into Excel Tables, it will be easy to handle. Check my video on Excel Tables for more details. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xebe3H4Mcko.html

@@XLnCADMalayalam Sir, I tried all ways to create a bar chart. It works with other data and examples but not in creating a bar chart. Any possible way to send u the screenshot, I would have done that. Appreciate if you could help.

Sir, I could finally solve the issue that was creeping in. The issue was with the data that was copied in 2019 Results. Though did the formating it was not showing properly, hence entered all the data manually and it worked. Thanks a bunch...Now I would like to create an excel wherein I need an excel dashboard on cars available in the market. It should display the car details when user select the manufacturer, model and should also need to compare two car models. Can I get a support from you>

If you are referring to the GENERATIVEAI function, it is a part of Excel Labs, an Excel Add-in. For GENERATIVEAI function to work properly, we need to have an account with OpenAI, then generate a unique API key which is not free. I recommend checking videos done by Mynda Tracey (myonlinetraininghub), Mr. Excel, Kenji Explains, etc.,

@@XLnCADMalayalam ok thankyou sir

I think 'Munna' already know that 😀

I recommend checking the online courses on MIS provided by Udemy, Skillshare, Coursera, etc.,

Try Excel Tables.

Ya am using tables

If you are using Excel Tables (I hope you have seen my video on Excel Tables), addition or deletion of columns won't break the formulas. If you aren't using Excel Tables and referring to a normal data range, you need to manually redefine (expand) the data range used in the formula.

An Excel file compatible with the older versions like Excel 2013, Excel 2016, etc., was sent to your mail. Hope it helps.

You could downloaded from the same page itself. But no need to worry, Files have been forwarded to the mail ID used for payment.

Received. Thanks

Please check the video description.

I haven't done any video on costing until. Thank you for the suggestion.

No need to worry. Files are forwarded to ja***nu@gmail.com, the mail ID used for payment.

Thank you :)

Sorry to hear that. Files have been forwarded to the mail ID used for making payment.

i didnt receive any mail yet

Please check the Spam folder too. The files were sent to two different mails. a***associates@hotmail.com and advoc*********@gmail.com

😂

A few people using the older versions of Excel (like Excel 2013, 2016) have reported this problem. Select the photo and click on the formula bar and the photos will update.

@@XLnCADMalayalam ഞാന്‍ EXCEL 2021 ആണ് ഉപയോഗിക്കുന്നത് . ഫോട്ടോ അപ്ഡേറ്റ് ആകുന്നില്ല

With lower version, I meant the versions other than 'Excel with Microsoft 365'. But the Picture lookup technique will work in lower versions too. And this is why I have included two different files for download. Check my video on Picture lookup in Excel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qlmA7ajmQnQ.html Like I mentioned before, while opening the second file using Excel 2013, some users reported that sometimes the picture won't update instantly. Following is the hack that can be used to update the picture. Select the picture, click on the formula bar and press the Enter key. At the same time, I want the file to work flawlessly irrespective of the versions. I will try to recreate the file using Excel 2013 or 2016 and will share the same with you as ASAP.

@@XLnCADMalayalam ഇപ്പോള്‍ ശരിയായി ....thanks...