Microsoft Excel Services

Digiwise can analyse your whole business or help with a specific system you would like to improve.  We then devise a solution specifically for your business.

Digiwise provides Excel Consulting and Excel Programming services.  We are experts in advanced Microsoft Excel technologies including:

  • Integrating Excel with databases including Microsoft Access, Microsoft SQL Server, Oracle and MySQL
  • Linking multiple sheets and files
  • Integrating Excel with financial applications such as MYOB and QuickBooks
  • Macros and Visual Basic for Applications (VBA) Programming
  • User-defined functions
  • Advanced formulas
  • Creating menus and adding form controls such as buttons
  • Configuring lists that can be filtered and sorted by the user
  • Data validation and drop-down lists
  • Protection to prevent unauthorised or accidental changes to specific cells
  • Pivot Tables for insightful data analysis 
  • Advanced graphs
  • Using Excel with web sites or Intranets (including Microsoft Sharepoint)