10 Magical Tricks in MS Excel || MS Excel Malayalam

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

[@_lovely_fidha_]

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

[@rows_columns]

🙏😊

[@midhun6296]

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]

@@rows_columns Watsapp contact please?

[@bijoygeevarghese2304]

Very useful and informative. Thank you sir

[@drpksukumarantrichur6613]

Very useful approach Heartfelt congratulations Dr P K Sukumaran

[@dhanyankooliyath2144]

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]

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

[@ksibrahim9329]

Excellent video. Thank you

[@asharafmuhammed8269]

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

[@rows_columns]

Thanks Brother😊

[@fasilkk674]

Great,as an accountant. Very useful

[@vishnusoman8532]

Nice Work, Thank you

[@askarabdulla387]

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

[@rows_columns]

Thanks Mate😊🤝

[@tonytony6563]

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

[@rows_columns]

😊🙏

[@vidyamr3359]

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

[@rows_columns]

Thanks Vidya😇

[@anasa9657]

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

[@muhsinp829]

ഞാനും

[@rows_columns]

:)

[@muralijyothy]

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

[@rows_columns]

❤️😊

[@mohmedmansooor488]

Thank u alfan... ബായി

[@sajeerks1708]

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

[@rows_columns]

Thanks brother...😊♥️

[@sameerthadathil8645]

Really helpful, Thanks brother

[@rows_columns]

Glad to hear that Bro :)

[@dforyou-informativetipstra9012]

Informative 🔥👍

[@sajujoseph5651]

Very very useful.. thank you so much

[@rows_columns]

Tnx Bro😊

[@slkkmr84]

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

[@rows_columns]

Appreciate it!

[@akshayp3554]

Great... Thank uu

[@shruthimuralidharan1376]

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

[@rows_columns]

My pleasure ☺️

[@abusalih4305]

Best presentation 👍

[@leonsoncv9034]

Thank you👍

[@raneesh_np]

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

[@rows_columns]

😄

[@muhammedshajikp.m.3139]

Appreciable presentation

[@rows_columns]

Thanks Brother :)

[@mohammedsalimmuttoon3231]

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

[@rows_columns]

❤️

[@salmanulfaris731]

Very useful, Thanks

[@rows_columns]

Thank you😊

[@asif100100]

Awesome man👍

[@techtravelbysameerkallai603]

Nice tutorial.. good starting.. best of luck

[@rows_columns]

Thanks Sameerka :)

[@cyriacjoseph13]

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

[@cyriacjoseph13]

Can u pleez mail those sheets @[e-mail]

[@rows_columns]

Sure Brother😊 & Thanks for your feedback :)

[@nidheesh1558]

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

[@rows_columns]

😊

[@abdullatheefk2866]

Hai Mr. Alfan, it is really AMAZING. Thanks

[@rows_columns]

😊

[@jabishalu]

Thank you ❤

[@deepakkareacode]

Nice. Really helpful ✌️✌️

[@rows_columns]

Thanks Deepak☺️

[@ameerali8690]

Thanks a tun bro.. for all your vedios

[@rows_columns]

Most welcome brother🦋

[@nihalamunaver6224]

Thnk you sir...very useful video

[@rows_columns]

So nice of you :)

[@sudheeshss9397]

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

[@rows_columns]

😄

[@sandrarajeev798]

You are brilliant sir

[@rows_columns]

🙏😊

[@ashrafachu7239]

Pwoli brother class അടിപൊളി aan

[@rows_columns]

😊

[@abdussalamputhupparambil6129]

Very helpful

[@izzamariyabinu5050]

Very useful bro

[@jinushsha]

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

[@rows_columns]

Thank you so much 🙂

[@edansmedia4698]

Thanks for all information ❤️

[@rows_columns]

My pleasure 😊

[@SanthoshKumar-xd5ki]

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

[@rows_columns]

Thank you so much 🙂

[@nadirshakv]

Great Job, keep going bro👍

[@rows_columns]

Thanks Man :)

[@dondavid333]

Good comprehension as per the caption.

[@rows_columns]

😊

[@shanilkumar7496]

good information thanks for sharing

[@rows_columns]

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]

Thank you Subscribed 👍

