Author Topic: Learning VBA/Macros for excel  (Read 2385 times)

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7570
  • Total likes: 28
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Learning VBA/Macros for excel
« on: February 10, 2012, 12:54:24 AM »
I need to learn VBA for excel any opinions on best course/book/other?

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 30533
  • Total likes: 7829
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Learning VBA/Macros for excel
« Reply #1 on: February 10, 2012, 12:58:40 AM »
I need to learn VBA for excel any opinions on best course/book/other?

There are a lot of good resources online, e.g. Mr. Excel.

Edit: I'm referring to the message boards, I have no experience with their courses.
100% of Likes will be donated to support our brothers and sisters in Eretz Yisrael

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7570
  • Total likes: 28
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Learning VBA/Macros for excel
« Reply #2 on: February 10, 2012, 01:02:16 AM »
There are a lot of good resources online, e.g. Mr. Excel.
i was told by an actuarial recruiter that it will be much easier to get a job if i know vba slash can get certified in excel/vba. As well as also learning SAS. so here i am trying to figure out what best way to go about doing those two things are

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 30533
  • Total likes: 7829
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Learning VBA/Macros for excel
« Reply #3 on: February 10, 2012, 01:04:23 AM »
i was told by an actuarial recruiter that it will be much easier to get a job if i know vba slash can get certified in excel/vba. As well as also learning SAS. so here i am trying to figure out what best way to go about doing those two things are

I've never studied it from a book, but I learnt tons from the myriads of VBA code samples/snippets online.
100% of Likes will be donated to support our brothers and sisters in Eretz Yisrael

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7570
  • Total likes: 28
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Learning VBA/Macros for excel
« Reply #4 on: February 10, 2012, 01:05:01 AM »
I've never studied it from a book, but I learnt tons from the myriads of VBA code samples/snippets online.
im assuming you dont have any experience with SAS do u

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 30533
  • Total likes: 7829
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Learning VBA/Macros for excel
« Reply #5 on: February 10, 2012, 01:06:21 AM »
im assuming you dont have any experience with SAS do u

None at all, sorry. Though it does sound like it's right up my alley.

I do have experience with Crystal Reports, though I'm not sure how prevalent that is anymore.
100% of Likes will be donated to support our brothers and sisters in Eretz Yisrael

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7570
  • Total likes: 28
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Learning VBA/Macros for excel
« Reply #6 on: February 10, 2012, 09:18:30 AM »
also anyone have any experience getting certified in excel/VBA

Offline SuperFlyer

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2009
  • Posts: 9351
  • Total likes: 414
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Learning VBA/Macros for excel
« Reply #7 on: February 11, 2012, 02:32:10 PM »
I believe by a job, where such a knowledge is a plus, and you state that you know it, you wouldn't need a certificate.

Btw, quite a lot of degrees for PC's have only the papers value, but the actual knowledge can be minimal*. For your type of job, I believe that knowing vba would really help you, so just getting the 'paper' would be a waste.

*some of the microsoft degrees.

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 30533
  • Total likes: 7829
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: Learning VBA/Macros for excel
« Reply #8 on: February 11, 2012, 07:17:20 PM »
I believe by a job, where such a knowledge is a plus, and you state that you know it, you wouldn't need a certificate.

Btw, quite a lot of degrees for PC's have only the papers value, but the actual knowledge can be minimal*. For your type of job, I believe that knowing vba would really help you, so just getting the 'paper' would be a waste.

*some of the microsoft degrees.

Just getting the paper (without sufficient knowledge) would be a waste, but I'm sure Excel certification can have some value.
100% of Likes will be donated to support our brothers and sisters in Eretz Yisrael

Offline myb821

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Mar 2011
  • Posts: 7570
  • Total likes: 28
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: New York
Re: Learning VBA/Macros for excel
« Reply #9 on: February 11, 2012, 07:19:30 PM »
anyone know anything about SAS

Offline Flying Fish

  • Dansdeals Gold Elite
  • ***
  • Join Date: Jul 2011
  • Posts: 217
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Learning VBA/Macros for excel
« Reply #10 on: February 12, 2012, 01:40:25 AM »
I need to learn VBA for excel any opinions on best course/book/other?
Look into NYU SCPS.

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5060
  • Total likes: 20
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Learning VBA/Macros for excel
« Reply #11 on: February 13, 2012, 09:42:46 AM »
this reminds me. i never got around to finishing my spreadsheet  :)

Offline skyguy918

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 3810
  • Total likes: 826
  • DansDeals.com Hat Tips 1
  • Gender: Male
    • View Profile
  • Location: Queens, NY
Re: Learning VBA/Macros for excel
« Reply #12 on: February 13, 2012, 12:39:29 PM »
I don't know a single actuary that's actually certified. You need the skills, and I suppose it might help that you can prove you have the skills, but in reality I don't know anyone that's done it. As far as SAS, we don't use it where I work, so maybe I'm biased, but there are so many different software packages being used at different insurers or other employers of actuaries that it seems a waste to learn a specific one before you actually need it.

If the recruiter feels SAS is prevalent enough to be worth zeroing in on, and that some sort of VBA/Excel certification will be a serious asset, they obviously have a better feel for the market than I do, so go for it.

As far as learning VBA, don't go to crazy with book learning. Find something that has the basics, and a lot of examples of tasks for you to write macros for. For me the number one way to learn with any programming environment is to actually write and test code.

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2623
  • Total likes: 52
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Learning VBA/Macros for excel
« Reply #13 on: February 15, 2012, 04:37:16 PM »
perhaps try here http://office.microsoft.com/en-us/excel they have lots of video's