Excel - Managing Databases

Ian Fraser Consulting
Melbourne, Victoria, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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.

...''

Phone:(03) 9489 7989

School Address:

Ian Fraser Consulting
10 Wakanui Street
Northcote Victoria 3070
Australia



Jobs & Resumes: Melbourne
Houses & Roommates: Melbourne
Travel Agencies: Melbourne

Search other schools for Excel - Managing Databases training resources.

Adobe Acrobat
Adobe Dreamweaver
Adobe Photoshop
Adobe Illustrator
InDesign CS3
Access Introduction
Access Advanced
Excel Introduction
Excel Advanced
Excel - Formulas and Functions
Frontpage Introduction
Outlook
Powerpoint Introduction
Powerpoint Advanced
Project Advanced
Project Introduction
Publisher
Word Advanced
Word Introduction

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.