TIPS AND TRICKS

Use Excel Filters to Answer Key Questions

Do you need to know who donated $1,000 or more or who sold more than $10,000 last month? Use the filter and display only the rows that meet your criteria while hiding the rows that do not. To filter numbers:

  • Select a range of cells containing the data.
  • On the Data tab, click Filter. Click on the drop down arrow and select numbers and criteria by pointing to Number Filters. Click one of the Comparison Operator commands.
  • In the Custom Auto-Filter dialog box, enter numbers or select numbers from the list.

Use Comparison Operator and Custom Auto-filter to filter using commands such as “between, above, below, equal to, and top 10.” In Excel 2007, you also can filter using colors, an exciting way to present your spreadsheet data.

When making key decisions based on large amounts of data, use the filter to isolate critical data. Use the filter to analyze data trends and patterns and you will be amazed at what you can measure and display!

 

 

USE OUR MS OFFICE FOUR AND EIGHT PACKS AND SAVE!

Share these passes with your colleagues for maximum flexibility!

Special Opportunity for Government Buyers

Call for details and Save


ATTENTION CCC ALUMNI!

Sign up for a second class during 2007 and save 15% off your class tuition.

 

We are proud of your success and want to say CONGRATULATIONS!!