Excel-based POS System Development

Job ID: 39292895

Budget: $30 – $250 USD

I'm looking for a professional Excel developer to create a comprehensive POS system for a fictional hunting company. This system needs to be fully functional with order entry, sales tracking, financials, current inventory tracking, and entry of new inventory upon purchase. All these features should be organized into separate sheets within a single workbook.

Key Requirements:
- Use of Macros for automation
- Proficient use of Excel functions such as SUMIF, COUNTIF, and VLOOKUP
- Utilization of Pivot Tables and charts for data analysis
- Design of a user-friendly Graphical User Interface (GUI) in Excel

The system should also include a dashboard with various types of charts for visual data representation. The charts should include, but not be limited to, Pivot tables, line charts, and bar graphs.

Ideal Skills:
- Extensive experience with Excel, particularly in creating complex workbooks
- Strong understanding of POS systems and inventory management
- Excellent skills in data visualization and creating user-friendly interfaces
- Proficient in using Excel functions and Macros

I attached the current state of the POS Syetme (very bad as of now) But it gives an idea of the format