• Excel Consulting Services

    The only thing that can't be automated in Excel is the input of raw data... and even that can sometimes be done. If you are looking to avoid repetitive tasks in your Excel spreadsheet (clearing out data to start a new month, manually incrementing dates, copy your data to historical tables, etc...) you should know that it's more than just possible!

    There are a wide variety of Excel gurus and specialists out there that you should seriously think about hiring.

    Why should I hire an Excel consultant?

    • Do you perform repetitive tasks in Excel? Some examples may include:
      • Clearing out worksheet cells to re-use your worksheets
      • Putting in you own name every time you open your workbook
      • Copying current data to historical columns
      • Saving a backup every month under a different filename
    • If you share your workbooks with others, do they constantly come back broken?
      • Formulas missing or overwritten?
      • People inserting rows where they shouldn't?
      • Invalid data in cells? (text in numerical fields, etc...)
    • Do you use your Excel information to do tasks in other Microsoft Office programs?
      • Mailing labels in Word?
      • Billing letters in Word?
      • Charts in Powerpoint?
      • Emails through Outlook?
    • Do you use your data to look up information elsewhere?
    • Do you want to do in depth data analysis, but find yourself without either the time or expertise?
    • Do you just plain want to learn more about the power of Microsoft Excel?

    If you answered "Yes" to ANY of the questions above, you should consider hiring your very own Excel guru. Not only do you get their expertise, but you get their passion for all things Excel!

    Of course, there is much more to Excel than automation, and much more that needs to be covered to truly meet the needs of all Excel users. Whether you need help building an add-in, fixing a broken workbook, redesigning workbooks for efficiency, or building an great looking Excel dashboard report, there is a consultant out there who can handle the task. The big questions, of course, are "how much will it cost" and "how do you find a reliable consultant?"

    How much do you spend on repetitive tasks?"

    Consulting appears expensive at first glance, so you need to work out the estimated payback before you pursue someone for your project. To help with this I've designed a spreadsheet to calculate just how much you spend on repetitive work. This will do two things for you... first, it will probably shock you to see how much you spend on repetitive work. Second, it will give you something to gauge against when someone quotes on your task, and allow you to figure out how long it will take to break even.

    Simply plug in the details of your task into the Microsoft Excel WebApp below, (Yes! It's a fully functional spreadsheet, right in the web page. Type in the blue cells and click the little filter icons to change the time period values.)

    Alternately, you can also download and use Download our Automation Evaluation form! It is an Excel file, which contains no macros, so it is not a security risk to your system.

    I'm convinced! Where to I find a reputable Excel consultant?"

    Well, if you're looking for training in Microsoft Excel, then look no further. I offer on-site training services! You can learn about my offerings on this page

  • MVP Logo
  • Recent Forum Posts


    Convert large dataset into 2 columns into multiple columns

    Hi. I have a large dataset from multiple experiments that are all in two columns, when in reality they should be split into 60 or so columns from 30 separate...

    needexcelhelp Yesterday, 11:20 PM Go to last post

    week num

    Excels weeknum function can result in a week 54 in some years! This is because:
    1. 1st January is always Week 1.
    2. But .... there is also...

    Hercules1946 Yesterday, 11:16 PM Go to last post

    Highlighting Cells based on Date

    I need help trying to accomplish this to save me some manual work.

    I have an excel spreadsheet where I need to Highlight cells in Column...

    myk2thestar23 Yesterday, 11:10 PM Go to last post


    Hi Thanks

    However the forumula used in previous post is showing 31/12/17 as week 53 when it should be 52 how do i alter the formula to correct...

    jonespandrew Yesterday, 07:00 PM Go to last post

    week num

    Hi thanks for this, the only issue now is that it is shows 31/12/17 as week 53 when infact it is week 52, what do i need to do to alter this....

    jonespandrew Yesterday, 06:59 PM Go to last post