10 Magical Tricks in MS Excel || MS Excel Malayalam

Поделиться
HTML-код
  • Опубликовано: 27 окт 2024

Комментарии • 389

  • @Faiztv-m2z
    @Faiztv-m2z 4 года назад +19

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

    • @rows_columns
      @rows_columns  4 года назад +1

      🙏😊

    • @midhun6296
      @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
      @usmanm2103 3 года назад

      @@rows_columns Watsapp contact please?

  • @anasa9657
    @anasa9657 4 года назад +3

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

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

    📌To Learn Microsoft Excel in English, Click on the Below Link:
    ruclips.net/video/Cn3-bLDkGMY/видео.html

  • @tonytony6563
    @tonytony6563 Год назад +2

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

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

    Very useful approach Heartfelt congratulations Dr P K Sukumaran

  • @dhanyankooliyath2144
    @dhanyankooliyath2144 2 года назад +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
      @rows_columns  2 года назад +1

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

  • @raneesh_np
    @raneesh_np 4 года назад +2

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

  • @asharafmuhammed8269
    @asharafmuhammed8269 4 года назад +2

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

  • @bijoygeevarghese2304
    @bijoygeevarghese2304 3 года назад +2

    Very useful and informative. Thank you sir

  • @muralijyothy
    @muralijyothy 2 года назад +1

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

  • @askarabdulla387
    @askarabdulla387 4 года назад +3

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

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

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

  • @vishnusoman8532
    @vishnusoman8532 3 года назад +2

    Nice Work, Thank you

  • @vidyamr3359
    @vidyamr3359 4 года назад +1

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

  • @himasinto4112
    @himasinto4112 3 года назад +1

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

  • @mohammedsalimmuttoon3231
    @mohammedsalimmuttoon3231 2 года назад +1

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

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

    Great,as an accountant. Very useful

  • @salmanulfaris731
    @salmanulfaris731 3 года назад +1

    Very useful, Thanks

  • @cyriacjoseph13
    @cyriacjoseph13 4 года назад +1

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

    • @cyriacjoseph13
      @cyriacjoseph13 4 года назад +1

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

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

      Sure Brother😊 & Thanks for your feedback :)

  • @sajujoseph5651
    @sajujoseph5651 4 года назад +1

    Very very useful.. thank you so much

  • @ameerali8690
    @ameerali8690 2 года назад +1

    Thanks a tun bro.. for all your vedios

  • @sandrarajeev798
    @sandrarajeev798 2 года назад +1

    You are brilliant sir

  • @sajeerks1708
    @sajeerks1708 4 года назад

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

  • @techtravelbysameerkallai603
    @techtravelbysameerkallai603 4 года назад +1

    Nice tutorial.. good starting..
    best of luck

  • @akhilsreekalummakayaz
    @akhilsreekalummakayaz 2 года назад +1

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

  • @shruthimuralidharan1376
    @shruthimuralidharan1376 4 года назад +1

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

  • @slkkmr84
    @slkkmr84 8 месяцев назад

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

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

    Excellent video. Thank you

  • @shanilkumar7496
    @shanilkumar7496 3 года назад +1

    good information thanks for sharing

    • @rows_columns
      @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

  • @abdussalamputhupparambil6129
    @abdussalamputhupparambil6129 3 года назад +1

    Very helpful

  • @nihalamunaver6224
    @nihalamunaver6224 4 года назад +1

    Thnk you sir...very useful video

  • @SanthoshKumar-xd5ki
    @SanthoshKumar-xd5ki 3 года назад

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

  • @shamal.k1531
    @shamal.k1531 2 года назад +1

    Verry useful vedio.. dear

  • @Ashiqali-ji1wq
    @Ashiqali-ji1wq 3 года назад +1

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

  • @akshayp3554
    @akshayp3554 3 года назад +1

    Great... Thank uu

  • @nidheesh1558
    @nidheesh1558 4 года назад +1

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

  • @ashrafachu7239
    @ashrafachu7239 4 года назад +1

    Pwoli brother class അടിപൊളി aan

  • @drelbyclt
    @drelbyclt 3 года назад +1

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

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

      Already uploaded.. Pls check my playlist

  • @asif100100
    @asif100100 3 года назад +1

    Awesome man👍

  • @vipinb3198
    @vipinb3198 Год назад +1

    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

  • @nashidalfajar430
    @nashidalfajar430 3 года назад +1

    Good presentation

  • @leonsoncv9034
    @leonsoncv9034 3 года назад +1

    Thank you👍

  • @jinushsha
    @jinushsha 4 года назад

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

  • @manissery1956
    @manissery1956 2 года назад +1

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

    • @rows_columns
      @rows_columns  2 года назад +1

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

    • @manissery1956
      @manissery1956 2 года назад +1

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

    • @rows_columns
      @rows_columns  2 года назад +1

      @@manissery1956 Sure Haridas, Considered👍😊

  • @sameerthadathil8645
    @sameerthadathil8645 4 года назад

    Really helpful, Thanks brother

  • @sajispanicker5789
    @sajispanicker5789 2 года назад +1

    Excellent dear 👍

  • @faisalcpcp8281
    @faisalcpcp8281 4 года назад +1

    Thank you
    Subscribed 👍

  • @abdullatheefk2866
    @abdullatheefk2866 4 года назад

    Hai Mr. Alfan, it is really AMAZING. Thanks

  • @mohmedmansooor488
    @mohmedmansooor488 4 года назад +1

    Thank u alfan... ബായി

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

    Appreciable presentation

  • @archafarooq
    @archafarooq 4 года назад +1

    Good job✌️all the best

  • @habenick
    @habenick 4 года назад +1

    Good initiative alfan bhai

  • @sharemalayali5212
    @sharemalayali5212 3 года назад +1

    In Excel use in share trading purpose effectively

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

    Best presentation 👍

  • @sudheeshss9397
    @sudheeshss9397 4 года назад

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

  • @izzamariyabinu5050
    @izzamariyabinu5050 4 года назад +1

    Very useful bro

  • @deepakkareacode
    @deepakkareacode 4 года назад +1

    Nice.
    Really helpful ✌️✌️

  • @shiyasvk
    @shiyasvk 2 года назад +1

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

  • @nazimamman
    @nazimamman 4 года назад +1

    good job @alfan....👍

  • @shukoorvbr5251
    @shukoorvbr5251 4 года назад +2

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

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

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

  • @josephpatrick5381
    @josephpatrick5381 4 года назад +1

    Good presentation.

  • @nadirshakv
    @nadirshakv 4 года назад +1

    Great Job, keep going bro👍

  • @basheertrissure
    @basheertrissure 3 года назад +1

    you are superrrrrrrr

  • @adilrp
    @adilrp 4 года назад

    Very usefull. Keep going Bro👍

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

    Informative 🔥👍

  • @jennymaliyekal1565
    @jennymaliyekal1565 4 года назад +1

    Good information

  • @jabishalu
    @jabishalu 8 месяцев назад

    Thank you ❤

  • @angelgeorgeofcl
    @angelgeorgeofcl 2 года назад +1

    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
      @rows_columns  2 года назад +1

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

    • @angelgeorgeofcl
      @angelgeorgeofcl 2 года назад +1

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

    • @rows_columns
      @rows_columns  2 года назад +1

      Keep Learning & Keep Thriving😊

  • @dondavid333
    @dondavid333 4 года назад

    Good comprehension as per the caption.

  • @jessyjoseph4388
    @jessyjoseph4388 3 года назад +1

    THank you

  • @sajispanicker5789
    @sajispanicker5789 2 года назад

    Superbly

  • @mansoorthayancheery5030
    @mansoorthayancheery5030 4 года назад +4

    Great Job.May Allah will bless you dear.

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

    excellent presentation

  • @siyadfathah007abdulrahman8
    @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)

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

    Amazing bro

  • @dhanyankooliyath2144
    @dhanyankooliyath2144 2 года назад +1

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

    • @rows_columns
      @rows_columns  2 года назад +1

      100%.. (By using power query App)

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

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

  • @jijophilip5692
    @jijophilip5692 4 года назад

    Thank You.

  • @ckck8262
    @ckck8262 8 месяцев назад

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

  • @sebyanto772
    @sebyanto772 3 года назад +1

    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

  • @binshadkv6219
    @binshadkv6219 4 года назад +1

    Good 👍👍👍👍

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

    Power pivot videos cheyyamoo

  • @barbiedoll3711
    @barbiedoll3711 2 года назад

    കേരള എന്ന പേര് ഡാറ്റ ഷീറ്റിൽ രണ്ട് തവണ ആവർത്തിച്ചു വരികയും, അതിൽ വ്യത്യസ്ത തലസ്ഥാനങ്ങൾ രേഖപ്പെടുത്തിയിട്ടുമുണ്ടെങ്കിൽ, നമ്മൾ vlookup കൊടുത്തു കഴിഞ്ഞു സ്റ്റേറ്റ് കോളത്തിൽ കേരള സെലക്ട് ചെയ്താൽ രണ്ട് ഉത്തരങ്ങളും കാണിക്കുമോ?

  • @jobinmathew9958
    @jobinmathew9958 4 года назад +1

    Bro... Excel shot cuts video cheyyamo?

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

      Definitely Brotha😊

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

      As requested :) ruclips.net/video/waBSpmzGVGY/видео.html

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

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

  • @asyedafwan5923
    @asyedafwan5923 4 года назад +1

    Wonderful

  • @yoosufkdl
    @yoosufkdl 4 года назад +1

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

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

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

  • @FazinBinUmmer
    @FazinBinUmmer 3 года назад +1

    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.

  • @sajikrishnan3
    @sajikrishnan3 3 года назад +1

    super

    • @drpksukumarantrichur6613
      @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

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

    Great

  • @jayalakshmik576
    @jayalakshmik576 Год назад

    Excel too ,soo that I can practice.

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

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

  • @sreelalps7184
    @sreelalps7184 2 года назад

    GREAT SIR.COULD YOU SHARE THE EXCEL SHEET

  • @shanmon939
    @shanmon939 4 года назад

    Super bro

  • @79prasa
    @79prasa 2 года назад

    amazing

  • @capturakeepsyousmiling3068
    @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

  • @tinsyjohn
    @tinsyjohn 4 года назад +1

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

  • @fahadcheruvannur
    @fahadcheruvannur 4 года назад

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

  • @sajujoseph5651
    @sajujoseph5651 4 года назад +1

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

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

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

  • @Ashie.o0
    @Ashie.o0 2 месяца назад

    A loan emi reducing aahno atho flat rate scheme aahno

  • @Natty-l7r
    @Natty-l7r Год назад

    Does flashfill only works on table