How to use the Macro Recorder in Excel - Malayalam Tutorial

എക്സലിലെ മാക്രോ റെക്കോർഡർ ഉപയോഗിച്ച് ഒരു മാക്രോ (Macro) അഥവാ പ്രോഗ്രാം തയ്യാറാക്കുന്നതെങ്ങനെ എന്ന് വിശദീകരിക്കുന്ന വീഡിയോ.
How to create a Macro using the Macro Recorder of Excel is explained in this video.
മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/...
Subscribe to the channel ‪@AjayAnandXLnCAD‬ for more.
/ ajayanandxlncad
Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ...
www.udemy.com/...
#ExcelMalayalam #MSOfficeMalayalam #MalayalamTutorial

[@arundineshkotta345]

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

[@abinabraham140]

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

[@XLnCADMalayalam]

Glad to hear that and Thanks :)

[@surajshowkath3359]

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

[@XLnCADMalayalam]

That's an awesome compliment.

[@mohamedmishajk3266]

You are a gift for those who tried to learn excel

[@XLnCADMalayalam]

That's an awesome compliment.

[@musthafamb1757]

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

[@XLnCADMalayalam]

My pleasure :)

[@vishwanpalliyalil]

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

[@rajukdavis]

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

[@XLnCADMalayalam]

Thanks a ton

[@hethandbeatycare]

Adipoli ❤❤❤❤ supr

[@akshaym5922]

Good narration 👍🏻

[@roopeshmadhavan2170]

A very good information

[@XLnCADMalayalam]

Thank you :)

[@latheeshkakkur6943]

Worth watching

[@XLnCADMalayalam]

Thank you :)

[@ahladandy431]

Wow 💯% worth watching.Thank you sir

[@XLnCADMalayalam]

Glad you liked it😀

[@Rasheedtu]

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

[@Binusdas]

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

[@XLnCADMalayalam]

My pleasure :)

[@Rahulxplod1]

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]

Glad to hear that. For more videos on Excel Macros check the videos section of this channel. Apart from that I have another KZbin 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.

[@varunsumithran4841]

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

[@harishnair7871]

very correct and aptly put !.

[@jklv4842]

Got a clear idea regarding macro. Thank you

[@XLnCADMalayalam]

Glad it was helpful! :)

[@roopeshmadhavan2170]

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

[@prathapmv2777]

Nice sir 👍.

[@XLnCADMalayalam]

Thank you 😀

[@pavithranpallavi]

Awesome

[@XLnCADMalayalam]

Thank you :)

[@raghukumarputhanveetil3529]

Well explained and excellent visual

[@XLnCADMalayalam]

Glad to hear that. Thank you :)

[@ShibuGeorgeMac]

Super!

[@XLnCADMalayalam]

Thank you! Cheers!

[@krishnaprasad6502]

Best trainer ♥️

[@Falcon-if4cs]

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

[@XLnCADMalayalam]

Great tip!

[@sajisajinaganraju3763]

thanks for your helpful mentality.

[@XLnCADMalayalam]

My pleasure

[@arunnd7401]

Super ❤️

[@XLnCADMalayalam]

Glad to hear that 😀

[@basheerk.h.7776]

Worth watching and very useful information 👍

[@XLnCADMalayalam]

Glad you think so!

[@indurajeev8865]

Helpful video. thanks and good explanation

[@XLnCADMalayalam]

So nice of you

[@anilnair8370]

Informative

[@sreelumenon3487]

Very informative sir.

[@XLnCADMalayalam]

Thank you :)

[@sanilkumar2375]

excellent explanation... thanks

[@renjudas5482]

Many thanks for sharing your knowledge to us .

[@XLnCADMalayalam]

My pleasure :)

[@adheevidhu8477]

Superb sir...

[@XLnCADMalayalam]

Thanks a ton

[@jinumathewjose2358]

Dear Sir very helpful thank you

[@shakigct2001]

Excellent expalnation

[@XLnCADMalayalam]

Thank you :)

[@smilewithpets]

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

[@XLnCADMalayalam]

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

[@abdulkalammampad8654]

Thanks

[@XLnCADMalayalam]

My pleasure :)

[@gokul152]

Super

[@XLnCADMalayalam]

Thank you. Cheers!

[@AromalAnish]

Very Good info and useful, thanks for the effort

[@XLnCADMalayalam]

Glad it was helpful!

[@hussaina2100]

great

[@XLnCADMalayalam]

Thank you :)

[@sisterscreations7113]

