Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly.

By the end of this workshop, you should be able to:

• Explain common database definitions and terms
• List examples of Excel databases
• Understand limitations of using Excel as a database
• Explain types of data stored in Excel
• Import text data into an Excel worksheet
• Export an Excel worksheet to a text file
• Set up a table in Excel
• Use the VLOOKUP function to lookup data
• Use the HLOOKUP function to lookup data
• Use MACTH and INDEX functions to perform a dynamic search
• Use Excel database functions such as DGET and DCOUNT
• Use Autofill
• Use Autocomplete
• Sort and Filter data
• Transpose data from rows to columns
• Use the Text to Columns feature
• Check for duplicate data
• Create data validation rules
• Consolidate data
• Group data
• Add subtotal rows to a list
• Explain the use of the SUBTOTAL function
• Outline data
• Work with data forms