VOices Blog Members Home Events Shopping Cart
Skip to main content
VOices
posted on Aug 16, 2018
excel%2bbasics-350px.jpg

Excel is a great tool for managing data, defined as “facts and statistics collected together for reference or analysis.” [1] Data can be numbers or text. Numbers can tell how much or how many, measure cost, or indicate the date and time. Text can be short codes, full words, phrases, addresses, phone numbers – basically, anything which can’t be counted is text.

Find Data: One at a Time

To find a specific piece of data, e.g. a person's name, click anywhere in your sheet, then click CTRL-F. Enter in the number or text you want to look for.

Note that Excel defaults to finding any cell which contains that number or text anywhere in the cell. For example, if you search for "Toronto", you will also be sent to cells which contain "Metro Toronto," "Greater Toronto Area," "Torontonian," etc.

Excel_Data_Manip_-_9.PNG

Click Find Next to find the first cell which contains that data. Keep clicking to find subsequent cells.

Excel_Data_Manip_-_10.PNG

Alternately, if you want to know the locations of all cells containing that data, then click Find All.

Excel_Data_Manip_-_11.PNG

Find Data using Filters

Excel has an Auto-Filter which is likely to do a lot of what you need, with just a couple of clicks.

1. Select your header row. Note that you can only select ONE row.

Excel_Data_Manip_-_1.png

2. Click Data → Filter

Excel_Data_Manip_-_2.png

3. Now you will see drop-down arrows appear next to every header. Click on one of the drop-downs. (in the example, I clicked the “province” dropdown)

Excel_Data_Manip_-_3.png

(a) You can sort the table by this column. Click one of the top three choices.

(b) You can select or deselect any values. Say you want to see everyone who is based in BC. Click Select All to deselect the whole list, then click BC.

Excel_Data_Manip_-_4.png

Excel_Data_Manip_-_5.PNG

(c) Let’s say you want to find out who in your list has a Hotmail account. You can use text filter to find that out. Click the Email dropdown, then Text Filters.

Excel_Data_Manip_-_6.png

To find everyone with a Hotmail account, you want to find every cell in the Email column which contains the word Hotmail.

Excel_Data_Manip_-_7.PNG

Note that we now have two filters: BC and Hotmail. You can see which columns are filtered because they have a filter icon in the dropdown box.

Excel_Data_Manip_-_8.png

To remove a filter, click the dropdown for that column and click Select All.

If you have a lot of filters which you want to reset all at once, the easiest way is to click Data → Filter to toggle the filtering off. Then go back to step one if you want to start filtering afresh.

The filter function can also be used to sort data. See our previous blog post to learn more about data sorting.

Learn More

To learn more about Excel, come to one of our courses

Excel 101

Excel 101 will help you bone up on the basics.

Click here to register Wednesday, September 19, 2018. 9:00 a.m. to 12:00 p.m.

Click here to register Wednesday, October 3, 2018. 9:00 a.m. to 12:00 p.m.

Excel 201

Excel 201 is for intermediate users who are ready to take their skills to the next level. In this course, we cover pivot tables, charts, and data substitution.

Click here to register Wednesday, October 31, 2018. 9:00 a.m. to 12:00 p.m.

Like what you've read? Subscribe to our RSS feed so you never miss a post! We have a general RSS Feed for all VOices blog posts, as well as an Operations RSS Feed which will focus on topics related to organizational operations.

Related Blog Posts:

 

Filed under: Operations
new comment comment
view archives archives
RSS rss