10 Magical Tricks in MS Excel || MS Excel Malayalam

Подписаться 54 тыс.

Просмотров 69 тыс.

50% 1

In this video we can learn top 10 interesting tips and tricks for Excel 2019 in Malayalam version specially for beginners. This is a tutorial describing various tips to boost your productivity in Excel when working with your spreadsheets.
Download file used in the video: drive.google.com/drive/folder...
#ExcelMalayalamTips #MalayalamExcel #SkilltoSucceedByAlFan
Contents:
1. 3D Calculation - 1:02
2. Flash Fill - 3:48
3. Drop Down - 6:22
4. Goal Seek - 11:44
5. FB Data import into Excel - 16:57
6. Transpose & Hide Cell - 11:29
7. Data Forecast - 22:09
8. Web Data - 24:39
9. Filled Map - 30:10
10. People Graph - 33:56

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 387

@Faiztv-m2z 4 года назад

Hi Alfan. You are amazing . I have using the excel last 15 years however from your videos lot of new things learned.

@rows_columns 4 года назад

🙏😊

@midhun6296 3 года назад

midhunpmanesh2005@gmail plz sent some of your works you have done it would be a great help for Me in studying it thank you, sir

@usmanm2103 2 года назад

@@rows_columns Watsapp contact please?

@bijoygeevarghese2304 3 года назад

Very useful and informative. Thank you sir

@drpksukumarantrichur6613 3 года назад

Very useful approach Heartfelt congratulations Dr P K Sukumaran

@ksibrahim9329 2 года назад

Excellent video. Thank you

@vishnusoman8532 2 года назад

Nice Work, Thank you

@mohmedmansooor488 4 года назад

Thank u alfan... ബായി

@fasilkk674 7 месяцев назад

Great,as an accountant. Very useful

@leonsoncv9034 3 года назад

Thank you👍

@jabishalu 4 месяца назад

Thank you ❤

@anasa9657 3 года назад

ഇബാദ്ക്കയുടെ വീഡിയോ കണ്ടിട്ട് വന്നതാണ്. ഈ functions എല്ലാം ഞാൻ പവടിച്ചിട്ടുണ്ട് പലതും ഉപയോഗിക്കാരും ഉണ്ട്. പക്ഷെ എനിക്ക് അറിയാമായിരുന്നു എക്സലിൽ ഇനിയും എത്രയോ പഠിക്കാൻ ഉണ്ടന്ന്. നിങ്ങളെ പരിചയപ്പെട്ടതിൽ സന്തോഷം. തീർച്ചയായും എല്ലാ വിഡിയോസും കണ്ടു തീർക്കണം 🥰 Thanks 🥰

@muhsinp829 3 года назад

ഞാനും

@rows_columns 3 года назад

@salmanulfaris731 2 года назад

Very useful, Thanks

@rows_columns 2 года назад

Thank you😊

@muhammedshajikp.m.3139 4 года назад

Appreciable presentation

@rows_columns 4 года назад

Thanks Brother :)

@akshayp3554 3 года назад

Great... Thank uu

@asharafmuhammed8269 4 года назад

Well begun is half done.You explained it in clear and simple manner!

@rows_columns 4 года назад

Thanks Brother😊

@jijophilip5692 3 года назад

Thank You.

@rows_columns 3 года назад

You're welcome

@vidyamr3359 3 года назад

Best best best presentation....really liked the way you explained ...keep doing....really helpful

@rows_columns 3 года назад

Thanks Vidya😇

@sandrarajeev798 2 года назад

You are brilliant sir

@rows_columns 2 года назад

🙏😊

@sameerthadathil8645 3 года назад

Really helpful, Thanks brother

@rows_columns 3 года назад

Glad to hear that Bro :)

@sajujoseph5651 3 года назад

Very very useful.. thank you so much

@rows_columns 3 года назад

Tnx Bro😊

@dhanyankooliyath2144 2 года назад

Your videos are awesome... I wonder why I didn't find you before.. very short, crisp and clear.. point to point.. keep going

@rows_columns 2 года назад

Thanks a ton for words! This is the actual reward😊

@abdussalamputhupparambil6129 2 года назад

Very helpful

@dforyou-informativetipstra9012 3 года назад

Informative 🔥👍

@abusalih4305 3 года назад

