How to create an Excel Dashboard - Malayalam Tutorial
Vložit
- čas přidán 22. 04. 2024
- 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
Nice presentation. Thank you.
Excellent!!!
വളരെ പ്രയോജനപ്രദമായ വീഡിയോ നന്ദി സർ
Glad to hear that. Thank you :)
wonderful
Simply sooper.... Thank you
You are Welcome 😊
super--------Downloaded Excellent Work.........
Glad to hear that :) Thank you
Hai sir, is this possible on Google sheets? If no, kindly make a session with Google sheets
Great skill
😀👍
Hi how we can use googlefinance in excel..
excel auto save option eganey kitum
Will it be better idea to use "Get Data From Web " and use power query for getting the data ?
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.
excellent 👍
Thank you! Cheers!
good work
Thank you! Cheers!
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.
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.
czcams.com/video/xebe3H4Mcko/video.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>
very useful
Glad you think so!
Excellent 😅
Done
Nice
😀👍
😂ഇത് പഴയതു അല്ലെ 🙂സെയിൽസ് ഡാഷ് ബോർഡ് ഞാൻ 🙂ഉണ്ടാക്കി കമ്പനിയെ 🙂ഞെട്ടിച്ചിരുന്നു 😌നമ്മോടാ കളി
💯
😀👍
Great Sir 🫡🫡🫡
Thank you :)
Ningal poliyanu
😀🙌
Hii please upload 540 constituency dash board
Enta Chetta Namichu Adipoli Oru Course erakkamo please ....?
😀👍
Vlookup cheyth table il row add cheythal pinne work cheyyunilla. Any solution?
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.
exact match ന് വേണ്ടി false Select ചെയ്യുന്നതെന്തിനെന്ന് മനസ്സിലായില്ല.
Ajay Chettan, Whom are you supporting?
I think 'Munna' already know that 😀
Sir "generative AI in Excel" tricks and tips video cheyamo
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
Can I get a copy?
Please check the video description.
Payment receipt Mataram kittiyullu, file engine download cheyanam
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
Project costing undo
I haven't done any video on costing until. Thank you for the suggestion.
Great effort ❤
Thank you :)
Open ചെയ്തപ്പോ candidate's ന്റെ ഫോട്ടോ കാണാൻ പറ്റുന്നില്ല
An Excel file compatible with the older versions like Excel 2013, Excel 2016, etc., was sent to your mail. Hope it helps.
Paid the amount but can't download the file
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
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
MIS നെ കുറിച്ച് ഒരു വീഡിയോ ചെയ്യുവോ..
I recommend checking the online courses on MIS provided by Udemy, Skillshare, Coursera, etc.,
കഴിഞ്ഞ തവണത്തെ ഫയൽ, പൊടി തപ്പി എടുത്തല്ലേ 😂
😂
ഫോട്ടോ മാറുന്നില്ല
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.
czcams.com/video/qlmA7ajmQnQ/video.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...