Build Interactive Dashboard in 10 Min || Excel Malayalam

In this video we can learn how to create dynamic and interactive Excel dashboards in Malayalam from scratch using the built in Excel tools. All you need is Microsoft Excel - No add-ins or VBA/Macros. With a dashboard, you can showcase the most important information and key performance indicators (KPIs) that your organization cares about. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac. Once you finish, you can share out your dashboard easily for others to consume. If you'd like to follow along, you'll find the sample sheet that I used below.
#createdashboard #exceldashboardmalayalam #skillstosucceedbyalfan
1:15 Demo
3:15 Pivot Table
4:34 Pivot Table Layout Settings
5:43 Create Multiple Pivot Table
8:26 Naming Pivot Table
9:17 Introduction to Slicer
11:04 Connect Pivot Table with Slicers
14:07 Insert Pivot Chart/Dashboard
15:31 Connect with Dashboards (MIS Report)
Learn basic of Pivot Table- • Learn Pivot Table in 1...
Download file used in the video: drive.google.c...
To learn Excel in English Click on : • FREE Excel Course (Bas...
View my comprehensive courses: laurelss.com/i...
Let’s connect on social media:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan

[@josephlijo2003]

Excellent bro …. I just noticed your channel and watched some of the videos … how neat and clear step by step you are describing each and everything …. Awesome bro .. 2 weeks only I joined a course to learn advance excel and now feel , if I saw your channel a couple of week before, I can save a handsome amount of money…. Welldone bro .. I will share your channel to my friends and colleagues too …

[@rows_columns]

Thanks a ton brother🙏😊

[@jothishkumar722]

വളരെ പ്രയോജനമുള്ളത്... സിമ്പിൾ അവതരണം.... സൂപ്പർ bro👍👍👍👍❤❤

[@rows_columns]

Thanks a lot brother🙏😊

[@anwarashraf143]

No words... Hatts off . Ikka dash board analysis ne patti cheyammo plzzzzz... Engane analysis cheyth management nu present cheyuka enna ariyana...

[@rows_columns]

Teerchayayum cheyyum bro😊🙏

[@rajukdavis]

Excellent idea by Mohammad AlFan. I will definitely use this. Probably due to time constraints, the explanation was faster. But repeating the video, I got the idea. Most of the time, I spend on reports. Once again thank you for your help.

[@rows_columns]

Thanks for watching & ur valuable feedback😊

[@vipinr9569]

Ithrem clear aayi oru class … Sooper and thanku..

[@athiinair]

Awesome presentation ; you made it very easy to learn and it was simply superb

[@rows_columns]

❤️

[@ArtDev1]

Thanks a lot for this video .helped me a lot to prepare my stuffs.

[@rows_columns]

Thanks bro :)

[@amalk6995]

Amazing video Alfan, truly appreciate your output...Keep going strong

[@rows_columns]

Thanks a ton Amal😊

[@jtjindia]

Super, dashboard in 18min tutorial is phenomenal !

[@rows_columns]

❤️

[@mansooralik9919]

Data file sheet not found. ​@@rows_columns

[@Nishad2010]

Super bro..analytics nalloru career und. Congratz

[@rows_columns]

Thanks Nishad Bro🤝😊

[@abdulbasith6398]

Thank you very much. Your videos are awesome and very very useful❤

[@shajishamshudheen8917]

Good Job! buddy, you deserve millions of subscribers

[@rows_columns]

🙏

[@shibmat1977]

Excellent Brother. Thanks a lot

[@rows_columns]

🙏🥰

[@praje123]

You made it easy to learn by the awesome presentation. Thanks a ton!

[@pranavpalakkad2016]

Awesome excellent.... Thank you

[@rows_columns]

Appreciate your positive feedback! Thrilled to hear you liked the video. Keep enjoying and stay tuned for more!😊

[@nv3336]

Woww.. Nice presentation.. Many thanks.. ❤️

[@Rechith1]

Awesome skills brother.! Keep rocking.

[@rows_columns]

😍

[@sivadas6357]

Explained well. Thanks. Excel guru.

[@rows_columns]

Thank you, I am happy to hear you feel that way!

[@RationaleMallu]

Most underrated KZbin Channel ever