Best presentation 👍

@ameerali8690 Год назад

Thanks a tun bro.. for all your vedios

@rows_columns Год назад

Most welcome brother🦋

@askarabdulla387 4 года назад

Really appreciate you man for this effort, remarkable vedio.. i learn somany things from this vedio.

@rows_columns 4 года назад

Thanks Mate😊🤝

@asif100100 3 года назад

Awesome man👍

@hemarajanp.k8899 3 года назад

Very usefull thanks

@rows_columns 3 года назад

Welcome 😊

@slkkmr84 4 месяца назад

Amazing stuff Bro. Keep up the good work. Thank you.

@rows_columns 4 месяца назад

Appreciate it!

@izzamariyabinu5050 4 года назад

Very useful bro

@edansmedia4698 3 года назад

Thanks for all information ❤️

@rows_columns 3 года назад

My pleasure 😊

@nihalamunaver6224 3 года назад

Thnk you sir...very useful video

@rows_columns 3 года назад

So nice of you :)

@muralijyothy 2 года назад

First time watching your video, wonderful presentation. Thank you very much.

@rows_columns 2 года назад

❤️😊

@deepakkareacode 4 года назад

Nice. Really helpful ✌️✌️

@rows_columns 4 года назад

Thanks Deepak☺️

@nidheesh1558 4 года назад

Nice video . Lot of information ❤️❤️❤️

@rows_columns 4 года назад

😊

@shruthimuralidharan1376 4 года назад

Thank you Alfan bhai.. atlast as promised I can learn excel from you 🙂

@rows_columns 4 года назад

My pleasure ☺️

@sajispanicker5789 Год назад

Superbly

@jessyjoseph4388 3 года назад

THank you

@rows_columns 3 года назад

You're welcome

@sudheeshss9397 3 года назад

Ithrem naal evdairunnu bro...... 👌👌👌👌👌👌👌👍👍👍

@rows_columns 3 года назад

😄

@sajeerks1708 3 года назад

Hi alfan sir,Excel use cheyan thudangiyit varshangalaayi thangalude vedeos valre helpful aanu keep go on. 👍✌️

@rows_columns 3 года назад

Thanks brother...😊♥️

@sharemalayali5212 3 года назад

In Excel use in share trading purpose effectively

@mohammedsalimmuttoon3231 2 года назад

Hi Allan, Amazing and well explained Thank you very much dear

@rows_columns 2 года назад

❤️

@techtravelbysameerkallai603 4 года назад

Nice tutorial.. good starting.. best of luck

@rows_columns 4 года назад

Thanks Sameerka :)

@tonytony6563 Год назад

ഒരുപാട് പഠിച്ചു താങ്കളിൽനിന്നും... God bless u ❤️

@rows_columns Год назад

😊🙏

@shamal.k1531 2 года назад

Verry useful vedio.. dear

@rows_columns 2 года назад

Thank bro👍😊

@cyriacjoseph13 4 года назад

Excellent job...Nice presentation...Looking forward for much more interesting and informative videos as such...

@cyriacjoseph13 4 года назад

Can u pleez mail those sheets @cyriacjoseph13@gmail.com

@rows_columns 4 года назад

Sure Brother😊 & Thanks for your feedback :)

@shanilkumar7496 3 года назад

good information thanks for sharing

@rows_columns 2 года назад

Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates

@faisalcpcp8281 4 года назад

Thank you Subscribed 👍

@rows_columns 4 года назад

♥️

@dondavid333 3 года назад

Good comprehension as per the caption.

@rows_columns 3 года назад

😊

@ashrafachu7239 4 года назад

Pwoli brother class അടിപൊളി aan

@rows_columns 4 года назад

😊

@abdullatheefk2866 3 года назад

Hai Mr. Alfan, it is really AMAZING. Thanks

@rows_columns 3 года назад

😊

@raneesh_np 3 года назад

സംഗതി അടിപൊളി ആയിട്ടുണ്ട്‌ .ഇബദുക്ക യുടെ ചാനലിൽ കണ്ടു . അറിഞ്ഞില്ല ആരും പറഞ്ഞില്ല... ❤❤❤❤❤

@rows_columns 3 года назад

😄

@josephpatrick5381 4 года назад

Good presentation.

@rows_columns 4 года назад

