Development of templates, formulas, and automation using macros written in VBA (visual basic for applications) along with documentation of new processes and any code written.

For example:

• Customize templates to improve speed, accuracy, or presentation of information, including formatting or colors to match your organization.

• Build complex formulas and custom functions to reduce steps for calculations and perform calculations beyond what’s built into Excel.

• Automate repeated or complex processes using VBA macros that are flexible to your project needs, then document the new processes and train staff.

• Create PivotTables and charts to summarize your data, including the best way to keep them up to date for your processes - whether they are for daily tracking or annual reports.

• Generate emails, PDFs, or Word docs from a CSV or Excel file, saving time and reducing error while providing more flexibility than mail merge.

• Handle broken or under-documented formulas and VBA macros, creating documentation plus updating code (if you have the copyright) or replacing it (if you don’t).