Excel templates, add-ins, Power BI reports

VBA Developer creates Excel VBA templates & add-ins, models, dashboards & reports. We also build Power BI dashboards & reports and can migrate your existing Excel dashboards to Power BI.

Excel templates

VBA Developer can provide the following services for templates and add-ins for new and existing projects.

Reports

  • Excel reports for analysis and modelling linked to multiple data sources using Power Query to extract, transform and load data
  • use tables, pivot tables and dynamic arrays to build user friendly dashboards with dependant dropdowns

VBA forms, ribbons

  • create custom VBA forms for data entry, custom ribbons to use utilities
  • optimise workbooks to improve slow performance, fix bugs
  • help with migration issues to a later version of Excel
  • provide training courses for beginner, intermediate and advanced users

Excel add-ins

Excel template add-in chart ribbon

VBA Developer provides the following services for Excel add-ins:

  • a chart add-in for custom chart creation to use your companies branding
  • update your existing add-ins to add new functionality, fix bugs
  • create bespoke add-ins to help improve efficiency
  • provide training, support and any documentation required

Power BI

VBA developer can create new Power BI dashboards and help migrate Excel based solutions to Power BI to benefit from the options it provides.

  • create Power BI dashboards & reports with interactive visualisations to analyse data
  • develop existing Power BI dashboards, adding new visualisations, calculated columns, DAX measures, maps

Word templates

Word templates, custom add-in ribbon

VBA Developer has built advanced letterhead templates for clients in many sectors to produce professional documents with custom functionality to improve efficiency and reduce maintenance costs. Features can include:

  • letterheads with multi-office, multi-language options to replace multiple templates
  • integration with Outlook, databases, build content from autotext

Word add-ins

  • Word adds-in with custom ribbons to run utilities e.g. toggle logos for printed documents, page options, insert boilerplate clauses from auto-text
  • custom VBA forms for data entry, custom ribbons to use utilities
  • provide bespoke training options for beginner, intermediate and advanced users

Free no obligation review

Contact us to carry out a free review of your existing templates and add-ins and advise on development options.