Spreadsheeting
We have thirty plus years experience utilising spreadsheet technology from the early spreadsheet software such as Multiplan and Lotus 123 through to the latest versions of Excel. We have deployed solutions utilising Macros and Visual Basic for Applications for Microsoft Office applications.
The power, capability and ubiquity of Excel makes it a great vehicle for analysis and for data visualisation. We can develop spreadsheet solutions from the beginning or repair or update existing spreadsheets and add additional capabilities such as Business Intelligence. We can streamline existing spreadsheets using, for example, array formulas which are much quicker, take up less storage space and can combine a range of functions in a way that standard formulas do not.
We can develop or work with the following as an example of the range of activities we can undertake to strengthen your business processes and reporting using or integrating Excel with other Microsoft Office products:
The power, capability and ubiquity of Excel makes it a great vehicle for analysis and for data visualisation. We can develop spreadsheet solutions from the beginning or repair or update existing spreadsheets and add additional capabilities such as Business Intelligence. We can streamline existing spreadsheets using, for example, array formulas which are much quicker, take up less storage space and can combine a range of functions in a way that standard formulas do not.
We can develop or work with the following as an example of the range of activities we can undertake to strengthen your business processes and reporting using or integrating Excel with other Microsoft Office products:
- Spreadsheet Auditing
- Complex formulas
- Financial formulas
- Spreadsheet repair and augmentation
- Complex and novel graphs
- Business Intelligence functionality including Excel based Dashboards
- Array formulas
- Pivot Tables
- Sparklines
- Additional functionality can be built in using Visual Basic for Applications
- Power Pivot
- Power Query
- Power View
- Excel Solver