Macro recording use cheythu advanced filter cheyyunnathinte video cheyyamo sir

[@XLnCADMalayalam]

Please check my video on Advanced Filter in Excel and try it yourself. kzbin.info/www/bejne/kJCpZmlmYr2Jo7M

[@ajaykumar6152]

Nice

[@XLnCADMalayalam]

Thank you😀

[@robinroy5991]

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

[@siddiqptb]

Truly informative

[@XLnCADMalayalam]

Thank you :)

[@joseCA]

Thanks for the video.

[@XLnCADMalayalam]

You are welcome!

[@rajeeshk8139]

Thank you sir,

[@XLnCADMalayalam]

Most welcome

[@leonsoncv9034]

Very good explanation

[@XLnCADMalayalam]

Thanks and welcome

[@leonsoncv9034]

Sir can we use the find option in Excel

[@sruthiskumar8372]

Thanks alot for this

[@XLnCADMalayalam]

My pleasure

[@itsmystyleonline]

Great

[@Demonoflaplace]

Superb. I want to learn more

[@XLnCADMalayalam]

Keep watching

[@sharafuthayyil7568]

very useful ..

[@XLnCADMalayalam]

Glad to hear that

[@farookthangalthangal5217]

Very good

[@XLnCADMalayalam]

Thank you

[@mammaliaagrofarm9179]

video yude koode file link koode thannoode

[@shejimonpb2967]

Super sir

[@XLnCADMalayalam]

Thank you

[@dudeyme3331]

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

[@NEXTEXACADEMY4education]

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

[@cyriacalexander001]

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

[@ajas8749]

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

[@janeeshpv439]

Helpful

[@XLnCADMalayalam]

Glad to hear that.

[@sankaranarayanan7773]

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]

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

[@Cshibu216]

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

[@maheshmurukkuzhi4076]

How to create a data entry system with equations

[@hawwabi279]

Thank u

[@XLnCADMalayalam]

My pleasure.

[@krishnankuttyr2993]

Filter cheyyunnathinulla program parayumo

[@XLnCADMalayalam]

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

[@krishnankuttyr2993]

Valiyoru data filter cheyyunna example

[@nimithanazar7175]

eniku course nu join cheyyan patunnillalo. udemy lu kaanikunillalo.

[@thanveermohammed]

👌✌️👍

[@visakhpu4515]

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]

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

[@sunilkumarak5793]

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

[@jayakrishnanr1785]

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

[@girishmohanan10]

Vlookup also can be performed by using Macro ?

[@XLnCADMalayalam]

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

[@rahmathasleem2913]

ee vidosil last kanikunna payroll paysilip printing vido link vidamo

[@omarzamankp6662]

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

[@sudheerumbayi8997]

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

[@Prasanthambali]

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]

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.

[@neethu7168]

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

[@XLnCADMalayalam]

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

[@Bossvlogs38]

hai how can i share macro excell sheet

[@Soujyam]

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]

What do you mean by 'plot'?

[@Soujyam]

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

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

[@sajadabbas]

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

[@princedavis2]

👍👍

[@rays49]

Does this work with merging cells?

[@vipinlal2948]

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

[@XLnCADMalayalam]

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.

[@praveenkumartirur6634]

Sir Excel 2007 il macro work cheyumo

[@XLnCADMalayalam]

Yes.

[@abinabraham140]

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]

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

[@sivedas]

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

[@XLnCADMalayalam]

Can you please explain with an example

[@JoseKurisinkal]

Low sound

[@ajmalkm1475]

Copy paste cheythaal pore

[@abdulsavad5665]

❤️❤️❤️

[@XLnCADMalayalam]

😀

[@aadilmohammed9495]

🙏

[@arun.t.m4523]

How to remove macro

[@XLnCADMalayalam]

Save the file as .xlsx

[@arun.t.m4523]

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

[@tvsomasekharan6648]

🌹🌹🌹🌹🌹🙏🏻🙏🏻🙏🏻

[@sreedharans4940]

Thanks

[@shaijaljanish4776]

Super

[@PremKumar-ci6cc]

Good

[@YT-pg9oq]

👍👍

[@sobithacps1822]

Super

[@Abdulgaffoor343]

Thank you

[@XLnCADMalayalam]

My pleasure :)

[@deepuvlm6351]

Thanks

[@XLnCADMalayalam]

Hope are you making use of it :)

[@shihabkallingal861]

👍👍👍

[@PremKumar-ci6cc]

👍👍👍