One thing you will want to do is to manage the data contained in your sheet. Some sheets are like databases in that each row contains related information about something (eg cell 1 contains a name, cell2-4 the address, cell5 a phone number). This row is known as a record. Instead of scrolling through the list it is much more convenient to let the computer search for you.
So, you might want to look up the details for all the Jones's living in Anytown, or all the companies in London or a list of all accountants with over 200 employees. The search facility can be quite powerful and complex searches can often be constructed, perhaps involving multiple search criteria. The computer gathers the information much quicker than you can - especially if there are several thousand records.
As data is entered more or less in random order the ability to sort into a particular order can come in handy. Examples of spreadsheets where this is useful are directories, listings of overdue accounts, popular products.
Sorting can usually be carried out on more than one column or key. For example, employees might be sorted into name and then department. You would specify name as the primary key.
Macros can be custom written code or they can just be a record of keystrokes or actions. The macro can be invoked and the actions carried out. I can be associated with a remote set of cells so as not to interfere with the worksheet labels and values. Each macro has its own unique name.
Spreadsheet intro The Display Basics Formulas
Home Music Wordprocessing Databases Education Glossary Bibliography Contact