Assignment Task:
Prepare working solutions in Excel that will manage the annual budget, current month's inventory, and a list of the current month's transactions for a company of your choosing. Your solutions could use formulas as well as functions specifically demonstrating use of "sum", "if", and "vlookup". You must also show appropriate use of filtering, sorting, referencing, and formatting where appropriate.
Appropriate use of both formulas and functions such as "sum", "if", and "vlookup" should be displayed. Absolute, relative, and mixed referencing as well as filtering, sorting, and formatting should also be used where appropriate. Charts and graphs should be used to provide visual representation of the data, where appropriate.
Budget:
Prepare an annual budget in an Excel spreadsheet for the company that details projected expenses and income for the year. The expenses should include: salaries/staff, rent/lease, telephone/internet, business rates, loans, gas, electricity, water, insurance, and stock items. The projected income, taxes, and profit as well as average, minimum, and maximum expenses for the year should also be displayed using functions and formulas.
Inventory:
The inventory spreadsheet should display a detailed list of items offered by the company and should monitor the number of items left in stock for the current month. It should also include the "sum" function as well as two other appropriate functions.
Transactions:
The transactions spreadsheet should provide a detailed display of the current month's transactions or sales carried out for the company. It should also include the "sum" function as well as two other appropriate functions.