Shelly Cashman Excel 365 | Module 10: SAM Project B Support Central скачать в хорошем качестве

Shelly Cashman Excel 365 | Module 10: SAM Project B Support Central

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/4B6NMKKBK... 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 365 | Module 10: SAM Project B Support Central PROJECT STEPS Kalen Goodrich is a development specialist for Support Central, a consortium of nonprofit organizations in Florida with headquarters in Tampa. Kalen is developing an Excel workbook to use for tracking and interpreting data about members, events, and donations. 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. Kalen 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 B4, and then apply bold formatting and a 14-point font size to indicate the text is a list heading. Kalen asks you to make it easy to navigate to the other worksheets. Add links to other places in the workbook as follows: In cell B5, insert a link to cell A1 of the Members worksheet. In cell B6, insert a link to cell A1 of the Events worksheet. In cell B7, insert a link to cell A1 of the Donations worksheet. Kalen also needs to be able to access data about past donations as he prepares to contact donors. He stores the past donation data in an Excel workbook. Add a link to the file as follows: In cell B8, insert a link to the file Support_EX365_10B_Archive.xlsx. Add the following text as a ScreenTip that explains what happens when users click the link: Display donations from previous years. The Support Central website provides information the organization managers use every day. In cell B9, add a link to the www.sc.example.com website. Kalen also wants you to include a way that he and other managers can request information from Support Central satellite offices. In cell B10, add a link to the info@sc.example.com email address. Kalen's plan is that when users click the New Member button on the Home Page worksheet, the Members worksheet opens and Excel adds a new, blank record to the Member table, where users can insert the new member information. Record a macro to automate the New Member button as follows: Enable all macros in the workbook, and then display the Developer tab on the ribbon. Record a macro stored in this workbook using Add_Member as the name of the macro. While recording the macro, display the Members worksheet. Also, while recording the macro, add a new blank record to the end of the Member table. Stop recording the macro. Assign the Add_Member macro to the New Member button on the Home Page worksheet and then run the Add_Member macro to make sure it inserts a new record at the bottom of the Member table on the Members worksheet. Kalen has already created similar macros to add a new event record and a new donation record. Return to the Home Page worksheet and assign the macros to buttons as follows: Assign the Add_Event macro to the New Event button. Assign the Add_Donation macro to the New Donation button. Go to the Members worksheet. Kalen wants you to create PivotTables that include member, event, and donation data. He already added the tables containing this data to the Data Model. Kalen asks you to list and total the funds raised for each event by city and start date. Create a PivotTable that displays this information as follows: Use Power Pivot to create a PivotTable on a new worksheet, using Events by City as the name of the worksheet. Display the City field values from the Member data source as row headings. Display the StartDate field values from the Event data source as column headings. Add the FundsRaised field from the Event data source to the Values area to sum the field values. (Ignore the alert that states "Relationships between tables may be needed." because these relationships will be created in a later step.) Group the start dates to display them as years and quarters only. (Hint: If necessary, remove any extra StartDate field appearing in the Columns area.) Format the PivotTable on the Events by City worksheet as follows to make it easier to interpret: Expand the year headings to display the quarter headings. Display the FundsRaised values using the Currency format with 0 decimal places and th #samproject1b #samprojects #cengageassignments #SC_EX365_10b #SC_EXCEL #excel_assignments #excel_sam_projects #Module10SamProjectb #support_central #shelly_cashman_excel #SC_EX365_10b_FirstLastName_1.xlsx #SC_EX365_10b_FirstLastName_2.xlsx