Youtor
Exp22ExcelCh11ML2Donors Exp22 Excel Ch11 ML2 Donors Complete Solution 100
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=4E2uS-iyyRE
Exp22_Excel_Ch11_ML2_Donors | Exp22 Excel Ch11 ML2 Donors | Complete Solution 100% • #Exp22_Excel_Ch11_ML2_Donors #Excel_Ch11_ML2_Donors #Ch11_ML2_Donors #ML2_Donors #Exp22ExcelCh11ML2Donors #ExcelCh11ML2Donors #Ch11ML2Donors #ML2Donors #Exp22_Excel_Ch11_ML2_Donors #Excel_Ch11_ML2_Donors #Ch11_ML2_Donors #ML2_Donors #Exp22ExcelCh11ML2Donors #ExcelCh11ML2Donors #Ch11ML2Donors #ML2Donors • • Contact Me: • • WhatsApp : +92 3706149511 • Gmail : [email protected] • Direct WhatsApp Link: • https://tinyurl.com/mpw3wwzk • • • • #Exp22_Excel_Ch11_ML2_Donors | Exp22 Excel Ch11 ML2 Donors • #Exp22_Excel_Ch11_ML2_Donors • #Excel_Ch11_ML2_Donors • #Ch11_ML2_Donors • #ML2_Donors • #Donors • #Exp22 Excel Ch11 ML2 Donors • #Excel Ch11 ML2 Donors • #Ch11 ML2 Donors • #ML2 Donors • • Project Description: • You are a development officer for a university. 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. • 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.
#############################