Thanks for your feedback☺️

@SunilKumar-om6vu 4 года назад

excellent presentation

@rows_columns 4 года назад

Glad you liked it!😇

@nashidalfajar430 3 года назад

Good presentation

@rows_columns 3 года назад

😍

@nadirshakv 4 года назад

Great Job, keep going bro👍

@rows_columns 4 года назад

Thanks Man :)

@jinushsha 3 года назад

Hi Brother. Good job and highly informative videos. Thank you and keep going. All the best

@rows_columns 3 года назад

Thank you so much 🙂

@SanthoshKumar-xd5ki 2 года назад

Great dear ❤really helpfull vidieo and your presentation extra ordinary 👍

@rows_columns 2 года назад

Thank you so much 🙂

@beautiful_life007 3 года назад

Great

@nazimamman 4 года назад

good job @alfan....👍

@rows_columns 4 года назад

Thanks da!☺️🤝

@himasinto4112 3 года назад

thanku brother njn first time excell use chyunathu ..karanam nte epolathe job nu excell must ahhnu so kuduthal padikkan ahhnu yutube refer cheyunathu ..ee video enik helpful ayyi keto thankuu so much brother

@rows_columns 2 года назад

Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates

@archafarooq 4 года назад

Good job✌️all the best

@rows_columns 4 года назад

😊

@capturakeepsyousmiling3068 2 года назад

Hi Alfan,Is there any possibility to count the total number of qty for an year for a particular part number and also any ways to count all the parts starting with FP----- & sp-----.Balance code after fp varies , but i need to count all the parts if it starts with FP.Please reply

@basheertrissure 2 года назад

you are superrrrrrrr

@rows_columns 2 года назад

🙏

@Ashiqali-ji1wq 3 года назад

My reports are very fast now Because of you thank you 💞

@rows_columns 3 года назад

Glad to know that brother😊

@adilrp 3 года назад

Very usefull. Keep going Bro👍

@rows_columns 3 года назад

🤝

@sabukaithapuzha8796 4 года назад

Good information

@rows_columns 4 года назад

😊

@asyedafwan5923 4 года назад

Wonderful

@rows_columns 4 года назад

Thanks Afwan :)

@abdulrasheed-ix9pm 3 года назад

Amazing bro

@sajispanicker5789 Год назад

Excellent dear 👍

@rows_columns Год назад

❤️

@79prasa Год назад

amazing

@habenick 4 года назад

Good initiative alfan bhai

@rows_columns 4 года назад

Thanks Bai :)

@jayalakshmik576 Год назад

Excel too ,soo that I can practice.

@vishnupp3200 3 года назад

Power pivot videos cheyyamoo

@rashisrainbow6719 4 года назад

ഈ ചാനൽ സബ്സ്ക്രൈബ് ചെയ്തവർക്ക് എൻ്റെ വാക്കുകൾ ഉപകാരപെടുകയാണെങ്കിൽ വായിക്കുക, വിദ്യാർത്ഥികൾക്കും പ്രൊഫഷനുകൾക്കും പെട്ടെന്ന് മനസിലാകുന്ന തരത്തിൽ വളരെ ലളിതകരമായ രീതിയിലാണ് അൽഫാൻ ഓരോ കാര്യങ്ങളും അവതരിപ്പിചിരിക്കുന്നത്. ഓരോ ഫങ്ക്ഷൻസും ഫോർമുലകളും എങ്ങനെയാണ് ഉപയോഗിക്കേണ്ടത് അത് പോലെ അതിൻറെ റിസൾട്ട് എങ്ങനെയാണ് ലഭിക്കുന്നത് എന്നൊക്കെ വളരെ ക്ലാരിറ്റിയോടു കൂടിയാണ് പറഞ്ഞു തരുന്നത്.എന്തായാലും എക്സെലിന്റെ ഉപയോഗം ഉള്ളവർ ഈ വീഡിയോസ് ഒക്കെ ഒരു പ്രാവശ്യം കാണുന്നത് നന്നായിരിക്കും.

@sebyanto772 2 года назад

Thank you, In Goal seak, =PMT (F3/12,60,F2) and value of -1720.80 is not clear as I tried , it' said formula error

@akhilsreekalummakayaz 2 года назад

