The AutoFilter feature is shown. This function will allow you to find specific information in a list, rather than having to scan the entire list. Keep good notes on this item, as you will need to use it to complete part of your course project following the fourth unit of this course. You will learn to retrieve data from a database using various queries. List instructions for use of MSQuery and QueryWizard to extract fields from external databases and then return the data to Excel.
Detailed notes are essential, as a great deal of new material is covered.
The fourth lesson shows you how to use workgroup capabilities. You will learn to set up and monitor the sharing of Excel workbooks so that more than one person can work on the workbook simultaneously. Also, you will be shown the proper sequence of steps necessary to create shared workbooks and resolve conflicts over modifications to a cell. When conflicts arise over certain changes to a cell and you cannot decide whether to accept the changes, just save the file under a different file name. This will allow you to save the original document as well as the suggestions under question until you decide what changes to make.