Glamping Cymru Excel-based Payslip System

• 

  Main Menu sheet which contains buttons mapped to macros

• 

  Excerpt of code

• 

  Payslip sheet

• 

  New Employee sheet

• 

  Employee Data sheet

• 

  Variables sheet

• 

  Calculations sheet

• 

  Archive sheet

• 

  Comparison sheet using a pivot table

Background & Summary

As part of the first year of my A-Level Applied ICT course I was given the task of creating a payslip system within Microsoft Excel for a fictional company named Glamping Cymru. This system was to use macros coded using Microsoft Visual Basic for Applications and buttons to navigate and perform tasks with minimal input from an average user.

How I built it

Using Microsoft Excel with macros implemented using Microsoft Visual Basic for Applications.

What I learned and accomplished

Learned how to program using VBA for Applications and how to use macros to run processes along with hidden formulea and buttons to provide a level of abstraction to make an user-friendly payslip system.

Built With

• excel
• microsoft-visual-basic-for-applications