FINAL PROJECT
Create a workbook that is relevant and applicable to your current line of work that includes the following elements:
1. Documentation sheet with an Executive Summary explaining each section of the worksheet and its objectives.
2. Print ready with header, footer and page numbers. Manual page breaks where needed.
3. Conditional formatting
4. Absolute and relative cell references.
5. Functions to include – at least 5 from each category:
- Statistical – SUM, COUNT, AVERAGE, etc.
- Logical functions – IF, AND, OR, etc.
- Lookup functions – VLOOKUP/HLOOKUP, etc.
- Date functions – TODAY, NOW, etc.
- Financial – NPV, IRR, SLN, DB, etc.
- MIN/MAX/MEDIAN
- SUMIF, COUNTIF, AVERAGEIF
- NESTED FUNCTIONS (using any of the above)
6. Charts – include at least 1 of each – Line, Stacked Column, Histogram, Combo, Sparklines, Data Bars.
(Chart Titles, Axes Titles, Data Labels, etc. MUST appear where appropriate.)
7. At least one defined EXCEL table and one pivot table. Use at least one slicer.
8. Add at least one data validation using a drop down list.
9. Include a one variable Data Table showing monthly payments for six different loan options.
10. At least two LP problem types from Chapter 3 of MDM Text.
11. Decision Making under Risk Analysis – Chapter 8 of MDM Text
11. One Simulation Model – Chapter 10 of MDM Text
12. One Forecasting Model – Chapter 11 of MDM Text
NOTE: All formulas and functions should reference cell addresses and/or defined name ranges – NOT hardcoded with a distinct value unless the value is commonplace. (ex. number of days in a year).
Apply formatting to all elements of the spreadsheet that will make the spreadsheet easier to read and interpret.
And remember – Less is More!
The post Conditional formatting appeared first on My Assignment Online.
