From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Search for data within a workbook
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Search for data within a workbook
- [Instructor] While working with your data in Excel, it's helpful if you know how to quickly find the information you want to work with. After watching this video, you'll know how to search for data using find and replace. Let's jump right in to our search workbook and take a look at the information included on each of our worksheets. First, we have quarter one internet orders. And it looks like I have other tabs that I can access using the navigation buttons. But, if I click on this vertical dotted line and hold my mouse down, I can decrease the width of my scroll bar and be able to see all of my worksheets at the same time. We also have product information, information on our sales reps, and 2019 commission. I'd like to quickly find the information regarding order status. I can use control F for find on my keyboard and find order status. It doesn't matter if it's upper and lower case as long as I do not have match case selected. Let's have Excel find the first instance of order…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
(Locked)
Import TXT or CSV data into an existing workbook3m 7s
-
(Locked)
Search for data within a workbook2m 36s
-
(Locked)
Navigate data with named ranges and hyperlinks5m 27s
-
(Locked)
Format worksheets and workbooks5m 1s
-
(Locked)
Customize headers and footers4m 37s
-
(Locked)
Display and modify content in different views5m
-
(Locked)
Modify basic workbook properties2m 33s
-
(Locked)
Customize the Quick Access Toolbar3m 55s
-
(Locked)
Inspect and export workbooks6m 33s
-
(Locked)
Configure print settings4m 15s
-
(Locked)
Challenge: Manage worksheets and workbooks1m 10s
-
(Locked)
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-