How to use the Macro Recorder in Excel - Malayalam Tutorial

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

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

  • @abinabraham140
    @abinabraham140 3 года назад +19

    Worth of watching, മലയാളത്തിൽ ഇത് പോലൊരു കണ്ടെന്റ് ഇത് ആദ്യം ആണ്...♥️

  • @arundineshkotta345
    @arundineshkotta345 3 года назад +16

    കമ്പ്യൂട്ടർ പഠിക്കുന്ന കാലത്ത് step by step ആയി എഴുതി വച്ച് പഠിക്കാൻ നോക്കിയിട്ട് കഴിയാത്ത കാര്യങ്ങളാണ് നിങ്ങളുടെ videos ൽ നിന്ന് പഠിക്കാൻ കഴിയുന്നത്. Thank you so much 🥰🥰

  • @surajshowkath3359
    @surajshowkath3359 4 года назад +5

    E lockdown samayath subscribe cheyth Kanaan pattiya ettavum nalla channel..very valuable informations..thank you sir..

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

    ഞാൻ ഗൾഫിൽ ജോലിചെയ്യുന്ന ആളാണ്
    തങ്ങളുടെ വീഡിയോസ് കണ്ടതുകൊണ്ട് എന്റെ ജോലിക് ഒരുപാട് സമയം സേവ് ചെയ്യാൻ പറ്റി food സൂപ്പർവൈസറിൽ പെട്ടെന്ന് dataanlysis ജോബിലേക് എന്നെ മാറ്റിയസമയത് ഞാൻ ആകെ ടെൻഷനിൽ ആയിരുന്നു പെരിന്തല്മണ്ണയിലിൽ നിന്നും വിശ്വനാഥൻ

  • @mohamedmishajk3266
    @mohamedmishajk3266 4 года назад +6

    You are a gift for those who tried to learn excel

  • @rajukdavis
    @rajukdavis 4 года назад +6

    Hats off to you. I always watch your excel study class which are remarkable. Very cool and brilliant explanations. Keep it up.

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

    Excellent. Thank you so much. Ee channel ippozhalley kandulloo ennathanu ente ettavum valiya sankadam.

  • @Rahulxplod1
    @Rahulxplod1 3 года назад +5

    Very informative lesson Sir, it would be great if you can explain more on Macros to make many tasks easier. The one explained in the video is very effective and worth learning.

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

      Glad to hear that. For more videos on Excel Macros check the videos section of this channel. Apart from that I have another RUclips channel (English) where I do videos on Advanced Excel lessons like Power Query, VBA Programming etc., You can find the link to that channel in the description of the videos.

  • @akshaym5922
    @akshaym5922 2 месяца назад

    Good narration 👍🏻

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

    ഇങ്ങള് പൊളിയാണ് മച്ചാനെ👍😁

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

    Wow.. well informative and helpful to my day to day excel work. Thank you

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

    വളരെ നന്നായിട്ടുണ്ട്.

  • @hethandbeatycare
    @hethandbeatycare 2 месяца назад

    Adipoli ❤❤❤❤ supr

  • @ahladandy431
    @ahladandy431 2 года назад +2

    Wow 💯% worth watching.Thank you sir

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

    Superb upto the point.. nothing less or more.. very good presentation

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

    Got a clear idea regarding macro. Thank you

  • @Falcon-if4cs
    @Falcon-if4cs 3 года назад +1

    Very helpful- thnks a lot.
    Click anywhere in data an Cntr key + * (to select full data)

  • @sisterscreations7113
    @sisterscreations7113 Месяц назад +1

    Macro recording use cheythu advanced filter cheyyunnathinte video cheyyamo sir

    • @XLnCADMalayalam
      @XLnCADMalayalam  Месяц назад

      Please check my video on Advanced Filter in Excel and try it yourself.
      ruclips.net/video/Z_F560-XVmQ/видео.html

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

    Well explained and excellent visual

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

    Informative

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

    Awesome

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

    Best trainer ♥️

  • @basheerk.h.7776
    @basheerk.h.7776 3 года назад +1

    Worth watching and very useful information 👍

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

    A very good information

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

    excellent explanation... thanks

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

    Helpful video. thanks and good explanation

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

    thanks for your helpful mentality.

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

    Worth watching

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

    Many thanks for sharing your knowledge to us .

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

    Very informative sir.

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

    Excellent expalnation

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

    Dear Sir
    very helpful
    thank you

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

    Hai.. Sir.... Macro cheyyumpo.. Subtotal add cheyyan pattunilla.. Cut ayii.. Pokunnuuu

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

    Nice sir 👍.

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

    Thank you 😊
    It's helped me a lot
    Keep making more videos

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

      Glad it helped.
      I hope you have gone through entire videos section.

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

    Very Good info and useful, thanks for the effort

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

    Sir very good lessons. My problem is if I want to copy formula with macros on excel sheet which will have different rows and different coloumns each time is it possible to set a macro

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

      നമുക്കിതു variable വെച്ച് കൊടുകാം. Excel vba യിൽ formula use ചെയാം. ഞാൻ automation series തുടങ്ങീട്ടുണ്ട്

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

    Super!

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

    Income tax calculators ൽ Enable Macro എന്ന option activate ചെയ്ത ശേഷമേ work ചെയ്യാനാവാറുള്ളൂ. അത് അവർ ഇത് പോലെ ആണോ ചെയ്യുന്നത്. അതോ കുറച്ചു കൂടെ Advanced ആയ Access ൽ ആണോ ?
    Income tax calculator excel ൽ develop ചെയ്യുന്നതെങ്ങനെ എന്ന് കാണിക്കുന്ന ഒരു വീഡിയോ ചെയ്തു തരുമെങ്കിൽ വല്യ ഉപകാരമായിരുന്നു .....❣️❣️🔥❣️❣️🔥❣️❣️🔥

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

    Superb sir...

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

    Nice video
    "How to edit or delete a previously made macro"
    ഇതും കൂടി ഒന്ന് കവർ ചെയ്യാവോ

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

      Go to developer, macros , select the macro u want to edit or delete

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

    Very good explanation

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

    Thank you

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

    ഇത്രയും കാലം എവിടെയായിരുന്നു സർ ... 😊??

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

    Allignment, column width എന്നൊക്കെ പോലെ, ഈ പ്രോഗ്രാമിൽ ഒരു സെല്ലിന് അകത്തുള്ള വാക്കുകൾ correction നടത്താൻ പറ്റുമോ...?

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

    Superb. I want to learn more

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

    Thanks for the video.

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

    Truly informative

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

    video yude koode file link koode thannoode

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

    Thank you sir,

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

    Kindly create a video for copy and paste in a different sheet if the date are match vba

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

    Thanks alot for this

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

    Super ❤️

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

    Very good

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

    very useful ..

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

    eniku course nu join cheyyan patunnillalo.
    udemy lu kaanikunillalo.

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

    Hi thanks for the video.
    9.14 - 9.26 a new information.
    It is still unknown for me why always open a blank excel sheet when I open a previously saved excel file. Hope you can help me on it.
    Tia

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

    Nice

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

    Super

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

    ee vidosil last kanikunna payroll paysilip printing vido link vidamo

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

    Vlookup also can be performed by using Macro ?

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

      Yes. Following is the syntax of VLOOKUP function in VBA
      Application.WorksheetFunction.VLOOKUP(lookup_value, table_array, column_index, range_lookup)

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

    Outlook pepole search chythu athu excel copy chyeyan macro use chythu pattumo

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

    How to create a data entry system with equations

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

    Does this work with merging cells?

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

    Sir, often i had to work with worksheet with more than 3 million raws. Such time excel seems struggling to perform it's functions like sort, filter, conditional format etc.
    Could you please tell, how can I manage with power query.

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

      Power Query as well as Power Pivot are designed to handle large datasets containing millions of records. Both of these features provides tools to Clean, Sort, and Filter data according to our requirements.
      To learn Power Query, I suggest 'M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query' by Ken Puls.

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

    Filter cheyyunnathinulla program parayumo

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

      There are many options like AutoFilter, Filter Function, Advanced Filter for filtering Data. Can you please explain the requirement with an example?

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

      Valiyoru data filter cheyyunna example

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

    Great

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

    Super sir

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

    great

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

    Helpful

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

    Sir, Can i run a macro in same header but different data

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

    How can we automate external applications/browsers using macro.
    ie, if I want to open youtube in chrome and after opening youtube i want to open xl n cad page, any more steps required than simply recording...?

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

      I assume you want to Hyperlink websites or webpages. If so, use Hyperlink function or Hyperlink feature for the same. I have done videos on both. Triggering actions using Macros is a different thing. If you looking for something like that you should refer the videos of Sumit Bansal or Leila Gharani on VBA for Excel

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

    Thank u

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

    hai
    how can i share macro excell sheet

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

    After running marco I have noticed that there is a change in number format in some colum. For example the original Date is 01/05/2021 But the excel is showing as 05/01/2021. Kindly help

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

    Ith namuk oru file le multiple sheetil matram use cheyyan pattukayollo vere file il work akille.....!!!! Enik run cheyyen nokkumbol nerathe cheyth vecha macro code kanunnilla run cheyyanum pattunnilla

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

      For reusing the Macro, you have to save the Excel Workbook as a Macro Enabled Workbook (.xlsm format).

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

    Sir Excel 2007 il macro work cheyumo

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

    I tried recording formatting a plot but it is not running always showing error. Can you show how to record macro of a plot.

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

      What do you mean by 'plot'?

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

      @@XLnCADMalayalam when I started the macro, i created a bar plot , then went on to change the colours, change legend names, add border and axis. Then stopped macro. When I executed it, it showed error and only bar plot without format appeared.

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

      Check the following solution.
      answers.microsoft.com/en-us/msoffice/forum/all/format-axis-font-in-vba/2fe979b0-1daa-415d-a550-c9e2c9d29fab

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

    സർ
    ഞാൻ freeze row, filters എന്നിവ ഉപയോഗിച്ചിരുന്നു
    Macro എക്സിക്യൂട്ട് ചെയ്‌തപ്പോ ശരിയായില്ല. എറർ vannu
    വാട്ട്‌ will be do

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

      To activate the Freeze Panes feature, you can use the following code.
      ActiveWindow.FreezePanes = True
      To turn off Freeze Panes, replace True with False.
      For better understanding, I suggest to check the 'VBA for Excel' Tutorials on my another channel. You can find the link in the description of this video.

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

    ഇത് ചെയ്ത് നോക്കാൻ ഇത് പോലെ ഉള്ള datas കിട്ടാൻ എന്ത് ചെയ്യണം

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

      More than 60 practice files (Excel Workbooks) are available with my online course on Excel. Check the description of the video for more details.

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

    👍👍👍

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

    👌✌️👍

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

    ഈ Entire Data select ചെയ്യാൻ Ctrl + *

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

    🙏

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

    Copy paste cheythaal pore

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

    ❤️❤️❤️

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

    Low sound

  • @arun.t.m4523
    @arun.t.m4523 4 года назад +1

    How to remove macro

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

      Save the file as .xlsx

    • @arun.t.m4523
      @arun.t.m4523 4 года назад

      @@XLnCADMalayalam ie save the file as normal excel format?

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

    🌹🌹🌹🌹🌹🙏🏻🙏🏻🙏🏻

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

    Thanks

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

    Super

  • @PremKumar-ci6cc
    @PremKumar-ci6cc 2 года назад

    Good

  • @YT-pg9oq
    @YT-pg9oq 2 года назад

    👍👍

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

    Thanks

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

    Thanks

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

    Super

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

    👍👍

  • @PremKumar-ci6cc
    @PremKumar-ci6cc 2 года назад

    👍👍👍