10 Magical Tricks in MS Excel || MS Excel Malayalam

[@Faiztv-m2z]

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?

[@tonytony6563]

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

[@rows_columns]

😊🙏

[@anasa9657]

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

[@muhsinp829]

ഞാനും

[@rows_columns]

:)

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

[@raneesh_np]

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

[@rows_columns]

😄

[@muralijyothy]

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

[@rows_columns]

❤️😊

[@bijoygeevarghese2304]

Very useful and informative. Thank you sir

[@vishnusoman8532]

Nice Work, Thank you

[@fasilkk674]

Great,as an accountant. Very useful

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

[@askarabdulla387]

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

[@rows_columns]

Thanks Mate😊🤝

[@asharafmuhammed8269]

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

[@rows_columns]

Thanks Brother😊

[@ameerali8690]

Thanks a tun bro.. for all your vedios

[@rows_columns]

Most welcome brother🦋

[@slkkmr84]

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

[@rows_columns]

Appreciate it!

[@salmanulfaris731]

Very useful, Thanks

[@rows_columns]

Thank you😊

[@sandrarajeev798]

You are brilliant sir

[@rows_columns]

🙏😊

[@mohammedsalimmuttoon3231]

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

[@rows_columns]

❤️

[@asif100100]

Awesome man👍

[@sajujoseph5651]

Very very useful.. thank you so much

[@rows_columns]

Tnx Bro😊

[@ashrafachu7239]

Pwoli brother class അടിപൊളി aan

[@rows_columns]

😊

[@vidyamr3359]

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

[@rows_columns]

Thanks Vidya😇

[@nihalamunaver6224]

Thnk you sir...very useful video

[@rows_columns]

So nice of you :)

[@shamal.k1531]

Verry useful vedio.. dear

[@rows_columns]

Thank bro👍😊

[@nidheesh1558]

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

[@rows_columns]

😊

[@techtravelbysameerkallai603]

Nice tutorial.. good starting..
best of luck

[@rows_columns]

Thanks Sameerka :)

[@sudheeshss9397]

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

[@rows_columns]

😄

[@sajispanicker5789]

Excellent dear 👍

[@rows_columns]

❤️

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

[@shruthimuralidharan1376]

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

[@rows_columns]

My pleasure ☺️

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

[@SanthoshKumar-xd5ki]

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

[@rows_columns]

Thank you so much 🙂

[@akshayp3554]

Great... Thank uu

[@Ashiqali-ji1wq]

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

[@rows_columns]

Glad to know that brother😊

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

[@habenick]

Good initiative alfan bhai

[@rows_columns]

Thanks Bai :)

[@deepakkareacode]

Nice.
Really helpful ✌️✌️

[@rows_columns]

Thanks Deepak☺️

[@archafarooq]

Good job✌️all the best

[@rows_columns]

😊

[@adilrp]

Very usefull. Keep going Bro👍

[@rows_columns]

🤝

[@akhilsreekalummakayaz]

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

[@rows_columns]

Thanks bro❤️

[@nadirshakv]

Great Job, keep going bro👍

[@rows_columns]

Thanks Man :)

[@abusalih4305]

Best presentation 👍

[@mohmedmansooor488]

Thank u alfan... ബായി

[@abdullatheefk2866]

Hai Mr. Alfan, it is really AMAZING. Thanks

[@rows_columns]

😊

[@nashidalfajar430]

Good presentation

[@rows_columns]

😍

[@izzamariyabinu5050]

Very useful bro

[@nazimamman]

good job @alfan....👍

[@rows_columns]

Thanks da!☺️🤝

[@rashisrainbow6719]

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

[@leonsoncv9034]

Thank you👍

[@faisalcpcp8281]

Thank you
Subscribed 👍

[@rows_columns]

♥️

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

[@muhammedshajikp.m.3139]

Appreciable presentation

[@rows_columns]

Thanks Brother :)

[@dforyou-informativetipstra9012]

Informative 🔥👍

[@manissery1956]

Thanks.3D ഫോര്മുലയിൽ ഒരേ ഫോർമാറ്റിൽ ഉള്ള ഡാറ്റ ആയിരിയ്ക്കണം അല്ലെ. Searchable dropdown ലിസ്റ്റ് എങ്ങനെ ഉണ്ടാക്കാം എന്ന് ഒരു വീഡിയോ ചെയ്യുമോ. അത് പോലെ എക്സൽ ഷീറ്റിൽ സ്റ്റോക്ക് exchange കിട്ടുമോ currency കൊണ്ടു വന്ന പോലെ.

[@rows_columns]

Yes, 3D calculations il ningal parajndpole👍
Searchable Drop down - Udane cheyyam😊
Yes, Stock exchange kittum (Live data).. Separate video il kaanikkam😊👍

[@manissery1956]

