Shelly Cashman Excel 2019 | Module 10: SAM Project 1b WebSmith скачать в хорошем качестве

Shelly Cashman Excel 2019 | Module 10: SAM Project 1b WebSmith

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6N... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@gmail.com We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English. Shelly Cashman Excel 2019 | Module 10: SAM Project 1b WebSmith PROJECT STEPS Woon Seong runs a small web design agency in Champaign, Illinois, and is developing an Excel workbook that her partners can use to track and interpret data about clients, projects, and invoices. She 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. Woon wants to include a list of links to resources she and her partners are likely to need. However, the first link she added is unnecessary. Remove the hyperlink from the text in cell B3. Woon wants to make it easy for users to navigate to the other worksheets. Add links to other places in the workbook as follows: In cell B4, insert a link to cell A1 of the Clients worksheet. In cell B5, insert a link to cell A1 of the Projects worksheet. In cell B6, insert a link to cell A1 of the Invoices worksheet. Woon also wants users to be able to access information about completed projects as they start working on new ones. Woon stores the completed project data in an Excel workbook. Add a link to the file as follows: In cell C4, insert a link to the file Support_EX19_10b_Completed.xlsx. Add the following text as a ScreenTip that explains what happens when users click the link: Open a workbook of past project data. WebSmith displays their work for clients on their website. In cell C5, add a link to the www.ws.example.com website. Woon wants to include a way that users can request help from the technical support firm the company uses. In cell C6, add a link to the info@support.example.com email address. Woon's plan is that when users click the Add Client button in cell C1, 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: Enable all macros in the workbook (if necessary), and then display the Developer tab on the ribbon. Begin recording a macro stored in this workbook using Add_Client as the name of the macro. Display the Clients worksheet, and then add a new blank record to the end of the Client table. Stop recording the macro. 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. Woon has already created similar macros to add a new project record and a new invoice record. Return to the Home Page worksheet, and then assign the macros to buttons as follows: Assign the Add_Project macro to the Add Project button. Assign the Add_Invoice macro to the Add Invoice button. Go to the Clients worksheet. Woon wants to create PivotTables that include client, project, and invoice data. She already added the tables containing this data to the Data Model. Woon wants to list and total each project amount by city and signing date. Create a PivotTable that displays this information as follows: Use Power Pivot to create a PivotTable on a new worksheet, using Projects by City as the name of the worksheet. Display the City field values from the Client table data source as row headings. Display the SigningDate field values from the Project table data source as column headings. Add the ProjectAmt field from the Project table data source to the Values area to sum the field values. Group the signing dates to display them as years and quarters only. (Hint: Expand the year headings to display the quarter headings, if necessary.) Woon also wants to list the paid and unpaid invoices for each month and then filter them by project type. Create a PivotTable that displays this information as follows: Use Power Pivot to create a PivotTable on a new worksheet, using Invoices by Month as the name of the worksheet. Display the SigningDate field values from the Project table data source as row headings. Display the InvoicePaid field values from the Invoice table data source as column headings. Sum the InvoiceAmt field values from the Invoice table data source. Use the ProjectType field from the Project table data source as a #samproject1b #samprojects #cengageassignments #SC_EX19_10b #SC_EXCEL #excel_assignments #excel_sam_projects #Module10SamProjectb #websmith #shelly_cashman_excel #SC_EX19_10b_FirstLastName_1.xlsx #SC_EX19_10b_FirstLastName_2.xlsx