"I am convinced that
spreadsheets can be as
useful as tractors on
the modern farm."

-John Clohesy, Author
 


Autofilter

This exercise will introduce you to one of the simplest, and most useful tools in Excel. If you try this exercise, you will be amazed at how versatile and easy to use this tool is. Imagine trying to group your herd records so that all the stock which have given birth in January, and have been given the E Coli jab, are shown together. This tool will do it for you easily. If you want to restore your confidence in what the computer can do for you, this is the exercise for you!

To download the instructions, click any of the following links. You are welcome to use these resources for your own use or for teaching. Feel free to adapt and update them.

Autofilter.doc  (slow download, but simplest - need MS Word)
Autofilter.pdf   (universally accessible - requires Acrobat
                         Reader)
Autofilter.zip    (WinZip, Word & PDF files - fast download to
                          your computer)

You need Adobe Acrobat Reader for the PDF files and
WinZip for the zipped files.

  
  
 
~Skills Checklist
~Excel Ready Reference
~Skills Summary
 
 
 
 
 
 
 

 

 

 

 

                     

About the Author  |  Project Overview Worksheets  |  Examples Resources  |  FeedbackContact Us  |  Home

                  Copyright © 2003 - 2005, John Clohesy, Brooksby Melton College
                      Designed & Managed by Black Dog Web Design