My professor assigned this assignment over break but didn't teach us how do do it. Please help. Below I attached the questions as well as the excel file mentioned.

When I open your excel file, I should be able to see on the first worksheet labeled clearly the following:

The total balance of Accounts Receivable.

The total amount of Invoices that are current.

The total amount of Invoices that are past due.

Below the above information, create a bar chart that has the invoices aged in the following categories:

Current (assume all invoice terms are net 30 days).

One to 30 days past due.

31-60 days past due.

61-90 days past due.

91 & over days past due.

Also, on the first worksheet, show a listing or chart showing the 5 customers with the highest overdue amounts. Show their total balances and amount overdue.

On another worksheet, create a pivot table which summarizes each customer and puts their balances into an aging using the categories in part 2.

On another worksheet, use a pivot table that will show the following for each customer. This pivot table should be able to summarize each customer by total outstanding but also be expanded to show all of their invoices currently outstanding.

On the first sheet have a place where the current date can be entered. Changing the current date, should change your information. Consider using date formulas on your data and adding new columns to the data.

\begin{tabular}{|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{l} Southern Industries \\ Outstanding Accounts Receivable \end{tabular}}} & \multicolumn{2}{|r|}{ Current Date } & \multirow[b]{3}{*}{ Total } \\ \hline & & & & \\ \hline & & Numben & Date & \\ \hline Western Supply & Invoice & 1223 & 1/31/2022 & 40,000 \\ \hline Yankee Industries & Invoice & 1222 & 1/31/2022 & 225,000 \\ \hline Builders Commercial & Invoice & 1110 & 6/2/2022 & 4,000 \\ \hline National Supply & Invoice & 1215 & 6/26/2022 & 1,359 \\ \hline Edmonds Manufacturing & Invoice & 1149 & 7/8/2022 & 88 \\ \hline Lang Supply & Invoice & 1206 & 8/23/2022 & 1,400 \\ \hline Bruce \& Co. & Invoice & 1102 & 9/1/2022 & 800 \\ \hline Cabno Inc. & Invoice & 1127 & 9/3/2022 & 600 \\ \hline Lang Supply & Invoice & 1207 & 9/23/2022 & 600 \\ \hline National Supply & Invoice & 1218 & 9/26/2022 & 1,000 \\ \hline Bruce \& Co. & Invoice & 1103 & 10/1/2022 & 1,500 \\ \hline GAB Corporation & Invoice & 1175 & 10/14/2022 & 400 \\ \hline Island Builders & Invoice & 1186 & 10/17/2022 & 3,500 \\ \hline Jackson Supply & Invoice & 1197 & 10/20/2022 & 1,200 \\ \hline National Supply & Invoice & 1219 & 10/26/2022 & 10,200 \\ \hline Anderson Industries & Invoice & 1090 & 10/28/2022 & 3,000 \\ \hline Bruce \& Co. & Invoice & 1104 & 11/1/2022 & 1,000 \\ \hline Cabono Inc. & Invoice & 1129 & 11/3/2022 & 1,200 \\ \hline Dye Brands & Invoice & 1141 & 11/5/2022 & 1,500 \\ \hline Edmonds Manufacturing & Invoice & 1153 & 11/8/2022 & 1,200 \\ \hline Frankel Inc. & Invoice & 1164 & 11/10/2022 & 500 \\ \hline GAB Corporation & Invoice & 1176 & 11/14/2022 & 4,000 \\ \hline Island Builders & Invoice & 1187 & 11/17/2022 & 300 \\ \hline Jackson Supply & Invoice & 1198 & 11/20/2022 & 11,250 \\ \hline National Supply & Invoice & 1220 & 11/26/2022 & 165 \\ \hline Anderson Industries & Invoice & 1091 & 11/28/2022 & 250 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|r|} \hline Regional Supply & Invoice & 1238 & 11/28/2022 & 238 \\ \hline Terminal Industries & Invoice & 1282 & 11/28/2022 & 511,000 \\ \hline Universal West Supply & Invoice & 1254 & 11/29/2022 & 9,000 \\ \hline Victoria Supply & Invoice & 1272 & 12/1/2022 & 3,000 \\ \hline Builders Commercial & Invoice & 1116 & 12/2/2022 & 700 \\ \hline Cabno Inc. & Invoice & 1130 & 12/3/2022 & 10,000 \\ \hline Dye Brands & Invoice & 1142 & 12/5/2022 & 350 \\ \hline Edmonds Manufacturing & Invoice & 1154 & 12/8/2022 & 800 \\ \hline Frankel Inc. & Invoice & 1165 & 12/10/2022 & 100 \\ \hline GAB Corporation & Invoice & 1177 & 12/14/2022 & 90 \\ \hline Jackson Supply & Invoice & 1199 & 12/20/2022 & 11,250 \\ \hline National Supply & Invoice & 1221 & 12/26/2022 & 600 \\ \hline Anderson Industries & Invoice & 1092 & 12/28/2022 & 2,000 \\ \hline Universal West Supply & Invoice & 1255 & 12/29/2022 & 1,125 \\ \hline Lang Supply & Invoice & 1285 & 12/30/2022 & 11,750 \\ \hline Bruce \& Co. & Invoice & 1105 & 12/31/2022 & 13,500 \\ \hline Handles Inc. & Invoice & 1297 & 12/31/2022 & 15,000 \\ \hline Quarter Supply & Invoice & 1291 & 12/31/2022 & 13,125 \\ \hline Totals & & & & 919,640 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Customers & \begin{tabular}{l} Total \\ Outstanding \end{tabular} \\ \hline \begin{tabular}{c} Anderson \\ Industries \end{tabular} & 5,250 \\ \hline 1090 & 3,000 \\ \hline 1091 & 250 \\ \hline 1092 & 2,000 \\ \hline \end{tabular}