Microsoft Excel Macros - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Microsoft Excel Macros

£0.00 @
Hi, I want from your own experiences which is a good website to learn macros for excel for free. I know there are tons out there but wanted to know if someone has used one personally. Read More
adamnsu Avatar
8m, 2w agoPosted 8 months, 2 weeks ago
Hi,

I want from your own experiences which is a good website to learn macros for excel for free. I know there are tons out there but wanted to know if someone has used one personally.
Tags:
adamnsu Avatar
8m, 2w agoPosted 8 months, 2 weeks ago
Options

All Responses

(15) Jump to unreadPost an answer
Responses/page:
#1
Mr excel and google
#2
Record what you want to do, then view it in the code editor.

It's a great start to see how it works.
#3
adam_holcombe
Record what you want to do, then view it in the code editor.
It's a great start to see how it works.

I dont know the basics. not even record
#4
I use http://www.excel-easy.com/ and http://www.excelforum.com/

the first one teaches you the basics and goes into more advanced stuff such as VBA. The second website has a brilliant community who can help out with any excel problems. I use it a bit for the VBA side of excel.
#5
joe_edd
I use http://www.excel-easy.com/ and http://www.excelforum.com/
the first one teaches you the basics and goes into more advanced stuff such as VBA. The second website has a brilliant community who can help out with any excel problems. I use it a bit for the VBA side of excel.

Finally a proper answer. thanks alot that people like you are out there!
#6
the first answer was also a good one. Mr Excel forum was a real help to me when I was teaching myself VBA.
#7
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.

You'd probably be better off learning something like python to get the basics down then going from there.
#8
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
#9
moneybag
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
Python teaches you the basics in a strict but easy manner.
It's fair better documented then vba, more actively taught and far more expandable, powerful and widely used.

It's like saying why learn to drive and take your full driving test if you only want drive an automatic. It sets you up for the automatic and makes driving anything else in the future a lot easier
#10
joedastudd
moneybag
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
Python teaches you the basics in a strict but easy manner.
It's fair better documented then vba, more actively taught and far more expandable, powerful and widely used.

It's like saying why learn to drive and take your full driving test if you only want drive an automatic. It sets you up for the automatic and makes driving anything else in the future a lot easier


Is there a good website to learn Python?
#11
justanothercid
Mr excel and google


let me elaborate on my answer if you search Mr excel with what you want to do in excel it's a really helpful forum and better advice than you will get here... also if you type into Google what you would like to do like sort list or make cell value change colour you do get lots of answers but if you look most are from forums list on here. there is no popular method to learn excel other than attempting to use it and asking questions... there is also about 30 ways to change colours and formats you just find what is best for you... if you want to learn sql then look at sqlzoo that'd set up to teach in the way you want to learn excel.
#12
joedastudd
moneybag
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
Python teaches you the basics in a strict but easy manner.
It's fair better documented then vba, more actively taught and far more expandable, powerful and widely used.
It's like saying why learn to drive and take your full driving test if you only want drive an automatic. It sets you up for the automatic and makes driving anything else in the future a lot easier
The point of the question was directly related to doing things in Excel though, so where does python come in use for Excel? I could understand your point if the question was "I want to get started in programming, what's the best language for beginners."
#13
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.

i want to learn macros in excel to get data into a particular format with a click of a button
#14
sydney871
joedastudd
moneybag
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
Python teaches you the basics in a strict but easy manner.
It's fair better documented then vba, more actively taught and far more expandable, powerful and widely used.
It's like saying why learn to drive and take your full driving test if you only want drive an automatic. It sets you up for the automatic and makes driving anything else in the future a lot easier
Is there a good website to learn Python?
probably
https://www.codecademy.com
Good little courses for quite a few different languages.


moneybag
joedastudd
moneybag
joedastudd
What exactly do you want to learn macros for?
Excel macros are based off vbscript which has limited use for most modern things.
You'd probably be better off learning something like python to get the basics down then going from there.
What's the point of learning python for someone interesed in Excel?
Python teaches you the basics in a strict but easy manner.
It's fair better documented then vba, more actively taught and far more expandable, powerful and widely used.
It's like saying why learn to drive and take your full driving test if you only want drive an automatic. It sets you up for the automatic and makes driving anything else in the future a lot easier
The point of the question was directly related to doing things in Excel though, so where does python come in use for Excel? I could understand your point if the question was "I want to get started in programming, what's the best language for beginners."
The loop and logic patterns are very similar.
Vba in my experience is a horrible language to learn; the documentation is terrible and for even basic things you end up looking on user forums for solutions.

Sure if your just making macros in excel and never plan on taking coding/programming any farther then spend time learning vba and the excel specifics to it otherwise learning something like python will offer a lot of transferable knowledge for your excel and good basis for other languages.

I was taught vba in school as part of it and it really put me off programming, stumbled upon lua on the PSP then pretty much fell in love with programming.
I mean the the likes of the raspberry pi (the pi is literally for python) pushing it forwards I really would at least tell anyone to dabble in the likes of python before getting frustrated with vba and thinking all languages are like it.
#15
PS: I also want to read already created macros as well too. I merely want it for work to make data trimming.My work involves downloading data regularly, but getting them into a usable format requires some time.

I really appreciate all the useful comments and suggestion.

Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!