A Development Officer

You are a development officer for a state university. As an officer, you manage a portfolio of important donors who contribute financially to different areas within the university. You categorize the donors based on the college or school for which they want their donations associated. You recently downloaded the portfolio to an Excel workbook. Based on the way the data downloads from the main database, you want to format the text for readability and to make it easier for you to analyze. In addition, you will create an advanced filter to review a list of donors for a particular college or school. Finally, you want to create a look up area to look up data for a specific donor and create a summary section.2The first column displays the name of the college or school (such as ART or BUSINESS) associated with each. You want to assign a three-character code for each college and use that code to attach to existing donor IDs to create a unique field.In cell B8, insert the LEFT function to extract the first three characters from the college name in cell A8. Copy the function to the range B9:B35.3You now want to combine the college ID and donor ID.In cell D8, insert the CONCAT function to combine the college ID in cell B8 with the donor ID in cell C8 with a hyphen between the two text strings. Copy the function to the range D9:D35.4In cell J8, insert a text function that displays the college name from cell A8 with just the first letter capitalized, such as Engineering. Copy the function to the range J9:J35.5The Full Name column displays last and first names of the donors. You want to display last names only in a separate column.In cell F8, type Schneider and use Flash Fill to fill in the last names for the donors in the range F9:F35.

Don't use plagiarized sources. Get Your Custom Essay on
A Development Officer
From $8/Page
Order Essay
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 20% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Toptutor4me
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 10k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Group Dynamics
Great job. I appreciate it.
Customer 452521, November 22nd, 2021
Other
I appreciate the help.
Customer 452567, March 18th, 2022
Nursing
Excellent!!! Thank you.
Customer 452487, September 13th, 2021
Healthcare Writing & Communications
Perfect! Thank you for also remembering to highlight the necessary words. Appreciate all of your help and hard work!
Customer 452483, November 7th, 2021
Nursing
Excellent job! super recommended.
Customer 452487, August 24th, 2021
English 101
Perfect! Very informative! Appreciate all of your hard work! Thank you very much.
Customer 452483, September 22nd, 2021
Psychology
Thank you for all of your help and hard work, truly appreciate you guys always being there with my hectic schedule. Thank you again!
Customer 452483, September 20th, 2021
Nursing
Good job! Thank you
Customer 452487, October 17th, 2021
Psychology
Thank you so much for all of your hard work & help! It’s perfect! Appreciate it!!
Customer 452483, September 11th, 2021
English 101
Thank you guys for always being there and helping me always get a 100% on my assignments!
Customer 452483, August 16th, 2021
English 101
Perfect! Thank you so much for all of your hard work and help! Appreciate it!!
Customer 452483, August 30th, 2021
Psychology
On point! Appreciate all the hard work!!
Customer 452483, August 16th, 2021
1159
Customer reviews in total
96%
Current satisfaction rate
2 pages
Average paper length
47%
Customers referred by a friend
OUR GIFT TO YOU
20% OFF your first order
Use a coupon 24/7HELP and enjoy expert help with any task at the most affordable price.
Claim my 20% OFF Order in Chat
Open chat
Chat with us Live Here
Get in Touch with Our Live Chat Agents via WhatsApp on +1(346) 416-0954. Get Unlimited Access to Answers on Any Queries With Your Paper.