Wing It is a fictitious company I created in order to use for examples to display my knowledge and skill set.
This Wing It workbook was created in Microsoft Excel. It is an xlsm file containing a VBA macro.
Highlights of the Wing IT Excel Spreadsheet
- A VBA macro was created to open the data entry form and is attached to the Data Entry button.
- The Data entry form enables data entry on the Data Sheet worksheet.
- Sales Data button opens the Sales Data Charts worksheet.
- Sales Data Charts worksheet contains a bar and pie chart based on the data from the Data Sheet worksheet, which contains bird seed sales data.
- The Sales Data Table worksheet has a Sales Tracker table containing referenced data from the Data Sheet worksheet such as the item's cost per item, percent markup, total sold, total revenue, shipping charge, shipping cost, profit, returns, and total income.
- The Data Sheet worksheet contains the Product ID, Product, Cost Per Product, Percent Markup, Total Sold, Shipping Charge, Shipping Cost, and Returns.
- Conditional formatting is applied on the Data Sheet that when a new product is entered, borders around the cells are established.