Course Objective:

To equip participants with Database management tools in Excel to handle efficiently and effectively both Finance and non-Finance data

Course Outline:
Eight guidelines for building a Database in Excel

Hands-on Project: Building Database Systems in Excel for Suppliers/Purchases ..Information, Customer/Sales Information, Human Resource data etc.

Data Forms for Data Capture and Data Query

Sorting and Complex sorting

Setting own Sort orders to meet reporting requirements

Automatic Subtotals

Auto filtering, Custom filtering, Multiple filtering etc.

Advanced Filtering

Macros and the Data query system

PivotTables and Pivot Charts

Protecting your Database