excel assignment

Must be Excel Expert with formulas. Take the attached spreadsheets and follow instructions highlighted in yellow on each spreadsheet You will take the analysis report and get the information to dump in the Spot pending report you want to compare the agreement numbers with the negative amounts shown on the analysis report and leave out those numbers which are positive or says billed at 100%. Create a template or manipulate the spreadsheet accordingly to match the agreement number to the negative numbers on that row for the agreement. You can use the Spot pending report to view to find your agreement on the analysis report once you are done locating the negative numbers that are not billed at 100% dump the info into the Spot pending report under the col labeled July costs make sure the amounts match that agreement on the spot pending report. If the amounts or agreement number is not found on the spot pending but you see it on the analysis report then add a row for the agreement and amount in the spot pending report