Excel Consulting

Hundreds of companies rely on spreadsheets to assist them with day-to-day functions; however, as things grow, the original solution is often not the best. Gravity Computing can offer specialised consulting and development within Microsoft Excel. We are your Kiwi source for Excel help!

 

  • Task Automation, with Excel macros and VBA

    The effects of Excel automation can be amazing. It is common for us to achieve a 90% reduction in manual effort, by using some advanced Excel macros (also known as Excel VBA). For example, one of our recent clients would spend the day taking measurements, then spend three hours every night converting his measurements into quotes. He wanted a way to decrease this time by half. Our solution involved an automated Excel workbook, and a netbook. He now types measurements directly into the netbook, which calculates the entire quote for him. The fifteen hours a week that he spent on calculations is now zero hours a week, and he's ecstatic. So if you're dealing with a repetitive, manual task in a spreadsheet, give us a call. There is a whole lot that can be taken care of with some advanced Excel macros and VBA... We can make Excel help you!

     

  • Consistency and Accuracy Checks

    Excel has a whole raft of features that can help make your job easier, and they're not all hiding underneath the covers of Excel macros and advanced formulas. Conditional formatting can make Excel help you spot values that are incorrect, data validation can prevent users from entering data in the wrong place, and there's always sheet protection to make things stay where they belong. With an Excel specialist's help, your data could become much more reliable.

 

  • Data Visualisation and Dashboards

    PivotTables, charts, timelines, dashboards, statistics... If you have a whole lot of data in your spreadsheet, gleaning information from it can be a mammoth task. Need to know more about your sales? Trying to analyse the results of your marketing? Have a monthly report but also want an automatic annual summary? With some Excel formulas we can pull your data together, and then we can produce graphs and charts to give you a clear visual representation of what you need to know. And the best part is that, once we help you sort out your data, you might find yourself doing less work as a result

    •  

  • Excel Training and Excel Help

    If you need some Excel help, but you don't know exactly what you need, give us a call anyway. We have some general Excel training packages that we can discuss with you, or we can tailor-make a specific lesson to get you exactly the Excel training that you need. We can take care of it all - from basic Excel training, right though to advanced formulas and macros. There's no reason to battle with Excel. If you're struggling, get in touch with us today.