[@hajasahib8943]

Thank you Brother very useful ✅

[@SajanVarghes]

very good presentation

[@sajnarajeebseju5502]

Great explanation...

[@shyjumathew07]

Excellent

[@rows_columns]

😊👍

[@sreejithkuttan9053]

സൂപ്പർ 👏🏾👏🏾👏🏾

[@ppunais86]

കിടുക്കി, തകർത്തു, തിമിർത്തു Thank you

[@rows_columns]

Ha ha ha😀

[@subairchanganath5927]

Hi, I am subair. എനിക്ക് അറിയേണ്ടത് ഒരു Table ൽ apple, grape orange എന്നിങ്ങനെ ഐറ്റംസ് കുറെ കൊടുത്തിട്ടുണ്ട്. അതിന്റെ unit price column blank ആണ്. പുറത്ത് ഒരു table ൽ ഇവയുടെ unit price കൊടുത്തിട്ടുണ്ട്. Formula ഉപയോഗിച്ച് unit price നെ എങ്ങനെ ആദ്യത്തെ table ലെ unit price column ത്തിൽ insert ചെയ്യുക. ഏത് ഫോർമുല ആണ് അതിനു വേണ്ടി ഉപയോഗിക്കുക? Reply പ്രതീക്ഷിക്കുന്നു. Thanks സുബൈർ

[@ppunais86]

@@subairchanganath5927 vlookup formula ഉപയോഗിച്ചാൽ കിട്ടില്ലേ?

[@kiranps7178]

veere level..kidu

[@rows_columns]

Tnx Macha!😉

[@amalnand1]

Bro salute 🙌 🙏 💯 👏

[@rows_columns]

Thank you, I am happy to hear you feel that way!

[@rush2siddu]

Thank you so much really appreciated for your effort

[@mebinscaria6723]

Really helpful thanks alot

[@shmbu]

Great Bro. All the best.

[@sreejithmantrikyantras8184]

Wonderful.....thank you very much

[@rows_columns]

😍

[@bijeeshbalachandran532]

എക്സലിൽ നിന്നും വാട്‌സ്ആപ്പ് മെസ്സേജ് അയക്കുന്നത് എങ്ങനെ ആണ് waiting for your reply...

[@josepaul7725]

very good..thanks...

[@rows_columns]

Thanks Jose😊

[@masaraccounts4024]

Great man...hats off...

[@rows_columns]

😊

[@pkmcalicut]

🔥 VB marakkalle

[@rows_columns]

Never bro🛠

[@mrshabeermp]

Explained very well Sir. 👏 😊

[@rows_columns]

Thank you Shabeer :)

[@SajeevAntony-b6g]

when I try to make quarter wise report. the date is shows in number format. I changed this format but when right click pivot table and take group the list shows like number. can you advise

[@sachinsatheesh4877]

Excellent bro !!!

[@rows_columns]

Thank you, I am happy to hear you feel that way!

[@Falcon-if4cs]

No enough words to thank Bro

[@rows_columns]

🙏💙

[@aslamkt5701]

Thank you sir🙏🙏🙏🙏❤❤

[@najeebibrahim8286]

Really helpful brother,

[@rows_columns]

Glad it helped

[@karthikavarma8970]

Thanks a lot, excellent

[@athiinair]

Hi, i am getting the message when i am updating the pivot table after editing some data - "We couldn't complete the action for the PivotTable "PivotTable1" in "Tables" because there's already a PivotTable "PivotTable2" there. Make space and try again." Can you pls help

[@rows_columns]

The error message you're encountering typically occurs when you try to update a pivot table, but there is insufficient space available for the updated pivot table to be created in the specified location. Here are a few steps you can take to resolve this issue: 1. Check for existing pivot tables: Verify if there are already existing pivot tables in the location where you're trying to update the pivot table. If there are, you can consider deleting or moving them to create space for the updated pivot table. 2. Adjust the layout: If there are multiple pivot tables occupying the same area, you may need to adjust their layout. Move or resize the existing pivot tables to make room for the updated one. 3. Clear the cache: Sometimes, clearing the cache for the workbook can help resolve the issue. To do this, go to the "Data" tab in Excel, click on "Refresh All," and then select "Clear All." 4. Verify data source range: Ensure that the data source range for the pivot table accurately reflects the data you want to include. If the data range is too large or doesn't cover the intended data, it can cause conflicts when updating the pivot table. 5. Check for hidden or grouped rows/columns: Hidden or grouped rows/columns within the data range can affect the space available for the pivot table. Unhide or ungroup any hidden or grouped rows/columns that may be interfering with the pivot table update. By following these steps, you should be able to address the "Make space and try again" error message when updating your pivot table. If the issue persists, please provide more specific details about your setup or share a sample of your workbook, so I can assist you further.

