Shelly Cashman Excel 365 | Modules 1-3: SAM Critical Thinking Capstone Project C

Описание: #Shelly_Cashman_Excel_365_Modules_1_3_SAM_Critical_Thinking_Capstone_Project_C #SC_EX365_CT_CS1-3C #ShellyCashmanExcel365Modules13SAMCriticalThinkingCapstoneProjectC #Excel_Modules_1_3_SAM_Capstone_Project_C #ExcelModules13SAMCapstoneProjectC #Capstone #Excel_Modules_1-3 #AWJonesFinanceConsultants #A_W_Jones_Finance_Consultants #AWJones #FinanceConsultants #Excel_Capstone_Project_1_3 #ExcelCapstoneProject13



Contact Me For Your Courses
Email :[email protected]
WhatsApp:+923035509136
WhatsApp Direct Chat : https://wa.link/b7c7l1


PROJECT STEPS
1. Gemma Oyuela is a senior account manager at A.W. Jones Finance Consultants, a consulting firm that works with financial companies around the world. Gemma has created a workbook summarizing the status of the consulting project for Asset Plus Solutions. She asks for your help in completing the workbook.

Go to the Project Status worksheet. The data is incomplete and the formatting needs to be finished. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.
2. Enter a function to the right of the cell marked "Date:" to display the current date and time, then use the Short Date number format to display only the date in the cell.
3. The worksheet title should use a consistent design throughout the workbook.

Change the fill color and the font color of the cell containing the text "Asset Plus System Upgrade" to match the cell below. Merge and center the contents through the end of the table data. Use AutoFit to resize row 2 to its best fit.
4. Format the billing rate data to suit the design of the worksheet and make the data easier to understand.

Italicize the label "Billing Rate:" to match the formatting in the cell labeled "Date:". Then apply the Currency number format to the rate to display it as a dollar amount.
5. The text in the first column needs to be displayed in a better way. Format the data in the first column as follows:

Merge the cells from the text "Asset Plus Solutions" down to the bottom of the Service ID column, including the total row. Rotate the text up in the merged cell so that the text reads from bottom to top. Middle-align and center the text. Remove the border from the merged cell, and then resize the column width to 3.00.
6. Format the row of data under the cell containing "Project Status Report" to show that it contains column headings.



#Shelly Cashman Excel 365 Modules 1-3 SAM Critical Thinking Capstone Project C
#Shelly_Cashman_Excel_365_Modules_1_3_SAM_Critical_Thinking_Capstone_Project_C #ShellyCashmanExcel365Modules13SAMCriticalThinkingCapstoneProjecTC
#Excel Modules 1-3 SAM Capstone Project C
#Excel_Modules_1_3_SAM_Capstone_Project_C
#ExcelModules13SAMCapstoneProjectC
#Excel Capstone Project 1-3 C
#ExcelCapstoneProject13C
#Excel_Capstone_Project_1_3_C
#Excel Module 1-3 SAM Project C Jones Finance Consultants
#Excel_Module_1_3_SAM_Project_C_A_W_Jones_Finance_Consultants
#ExcelModule13SAMProjectCAWJonesFinanceConsultants
#SC_EX365_CT_CS1-3C_FirstLastName_1.xls
#SC_EX365_CT_CS1-3C_FirstLastName_2.xlsx
#SC_EX365_CT_CS1-3C
#A.W. Jones Finance Consultants
#AWJonesFinanceConsultants
#A_W_Jones_Finance_Consultants
#CREATE FORMULAS WITH FUNCTIONS
#CREATE_FORMULAS_WITH_FUNCTIONS
#CREATE FORMULAS WITH FUNCTIONS
#ShellyCashmanExcel2019
#Capstone
#capstoneproject
#Shelly
#A.W. Jones Finance Consultants SAM Project
#AWJonesFinanceConsultantsSAMProject
#A_W_Jones_Finance_Consultants_SAM_Project
#cengage
#ex19
#ex365
#Excel Module 1-3 Critcal Thinking Capstone Project
#ExcelModule13CritcalThinkingCapstoneProject
#Excel_Module_1_3_Critcal_Thinking_Capstone_Project


#Shelly Cashman Excel 365 Modules 1-3 SAM Capstone Project A
#Shelly_Cashman_Excel_365_Modules_1_3_SAM_Capstone_Project_A #ShellyCashmanExcel365Modules13SAMCapstoneProjectA
#Shelly Cashman Excel 365 Modules 1-3 SAM Capstone Project B
#Shelly_Cashman_Excel_365_Modules_1_3_SAM_Capstone_Project_B #ShellyCashmanExcel365Modules13SAMCapstoneProjectB
#Shelly Cashman Excel 365 Modules 1-3 SAM Capstone Project C
#Shelly_Cashman_Excel_365_Modules_1_3_SAM_Capstone_Project_C #ShellyCashmanExcel365Modules13SAMCapstoneProjectC


#Shelly Cashman Excel 365 Modules 4-7 SAM Capstone Project A
#Shelly_Cashman_Excel_365_Modules_4_7_SAM_Capstone_Project_A #ShellyCashmanExcel365Modules47SAMCapstoneProjectA
#Shelly Cashman Excel 365 Modules 4-7 SAM Capstone Project B
#Shelly_Cashman_Excel_365_Modules_4_7_SAM_Capstone_Project_B #ShellyCashmanExcel365Modules47SAMCapstoneProjectB
#Shelly Cashman Excel 365 Modules 4-7 SAM Capstone Project C
#Shelly_Cashman_Excel_365_Modules_4_7_SAM_Capstone_Project_C #ShellyCashmanExcel365Modules47SAMCapstoneProjectC