Microsoft Excel - Database – An Introduction
Course Duration: 90 Minutes
Target Audience:
This session will explain the concept of Databases within Excel. It will ensure the participant is comfortable managing and analysing large blocks of data.
Course Objectives:
To be able to create and manage a database in an Excel file. Apply sorts and filters to data. Convert a database list to a Table and manage table functionality.
Course Outline:
Introduction and Overview
CONTENT
Creating and Managing a Database
-
Creating and setting up a database
-
Using the Sort facility
-
Using the AutoFilter facility
-
Creating a custom filter
Convert a Database to a Table
-
Using a Table
-
Formula and Format functionality within a table