Excel templates and add-ins can help a business automate tasks to improve productivity and consistency. VBA Developer provides the following services for Excel templates & add-ins:
- create new Excel templates and add-ins to help automate tasks and advise on improvements and future development
- develop Excel dashboards and reports using pivot tables, power pivot, power query and slicers for interactive data filtering
- pricing & quotation templates to allow users to produce quotes from complex data models
- update and maintain existing Excel templates and add-ins e.g. custom ribbons, VBA forms
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 information 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 and clean and shape it to produce dashboards
- pivot tables with slicers, Pivot charts, KPIs, interactive maps
- power view models to use an interactive view instead of an Excel spreadsheet view
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 entered correctly by applying business logic and validating data. Examples of Excel templates developed include quotation tools, pricing models, invoices, time sheets and expenses among many others.
Custom add-ins & ribbons
Excel chart ribbon
Excel add-ins load when Excel starts and provide functionality available to all workbooks, they have the following benefits:
- act as a library for code rather than storing code in separate templates.
- an add-in can have its own ribbon with separate tabs for running templates and utilities.
- streamlines the amount of code and avoids duplication
- reduces development and maintenance costs.
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 time required to produce charts and ensure consistency.
- custom charts optimised for use in PowerPoint presentations in full and half page sizes.
- ability to reformat existing charts in custom colours
- options to format charts as in the screenshot above