Brother.. Nice video and class.. True copy think channel lu interview kandit anu evide vanath.. Nice class ..

@rows_columns 2 года назад

Thanks bro❤️

@sajikrishnan3 3 года назад

super

@drpksukumarantrichur6613 3 года назад

Dear Sir, Very interesting informative and inspiring presentation. I can vouch that this is the easily first video class about Excel . I have visited many and found this the best. I request you to kindly send me the Excel formulas and examples in Excel to my Email ID: drsukumaranpk@yahoo.co.uk Thank u very much with best wishes Dr P K Sukumaran

@shanmon939 3 года назад

Super bro

@falah_6862 4 года назад

Wooww 💯

@asyedafwan5923 4 года назад

😃❤️

@drelbyclt 2 года назад

Pls make video to hide zeros from tables and keetp it blank wherever data is nil.

@rows_columns 2 года назад

Already uploaded.. Pls check my playlist

@binshadkv6219 4 года назад

Good 👍👍👍👍

@rows_columns 4 года назад

😊

@sreelalps7184 Год назад

GREAT SIR.COULD YOU SHARE THE EXCEL SHEET

@FazinBinUmmer 3 года назад

Beautiful presentation, but I have a doubt : For goal seek any way to make the goal value to be dynamic by referencing a target cell, Bcos in your example you typed 80,000, any way I can set that to a cell in the sheet so that I can keep changing my target goal, else I'll have to open goal seek option everytime right.

@rows_columns 3 года назад

You’re right✅

@vtnishadvt 4 года назад

ماشاء الله مبروك

@rows_columns 4 года назад

☺️

@mansoorthayancheery5030 3 года назад

Great Job.May Allah will bless you dear.

@rows_columns 3 года назад

Many many thanks :)

@sahalmaharoof3949 2 года назад

Pudhudhaaayi indakan ponna sales data idhepole data validation cheydha mistake verathirikan sahayikumo??

@fahadcheruvannur 3 года назад

Hi alfan, looking for a excel based quotation, invoice, proforma , purchase order template

@sajujoseph5651 3 года назад

Can we find out triplicate or more values by using conditional formating?

@rows_columns 3 года назад

Yes... will show you in upcoming conditional formatting topic😊

@ckck8262 4 месяца назад

Hii sir can you please include question related to MOS excel exam

@vishnujanardhanan6360 3 года назад

automatic flash fill option not seen in my excel. i checked in options-advanced options..

@vipinkv2050 4 года назад

Hi Bro, how can we drag the data from selective sheet and consolidate under single worksheet/File?

@rows_columns 4 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--o1PzZXcH70.html Hope its help you😊

@tinsyjohn 4 года назад

For flash fill, should the new column be next to the column from which data is to be taken?

@rows_columns 4 года назад

Yes :)

@ashiqmuhammed2968 3 года назад

Mobile app ചെറിയ മിനി Market sujjest ചെയ്യാമോ??? Pls

@rejiravi5600 Год назад

Starter

@siyadfathah007abdulrahman8 2 года назад

Hi 👋, when I try to study web data but not Getdata icon in my excel sheet(its position is left end corner of the excel sheet)

@angelgeorgeofcl 2 года назад

Hi Thank You very much for the videos!! Can you send these worksheets for practice purpose, that would be great! Thank you again.

@rows_columns 2 года назад

Thanks for your words😊 You can directly download complete worksheets from the below link: www.rowscolumns.com/free-excel-templates?fbclid=IwAR1gKLidjH6WnhyDC5lFa5SbYHqpGOQCcgeNolFl6w5mexYWs5MEQ5OEMRo

@angelgeorgeofcl 2 года назад

@@rows_columns Thanks!! You're a life saver for beginners like me!!!!

@rows_columns 2 года назад

Keep Learning & Keep Thriving😊

@sharfudheenc6179 2 месяца назад

Bro ore item total aakanulla value and quandity toatal cheyyan entha cheyya

@shibuchirathalackal9187 3 года назад

Sir ,How to hide cell high lighting while opening a excel vba programme Home Page

@rows_columns 3 года назад

Will explain you the same in VBA series....

@vipinb3198 Год назад

Amazing Mr.Alfan. I am sure that your videos will help people who are working in Accounts and finance like me. Keep going on. Again its simply amazing 👍 respect you