Author Topic: Looking to learn quickbooks and excel. What do you recommend?  (Read 3006 times)

Adam Zapple

  • Bristles
  • ***
  • Posts: 473
My current career does not involve a whole lot of computer work outside some job-specific software.  What would be the best way to relearn Excel (I was good with it about 15 years ago) and to learn quickbooks?  Of course a free resource would be best but I would pay some dollar amount (TBD) if it meant a better learning experience.
« Last Edit: March 12, 2018, 01:03:31 PM by Mr. JL »

FIRE47

  • Bristles
  • ***
  • Posts: 350
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #1 on: March 12, 2018, 09:43:13 AM »
I'm just curious why you are interested?

Is it for a specific job?

With a bit of excel and bookkeeping and or tax knowledge there would be no shortage of medium skill/medium pay work available for side hustles. I am currently working as a CPA but when I hit FIRE/RE I plan on picking up some side work PT at $20-$30/ hour as an employee or $50/hour independent or part time contractor just doing low level tax prep and bookkeeping work to keep busy. I don't want to do the higher level stuff at that point once I'm done.

goalphish2002

  • Bristles
  • ***
  • Posts: 290
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #2 on: March 12, 2018, 09:59:16 AM »
I'm just curious why you are interested?

Is it for a specific job?

With a bit of excel and bookkeeping and or tax knowledge there would be no shortage of medium skill/medium pay work available for side hustles. I am currently working as a CPA but when I hit FIRE/RE I plan on picking up some side work PT at $20-$30/ hour as an employee or $50/hour independent or part time contractor just doing low level tax prep and bookkeeping work to keep busy. I don't want to do the higher level stuff at that point once I'm done.

I did tax one season about 3-4 years ago part-time (the guy I worked for was kind of shady so I stopped).  I am a cost engineer full time with a master's in accounting.  I do not have a CPA.  Can you advise on what to do to get into this for the long term?  I am not thinking about quitting my day job.  But, I know taxes will always be an option if I get more experience.

Adam Zapple

  • Bristles
  • ***
  • Posts: 473
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #3 on: March 12, 2018, 10:10:53 AM »
I'm just curious why you are interested?

Is it for a specific job?

With a bit of excel and bookkeeping and or tax knowledge there would be no shortage of medium skill/medium pay work available for side hustles. I am currently working as a CPA but when I hit FIRE/RE I plan on picking up some side work PT at $20-$30/ hour as an employee or $50/hour independent or part time contractor just doing low level tax prep and bookkeeping work to keep busy. I don't want to do the higher level stuff at that point once I'm done.

This is exactly what I am looking to do.  I'm looking for a side hustle for now and maybe a part time or seasonal gig in 5-10 years when I FIRE.  I would at least consider a complete career change between now and then but would like to dip my toes in first (my current gig is pretty good but I'm growing bored).  I have an interest in financial planning but would not be opposed to anything number crunching related since I enjoy that kind of thing anyway.

The other day I took a course at my local community college on estate planning and the professor pulled me aside after class and said her firm was hiring.  She asked me about my computer skills and was less than impressed with my response so I figure I should brush up. 

As a CPA, what would you look for if you were hiring an entry level candidate at your place of employment?

Jouer

  • Pencil Stache
  • ****
  • Posts: 500
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #4 on: March 12, 2018, 10:19:09 AM »
google/youtube search

There is a web tutorial for just about anything excel. This goes for almost any data software.

FIRE47

  • Bristles
  • ***
  • Posts: 350
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #5 on: March 12, 2018, 11:47:00 AM »
I'm just curious why you are interested?

Is it for a specific job?

With a bit of excel and bookkeeping and or tax knowledge there would be no shortage of medium skill/medium pay work available for side hustles. I am currently working as a CPA but when I hit FIRE/RE I plan on picking up some side work PT at $20-$30/ hour as an employee or $50/hour independent or part time contractor just doing low level tax prep and bookkeeping work to keep busy. I don't want to do the higher level stuff at that point once I'm done.

This is exactly what I am looking to do.  I'm looking for a side hustle for now and maybe a part time or seasonal gig in 5-10 years when I FIRE.  I would at least consider a complete career change between now and then but would like to dip my toes in first (my current gig is pretty good but I'm growing bored).  I have an interest in financial planning but would not be opposed to anything number crunching related since I enjoy that kind of thing anyway.

