ianfraserconsulting - Learning and Development Consultants

Excel - Managing Databases

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

Rules of creating a Database

• Elements of a Database
• Create an Excel Database
• Do’s
• Don’ts
• Modifying the Database Structure

 Database Tools

• Sorting
• Filtering in Excel
• Calculations for Filtered Lists

 Calculating your Data

• Subtotals
• Pivot Tables
• Other features of Pivot Tables

Pre-requisites

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

Course Duration

1/2 day

Download the course outline in PDF format