Gaynor Jones

I am an analytical, organised and detail oriented accountant/office manager for an Audit Firm. Excel has always been my favourite program to work with. Over the years I have used various formulas and Macros to optimize my work efficiency. During the recent lock down periods I decided to use this time to further improve my skills. Knowing the benefits of being able to use Macros and complex formulas I completed courses on VBA, Power Query, Power Pivot and DAX. With this new knowledge I have rewritten my initial Macros and added many more, making my day to day repetitive work a lot quicker and more accurate.
Projects within Udemy Course and Daily work environment:
Invoice Generation, Sales Reporting, Automated Table of Contents, Automated Send email with extract from Excel as an attachment, import data from various programmes Pastel, Pastel Payroll and Banks
Working with Variables, Error Handling, Looping, Arrays, Pivot Tables, Events, List Boxes, User Forms, Function Procedures,