O'Reilly logo

Microsoft® Office Excel® 2013: Part 1, 2nd Edition by Tim Barnosky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ACTIVITY 3-2: Searching for and Replacing Data

Before You Begin

The my_sales_data.xlsx file is open.

Scenario

You have received notification from the human resources department that one of your sales reps has been transferred to a different region, and another was recently married and has changed her name. You decide to use the Find command to locate the employee information without having to manually search the worksheet so you can update the records. Additionally, My Footprint Sports has recently consolidated the sales teams from two regions into one. You realize it would be easier to use the Replace command to update all of the records at once rather than to do so one at a time.

  1. Change the regional information for the transferred ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required