making an excel spreadsheet more effective and efficient
Attached Files:
- Commission Calculation.xlsx (24.395 KB)
Problem #1: The purpose of this assignment is to have you analyze a workbook and determine its inefficiencies. Remember, worksheets should be professional, easy to understand, easy to maintain, and efficient. Hint: use the spreadsheet checklist and the material you covered in the textbook.
The data file needed for this problem: Commission Calculation.
This worksheet was produced by Thomas Ford for his company Janesville Consulting Services.
- The calculations used in this file are primarily accurate, however, this is not an effective nor efficient worksheet. Perform an analysis of the worksheet. Your analyses should identify the inefficiencies within this worksheet.
- Modify the Commission Calculation workbook to be more efficient, easy to understand and maintain, and professional. Using a little professional color is okay!
I HAVE ATTACHED THE EXCEL DOCUMENT AND A SPREADSHEET CHECKLIST THAT LISTS ALL FORMATING AND EXPECTATIONS FOR WHAT THE DOCUMENT SHOULD LOOK LIKE.