At OHPO Konsult we are dedicated to helping companies work smarter with Microsoft Office, focusing on Microsoft Excel.
The Microsoft Office suite is widely used for professional purposes around the World and therefore many users are already familiar with the interface. Excel, along with the rest of the Office suite, can to a great extent be customised, automated and integrated and a more efficient and secure use can save time and money. Saving a few minutes a day will ultimately release extra working days on an annual basis, time that could and should be used for more worthwhile activities like meeting new customers. Together with Visual Basic for Applications (VBA), the built-in development tool, Microsoft Office gives you a very flexible and cost-efficient alternative to off-the-shelf-software or bespoke standalone solutions. In addition to development of solutions, we are also available for bespoke workshops and one-to-one tuition.
Consolidation of spreadsheets
Excel spreadsheets from different business units can be automatically consolidated in a central spreadsheet for instance at the finance department. Adding data validation routines helps early error detection.
Creation, redesign and restoration of spread sheets
Gradually building your own spreadsheet and sharing it with colleagues sometimes creates a monster that will demand all of your time. As outsiders with fresh pair of eyes we will analyse existing needs and suggest changes.
Interaction with third party software
Exporting and importing data from third party business systems are very common tasks in the business world. However, they are far from seamless. Getting the formatting right when exporting and finding data that is relevant for your analysis when importing is often very time consuming. This can be solved by automating Excel.
Integrating Word and Excel
Building templates in Word that are linked to Excel can be very useful for instance when writing tenders and reports. Adding Outlook gives you the possibility of sending the documents automatically to your customers or colleagues.
Excel can be used as a front end to an Access or SQL Server database. Using VBA, the records can be easily manipulated and analysed. Development of Add-Ins: Add-Ins are custom-made functions that are added to the software’s default functions. These functions will work each time you open the programs irrespective of the actual documents you are opening. Right now you may as well be using an Add-In without knowing. Add-Ins can easily be distributed to all of your work stations.