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

  • @dhaneshpt8641
    @dhaneshpt86413 ай бұрын

    Nice presentation. Thank you.

  • @dasprem3992
    @dasprem39923 ай бұрын

    Excellent!!!

  • @shibusadanandan9006
    @shibusadanandan90062 ай бұрын

    wonderful

  • @anilkumar-kp4qc
    @anilkumar-kp4qc3 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Glad to hear that. Thank you :)

  • @tkjayeshkumar5658
    @tkjayeshkumar56582 ай бұрын

    Simply sooper.... Thank you

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 ай бұрын

    You are Welcome 😊

  • @vishnujoy8137
    @vishnujoy81373 күн бұрын

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

  • @surendranmathyari5008
    @surendranmathyari50083 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Glad to hear that :) Thank you

  • @anu007kumar
    @anu007kumar3 ай бұрын

    Great skill

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😀👍

  • @riyaccj
    @riyaccj2 ай бұрын

    Excellent 😅

  • @vallavilasreekumar4420
    @vallavilasreekumar44203 ай бұрын

    excellent 👍

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Thank you! Cheers!

  • @maheshkumar.u.v7350
    @maheshkumar.u.v73502 ай бұрын

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

  • @shabeer.valappil
    @shabeer.valappil2 ай бұрын

    Done

  • @sreeharivalsan8280
    @sreeharivalsan82803 ай бұрын

    good work

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Thank you! Cheers!

  • @jijeeshpadmanabhan350
    @jijeeshpadmanabhan3502 ай бұрын

    very useful

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 ай бұрын

    Glad you think so!

  • @mithus143
    @mithus1433 ай бұрын

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

  • @XLnCADMalayalam

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

  • @user-wg5sc1nm7o
    @user-wg5sc1nm7o3 ай бұрын

    excel auto save option eganey kitum

  • @wolfvsman4578
    @wolfvsman45783 ай бұрын

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

  • @Mani_parayil
    @Mani_parayil3 ай бұрын

    Ningal poliyanu

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😀🙌

  • @bejoychandran479
    @bejoychandran479Ай бұрын

    Hi how we can use googlefinance in excel..

  • @TrendingDrops3624shan
    @TrendingDrops3624shan3 ай бұрын

    💯

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😀👍

  • @rashs9901
    @rashs99013 ай бұрын

    Nice

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😀👍

  • @rafeequekc4530
    @rafeequekc45303 ай бұрын

    Great Sir 🫡🫡🫡

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Thank you :)

  • @anup782
    @anup7822 ай бұрын

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

  • @prathyashprathyu1112
    @prathyashprathyu111221 күн бұрын

    Hii please upload 540 constituency dash board

  • @xyzO786
    @xyzO7863 ай бұрын

    Great effort ❤

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Thank you :)

  • @jitheshm5066
    @jitheshm50662 ай бұрын

    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

    @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

    @jitheshm5066

    2 ай бұрын

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

  • @XLnCADMalayalam

    @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

    @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

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

  • @karunakrishnamallesh419
    @karunakrishnamallesh4193 ай бұрын

    Ajay Chettan, Whom are you supporting?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    I think 'Munna' already know that 😀

  • @jayannandu999
    @jayannandu9993 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Try Excel Tables.

  • @jayannandu999

    @jayannandu999

    3 ай бұрын

    Ya am using tables

  • @XLnCADMalayalam

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

  • @fredyfrancisthekomban
    @fredyfrancisthekomban3 ай бұрын

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

  • @XLnCADMalayalam

    @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

    @fredyfrancisthekomban

    3 ай бұрын

    @@XLnCADMalayalam ok thankyou sir

  • @joshuajohn5458
    @joshuajohn54583 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

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

  • @reshmajoseph9012
    @reshmajoseph90123 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

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

  • @shabeerpu4330
    @shabeerpu43302 ай бұрын

    Payment receipt Mataram kittiyullu, file engine download cheyanam

  • @XLnCADMalayalam

    @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

    @shabeerpu4330

    2 ай бұрын

    Received. Thanks

  • @nishanthalavakkan4702
    @nishanthalavakkan47023 ай бұрын

    Project costing undo

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

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

  • @npprakash1827
    @npprakash18273 ай бұрын

    Can I get a copy?

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    Please check the video description.

  • @abduljabbarmuhammed6058
    @abduljabbarmuhammed60582 ай бұрын

    Paid the amount but can't download the file

  • @XLnCADMalayalam

    @XLnCADMalayalam

    2 ай бұрын

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

  • @ashkark5542
    @ashkark55423 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

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

  • @ashkarkk

    @ashkarkk

    3 ай бұрын

    i didnt receive any mail yet

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

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

  • @rijopoulose852
    @rijopoulose8523 ай бұрын

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

  • @XLnCADMalayalam

    @XLnCADMalayalam

    3 ай бұрын

    😂

  • @anilkumarv5209
    @anilkumarv52093 ай бұрын

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

  • @XLnCADMalayalam

    @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

    @anilkumarv5209

    3 ай бұрын

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

  • @XLnCADMalayalam

    @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

    @anilkumarv5209

    3 ай бұрын

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

Келесі