John Mallinson , Edinburgh, United Kingdom

I have been working with VBA, Excel and other Office applications for over 20 years, I have a thorough understanding of how to get the best out of these tools to produce custom solutions for clients ranging from individual users to global IT corporations (until recently having worked in the IT industry for one).



I have completed VBA projects ranging from a dozen-or-so lines of code in a single Excel workbook through to many thousands of lines across multiple integrated add-ins, templates and workbooks.



While my specialism is in Excel, I regularly work with Word, Outlook and PowerPoint to use VBA macros to automate the creation of documents, emails and presentations and work with web browsers and Power Query to extract and transform data. I can help you with complex and custom formulas, importing / cleaning data with or without Power Query, charts, PivotTables, dashboards, templates, add-ins, macros and ribbon customization.



• Complex formulas: conditional sums, lookups, unique values, manipulating text, …

• Custom formulas: sum cells based on format, custom array sorts, fixed random values, …

• Extracting, transforming and loading data: aggregating, merging, aligning data from one or multiple tables

• Charts: built-in and customized such as conditional formatted charts, panel charts, …

• PivotTables: including Slicers, Timelines and PivotCharts

• Dashboards: interactive, updatable, key data, charts, Sparklines, drill-downs etc.

• Templates: planners, timesheets, trackers, budgets … with and without macros

• Add-ins: command bars, ribbon customization, custom formulas, …

• Macros: to automate Excel – custom formats, formulas, comparisons, working with external references, …

• Ribbon customization: from individual buttons and checkboxes to entire ribbon tabs