VBA Skill Appraisal for Dandie Romero

VBA Skill Appraisal for Dandie Romero

Dandie Romero
Course Attended: Advanced VBA Programming in Excel
Year Attended: 2014

Dandie undertook an unsupervised VBA programming project upon finishing the 4 day Advanced VBA Programming in Excel workshop from Aeternus Consulting LLP.

Nature of Project:
Dandie implemented a database application for a pharmacy to track the issue of controlled medicines to patients. His application has solved the laborious problem of manual tracking of various medical products and improved accuracy and error rates in this work process.

Screen Shots of Application

Critique on Criteria: Code Documentation
Excellent code documentation. There was liberal use of coding comments to explain the logic of VBA codes. Good use of variable naming to improve readability of codes for long term maintenance.

vbe-dandie

Critique on Criteria: Degree of Modularity Designed
Excellent structuring of modules. Subroutines are well modularised as evidenced by its relatively small size and the subroutines are further organized into modular folders within the VBA project. Each Worksheet object serves a single purpose and together they form a coherent system.

projectlist-dandie
worksheetlist-dandie

Critique on Criteria: Visual Appeal, Ease of Use, Functional Quality
Good visual appeal & ease of use. There is considerable effort in the interface design to improve usability of the database application. The interface has effectively removed the complexity of a traditional Excel workbook with numerous worksheets. Excellent functional quality. The application built-in numerous features that aids the business workflow of issuing medical products. There is a search feature, drop list customization, multiple reporting features.

Overall Achievement & Demonstrated Areas of Competence

Dandie has demonstrated high level of competence in the following areas:

  • Good understanding of the business problem and able to conceptualize an Excel database application to address the problem.
  • Able to design an abstract database information structure that captures the actual business process and required data.
  • Able to design a functional and coherent user interface in Excel application programming.
  • Proficient in VBA programming in Excel to create a working database application.

    Date: 28 May 2014
    Derek Leong
    Developer Consultant
    Æternus Consulting LLP

About Aeternus Consulting

Aeternus Consulting is the premier training center for VBA Courses, VBA Programming Language and Excel Macro Courses in Singapore.

Related Link: Aeternus Consulting VBA Training Courses Singapore

basic vba programming microsoft excel training course singapore
basic vba programming microsoft excel training course singapore
advanced vba programming microsoft excel training course singapore
advanced vba programming microsoft excel training course singapore

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)