YO$22\_$Excel$\_$CH$09\_$Prepare$\_$Data$\_$Integration$\_$PartB

Project Description:

The Red Bluff Golf Course & Pro Shop manager, Aleeta Herriott, has asked you to create a report that analyzes costs and revenues from tournaments hosted over the past year. In the past, her staff had to reenter data manually from different sources to create this report because no one at the resort knew how to import the data. As a result, they rarel completed the report. Aleeta worries about the accuracy of the reports that were compiled because of the manual data entry. However, she did keep all the original files. Recently, a new Golf database was created to track sales and allow easy export to Excel for analysis. Aleeta wants you to design a spreadsheet that will help her automate the process of gathering and standardizing the data from the past for analysis.

Steps to Perform:

$\backslash$table$[[$Step$,$Instructions,$\backslash$table$[[$Points$],[$Possible$]]],[1,\backslash$table$[[$Start Excel. Download and open the file named$],[$Excel$\_$Ch$09\_$Prepare$\_$Datalntegration$2$of$3.$xlsx$.$ Grader has automatically added your last$],[$name to the beginning of the filename.$]],0],[),\backslash$table$[[$A list of customer information on a tournament golf club giveaway has been provided in the$],[$Excel$\_$Ch$09\_$Prepare$\_$Datalntegration$2$of$3.$xlsx workbook. The data needs to be cleansed$],[$before it can be used for purposes such as analysis or merging to a Word document.$],[$On the RegistrationData worksheet in column B$,$ use Flash Fill to separate the first name from$],[$the name in column A $.]],4],[3,\backslash$table$[[$The dates in column C are not stored in date formats that Excel can use. In column D $,$ use$],[$Flash Fill to convert the data in column C into a month$/$day$/$year date format e$.$g$.,4/13/2025,],[\frac{3}{18}\frac{?}{2025},$ etc.$]],6],[4,\backslash$table$[[$The phone numbers provided in column $E$ are not in a standard phone number format. In order$],[$to include these phone numbers in mail merges or other professional formats, they need to be$],[$formatted using a hyphen.$],[$In column $F,$ use Flash Fill to convert the string of numbers in column $E$ to include a hyphen in$],[$between the first $3$ digits and the last $4$ digits e$.$g$.,555-6199,555-1953,$ etc.$]],6]]$