The other day I took a course at my local community college on estate planning and the professor pulled me aside after class and said her firm was hiring.  She asked me about my computer skills and was less than impressed with my response so I figure I should brush up. 

As a CPA, what would you look for if you were hiring an entry level candidate at your place of employment?

Well one thing I would mention is that unless it's for one specific employer that uses Quickbooks the other main accounting/bookkeeping software most small business use is Sage 50 (in Canada). In the US it might still be called Simply or Simply Accounting so I would most likely try to learn both.

As for an entry level candidate it would depend - there are basically 3 starting points in an accounting firm. Bookkeeper, Accounting technician and Staff Accountant. Keep in mind this is from a Canadian perspective based on a typical local public firm. I have worked at  Big 4 but for a side hustle I think this can safely be ignored, although their smaller regional offices work in much the same way in my experience.

Staff Accountant is basically someone who wants to earn their designation and has an accounting degree, unless you have significant prior experience from before the time that you needed a degree this one is probably ruled out without going back to school. It is probably the most thankless/ demanding and you will only earn barely more than the other roles year 1 and 2 and as a side hustle you can't advance, so there is no point in looking to do this as a part time gig.

An accounting technician is someone who doesn't have a university degree or the desire to earn a designation but wants to do more than basic bookkeeping and personal tax prep. They usually have 2-3 years of college (I guess this might be trade school in the US?) Or they came right out of high-school 15+ years ago.

A bookkeeper or on the tax side a basic preparer usually just has experience and some limited credential or courses behind them.

The easiest way to get into a firm in your case would be to earn some basic credentials of some kind through a community college, a bookkeeping certificate of some kind perhaps. 

I find a lot of firms simply don't advertise they are hiring even though there are multiple positions open at all times and they are drowning. Your best bet is to ask someone who works there, or to simply apply to multiple. The business is fairly seasonal so arrangements where a good employee only wants to work busy times of year are actually ideal and hard to come by.


From a small business perspective there is usually a shortage of bookkeepers/accounting technician types who give a crap and take pride in their work and lots of smaller companies are just looking to hire someone part-time. They are often only offering part-time hours and ~$20-$25 an hour so they can never find someone competent or that who will stick around. This leaves a niche to be filled if you are ok with this arrangement. The problem is that no business owner wants someone touching their books who has no experience.

Your best bet is to earn some type of basic credential, cut your teeth at a small local firm who will give you a chance and show you the ropes, then if you want to continue there you can or you can do part-time work for a few small businesses.

Alternatively you can volunteer to do the books for a small charity or not-for-profit and just leverage that experience to branch into paid work. Also speaking from experience the volunteer treasurer on these things is usually overloaded and would gladly train you if you wanted to learn. In my line of work I don't use quickbooks except pulling reports and sifting through it to examine what the internal accountant/bookeeper has done, but when I volunteered for a small board the treasurer taught me how to use quickbooks from a bookkeeping perspective.
« Last Edit: March 12, 2018, 12:29:16 PM by FIRE47 »

ketchup

  • Magnum Stache
  • ******
  • Posts: 4323
  • Age: 34
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #6 on: March 12, 2018, 12:26:48 PM »
1) Dick around for a few hours in the software.

2) Then pretend you're doing something practical in the software that's about 30% past your current knowledge.  Google searches will typically answer any concerns here.  If not, post on an enthusiast forum for the software.

3) Repeat steps 1, 2, and 3.

This approach has worked for me with just about any software, from MS Office to Photoshop to Lotus Fucking Notes.
« Last Edit: March 12, 2018, 12:28:45 PM by ketchup »

jlcnuke

  • Pencil Stache
  • ****
  • Posts: 931
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #7 on: March 12, 2018, 12:30:54 PM »

Adam Zapple

  • Bristles
  • ***
  • Posts: 473
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #8 on: March 12, 2018, 12:56:18 PM »
I am impressed with anyone who can self-teach through youtube or google.  Unfortunately, I am not one of those people.  I tend to start but then fizzle out or get distracted by other demands on my time. 

I do much better learning within a set structure and would like the piece of paper that comes with a completed course.  I am looking more for recommendations from someone who has used a specific online course for office products or accounting software, if that person exists on this forum. 

@FIRE47 your advice was extremely helpful.  Thank you for taking the time to spell that all out for me.  I live in the US but I'm sure most of your advice is just as relevant here.  I should mention that I already have a degree in business admin which will certainly help, although I have not put it to use in 15 years.  I think pairing that with an online or community college course, as you suggested, would make me a pretty good candidate for an entry level position.  Right now I am enjoying taking courses here and there and learning new things.  I'm excited to see where it leads. 

