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

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

@XLnCADMalayalam

3 жыл бұрын

Glad to hear that and Thanks :)

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

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

@XLnCADMalayalam

4 жыл бұрын

That's an awesome compliment.

Dear Sir very helpful thank you

excellent explanation... thanks

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

Best trainer ♥️

You are a gift for those who tried to learn excel

@XLnCADMalayalam

3 жыл бұрын

That's an awesome compliment.

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

@XLnCADMalayalam

3 жыл бұрын

Thanks a ton

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

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

Informative

Many thanks for sharing your knowledge to us .

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

Does this work with merging cells?

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

@XLnCADMalayalam

3 жыл бұрын

My pleasure :)

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

Got a clear idea regarding macro. Thank you

@XLnCADMalayalam

2 жыл бұрын

Glad it was helpful! :)

Wow 💯% worth watching.Thank you sir

@XLnCADMalayalam

2 жыл бұрын

Glad you liked it😀

Helpful video. thanks and good explanation

@XLnCADMalayalam

3 жыл бұрын

So nice of you

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

Worth watching and very useful information 👍

@XLnCADMalayalam

2 жыл бұрын

Glad you think so!

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

@harishnair7871

2 жыл бұрын

very correct and aptly put !.

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

@XLnCADMalayalam

3 жыл бұрын

Great tip!

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

@XLnCADMalayalam

3 жыл бұрын

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

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

2 жыл бұрын

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

thanks for your helpful mentality.

@XLnCADMalayalam

2 жыл бұрын

My pleasure

Awesome

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Very Good info and useful, thanks for the effort

@XLnCADMalayalam

3 жыл бұрын

Glad it was helpful!

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

Thanks for the video.

@XLnCADMalayalam

4 жыл бұрын

You are welcome!

Thanks

ee vidosil last kanikunna payroll paysilip printing vido link vidamo

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

Great

Super

Truly informative

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

hai how can i share macro excell sheet

Well explained and excellent visual

@XLnCADMalayalam

2 жыл бұрын

Glad to hear that. Thank you :)

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

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

3 жыл бұрын

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

A very good information

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Very informative sir.

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

How to create a data entry system with equations

Thanks alot for this

@XLnCADMalayalam

3 жыл бұрын

My pleasure

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

Worth watching

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Superb. I want to learn more

@XLnCADMalayalam

3 жыл бұрын

Keep watching

Good

Thank you sir,

@XLnCADMalayalam

2 жыл бұрын

Most welcome

eniku course nu join cheyyan patunnillalo. udemy lu kaanikunillalo.

Thank you

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

very useful ..

@XLnCADMalayalam

3 жыл бұрын

Glad to hear that

Super!

@XLnCADMalayalam

2 жыл бұрын

Thank you! Cheers!

Superb sir...

@XLnCADMalayalam

3 жыл бұрын

Thanks a ton

Nice sir 👍.

@XLnCADMalayalam

Жыл бұрын

Thank you 😀

👌✌️👍

Excellent expalnation

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

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

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

Very good

@XLnCADMalayalam

3 жыл бұрын

Thank you

Super ❤️

@XLnCADMalayalam

Жыл бұрын

Glad to hear that 😀

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

2 жыл бұрын

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.

Thank u

@XLnCADMalayalam

4 жыл бұрын

My pleasure.

Helpful

@XLnCADMalayalam

3 жыл бұрын

Glad to hear that.

👍👍

🙏

👍👍👍

Super sir

@XLnCADMalayalam

3 жыл бұрын

Thank you

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

@XLnCADMalayalam

3 жыл бұрын

Can you please explain with an example

Very good explanation

@XLnCADMalayalam

3 жыл бұрын

Thanks and welcome

@leonsoncv9034

3 жыл бұрын

Sir can we use the find option in Excel

great

@XLnCADMalayalam

2 жыл бұрын

Thank you :)

Vlookup also can be performed by using Macro ?

@XLnCADMalayalam

2 жыл бұрын

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

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

video yude koode file link koode thannoode

Nice

@XLnCADMalayalam

9 ай бұрын

Thank you😀

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).

Sir Excel 2007 il macro work cheyumo

@XLnCADMalayalam

3 жыл бұрын

Yes.

Filter cheyyunnathinulla program parayumo

@XLnCADMalayalam

3 жыл бұрын

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

@krishnankuttyr2993

3 жыл бұрын

Valiyoru data filter cheyyunna example

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

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

❤️❤️❤️

@XLnCADMalayalam

2 жыл бұрын

😀

🌹🌹🌹🌹🌹🙏🏻🙏🏻🙏🏻

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

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

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

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

Low sound

How to remove macro

@XLnCADMalayalam

3 жыл бұрын

Save the file as .xlsx

@arun.t.m4523

3 жыл бұрын

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

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

ഇത് ചെയ്ത് നോക്കാൻ ഇത് പോലെ ഉള്ള 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.

Copy paste cheythaal pore

Super

Thanks

@XLnCADMalayalam

2 жыл бұрын

My pleasure :)

👍👍

👍👍👍

Thanks

@XLnCADMalayalam

3 жыл бұрын

Hope are you making use of it :)

Super

@XLnCADMalayalam

3 жыл бұрын

Thank you. Cheers!