Exp22_Excel_Ch11_ML2_Donors | Exp22 Excel Ch11 ML2 Donors | How to do Exp22_Excel_Ch11_ML2_Donors

Contact Me For Help in Your Assignments and Courses
WhatsApp : +923209088014
Email : myitlabservice@gmail.com
WhatsApp Direct Link :https://wa.me/923209088014

Tired of MYITLAB hurdles? Welcome to your digital toolbox! This channel breaks down MyITLab's features into bite-sized, practical tutorials. We'll show you how to conquer assignments, master software skills, and troubleshoot common issues. Think of us as your personal IT tutor, always ready to simplify the complex and empower you to succeed.

We can do complete MyITLab course , Microsoft Word ,Microsoft PowerPoint , Microsoft Excel , Microsoft Access.

#Exp22_Excel_Ch11_ML2_Donors
#Exp22 Excel Ch11 ML2 Donors
#Exp22ExcelCh11ML2Donors
#exp22_excel_ch11_ml2_donors
#exp22 excel ch11 ml2 donors
#exp22excelch11ml2donors
#Ch11_ML2_Donors
#Ch11 ML2 Donors
#Ch11ML2Donors
#ch11_ml2_donors
#ch11 ml2 donors
#ch11ml2donors
#Excel_Training
#Excel Training
#Excel_training
#excel_training
#excel_Training
#exceltraining
#exceltraining

Steps to Perform:
Step Instructions
1 Start Excel. Download and open the file named Exp22_Excel_Ch11_ML2_Donors.xlsx. Grader has automatically added your last name to the beginning of the filename.
2 Use the Donors worksheet through Step 13. The 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 B7, insert the LEFT function to extract the first three characters from the college name in cell A7. Copy the function to the range B8:B34.
3 The Full Name column displays last and first names of the donors. You want to display last names only in a separate column.

In cell E7, type Schneider and use Flash Fill to fill in the last names for the donors in the range E8:E34.
4 The Address column contains street addresses, city names, and state abbreviations. To manage the address list better, you will separate the data into three columns.

Select the addresses in the range F7:F34 and convert the text to columns, separating the data at commas. Deselect other delimiters.
5 The college and school names display in all capital letters in column A. You want to display the names in upper- and lowercase.

In cell I7, insert a text function that displays the college name from cell A7 with just the first letter capitalized, such as Engineering. Copy the function to the range I8:I34.
6 To analyze the donor records, you are ready to create criteria and output ranges. You will enter conditions to find records for donors to the College of Business who donated $15,000 or more.

Copy the range A6:J6 to cell A37 to create the column labels for the criteria range. Type Business in cell I38 and less than or equal to 15000 in cell J38.
7 You are ready to create the output area and perform the advanced filter.

Copy the column labels from the range A37:J37 to cell A41 to create the column labels for the output range. Perform the advanced filter by copying the records to the output area.
8 Now that you created a copy of the records meeting the conditions, you are ready to enter database functions in the Summary area.

In cell J2, insert the database function to total the value of the donations for the records that meet the conditions in the criteria range you created in Step 6.

In cell J2, insert the database function to total the value of the donations for the records that meet the conditions in the criteria range you created in Step 6. 5
9 In cell J3, insert the database function to calculate the average donation for the records that meet the conditions in the criteria range that you created in Step 6. 5
10 In cell J4, insert the database function to count the number of records that meet the conditions in the criteria range that you created in Step 6. 5
11 You want to display an alphabetical list of each state abbreviation.

In cell L2, insert a SORT function with a nested UNIQUE function to display an alphabetical list of state abbreviations in the range H7:H34. 5
12 Now you want to display a list of state abbreviations that occur only once within the dataset.

In cell M2, insert the UNIQUE function to display a list of state abbreviations that occur only once within the range H7:H34. 5
13 You want to use a function that extracts data from another worksheet based on the school or college name entered in cell B2. The data entered in cell B2 must match an existing worksheet name: Art, Business, or Engineering.
#Exp22_Excel_Ch11_ML2_Donors
#Exp22 Excel Ch11 ML2 Donors
#Exp22ExcelCh11ML2Donors
#exp22_excel_ch11_ml2_donors
#exp22 excel ch11 ml2 donors
#exp22excelch11ml2donors
#Ch11_ML2_Donors
#Ch11 ML2 Donors
#Ch11ML2Donors
#ch11_ml2_donors
#ch11 ml2 donors
#ch11ml2donors
#Excel_Training
#Excel Training
#Excel_training
#excel_training
#excel_Training
#exceltraining
#exceltraining

Видео Exp22_Excel_Ch11_ML2_Donors | Exp22 Excel Ch11 ML2 Donors | How to do Exp22_Excel_Ch11_ML2_Donors канала MyITLAB Service