Excel 2016 - Intermediate

Use averageif, countif, sumif, and if to create a summary report. Activity 3: Mailing List – Find and Remove Duplicates. Create a new column to combine first name and last name together (concatenate or flash fill) Create a table. Use conditional formatting to find duplicates. Sort column A-Z. Filter by color. Look closely at duplicates ................
................