+ Reply to Thread
Results 1 to 17 of 17

Excel enthusiast want to turn it into a career

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    0

    Excel enthusiast want to turn it into a career

    Hey Everyone,

    I've been using excel for the last decade and have gotten VERY good with it as opposed to my peers. I want to know if anyone has had success turning this skill into a career as opposed to the office excel guru. Thoughts welcome.

    Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: Excel enthusiast want to turn it into a career

    What's your definition of "VERY good at it"? What sort of things can you/ do you do?

    Short answer: yes, it's possible to make a career out of it.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-15-2014
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    0

    Re: Excel enthusiast want to turn it into a career

    I'm pretty good at extracting information with commands like vlookup, small, indirect, rows, count, sumifs, countifs, etc... extracting useful information from a thread is fairly simple and taking information from a bunch of sources and putting it together is equally easy.

    Conditional formatting, debugging, and all of the usual suspects like cell formatting and sorting data are easy as well. I have a pretty good grasp on array formulas.

    I recently took every worker in my company and devised a time sheet which all feed together into a master time sheet which can be uploaded into quickbooks.

    I look at the guys on Mr. Excel on youtube and I'm not near as good as him, but I'm a lot better than the average Joe. I'm not sure if this answers your question.

    Thanks for responding.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: Excel enthusiast want to turn it into a career

    I guess you have to ask yourself if "I'm a lot better than the average Joe" is good enough?

    What are your weak spots? You don't mention Tables, Charts, Pivot Tables, VBA. Can you, and do you, answer questions on any forum?

    And then ask yourself how confident you are about talking to a client, discussing and understanding their requirement, and then converting that requirement into a stable, robust and aesthetically pleasing spreadsheet solution? Documenting it and handing it over for them to take as their own, love it, cherish it, care for it and improve it?

    And the other things to think about from a business perspective are: where you will get your customers, promoting (advertising) yourself, tax, public liability insurance, business banking charges, etc.

    Got to say, moving from enthusiastic amateur to professional can knock a lot of enthusiasm out of you

    For what it's worth, I took voluntary redundancy from a Bank, a couple of years before I was due to retire and then decided to set up as a consultant. Spent a lot of time answering questions on the forum and, so far, got three customers through the forum. Others have come from a business networking club and one from the wife of a long term friend. My first customer, who contacted me through the forum, effectively funded the business set up costs ... and I'm still working with him 18 months later

    Regards, and good luck if you decide to go with it.


    Regards, TMS

  5. #5
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Excel enthusiast want to turn it into a career

    I guess it also depends on what you mean by "professional"....My current "Title" is Inventory Analyst, but I'm really a data miner....I say it like that because I use different "mines" for my data. We use JDE for out Business controls, so I'm mining in Oracle/SQL. We have local or corporate Access DB's and a multitude of other mines. And I consider the internet(Dogpile) and this forum mines, because sometimes I need to mine data out of here ( I don't know everything)....I use excel for just about everything I send out to customers (internal/external). I'm considered the subject matter expert for Microsoft Office on my site. This is my profession, previously I was an IT Manager,Network Engineer, DB Admin, SysAdmin...I think people can make a great living at using excel without being a consultant....that would not be my cup to tea...but TMShucks did a great job of reminding us what is involved in starting/creating/running a business...HTH
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: Excel enthusiast want to turn it into a career

    I was interpreting this, maybe wrongly:
    success turning this skill into a career as opposed to the office excel guru
    I guess I thought there was a desire to move out ... but maybe move out to another employer with a career/role change.


    Regards, TMS

  7. #7
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Excel enthusiast want to turn it into a career

    I see that also...just giving a different perspective....from my perspective I don't see that they need to different....as I re-read the OP I definitely see your point...I can also see that being an office guru in a small company vs a large company is a difference also....thanks for the thoughts....

  8. #8
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Excel enthusiast want to turn it into a career

    I'd love to be a self employed Excel consultant. There are several issues for me to overcome though:

    - Most companies don't realise the need. Excel is a ubiquitous office tool, most people don't really understand the power / opportunity it has, or appreciate the value of enhancing Excel solutions and / or training.
    - As good as I like to think I am with Excel, there are LOADS who are far better. It only takes 15 minutes on this forum to see guys who make it look REALLY easy. It's a humbling experience, at times. The flip side of this one, though, is when some of these guys recognize my solutions as being valuable, then that's a real measure of competence, to me.
    - Excel skills alone are not enough. There are many other essential business skills involved in being an independent consultant (in any arena), particularly communication and marketing. I rather suspect the pipe dream of sitting doing cool Excel stuff all day every day never quite pans out that way, and much time is consumed in marketing, negotiating, politicking... etc.

    I have been fortunate enough to have a few small commissioned Excel jobs recently. Not enough to consider reliable income, but certainly enough to cover some beers, and keep me persuaded that doing Excel stuff at 9pm on a Friday evening is cooler than watching telly

    I guess my game plan is to stick on this forum as much as I can, and when I can reliably and accurately answer the majority of queries posted, then I'll consider myself pretty competent. I learn from here daily.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel enthusiast want to turn it into a career

    Beer and Cigarettes? That's substantial
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  10. #10
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Excel enthusiast want to turn it into a career

    Quote Originally Posted by xladept View Post
    Beer and Cigarettes? That's substantial
    I quit the smokes 7 months ago! =proud()

  11. #11
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,467

    Re: Excel enthusiast want to turn it into a career

    @OllyXLS: agree with everything you said. I might have said this before, but I have no expectations of becoming a millionaire any time soon ... but the income is very much worth having.

  12. #12
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel enthusiast want to turn it into a career

    @Olly - quitting is easy - I've quit a million times

    Seriously, I've just dealt with the Open as Read Only nuisance and hope to get a gig from it
    Last edited by xladept; 01-17-2014 at 06:32 PM.

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Excel enthusiast want to turn it into a career

    Quote Originally Posted by OllyXLS View Post
    I quit the smokes 7 months ago! =proud()
    Congrats, keep it up!!! I quit a little over a year ago =alsoproud(). Just remember its easier to stay quitted than to re-quit

    To add my 2 cents worth to this discussion though. I thought I was good at excel, and was also considered the falcility guru where I worked before (and still am where I work now) Then I joined this forum and saw what a real expert/guru looked like (and I dont just mean member titles)

    Formula-wise I have grown in leaps and bounds, but still have miles to go
    VBA-wise, I have maybe just let my pinky-toe look at the water, but have not yet let it get wet

    It has been said many times, by many of the real experts here, that you cannot know it all when it comes to excel, there is always something to learn - thats what keeps it so fresh and adictive
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  14. #14
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel enthusiast want to turn it into a career

    Sure, you can make a career out of excel.

    If you decide to try it out these are some of the folks you'll be competing with for the business:

    Bob Phillips
    Chip Pearson
    Bill Jelen
    Ron De Bruin
    Jon Peltier
    Jan Karel Pieterse
    Andy Pope
    Charley Kyd

    I myself have even considered this but in reality I'm not good enough. I'm good in some aspects of Excel but lacking in others. What I'm good at (formulas) may not be enough to sustain a "consultant" career.

    I've considered writing a book or putting together a database of example formulas. I have literally 1000's of examples. I have no idea how one goes about getting a book published!

    My background in Excel started in the early 80's working as a chemistry lab technician. We used spreadsheets extensively and this is where I learned most of what I know about Excel through trial and (lots) of error!
    Last edited by Tony Valko; 01-17-2014 at 09:56 PM.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  15. #15
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Excel enthusiast want to turn it into a career

    @Tony - Check out CreateSpace - it's easy to publish a book there (but I've only sold seven since April 2012) - but the whole thing cost me less than $300.

  16. #16
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Excel enthusiast want to turn it into a career

    @xladept...

    Thanks, I'll check that out.

  17. #17
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel enthusiast want to turn it into a career

    Quote Originally Posted by Tony Valko View Post
    If you decide to try it out these are some of the folks you'll be competing with for the business:

    Bob Phillips
    Chip Pearson
    Bill Jelen
    Ron De Bruin
    Jon Peltier
    Jan Karel Pieterse
    Andy Pope
    Charley Kyd
    I think unless you decide to start out by targeting Fortune 500 type companies, you're unlikely to be competing with most of those guys!

    There are an awful lot of Excel consultant/specialists out there who are, in my opinion, distinctly average at best so if you're aiming at SME clients, I'm pretty sure there's a market - the only issue is getting yourself known to them.

    For enterprises (largely excluding banking), I'm always amazed that none of them seem to really make the connection between that fact that almost all their numbers come through Excel at some point, and the need for good Excel developers, or even users. The level of Excel knowledge and lack of real training at pretty much every company I've ever been in is quite startling. So I think that, in addition to offering consulting, offering training services might be a good idea.

    Just my tuppence worth.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel enthusiast
    By ExcelDominator in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-27-2013, 01:40 PM
  2. Excel enthusiast
    By k4nch1 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2013, 07:24 PM
  3. Excel enthusiast
    By Diezel10 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-09-2012, 07:17 PM
  4. excel enthusiast
    By excelvba123 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 05-05-2012, 03:09 AM
  5. Replies: 0
    Last Post: 09-06-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1