Microsoft Office Tutorials and References
In Depth Information
Chapter 5: Focusing on specific data by using filters
Focusing on specific
data by using filters
IN THIS CHAPTER, YOU WILL LEARN HOW TO
▪ Limit data that appears on your screen.
▪ Filter Excel table data by using slicers.
▪ Manipulate worksheet data.
▪ Define valid sets of values for ranges of cells.
With Microsoft Excel 2013, you can manage huge data collections, but storing more than
1 million rows of data doesn’t help you make business decisions unless you have the ability
to focus on the most important data in a worksheet. Focusing on the most relevant data in
a worksheet facilitates decision making, whether that data represents the 10 busiest days
in a month or revenue streams that you might need to reevaluate. Excel offers a number of
powerful and flexible tools with which you can limit the data displayed in your worksheet.
When your worksheet displays the subset of data you need to make a decision, you can
perform calculations on that data. You can discover what percentage of monthly revenue
was earned in the 10 best days in the month, find your total revenue for particular days of
the week, or locate the slowest business day of the month.
Just as you can limit the data displayed by your worksheets, you can create validation rules
that limit the data entered into them as well. By setting rules for data entered into cells, you
can catch many of the most common data entry errors, such as entering values that are too
small or too large, or attempting to enter a word in a cell that requires a number. If you add
a validation rule to worksheet cells after data has been entered into them, you can circle
any invalid data so that you know what to correct.
In this chapter, you’ll limit the data that appears on your screen, manipulate worksheet data,
and create validation rules that limit data entry to appropriate values.