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
Recent projects include an automated, interactive dashboard for a customer services department, a risk / assumption analyzer, a tool to filter medicines by name, an attendance / vacation tracker, automatic email dispatch from Excel for a shipping company, populating Word ‘puzzle’ templates and an invoice / quotation generator … samples of these and other projects are available in my Upwork portfolio.
While I have been working in this field for many years, I am new to Guru and trying to build up my profile, hence my hourly rate currently includes a substantial discount.
I’m used to working to deadlines, I’m hard-working and reliable, I speak English natively.
Please contact me to discuss your project!