Excel templates

Excel templates and add-ins can help a business automate tasks to improve productivity and consistency. VBA Developer provides the following services:

  • create new Excel templates & add-ins to help automate tasks and advise on improvements
  • develop Excel dashboards and reports using tables, pivot tables, power query and slicers for interactive data filtering
  • update and maintain existing Excel templates and add-ins e.g. custom ribbons

Free review

VBA Developer can carry out a free no obligation review of your existing templates and add-ins and advise on development options.

Custom add-ins & ribbons

Excel chart ribbon
Excel chart ribbon

VBA Developer has developed a custom chart add-in so companies can use their own colour scheme rather than using Microsoft’s default colours for your charts. The add-in has the following features:

  • create custom charts in client specific colours and sizes reducing the required to produce charts and ensure consistency
  • custom charts optimised for use in PowerPoint presentations in full and half page sizes
  • reformat existing charts in custom colours
  • options to format charts as in the screenshot above

Excel dashboards & reports with Pivot tables for BI

Dashboard & report templates enable users to view data in a more visually appealing way to make the information more meaningful and clearer to the user. Reporting tools help automate the repetitive tasks involved in creating management reports and summarise data in several spreadsheets.

Management information reports can be developed with features including:

  • data models using Power Query to extract data from multiple sources, transform the data by removing unwanted fields and reformat it and then load it into workbook
  • pivot tables with slicers, Pivot charts, KPIs

Excel VBA forms and data entry

Templates with VBA forms help the data entry process allowing users to select information from lists or drop boxes instead of typing it ensuring data is correctly entered by data validation and applying business logic. Examples of templates developed include quotation tools, pricing models, invoices, time sheets and expenses, see examples here

 

What was the purpose of your visit to this website?(required)