How to create an Excel Dashboard - Malayalam Tutorial

2024 കേരള ലോക്സഭാ തിരഞ്ഞെടുപ്പ്, പ്രധാന വിവരങ്ങൾ എക്സൽ ഡാഷ്ബോർഡിൽ.
Excel Dashboard with details of Kerala Lok Sabha Election 2024.
Download the Excel file.
rzp.io/l/wUqvlmv
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/...
Subscribe to the channel ‪@AjayAnandXLnCAD‬ for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/...
#keralaelection #election2024 #exceldashboard

[@anilkumar-kp4qc]

വളരെ പ്രയോജനപ്രദമായ വീഡിയോ നന്ദി സർ

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@dhaneshpt8641]

Nice presentation. Thank you.

[@vishnujoy8137]

Enta Chetta Namichu Adipoli Oru Course erakkamo please ....?

[@XLnCADMalayalam]

😀👍

[@melevilacompany]

sir oru doubt 20000 enna valuvine 25+50+30+50+100+15+10+10.......=20000 enna reethiyil cheyyan pattumo?

[@maheshkumar.u.v7350]

Hai sir, is this possible on Google sheets? If no, kindly make a session with Google sheets

[@tkjayeshkumar5658]

Simply sooper.... Thank you

[@XLnCADMalayalam]

You are Welcome 😊

[@shibusadanandan9006]

wonderful

[@anu007kumar]

Great skill

[@XLnCADMalayalam]

😀👍

[@prathyashprathyu1112]

Hii please upload 540 constituency dash board

[@jijeeshpadmanabhan350]

very useful

[@XLnCADMalayalam]

Glad you think so!

[@surendranmathyari5008]

super--------Downloaded Excellent Work.........

[@XLnCADMalayalam]

Glad to hear that :) Thank you

[@bejoychandran479]

Hi how we can use googlefinance in excel..

[@vallavilasreekumar4420]

excellent 👍

[@XLnCADMalayalam]

Thank you! Cheers!

[@dasprem3992]

Excellent!!!

[@mithus143]

Will it be better idea to use "Get Data From Web " and use power query for getting the data ?

[@XLnCADMalayalam]

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.

[@karunakrishnamallesh419]

Ajay Chettan, Whom are you supporting?

[@XLnCADMalayalam]

I think 'Munna' already know that 😀

[@riyaccj]

Excellent 😅

[@xyzO786]

Great effort ❤

[@XLnCADMalayalam]

Thank you :)

[@jitheshm5066]

Sir, Not able to create chart for constituency wise. The chart displays values only for the last row and not fully. Is it because of the Vlookup formula being there or due to formating issue. I tried changing to numeric value but still not getting the correct chart as in video.

[@XLnCADMalayalam]

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.

[@jitheshm5066]

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

[@XLnCADMalayalam]

When data is converted into Excel Tables, it will be easy to handle. Check my video on Excel Tables for more details. kzbin.info/www/bejne/rpbFlmZ-abKWodE

[@jitheshm5066]

@@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.

[@jitheshm5066]

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>

[@sreeharivalsan8280]

good work

[@XLnCADMalayalam]

Thank you! Cheers!

[@fredyfrancisthekomban]

Sir "generative AI in Excel" tricks and tips video cheyamo

[@XLnCADMalayalam]

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.,

[@fredyfrancisthekomban]

@@XLnCADMalayalam ok thankyou sir

[@rashs9901]

Nice

[@XLnCADMalayalam]

😀👍

[@shabeer.valappil]

Done

[@rafeequekc4530]

Great Sir 🫡🫡🫡

[@XLnCADMalayalam]

Thank you :)

[@reshmajoseph9012]

MIS നെ കുറിച്ച് ഒരു വീഡിയോ ചെയ്യുവോ..

[@XLnCADMalayalam]

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

[@npprakash1827]

Can I get a copy?

[@XLnCADMalayalam]

Please check the video description.

[@Mani_parayil]

Ningal poliyanu

[@XLnCADMalayalam]

😀🙌

[@nishanthalavakkan4702]

Project costing undo

[@XLnCADMalayalam]

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

[@anup782]

exact match ന് വേണ്ടി false Select ചെയ്യുന്നതെന്തിനെന്ന് മനസ്സിലായില്ല.

[@jayannandu999]

Vlookup cheyth table il row add cheythal pinne work cheyyunilla. Any solution?

[@XLnCADMalayalam]

Try Excel Tables.

[@jayannandu999]

Ya am using tables

[@XLnCADMalayalam]

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.

[@user-wg5sc1nm7o]

excel auto save option eganey kitum

[@TrendingDrops3624shan]

💯

[@XLnCADMalayalam]

😀👍

[@shabeerpu4330]

Payment receipt Mataram kittiyullu, file engine download cheyanam

[@XLnCADMalayalam]

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

[@shabeerpu4330]

Received. Thanks

[@joshuajohn5458]

Open ചെയ്തപ്പോ candidate's ന്റെ ഫോട്ടോ കാണാൻ പറ്റുന്നില്ല

[@XLnCADMalayalam]

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

[@ashkark5542]

I paid ₹25 for download excel file. I could not download it. Please share me the file link

[@XLnCADMalayalam]

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

[@ashkarkk]

i didnt receive any mail yet

[@XLnCADMalayalam]

Please check the Spam folder too. The files were sent to two different mails. a***[e-mail] and advoc*********@gmail.com

[@wolfvsman4578]

😂ഇത് പഴയതു അല്ലെ 🙂സെയിൽസ് ഡാഷ് ബോർഡ്‌ ഞാൻ 🙂ഉണ്ടാക്കി കമ്പനിയെ 🙂ഞെട്ടിച്ചിരുന്നു 😌നമ്മോടാ കളി

[@abduljabbarmuhammed6058]

Paid the amount but can't download the file

[@XLnCADMalayalam]

No need to worry. Files are forwarded to ja***[e-mail], the mail ID used for payment.

[@anilkumarv5209]

ഫോട്ടോ മാറുന്നില്ല

[@XLnCADMalayalam]

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.

[@anilkumarv5209]

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

[@XLnCADMalayalam]

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. kzbin.info/www/bejne/p53QcmqXn9KEpLM 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.

[@anilkumarv5209]

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

[@rijopoulose852]

കഴിഞ്ഞ തവണത്തെ ഫയൽ, പൊടി തപ്പി എടുത്തല്ലേ 😂

[@XLnCADMalayalam]

😂