[@shijogeorge8008]

Well-done 👏

[@rows_columns]

Thanks bro :)

[@akjasar9069]

ningal kaanichath oru fixed datayude pivo table chart aan. ingane oru fixed data allathe daily transaction nadannkondirikumbol automatic aayitt thanne engane pivo table chart data change aakum? ee oru format onn paranj tharaamo? for example nammal tallyil kaanaarille nammal ipol or data enter cheyth kayinjal athin anusarich chart automatic aayi change aakunnath. ithpole excelil engane cheyyaanakum?

[@Moukode9909Ebrahim]

good one

[@abduljaleel576]

Well explained

[@rows_columns]

Thank you!

[@satheeshram6826]

Hi Mohammad AlFan I have few doubts on the Dashboard how to connect with you for the queries

[@PremKumar-ci6cc]

Very good,,,👍👍👍🌹🌹🌹

[@ttvaisakh]

Great video bro.It helped ❤️

[@rows_columns]

😍

[@thahirmali]

Superb

[@ashik.cheroor2610]

Super Bro

[@rows_columns]

😊👍

[@JevinVazhakkal]

Can you please share this Dataset, I would like to practice.

[@rows_columns]

Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support 😊 drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ

[@linotnow]

സൂപ്പർ

[@lakshmiprasad4026]

Lovelyyyyy one!!!!

[@rows_columns]

❤️😊

[@harizabdulvahid3553]

جزاكم الله ألف خير 👍

[@rows_columns]

😊

[@anandsr2377]

ചേട്ടാ.. ഒരു അറ്റന്റൻസ് ഫയൽ എങ്ങനെ സെറ്റ് ചെയ്യാൻ പറ്റും? അത് പോലെ അറ്റന്റൻസ് ആബ്സെന്റ് പോയിട്ട് എത്ര ദിവസം വർക്ക്‌ ചെയ്തു എന്നാ കൗണ്ട് ഓട്ടോമാറ്റിക് ആയി എങ്ങനെ sort ചെയ്യാൻ പറ്റും? പറഞ്ഞു തരുമോ

[@rows_columns]

Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates

[@AJ2015a]

Nice..

[@dewdrops3743]

Data puthiyathayi add ചെയ്താൽ auto update aakumo graph..??

[@rows_columns]

Yes!

[@vslinus]

good one!

[@rows_columns]

Thanks bro😊

[@sruthiks2495]

Thank u sir

[@jesbinkunjumon3757]

Nice bro

[@aswinanand1235]

Helpfull

[@prasanthpillai8272]

Thanks a lot

[@rows_columns]

Most welcome

[@yadhukrishnanra930]

Epic video

[@rows_columns]

💙

[@abdulbasith6398]

Hi, i couldn't download the file which you used here. The site is unable to open.

[@ronygeorge1996]

Thanks bro

[@rows_columns]

Thank you, I am happy to hear you feel that way!

[@mansoorthayancheery5030]

Awesome ✌❤

[@rows_columns]

😍

[@mirashmichu1815]

Bhai... 🤝🤝👍

[@rows_columns]

😍

[@jinuvarghese3364]

New data amend cheithal automatic aayi updated aakumo?

[@santhoshbpillai6679]

👍👍👍👍👍👍👍thk u so much.

[@rows_columns]

Most welcome😊

[@blessyponnachen9528]

Can we do dashboard with only 17 rows and 7 columns of data

[@rows_columns]

Yes, we can🙏

[@SuperRajeshnair]

Enrolled

[@FUHADEm]

Sir , Ith practise cheyaanulla data download cheyanulla link work aavunilla

[@rows_columns]

Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support 😊 drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ

[@anudsb5768]

