Excel - managing databases	Download the course outline in PDF format

Course objectives

At the end of the course participants will be able to:

• Create databases in Microsoft Excel
• Move about the database and find data
• Do’s and Do nots of  creating databases in Excel
• Perform calculations on data by using functions and formulas
• Filter a database in Excel
• Work with Pivot Tables and Sub Totals to generate calculations

Course topics

Pre-requisites

Introduction to Microsoft Excel or have a good understanding of the basic features of Microsoft Excel.

Course duration

1/2 day