Excel Databases

Description

This course is for people who have an intermediate knowledge of Excel and wish to use it to manage data such as lists of residents, birthday lists and databases. Participants should be familiar with Windows and happy with using the mouse, menus and scroll bars.

What you will learn

• Create a List in Excel
• Create a Database in Excel
• Consolidate information from more than one list
• Analyse the information using Excel’s Data menu
• Sort and Filter including the use of Advanced Filters
• Use the Subtotals Command
• Use Pivot Tables to analyse your data