Thanku sir

[@rows_columns]

Welcome bro😊

[@poojaprahlad]

Hi sir, Can you please share the data for practice.

[@rows_columns]

Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support 😊 drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ

[@poojaprahlad]

@@rows_columns thank you so much for the response sir ❤️

[@raslanjahfer1487]

Hi Alfan Hope you are well doing I had watched your videos and its amazing. Keep up going The Dashboard was good, its simple and easy, But do you know any trick to show the Growth or decline % to calculate in pivot table which will reflect on pivot table and charts for each month and for each year or Any idea to show in Charts. I had developed one dashboard, But need to show gross or Decline % in Pivot table or pivot charts Looking forward for your valuable tips

[@rows_columns]

Hi Raslan Alhamdulilla , All well brother😊 Hope your doing great! Surely will be uploading an exclusive video for Dashboard Analysis😊👍

[@raslanjahfer1487]

@@rows_columns do have any idea to include growth or decline % in pivot table?

[@rows_columns]

@@raslanjahfer1487 Yes, will show it in separate video!

[@Zainarafa]

Data analytics book Amazon link description il share cheyoo

[@rows_columns]

Yeah sure😃 www.amazon.in/DATA-ANALYTICS-For-Beginners/dp/B08NF1426C/ref=sr_1_15?crid=2W9JY3WXUYH1J&keywords=data+analytics+books&qid=1637178511&sprefix=data+anlystic%2Caps%2C354&sr=8-15

[@rithwicreationspresents1970]

👍👍

[@rows_columns]

🙌

[@akhilkrishnaswami1248]

❤❤❤❤

[@jihadvp4536]

شكرا لك

[@rows_columns]

😊❤️

[@raneesh_np]

🔥🔥🔥🔥🔥👌👌

[@rows_columns]

😊

[@nazareenalthaf7829]

Sir practice cheyyan data file kittumo

[@rows_columns]

Already mentioned in the video….kindly listen😃

[@nazareenalthaf7829]

@@rows_columns ok sir check cheythu but ee file kittiyilla

[@rows_columns]

Pls try now..

[@Faisal-Nalett]

Oru rakshayumlla

[@sibinthomas9865]

hi sir can you pls sent this spreadsheet

[@rows_columns]

Download file used in the video > www.rowscolumns.com/free-excel-templates

[@renjikp8285]

👍👍👍👍👍👍

[@seema1742]

ചേട്ടായീ... പുതിയ വീഡിയോ ഒന്നും ഇടുന്നില്ലേ 😿

[@rows_columns]

Udane varum👍

[@arunghoshks1205]

mail ayakamo excel

[@rows_columns]

Sure

[@mansooralik9919]

Not found the data sheet

[@rows_columns]

Apologies for the delayed response; my system is currently undergoing maintenance due to technical issues. You can access the requested file through the link below. Thanks for your understanding and support: drive.google.com/drive/folders/1WArNDI5AYVkHKB-Vxdl3V3u6xtjFT7xJ

[@j1d9tj]

Can I call you. I need a help in excel. Thank you.

[@rows_columns]

Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates

[@sreekumark.s.3425]

🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@j1d9tj]

Hi

[@rows_columns]

Hi

[@Rebeu93130]

Fake thumbails ?

[@ImranKhan-ew5nv]

Hi, your videos are very helpful thank you for that, I was trying to sort out one problem in excel, thought check with you hope you can help I want to bring Referrence number next to the customer account number column from another data, here the unique fields are customer account number and amount in both data. So to find the reference number I combined account number and amount in both data and did vlookup Here the problem Iam facing is the master data Iam using to find the reference number having same account number with same amount for multiple days with unique reference number, my vlookup is giving me only one reference number for all the same account whereas it has different reference number Since the data I require is so big, I can’t find it individually hope you can help me out Eg A having txn for $100 on 24.11.21 again A having txn for $100 on 25.11.21 A having again txn for $100 on 30.11.21 Reference number for the three txn are different and unique but when I want to find the exact reference number against the actual vlookup is not helping I

[@rows_columns]

Hi Imran, will check and revert.

[@rishadav6465]

👍👍👍👍👍👍

[@rows_columns]

Thanks for watching! 😊 Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates