Home Salon Management System

This project involved the creation of an Excel workbook intended to be used as a database and management system for running a home salon. The final product began essentially as an ‘upgrade’ to an existing workbook used by my sister who works as a hairdresser out of her home. The old workbook was outdated and ‘clunky’ with various glitches occurring. The old workbook used only worksheet formulas to keep track of basic income and expenses on a monthly basis with summary information on a master sheet. The new workbook created for this project provides all the functionality of the old workbook with improved ease of use as well as additional useful functions and features. The new workbook uses multiple user forms to make it easier to enter income and expenses to better manage the finances of a home salon business and the worksheet have a much improved appearance. Additionally, the new workbook adds functionality to store data such as contact info, hair color formulas, notes, etc. on all clients entered in the client data worksheet. Information on each client is conveniently displayed and can be edited on a user form, where new clients can also be added and managed. The user can also choose to send e-mail and text alerts to clients reminding them of their next appointment.

Excel Project: Excel Workbook

Project Write-up: PDF Document