Shelly Cashman Excel 365 | Module 1: End of Module Project 1 Anywhere Fitness
Complete a client tracker worksheet
· Excel Projects Help
GETTING STARTED
1. Save the file SC_EX365_EOM1-1_FirstLastName_1.xlsx as SC_EX365_EOM1-1_FirstLastName_2.xlsx
a. Edit the file name by changing “1” to “2”.
b. If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
2. With the file SC_EX365_EOM1-1_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
a. If cell B6 does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. Emery Larson is a personal trainer for Anywhere Fitness, a virtual fitness consulting company. She created a worksheet to help her keep in touch with her clients; she asks for your help in completing the worksheet. Go to the Current Accounts worksheet. Cut the worksheet subtitle, Current Accounts, from cell C2 and paste it in cell A2.
2. Copy Emery's name in cell G2, and paste it in cell C11. Clear the contents of cell G2.
3. In cell C3, enter Goal as the column heading.
4. Change the font size of the range A3:J3 to 12 point, and then bold the contents.
5. Use AutoFit to resize columns G and H to their best fit.
6. Apply the Text number format to the range D4:D9.
7. In cell E5, use Social media as the complete entry for the cell.
8. Anywhere Fitness has a company policy to contact their clients once every week. In cell H4, create a formula without a function that adds 7 days to the date the client was last contacted (cell G4).
9. Fill the range H5:H9 with the formula in cell H4.
10. In cell J9, enter 2500 as the plan amount for Robert Bennett.
11. In cell J10, enter a formula that uses the SUM function to sum the contract amounts (the range J4:J9).
12. Change the orientation of the worksheet to Landscape, and then change the print scaling to fit the sheet on one page.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.
Final Figure 1: Client Tracker