Jouer

  • Pencil Stache
  • ****
  • Posts: 500
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #9 on: March 12, 2018, 01:47:24 PM »
I am impressed with anyone who can self-teach through youtube or google.  Unfortunately, I am not one of those people.  I tend to start but then fizzle out or get distracted by other demands on my time. 

I do much better learning within a set structure and would like the piece of paper that comes with a completed course.  I am looking more for recommendations from someone who has used a specific online course for office products or accounting software, if that person exists on this forum. 

@FIRE47 your advice was extremely helpful.  Thank you for taking the time to spell that all out for me.  I live in the US but I'm sure most of your advice is just as relevant here.  I should mention that I already have a degree in business admin which will certainly help, although I have not put it to use in 15 years.  I think pairing that with an online or community college course, as you suggested, would make me a pretty good candidate for an entry level position.  Right now I am enjoying taking courses here and there and learning new things.  I'm excited to see where it leads.

Don't tell the bolded part to prospective employers. I don't know about in the accounting world but in the data science world it is expected that we can learn/master different software on our own. And it's a question we ask in interviews.

FIRE47

  • Bristles
  • ***
  • Posts: 350
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #10 on: March 12, 2018, 01:49:13 PM »
I am impressed with anyone who can self-teach through youtube or google.  Unfortunately, I am not one of those people.  I tend to start but then fizzle out or get distracted by other demands on my time. 

I do much better learning within a set structure and would like the piece of paper that comes with a completed course.  I am looking more for recommendations from someone who has used a specific online course for office products or accounting software, if that person exists on this forum. 

@FIRE47 your advice was extremely helpful.  Thank you for taking the time to spell that all out for me.  I live in the US but I'm sure most of your advice is just as relevant here.  I should mention that I already have a degree in business admin which will certainly help, although I have not put it to use in 15 years.  I think pairing that with an online or community college course, as you suggested, would make me a pretty good candidate for an entry level position.  Right now I am enjoying taking courses here and there and learning new things.  I'm excited to see where it leads.

Absolutely your degree will help as I'm sure it will include a couple of accounting courses. Also just having the business degree in general will help.

nemesis

  • Bristles
  • ***
  • Posts: 259
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #11 on: March 12, 2018, 01:52:20 PM »
I find it very difficult to learn in a vacuum.  Learning works best when you can apply the learning towards specific achievable goals.

I suggest you find a side hustle that will help you learn.  It doesn't even have to make much money. For example, volunteer to help with managing finances at a church, or a non-profit organization.  Learn how to help them keep the books, use excel to do things.  It will be more rewarding and a better way to learn, than in a vacuum.

FIRE47

  • Bristles
  • ***
  • Posts: 350
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #12 on: March 12, 2018, 01:58:55 PM »
I'm just curious why you are interested?

Is it for a specific job?

With a bit of excel and bookkeeping and or tax knowledge there would be no shortage of medium skill/medium pay work available for side hustles. I am currently working as a CPA but when I hit FIRE/RE I plan on picking up some side work PT at $20-$30/ hour as an employee or $50/hour independent or part time contractor just doing low level tax prep and bookkeeping work to keep busy. I don't want to do the higher level stuff at that point once I'm done.

I did tax one season about 3-4 years ago part-time (the guy I worked for was kind of shady so I stopped).  I am a cost engineer full time with a master's in accounting.  I do not have a CPA.  Can you advise on what to do to get into this for the long term?  I am not thinking about quitting my day job.  But, I know taxes will always be an option if I get more experience.

If you want to do it as a side hustle on your own or part time for a couple small businesses you have to know the nuts and bolts ground level stuff - bookkeeping, payroll, personal tax and basic corporate tax filing and your basic accounting concepts to put some statements together. No one will go to a side hustle type of an operation for the high-end stuff, nor will you have the qualifications to sign off on financial statements. You also don't want to deal with the risk of that type of work on your own anyways.

To be honest with all of the regulations in accounting now and the fact that it continues to grow more and more complex, not to mention the hassle of marketing, for me just helping a couple small businesses on the side or working part-time for a firm would be what I would do.


If you want to work part time at a firm your Master's in accounting would be a good start, but there may be an issue of being overqualified starting out with all of the 22 year old grads.

