Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction

Описание: #Shelly Cashman Excel 365 | Module 10: SAM Project A
#Shelly Cashman Excel 365 | Module 10: SAM Project A



Contact Us:
WhatsApp Number:+923187569415
Chatting Link :https://tinyurl.com/yzpfk6fm




I am providing help in all online courses like Excel, Word, Access, PowerPoint, Accounting , Management Courses, Finance Courses, Computer Science Courses, Information Technology Courses, All Writing Assignments etc. I can do your Quizzes, Exams , Mid-Term, Final Exams. In short I can get you A grade in your courses. If you want me do your courses My WhatsApp number and Email is given you can contact me through that. Thanks




PROJECT STEPS
1. Corey Hess is a financial analyst for Lincoln Construction, a company in Lincoln, Nebraska specializing in architectural restoration services. Corey is developing an Excel workbook to use for tracking and interpreting data about clients, projects, and invoices. He asks for your help in setting up tools to analyze the data and to automate the workbook to make it easier to use.
Go to the Home Page worksheet. Corey wants you to include a list of links to resources he and other managers are likely to need. However, the first link he added is unnecessary.
Remove the hyperlink from the text in cell C4, and then apply bold formatting and a 14-point font size to indicate the text is a list heading.
2. Corey asks you to make it easy to navigate to the other worksheets. Add links to other places in the workbook as follows:
a. In cell C5, insert a link to cell A1 of the Clients worksheet.
b. In cell C6, insert a link to cell A1 of the Projects worksheet.
c. In cell C7, insert a link to cell A1 of the Invoices worksheet.
3. Corey also needs to be able to access data about past projects as he prepares proposals for new projects. He stores the historical data in an Excel workbook. Add a link to the file as follows:
a. In cell C8, insert a link to the file Support_EX365_10A_History.xlsx.
b. Add the following text as a ScreenTip that explains what happens when users click the link:
Access past project data.
4. The Lincoln Construction website provides information the company managers use every day. In cell C9, add a link to the www.lc.example.com website.
5. Corey also wants you to include a way that he and other managers can request information from other Lincoln Construction offices. In cell C10, add a link to the [email protected] email address.
6. Corey's plan is that when users click the Add Client button on the Home Page worksheet, the Clients worksheet opens and Excel adds a new, blank record to the Client table, where users can insert the new client information. Record a macro to automate the Add Client button as follows:
a. Enable all macros in the workbook, and then display the Developer tab on the ribbon.
b. Record a macro stored in this workbook using Add_Client as the name of the macro.
c. While recording the macro, display the Clients worksheet.
d. Also, while recording the macro, add a new blank record to the end of the Client table.
e. Stop recording the macro.
f. Assign the Add_Client macro to the Add Client button on the Home Page worksheet and then run the Add_Client macro to make sure it inserts a new record at the bottom of the Client table on the Clients worksheet.


#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10
#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A
#SAM Project A
#Lincoln Construction
#Module 10

#Shelly Cashman Excel 365 | Module 10: SAM Project A Lincoln Construction
#Shelly Cashman Excel 365 | Module 10: SAM Project A