Groups

    Microsoft Excel Macros

    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.

    15 Comments

    Mr excel and google

    Record what you want to do, then view it in the code editor.

    It's a great start to see how it works.

    Original Poster

    adam_holcombe

    Record what you want to do, then view it in the code editor. It's a great … 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

    I use excel-easy.com/ and 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.

    Original Poster

    joe_edd

    I use http://www.excel-easy.com/ and http://www.excelforum.com/the first … 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!

    the first answer was also a good one. Mr Excel forum was a real help to me when I was teaching myself VBA.

    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.

    joedastudd

    What exactly do you want to learn macros for?Excel macros are based off … 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?

    moneybag

    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

    joedastudd

    Python teaches you the basics in a strict but easy manner.It's fair … 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?

    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.

    joedastudd

    Python teaches you the basics in a strict but easy manner.It's fair … 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."

    Original Poster

    joedastudd

    What exactly do you want to learn macros for?Excel macros are based off … 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

    sydney871

    Is there a good website to learn Python?

    probably
    codecademy.com
    Good little courses for quite a few different languages.


    moneybag

    The point of the question was directly related to doing things in Excel … 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.

    Original Poster

    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 a comment
    Avatar
    @
      Text
      Top Discussions
      1. love affairs1649
      2. The obvious next step become Ken then become Barbie1525
      3. Important info for Ryanair customers1825
      4. word association Game73944491

      See more discussions