[@rows_columns]

♥️

[@nazimamman]

good job @alfan....👍

[@rows_columns]

Thanks da!☺️🤝

[@sajispanicker5789]

Superbly

[@adilrp]

Very usefull. Keep going Bro👍

[@rows_columns]

🤝

[@sharemalayali5212]

In Excel use in share trading purpose effectively

[@jijophilip5692]

Thank You.

[@rows_columns]

You're welcome

[@hemarajanp.k8899]

Very usefull thanks

[@rows_columns]

Welcome 😊

[@archafarooq]

Good job✌️all the best

[@rows_columns]

😊

[@shamal.k1531]

Verry useful vedio.. dear

[@rows_columns]

Thank bro👍😊

[@abdulrasheed-ix9pm]

Amazing bro

[@josephpatrick5381]

Good presentation.

[@rows_columns]

Thanks for your feedback☺️

[@habenick]

Good initiative alfan bhai

[@rows_columns]

Thanks Bai :)

[@SunilKumar-om6vu]

excellent presentation

[@rows_columns]

Glad you liked it!😇

[@sajispanicker5789]

Excellent dear 👍

[@rows_columns]

❤️

[@himasinto4112]

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]

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

[@Ashiqali-ji1wq]

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

[@rows_columns]

Glad to know that brother😊

[@nashidalfajar430]

Good presentation

[@rows_columns]

😍

[@jessyjoseph4388]

THank you

[@rows_columns]

You're welcome

[@basheertrissure]

you are superrrrrrrr

[@rows_columns]

🙏

[@sabukaithapuzha8796]

Good information

[@rows_columns]

😊

[@shanmon939]

Super bro

[@beautiful_life007]

Great

[@asyedafwan5923]

Wonderful

[@rows_columns]

Thanks Afwan :)

[@drelbyclt]

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

[@rows_columns]

Already uploaded.. Pls check my playlist

[@capturakeepsyousmiling3068]

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

[@akhilsreekalummakayaz]

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

[@rows_columns]

Thanks bro❤️

[@vishnupp3200]

Power pivot videos cheyyamoo

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

[@sreelalps7184]

GREAT SIR.COULD YOU SHARE THE EXCEL SHEET

[@sebyanto772]

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

[@79prasa]

amazing

[@binshadkv6219]

Good 👍👍👍👍

[@rows_columns]

😊

[@jayalakshmik576]

Excel too ,soo that I can practice.

[@falah_6862]

Wooww 💯

[@asyedafwan5923]

😃❤️

[@sajujoseph5651]

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

[@rows_columns]

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

[@sajikrishnan3]

super

[@drpksukumarantrichur6613]

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: [e-mail] Thank u very much with best wishes Dr P K Sukumaran

[@FazinBinUmmer]

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]

You’re right✅

[@vishnujanardhanan6360]

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

[@mansoorthayancheery5030]

Great Job.May Allah will bless you dear.

[@rows_columns]

Many many thanks :)

[@rashisrainbow6719]

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

[@tinsyjohn]

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

[@rows_columns]

Yes :)

[@vtnishadvt]

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

[@rows_columns]

☺️

[@vipinkv2050]

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

[@rows_columns]

kzbin.info/www/bejne/Y6CUga2Qjch7bZI Hope its help you😊

[@fahadcheruvannur]

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

[@rejiravi5600]

Starter

[@siyadfathah007abdulrahman8]

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)

[@ckck8262]

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

[@shibuchirathalackal9187]

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

[@rows_columns]

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

[@sahalmaharoof3949]

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

[@angelgeorgeofcl]

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]

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

[@angelgeorgeofcl]

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

[@rows_columns]

Keep Learning & Keep Thriving😊

[@vivekkrishnan.d925]

sir,how we find out duplicate values in more than one columns

[@rows_columns]

There are multiple ways Brother :).. Please look into my video > kzbin.info/www/bejne/jYC4qWqKiZiYo5Y

[@user-be1eg7tr8r]

Does flashfill only works on table

[@yoosufkdl]

Flash fill available on excel 2007? And also data forecast, maps?

[@rows_columns]

Flash Fill was released in Excel 2013, and any later versions will also have it👍😊