98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Making The Most Of Filtering In Excel
Tue 30th June 2009
Whereas Microsoft Word was a natural progression from the typewriter, the advent of Excel and its ilk was a giant leap from hand-written to typed entries. And yet when my mother's department switched to a computerised system in the late-seventies, many of her colleagues yearned for a return to the manual system. Old habits really do die hard.
I am pretty sure that this yearning would not have lasted very long, however, as employees became accustomed to the new technology and discovered the many advantages of computerised data entry. The ease with which data can be manipulated, and the array of tools that can perform essential tasks will have converted even the most die-hard traditionalist.
Even basic functions that we take very much for granted today, such the Filter command would have been considered major breakthroughs back then, as they can deliver at a stroke on screen what would be very difficult to do by hand.
The Filter tool is a particularly useful function that allows the operator to extract data from a list according to certain criteria. This filtered data can then be manipulated as though it was a distinct group, separated from the list to which it belongs. For example, the operator may wish to send an email to all females on the database, or people from a certain postcode area. In its most basic form, the Filter tool enables the operator to separate selected groups from the main 'database', although more complex tasks can be performed.
To experiment with filtered data: on an open worksheet, select a cell within the list range. Click Data/Filter/AutoFilter. You will see drop-down arrows appear at the head of each column. Click the arrow at the head of the column you want to filter and study the options. You can then select from the drop-down menu the records that you wish to separate from the list. Having done this, you can click on the arrows of other columns to filter out even more records. Returning to the drop-down lists, as well as the contents of the cells in that column, you will see a Top 10 command, and clicking this will display the first ten items in that list (you can also view the bottom ten).
You can carry out more complex searches by clicking the Custom command, although this does introduce more complicated actions, such as searching for records that meet more than one of the criteria, and so it may be better to explore Excel at this level by enrolling on a training course. To remove the filter and return to the full worksheet, simply click Data/Filter/Show All.
Separating certain groups from a list in the old days of hand-written ledgers would be a very time-consuming task that would involve writing a new list. To be able to perform the same task with only a few clicks of the mouse shows the value of familiarising yourself with some of the many useful tools that lie hidden beneath the surface of Excel.
Author is a freelance copywriter. For more information on excel+training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-463-excel-filter-tips.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsThe British Academy
D.noriega@thebritishacademy.ac.uk Desiree N Excel Intermediate Fun, interesting and really well paced class Frankham Consultancy Group Limited
Group Purchase Ledger Clerk Marco Silver Excel Advanced I found the session really useful and will be applying what I have learnt at work. Westmeria Healthcare Ltd
Accounts Assistant Luiza Gjeci Excel Introduction The teacher was very very good. Thank you so much |
PUBLICATION GUIDELINES