You are a volunteer for Health Right, a nonprofit company that provides free physical fitness classes to schools that do not have a physical education facility. As part of your duties, you generate weekly reports that detail donation pledge calls placed, as well as pledge dollars received. You also maintain pledge drive agent personal information and manage the thank-you gifts agents receive for volunteering their time. This week you have decided to overhaul your report by updating agent contact information, importing data previously stored outside your old report, implementing a PivotTable using Power Pivot, and utilize Power-Add-Ins to edit and visualize the week’s data.
Start Excel. Download and open the file named Exp19_Excel_Ch10_HOEAssessment – PledgeDrive.xlsx. Grader has automatically added your last name to the beginning of the filename.
Use Get & Transform (Power Query) to load the file e10c2VolunteerInfo.csv in the Power Query Editor. Use the Power Query Editor to split column D into three separate columns for City, State, and Zip using comma as the delimiter. Edit the city.state.zip1 column heading to City, city.state.zip2 to State, and city.state.zip3 to Zip then load the data to the existing worksheet.
Rename the worksheet Volunteer Information.
Set the External Data Range Properties to Refresh data when opening the file.
Use Get & Transfrom (Power Query) to load the Pledge table from xml file e10c2Rewards.xml into a new worksheet. Be sure to add the information to the data model.
Rename the worksheet Rewards.
Apply Accounting Number Format to the dollar amounts imported into column A.
Use Get & Transform (Power Query) to load the Contacts table from the file e10c2Contacts.accdb in the Power Query Editor. Use the Power Query Editor to remove the Income and Dependents fields then load the data in a new worksheet.
Rename the worksheet Pledge Leads.
Use Power Pivot to import the Transactions table from the Access database e10c1PledgeDollars.accdb into a PivotTable. Place the PivotTable on a new worksheet named Pledge Dollars. Add the Date field to the Filters area, add Operator_ID to the Rows area, and add Pledge_Amount to the Values area. Save the workbook.
Create a relationship between the Operator_ID in the Transactions table and the Operator_ID in the Volunteer Information worksheet.
Insert a 3D Map (Power Map) using the Volunteer Information zip code (Zip) as the location dimension, Pledge_Amount as the height dimension, and Operator_ID as the category dimension. Zoom the plot area as needed to display results.
Save and close the file. Submit Exp19_Excel_Ch10_HOEAssessment – PledgeDrive.xlsx as directed.
Why Choose Us
We value our clients. For this reason, we ensure that each paper is written carefully as per the instructions provided by the client. Our editing team also checks all the papers to ensure that they have been completed as per the expectations.
Professional Academic Writers
Over the years, our Acme Homework has managed to secure the most qualified, reliable and experienced team of writers. The company has also ensured continued training and development of the team members to ensure that it keep up with the rising Academic Trends.
Our prices are fairly priced in such a way that ensures affordability. Additionally, you can get a free price quotation by clicking on the "Place Order" button.
We pay strict attention on deadlines. For this reason, we ensure that all papers are submitted earlier, even before the deadline indicated by the customer. For this reason, the client can go through the work and review everything.
At Buy An Essay, all papers are plagiarism-free as they are written from scratch. We have taken strict measures to ensure that there is no similarity on all papers and that citations are included as per the standards set.
Customer Support 24/7
Our support team is readily available to provide any guidance/help on our platform at any time of the day/night. Feel free to contact us via the Chat window or support email: email@example.com.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Buy An Essay has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.
At Buy An Essay, we prioritize on all aspects that bring about a good grade such as impeccable grammar, proper structure, zero-plagiarism and conformance to guidelines. Our experienced team of writers will help you completed your essays and other assignments.
Admission and Business Papers
Be assured that you’ll definitely get accepted to the Master’s level program at any university once you enter all the details in the order form. We won’t leave you here; we will also help you secure a good position in your aspired workplace by creating an outstanding resume or portfolio once you place an order.
Editing and Proofreading
Our skilled editing and writing team will help you restructure you paper, paraphrase, correct grammar and replace plagiarized sections on your paper just on time. The service is geared toward eliminating any mistakes and rather enhancing better quality.
We have writers in almost all fields including the most technical fields. You don’t have to worry about the complexity of your paper. Simply enter as much details as possible in the place order section.