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/course/microsof...
Subscribe to the channel @AjayAnandXLnCAD for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/course/learn-mi...
#keralaelection #election2024 #exceldashboard
Пікірлер: 79
Nice presentation. Thank you.
Excellent!!!
wonderful
വളരെ പ്രയോജനപ്രദമായ വീഡിയോ നന്ദി സർ
@XLnCADMalayalam
3 ай бұрын
Glad to hear that. Thank you :)
Simply sooper.... Thank you
@XLnCADMalayalam
2 ай бұрын
You are Welcome 😊
Enta Chetta Namichu Adipoli Oru Course erakkamo please ....?
super--------Downloaded Excellent Work.........
@XLnCADMalayalam
3 ай бұрын
Glad to hear that :) Thank you
Great skill
@XLnCADMalayalam
3 ай бұрын
😀👍
Excellent 😅
excellent 👍
@XLnCADMalayalam
3 ай бұрын
Thank you! Cheers!
Hai sir, is this possible on Google sheets? If no, kindly make a session with Google sheets
Done
good work
@XLnCADMalayalam
3 ай бұрын
Thank you! Cheers!
very useful
@XLnCADMalayalam
2 ай бұрын
Glad you think so!
Will it be better idea to use "Get Data From Web " and use power query for getting the data ?
@XLnCADMalayalam
3 ай бұрын
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.
excel auto save option eganey kitum
😂ഇത് പഴയതു അല്ലെ 🙂സെയിൽസ് ഡാഷ് ബോർഡ് ഞാൻ 🙂ഉണ്ടാക്കി കമ്പനിയെ 🙂ഞെട്ടിച്ചിരുന്നു 😌നമ്മോടാ കളി
Ningal poliyanu
@XLnCADMalayalam
3 ай бұрын
😀🙌
Hi how we can use googlefinance in excel..
💯
@XLnCADMalayalam
3 ай бұрын
😀👍
Nice
@XLnCADMalayalam
3 ай бұрын
😀👍
Great Sir 🫡🫡🫡
@XLnCADMalayalam
3 ай бұрын
Thank you :)
exact match ന് വേണ്ടി false Select ചെയ്യുന്നതെന്തിനെന്ന് മനസ്സിലായില്ല.
Hii please upload 540 constituency dash board
Great effort ❤
@XLnCADMalayalam
3 ай бұрын
Thank you :)
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
2 ай бұрын
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
2 ай бұрын
@@XLnCADMalayalam : Is it mandatory to convert all datas into tables?
@XLnCADMalayalam
2 ай бұрын
When data is converted into Excel Tables, it will be easy to handle. Check my video on Excel Tables for more details. kzread.info/dash/bejne/qpmWx5WBZLDJm9I.html
@jitheshm5066
2 ай бұрын
@@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
2 ай бұрын
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>
Ajay Chettan, Whom are you supporting?
@XLnCADMalayalam
3 ай бұрын
I think 'Munna' already know that 😀
Vlookup cheyth table il row add cheythal pinne work cheyyunilla. Any solution?
@XLnCADMalayalam
3 ай бұрын
Try Excel Tables.
@jayannandu999
3 ай бұрын
Ya am using tables
@XLnCADMalayalam
3 ай бұрын
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.
Sir "generative AI in Excel" tricks and tips video cheyamo
@XLnCADMalayalam
3 ай бұрын
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
3 ай бұрын
@@XLnCADMalayalam ok thankyou sir
Open ചെയ്തപ്പോ candidate's ന്റെ ഫോട്ടോ കാണാൻ പറ്റുന്നില്ല
@XLnCADMalayalam
3 ай бұрын
An Excel file compatible with the older versions like Excel 2013, Excel 2016, etc., was sent to your mail. Hope it helps.
MIS നെ കുറിച്ച് ഒരു വീഡിയോ ചെയ്യുവോ..
@XLnCADMalayalam
3 ай бұрын
I recommend checking the online courses on MIS provided by Udemy, Skillshare, Coursera, etc.,
Payment receipt Mataram kittiyullu, file engine download cheyanam
@XLnCADMalayalam
2 ай бұрын
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
2 ай бұрын
Received. Thanks
Project costing undo
@XLnCADMalayalam
3 ай бұрын
I haven't done any video on costing until. Thank you for the suggestion.
Can I get a copy?
@XLnCADMalayalam
3 ай бұрын
Please check the video description.
Paid the amount but can't download the file
@XLnCADMalayalam
2 ай бұрын
No need to worry. Files are forwarded to ja***nu@gmail.com, the mail ID used for payment.
I paid ₹25 for download excel file. I could not download it. Please share me the file link
@XLnCADMalayalam
3 ай бұрын
Sorry to hear that. Files have been forwarded to the mail ID used for making payment.
@ashkarkk
3 ай бұрын
i didnt receive any mail yet
@XLnCADMalayalam
3 ай бұрын
Please check the Spam folder too. The files were sent to two different mails. a***associates@hotmail.com and advoc*********@gmail.com
കഴിഞ്ഞ തവണത്തെ ഫയൽ, പൊടി തപ്പി എടുത്തല്ലേ 😂
@XLnCADMalayalam
3 ай бұрын
😂
ഫോട്ടോ മാറുന്നില്ല
@XLnCADMalayalam
3 ай бұрын
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
3 ай бұрын
@@XLnCADMalayalam ഞാന് EXCEL 2021 ആണ് ഉപയോഗിക്കുന്നത് . ഫോട്ടോ അപ്ഡേറ്റ് ആകുന്നില്ല
@XLnCADMalayalam
3 ай бұрын
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. kzread.info/dash/bejne/o6Cho5mamtC3nrQ.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.
@anilkumarv5209
3 ай бұрын
@@XLnCADMalayalam ഇപ്പോള് ശരിയായി ....thanks...