Banner Image

All Services

Programming & Development

Excel Macros and VBA

$15/hr Starting at $25

MS Excel is such a powerful resource. Excel Macros and VBA programming mean that routine tasks can be automated, data can be checked or validated at input, and amazing complex routines can be achieved with VBA programming. From a simple day to day tasks , say a form where the user can enter expenses, an Excel Macro or User Form can make sure that the data entered is in the right format - pull down boxes can make sure that only permitted categories are selected. Excel runs background checks to ensure the form is completed accurately. To more complex projects where external data can be imported at the push of a button, processed and analysed with exceptions identified, put into report and graph format, printed or distributed electronically and archived. All at the push of a button! In a recent project I helped a busy High School Head Teacher to improve his management information system. The school used a government standard database to record all student information, including grades, attendance, behaviour and course information. However the system was cumbersome and the School Admin staff spent many hours per week running and printing reports for the Management Team We specified a new approach which achieved the following: The Headmaster saw a huge uplift in staff morale as a result of the new reporting system as

About

$15/hr Ongoing

Download Resume

MS Excel is such a powerful resource. Excel Macros and VBA programming mean that routine tasks can be automated, data can be checked or validated at input, and amazing complex routines can be achieved with VBA programming. From a simple day to day tasks , say a form where the user can enter expenses, an Excel Macro or User Form can make sure that the data entered is in the right format - pull down boxes can make sure that only permitted categories are selected. Excel runs background checks to ensure the form is completed accurately. To more complex projects where external data can be imported at the push of a button, processed and analysed with exceptions identified, put into report and graph format, printed or distributed electronically and archived. All at the push of a button! In a recent project I helped a busy High School Head Teacher to improve his management information system. The school used a government standard database to record all student information, including grades, attendance, behaviour and course information. However the system was cumbersome and the School Admin staff spent many hours per week running and printing reports for the Management Team We specified a new approach which achieved the following: The Headmaster saw a huge uplift in staff morale as a result of the new reporting system as

Skills & Expertise

CData ValidationEmail ServicesExcelExcel MacrosMacrosMs ExcelUser FormsVBAVBA Programming

Related Work Collections

4 Reviews

  • Nathan 115 says,

    Paul is great to work with. Not only was he very professional, but cordial, as well. And, he more than helped me, but taught me a few tricks, as well. Highly recommended!

    for Excel Sheet on May 17, 2016

  • Phil 60 says,

    Paul did an excellent job helping me format Excel charts for a presentation. I will definitely use him again.

    for Help with two charts on Apr 01, 2016

  • gflory says,

    Excellent grasp of the software and my specific Excel workbook needs. Provided recommendations for improvement that I will be implementing

    for excel spreadsheet update on Dec 18, 2015

  • Jacob_Weiss1 says,

    Paul is a very talanted person, his work was excellent, with not having to explain too much.

    for Excel List Maintanence on Mar 09, 2015