| | Project and Excel Grading Rules: |
| | *** (Each Mistake = -1 Point) |
| | (1) | Report must begin with "Executive Summary Page" |
| | | | >> With few short paragraphs & bullet points |
| | (2) | Second page concisely describing "Statement of Work (SOW)" |
| | (3) | Third page should contain "Business & Analysis Assumptions" |
| | (4) | Fourth page should contain "Analysis Summary & Recommendations" |
| | | | >> Scenario Analysis (when applicable) |
| | | | >> Baseline, Best-Case, and Worst-Case |
| | | | >> Break-even Analysis |
| | | | >> Sensitivity Analysis |
| | (4) | Standard Font - Arial |
| | (5) | Standard Font Size - 11, 11.5, 12 |
| | (6) | Page Set-Up - Portrait or Landscape |
| | (7) | Print Area Set Up |
| | (8) | Equation Writing |
| | (9) | Format Cells for Currency - Accounting with 2 Decimals |
| | (10) | View - Zoom 110% and/or Freeze Panes |
| | (11) | Reporting numbers and % - use 2 Decimals |
| | (12) | Linking Cells (same page vs. between pages and/or between files) |
| | (13) | Font Color vs. Cell Color (Fonts all in black and no highlighted cell) |
| | (14) | Key Financial/Account Reconciliations as and when required or necessary |
| | (15) | Publications and References used |
| | (16) | You must do spelling/grammar check on your writing |
| | *** You must take pride in your work; please autograph your work with excellence! |
onlyamor
project__excel_grading_rules.xlsx
