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
Пікірлер: 387
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?
Very useful and informative. Thank you sir
ഇബാദ്ക്കയുടെ വീഡിയോ കണ്ടിട്ട് വന്നതാണ്. ഈ functions എല്ലാം ഞാൻ പവടിച്ചിട്ടുണ്ട് പലതും ഉപയോഗിക്കാരും ഉണ്ട്. പക്ഷെ എനിക്ക് അറിയാമായിരുന്നു എക്സലിൽ ഇനിയും എത്രയോ പഠിക്കാൻ ഉണ്ടന്ന്. നിങ്ങളെ പരിചയപ്പെട്ടതിൽ സന്തോഷം. തീർച്ചയായും എല്ലാ വിഡിയോസും കണ്ടു തീർക്കണം 🥰 Thanks 🥰
@muhsinp829
3 жыл бұрын
ഞാനും
@rows_columns
3 жыл бұрын
:)
Very useful approach Heartfelt congratulations Dr P K Sukumaran
Nice Work, Thank you
Excellent video. Thank you
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 :)
Informative 🔥👍
Best best best presentation....really liked the way you explained ...keep doing....really helpful
@rows_columns
3 жыл бұрын
Thanks Vidya😇
ഒരുപാട് പഠിച്ചു താങ്കളിൽനിന്നും... God bless u ❤️
@rows_columns
Жыл бұрын
😊🙏
Really appreciate you man for this effort, remarkable vedio.. i learn somany things from this vedio.
@rows_columns
4 жыл бұрын
Thanks Mate😊🤝
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😊
Well begun is half done.You explained it in clear and simple manner!
@rows_columns
4 жыл бұрын
Thanks Brother😊
Great... Thank uu
Amazing stuff Bro. Keep up the good work. Thank you.
@rows_columns
5 ай бұрын
Appreciate it!
Thank u alfan... ബായി
Great,as an accountant. Very useful
Nice tutorial.. good starting.. best of luck
@rows_columns
4 жыл бұрын
Thanks Sameerka :)
Best presentation 👍
Awesome man👍
Very very useful.. thank you so much
@rows_columns
3 жыл бұрын
Tnx Bro😊
Thank you👍
Great Job, keep going bro👍
@rows_columns
4 жыл бұрын
Thanks Man :)
Very useful, Thanks
@rows_columns
2 жыл бұрын
Thank you😊
Hi Allan, Amazing and well explained Thank you very much dear
@rows_columns
2 жыл бұрын
❤️
Thanks a tun bro.. for all your vedios
@rows_columns
Жыл бұрын
Most welcome brother🦋
സംഗതി അടിപൊളി ആയിട്ടുണ്ട് .ഇബദുക്ക യുടെ ചാനലിൽ കണ്ടു . അറിഞ്ഞില്ല ആരും പറഞ്ഞില്ല... ❤❤❤❤❤
@rows_columns
3 жыл бұрын
😄
Appreciable presentation
@rows_columns
4 жыл бұрын
Thanks Brother :)
Nice video . Lot of information ❤️❤️❤️
@rows_columns
4 жыл бұрын
😊
Thank you Alfan bhai.. atlast as promised I can learn excel from you 🙂
@rows_columns
4 жыл бұрын
My pleasure ☺️
good job @alfan....👍
@rows_columns
4 жыл бұрын
Thanks da!☺️🤝
First time watching your video, wonderful presentation. Thank you very much.
@rows_columns
2 жыл бұрын
❤️😊
Very helpful
Thank you ❤
Nice. Really helpful ✌️✌️
@rows_columns
4 жыл бұрын
Thanks Deepak☺️
Really helpful, Thanks brother
@rows_columns
3 жыл бұрын
Glad to hear that Bro :)
Very useful bro
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
Superbly
Thnk you sir...very useful video
@rows_columns
3 жыл бұрын
So nice of you :)
Verry useful vedio.. dear
@rows_columns
2 жыл бұрын
Thank bro👍😊
Hi Brother. Good job and highly informative videos. Thank you and keep going. All the best
@rows_columns
3 жыл бұрын
Thank you so much 🙂
Hi alfan sir,Excel use cheyan thudangiyit varshangalaayi thangalude vedeos valre helpful aanu keep go on. 👍✌️
@rows_columns
3 жыл бұрын
Thanks brother...😊♥️
Good job✌️all the best
@rows_columns
4 жыл бұрын
😊
Pwoli brother class അടിപൊളി aan
@rows_columns
4 жыл бұрын
😊
Great dear ❤really helpfull vidieo and your presentation extra ordinary 👍
@rows_columns
2 жыл бұрын
Thank you so much 🙂
You are brilliant sir
@rows_columns
2 жыл бұрын
🙏😊
Hai Mr. Alfan, it is really AMAZING. Thanks
@rows_columns
3 жыл бұрын
😊
Thank you Subscribed 👍
@rows_columns
4 жыл бұрын
♥️
Very usefull thanks
@rows_columns
3 жыл бұрын
Welcome 😊
Excellent dear 👍
@rows_columns
Жыл бұрын
❤️
Good presentation.
@rows_columns
4 жыл бұрын
Thanks for your feedback☺️
Very usefull. Keep going Bro👍
@rows_columns
3 жыл бұрын
🤝
Ithrem naal evdairunnu bro...... 👌👌👌👌👌👌👌👍👍👍
@rows_columns
3 жыл бұрын
😄
Good presentation
@rows_columns
3 жыл бұрын
😍
Thank You.
@rows_columns
3 жыл бұрын
You're welcome
Amazing bro
Good initiative alfan bhai
@rows_columns
4 жыл бұрын
Thanks Bai :)
Thanks for all information ❤️
@rows_columns
3 жыл бұрын
My pleasure 😊
Good information
@rows_columns
4 жыл бұрын
😊
Good comprehension as per the caption.
@rows_columns
3 жыл бұрын
😊
excellent presentation
@rows_columns
4 жыл бұрын
Glad you liked it!😇
you are superrrrrrrr
@rows_columns
2 жыл бұрын
🙏
Wonderful
@rows_columns
4 жыл бұрын
Thanks Afwan :)
Great
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
THank you
@rows_columns
3 жыл бұрын
You're welcome
📌To Learn Microsoft Excel in English, Click on the Below Link: kzread.info/dash/bejne/daJnj8SFdM6tfbw.html
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
My reports are very fast now Because of you thank you 💞
@rows_columns
3 жыл бұрын
Glad to know that brother😊
Good 👍👍👍👍
@rows_columns
4 жыл бұрын
😊
amazing
ഈ ചാനൽ സബ്സ്ക്രൈബ് ചെയ്തവർക്ക് എൻ്റെ വാക്കുകൾ ഉപകാരപെടുകയാണെങ്കിൽ വായിക്കുക, വിദ്യാർത്ഥികൾക്കും പ്രൊഫഷനുകൾക്കും പെട്ടെന്ന് മനസിലാകുന്ന തരത്തിൽ വളരെ ലളിതകരമായ രീതിയിലാണ് അൽഫാൻ ഓരോ കാര്യങ്ങളും അവതരിപ്പിചിരിക്കുന്നത്. ഓരോ ഫങ്ക്ഷൻസും ഫോർമുലകളും എങ്ങനെയാണ് ഉപയോഗിക്കേണ്ടത് അത് പോലെ അതിൻറെ റിസൾട്ട് എങ്ങനെയാണ് ലഭിക്കുന്നത് എന്നൊക്കെ വളരെ ക്ലാരിറ്റിയോടു കൂടിയാണ് പറഞ്ഞു തരുന്നത്.എന്തായാലും എക്സെലിന്റെ ഉപയോഗം ഉള്ളവർ ഈ വീഡിയോസ് ഒക്കെ ഒരു പ്രാവശ്യം കാണുന്നത് നന്നായിരിക്കും.
Wooww 💯
@asyedafwan5923
4 жыл бұрын
😃❤️
Brother.. Nice video and class.. True copy think channel lu interview kandit anu evide vanath.. Nice class ..
@rows_columns
2 жыл бұрын
Thanks bro❤️
Super bro
Excel too ,soo that I can practice.
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
In Excel use in share trading purpose effectively
ماشاء الله مبروك
@rows_columns
4 жыл бұрын
☺️
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
Great Job.May Allah will bless you dear.
@rows_columns
3 жыл бұрын
Many many thanks :)
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
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)
Pudhudhaaayi indakan ponna sales data idhepole data validation cheydha mistake verathirikan sahayikumo??
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✅
Can we find out triplicate or more values by using conditional formating?
@rows_columns
3 жыл бұрын
Yes... will show you in upcoming conditional formatting topic😊
automatic flash fill option not seen in my excel. i checked in options-advanced options..
Power pivot videos cheyyamoo
Hi alfan, looking for a excel based quotation, invoice, proforma , purchase order template
Hi Bro, how can we drag the data from selective sheet and consolidate under single worksheet/File?
@rows_columns
4 жыл бұрын
kzread.info/dash/bejne/X6NlstyTiMauZ5M.html Hope its help you😊
For flash fill, should the new column be next to the column from which data is to be taken?
@rows_columns
4 жыл бұрын
Yes :)
🤘😍😍😍😍❤❤❤
Starter
GREAT SIR.COULD YOU SHARE THE EXCEL SHEET
👏🏻
@rows_columns
4 жыл бұрын
☺️
Bro ore item total aakanulla value and quandity toatal cheyyan entha cheyya
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
Sir ,How to hide cell high lighting while opening a excel vba programme Home Page
@rows_columns
4 жыл бұрын
Will explain you the same in VBA series....
Hii sir can you please include question related to MOS excel exam