Join Dennis Taylor for an in-depth discussion in this video Finding and replacing data, part of Excel 2013 Essential Training.
On the Home tab in the ribbon the editing group on the right-hand side contains…a number of features including a binoculars icon for Find & Select.…Some of the things we're about to show you in this movie could be done more…efficiently with a filter, but not always.…Sometimes we're simply looking for data.…Let's imagine that we're looking for somebody named Rick.…Before searching for data in Excel it's best to narrow down the search.…If you click a single cell and then activate the Find feature, you will…automatically be looking in the entire worksheet.…
If you select a range--possibly you have this range already selected for…a different reason--…if you start a Find now, we're only looking for data within the range.…Now let's say we are looking for someone named Rick.…The only location in this worksheet where we see names like that is column A.…Let's go to column A, select that first, and now our search process using Find will…only be looking in column A. Notice it's "Find and Replace".…We're simply going to do Find here.…
Author
Released
1/29/2013- What is Excel and what is it used for?
- Using the menus
- Working with dates and times
- Creating simple formulas
- Formatting fonts, row and column sizes, borders, and more
- Inserting shapes, arrows, and other graphics
- Adding and deleting rows and columns
- Hiding data
- Moving, copying, and pasting
- Sorting and filtering data
- Printing your worksheet
- Securing your workbooks
- Tracking changes
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced -
Excel 2013 Tips and Tricks
with Dennis Taylor4h 34m Intermediate -
Excel 2016: Cleaning Up Your Data
with Dennis Taylor2h 26m Intermediate
-
Introduction
-
Welcome39s
-
-
1. Getting Started with Excel 2013
-
What is Excel used for?1m 49s
-
Using the menu system4m 30s
-
The Quick Access Toolbar4m 41s
-
Using the Formula bar1m 43s
-
Using the Status bar2m 24s
-
Using the built-in help2m 54s
-
Creating new files2m 11s
-
-
2. Entering Data
-
Working with dates and times3m 32s
-
Using Undo and Redo4m 50s
-
Adding comments2m 55s
-
Using Save or Save As3m 57s
-
3. Creating Formulas and Functions
-
Using SUM and AVERAGE3m 25s
-
4. Formatting
-
Designing borders3m 26s
-
Formatting numbers and dates4m 31s
-
Conditional formatting4m 21s
-
Creating and using tables9m 59s
-
5. Adjusting Worksheet Layout and Data
-
6. Printing
-
Previewing page breaks4m 56s
-
7. Introduction to Charting
-
Creating charts4m 36s
-
Exploring chart types7m 47s
-
Formatting charts5m 42s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks2m 40s
-
Sharing workbooks4m 7s
-
Tracking changes4m 32s
-
12. Database Features
-
Sorting data6m 9s
-
Using filters6m 16s
-
Removing duplicate records2m 38s
-
-
13. PivotTables
-
Creating PivotTables8m 36s
-
Manipulating PivotTable data9m 47s
-
Grouping by other factors2m 33s
-
Using PivotCharts3m 59s
-
-
14. Data Analysis Tools
-
Using Goal Seek6m 8s
-
Using Solver6m 34s
-
Using Scenario Manager6m 11s
-
Using Data Tables4m 36s
-
-
15. Introduction to Macros
-
Definition and examples6m 48s
-
Running a macro10m 43s
-
-
Conclusion
-
Next steps29s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Finding and replacing data