« Last Edit: March 12, 2018, 02:05:31 PM by FIRE47 »

Adam Zapple

  • Bristles
  • ***
  • Posts: 473
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #13 on: March 13, 2018, 09:22:31 AM »
I am impressed with anyone who can self-teach through youtube or google.  Unfortunately, I am not one of those people.  I tend to start but then fizzle out or get distracted by other demands on my time. 

I do much better learning within a set structure and would like the piece of paper that comes with a completed course.  I am looking more for recommendations from someone who has used a specific online course for office products or accounting software, if that person exists on this forum. 

@FIRE47 your advice was extremely helpful.  Thank you for taking the time to spell that all out for me.  I live in the US but I'm sure most of your advice is just as relevant here.  I should mention that I already have a degree in business admin which will certainly help, although I have not put it to use in 15 years.  I think pairing that with an online or community college course, as you suggested, would make me a pretty good candidate for an entry level position.  Right now I am enjoying taking courses here and there and learning new things.  I'm excited to see where it leads.

Don't tell the bolded part to prospective employers. I don't know about in the accounting world but in the data science world it is expected that we can learn/master different software on our own. And it's a question we ask in interviews.

Don't worry, I won't lead off with that on my resume :)

It's not that I can't do it, I just prefer a course that is already laid out for me since it will be a much more efficient way of learning.  I found several courses on Udemy.  They are all very highly rated and only 20 bucks.  Well worth it to me.  I'll report back.  If anyone has any other suggestions i.e. finance/accounting careers or side hustles, I'm all ears.  I'm just beginning my search.

mathlete

  • Handlebar Stache
  • *****
  • Posts: 2131
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #14 on: March 13, 2018, 09:40:26 AM »
YouTube and StackOverflow are great for Excel. But I say that as someone who learned by having projects to do with Excel literally all the time at work.

The Internet has pretty much all the answers you could ever need, but without something concrete to work on, you may not know which questions you should be asking. I can throw out a couple of tips though:

Basic:

1.) Make sure you're comfortable with the order of mathematical operations a.k.a. PEMDAS a.k.a. Parentheses, exponents, multiplication, division, addition, subtraction. If you get this mixed up, you'll find yourself with formulas that give you wrong/unexpected answers.

2.) If you ever find yourself thinking, "I wonder if there is an easy way to do this, this, and this..." the answer is almost always, "Yes."

3.) If your producing work for someone who likes to print hard copies on paper (ugh!), be sure to check out the "print-preview" of your work to make sure it looks as intended.

Intermediate:

3.) The Excel formulas VLOOKUP, HLOOKUP, and SUMIFS get used all the time. Watch some videos on what they are, what they do, and how they're used, and you should get an idea of how useful they are.

Advanced:

4.) If you want to improve the speed at which you work in Excel, I would suggest learning keyboard shortcuts. They are much much faster than mousing up to the ribbon at the top of the screen and clicking through various options. You can teach yourself these rather easily. Just hit the "ALT" key, and several letters will appear at the top of the screen. Hit the letter that corresponds with the

And I haven't even touched VBA yet!! But this post is probably way too scary and esoteric as it is.

catccc

  • Handlebar Stache
  • *****
  • Posts: 1919
  • Location: SE PA
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #15 on: March 13, 2018, 10:38:20 PM »
Just skimmed this, so apologies if this has already been mentioned... but maybe you can seek opportunities for continuing education with your current employer?  Maybe they have some sort of tuition reimbursement benefit?  You could also look into continuing ed classes from your state's CPA organization and take some classes.  I'm in PA and my employer covers my PICPA class pass (kind of like a season pass for CPE credits).  So once I have the pass, I can take up to 80 or 90 hours of classes (or webinars or self study courses), and it really doesn't even need to be super relevant to my job.

Rocketman

  • Stubble
  • **
  • Posts: 118
Re: Looking to learn quickbooks and excel. What do you recommend?
« Reply #16 on: March 14, 2018, 12:23:18 AM »
For excell set up some home spreadsheets;
Your balance sheet
Your investment report
Your monthly budget
Amortization schedule for all your outstanding loans
Re create your electric bill
Create a schedule for IRS personal tax tables.

Find what the payback is if you put solar on your roof.

Lots of good uses for excel

And make them nice and fancy - like you are giving them to your boss.
« Last Edit: March 14, 2018, 12:25:09 AM by Rocketman »