Description

You will create a spreadsheet that conducts a late payment analysis for an accounting department.

Objectives

Be able to calculate with dates in Excel

Formulate business problem-solving strategies

Design and construct spreadsheet-based reports

Directions

Based on this week's lecture and material, create a spreadsheet of a Late Payment Analysis. You will use the Nested IF function to identify orders that are late in payment and calculate with dates in Excel.

Fill in the Rest of the information following the directions

Clipboard Font Alignment Number F9 1 LATE PAYMENT ANALYSIS Today's date: 7/15/2017 4 5 Order# 6 AZ-234 Accounting Major 144.25 6/12/2017 7 MW-945Finance Major 8 PA-216 9 DR-340 Marketing Major 255.905/14/2017 10 Customer Amount Date Sent Days Out Status S 215.44 4/10/2017 Management Major322.05 7/10/2017 12 13 15 16 17 18 19 20