Join Dennis Taylor for an in-depth discussion in this video Challenge: Reorder names in an employee list, part of The 5-Day Excel Challenge.
- View Offline
- On Day 2, the Objectives for our…5-Day Excel Challenge course begin with…opening the relevant file, the Excel Challenge 2 workbook.…There are two sheets in it, Employees 1, Employees 2.…The first objective will be, on that Employees 1 worksheet,…sort the names to appear as Hayes, Edward.…As we look at this workbook on the Employees 1 sheet,…recognize the names are in first name last name order.…We want the names to look like Hayes, Edward.…So we need to manipulate the data in Column A,…in order to achieve that objective of sorting this list…based on the names in Column A in reverse order,…last name, first name.…
Our second objective is, on the Employees 2 worksheet,…to do essentially the same thing,…however, it's a little different.…Some of the names have middle initials or middle names,…and you can see on the Employees 2 sheet…where that's the case with Edward P. Hayes…and Nathaniel R. Nichols and certainly some others.…Similar challenge, we need to sort this list by last name,…but on the Employees 2 sheet,…
The challenges will ask you to:
- Generate a list of future dates
- Clean up a list of employee data
- Create a dynamic chart
- Create a pivot table to analyze sales data
- Match data across multiple lists
Starter and solution files for Excel 2010, 2013, 365, and Excel for Mac 2011 are provided in the exercise files, so you can follow along with your version of Excel.