@@rows_columns Thanks a lot. Searchable dropdown list ചെയ്യുമ്പോൾ അത് all inclusive ആക്കണം. പല rowsil നിന്നും കിട്ടും പോലെ വേണം. ഇത് വരെ കണ്ട അപൂർവം വീഡിയോ മാത്രമേ multiple സെൽ ചെയ്തള്ളൂ. എല്ലാവർക്കും മനസ്സിലാകുന്ന ഒരു സൂപ്പർ വീഡിയോ പ്രതീക്ഷിയ്ക്കുന്നു. അത് പോലെ സ്റ്റോക്ക് exch.

[@rows_columns]

@@manissery1956 Sure Haridas, Considered👍😊

[@basheertrissure]

you are superrrrrrrr

[@rows_columns]

🙏

[@jinushsha]

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

[@rows_columns]

Thank you so much 🙂

[@shiyasvk]

ഇപ്പോൾ ആണ് കാണുന്നത് , ഒരുപാട് ഉപകാരപ്പെട്ടു. nword ഉപയോഗിക്കുന്നത് പറയാമോ ?

[@rows_columns]

Sure, definitely👍😊

[@josephpatrick5381]

Good presentation.

[@rows_columns]

Thanks for your feedback☺️

[@abdulrasheed-ix9pm]

Amazing bro

[@shukoorvbr5251]

Very Good. ഒരു figure മറ്റൊരു കോളത്തിൽ words ൽ (English) കാണിക്കാനായി കൊടുക്കുന്ന formula പറഞ്ഞുതരാമോ ( Eg:- figure ന്റെ Col. name B4)

[@rows_columns]

Thanks for your feedback :) With regards to your requested topic ഉടൻ തന്നെ upload ചെയ്യുന്നതായിരിക്കും.. In sha allah :)

[@dondavid333]

Good comprehension as per the caption.

[@rows_columns]

😊

[@sabukaithapuzha8796]

Good information

[@rows_columns]

😊

[@hemarajanp.k8899]

Very usefull thanks

[@rows_columns]

Welcome 😊

[@jabishalu]

Thank you ❤

[@sajispanicker5789]

Superbly

[@SunilKumar-om6vu]

excellent presentation

[@rows_columns]

Glad you liked it!😇

[@vishnupp3200]

Power pivot videos cheyyamoo

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

[@mansoorthayancheery5030]

Great Job.May Allah will bless you dear.

[@rows_columns]

Many many thanks :)

[@sahalmaharoof3949]

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

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

[@binshadkv6219]

Good 👍👍👍👍

[@rows_columns]

😊

[@Blissfullyangel]

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

[@Blissfullyangel]

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

[@rows_columns]

Keep Learning & Keep Thriving😊

[@dhanyankooliyath2144]

Can I pull the data from the portals which requires the credentials?

[@rows_columns]

100%.. (By using power query App)

[@dhanyankooliyath2144]

@@rows_columns could you please help me with some youtube links if possible only..

[@sharemalayali5212]

In Excel use in share trading purpose effectively

[@jobinmathew9958]

Bro... Excel shot cuts video cheyyamo?

[@rows_columns]

Definitely Brotha😊

[@rows_columns]

As requested :) th-cam.com/video/waBSpmzGVGY/w-d-xo.html

[@jijophilip5692]

Thank You.

[@rows_columns]

You're welcome

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

[@shanmon939]

Super bro

[@jessyjoseph4388]

THank you

[@rows_columns]

You're welcome

[@tinsyjohn]

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

[@rows_columns]

Yes :)

[@ckck8262]

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

[@ashiqmuhammed2968]

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

[@sharfudheenc6179]

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

[@sajujoseph5651]

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

[@rows_columns]

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

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

[@sreelalps7184]

GREAT SIR.COULD YOU SHARE THE EXCEL SHEET

[@Ashie.o0]

A loan emi reducing aahno atho flat rate scheme aahno

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

[@askarabdulla387]

Bro, aadyam kaanichathin pakaram consolidat cheyyunnathalle elupam.

[@rows_columns]

Both way u can use👍... 3D is different style of consolidation😊 Hope u already saw Consolidation Module.

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

[@asyedafwan5923]

Wonderful

[@rows_columns]

Thanks Afwan :)

[@brave4466]

3D calculationil Sum ചെയ്യുമ്പോ ഒരു column miss aakunnund
Total figur kittunnilla

[@rows_columns]

Try again

[@falah_6862]

Wooww 💯

[@asyedafwan5923]

😃❤️

[@hafsal0482]

Conatact number undo ? nJaan Uk yil aanu VBA macro nte oru doubt chodikan aarnnu

[@vipinkv2050]

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

[@rows_columns]

th-cam.com/video/-o1PzZXcH70/w-d-xo.html
Hope its help you😊

[@fahadcheruvannur]

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

[@vishnujanardhanan6360]

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

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