Excel 2003

Avaal Technology Solutions Inc.
Brampton, Ontario, Canada

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

Course Description:

'' Excel - Chapter 1:

Excel Databases and Data Form
Setting a Single Record with Formulas
Adding Records to a Database
Finding Records
Excel - Chapter 2:

Data Validation
Establishing Data Entry Criteria
Using Formulas and Lists to Restrict Data
Using Data Validation on Existing Data
Data Validation Exclusions
Excel - Chapter 3:

Data Sort
Sorting from a Menu
Sorting from the Toolbar
Multiple-Key Sorting
Sorting Columns
Excel - Chapter 4:

Data Subtotals
Single Level Subtotals
Multiple Level Subtotals
Excel - Chapter 5:

Data Filter
Criteria
Multiple Column
Creating Custom Filter
Copying Formatting and Sorting Data
Using "SUBTOTAL" Function to Count Results
Advanced Filter
Excel - Chapter 6:

Data Functions
"SUMIF", "COUNTIF"
Array Formulas
Database Functions
Excel - Chapter 7:

The IF Function and VLOOKUP
"IF" Functions and Relational Operators
Using Text in "IF" Functions
Logical Operators ("AND" and "OR") with "IF" Functions
Nested "IF" Functions
Getting Table Data with "VLOOKUP" Function
Excel - Chapter 8:

Dates and Time
Using Dates as Values
Entering a Series of Dates
Date/Time Techniques
Excel - Chapter 9:

Understanding Pivot tables and charting
Creating a Dynamic Chart using Pivot Charts
...''

Elements of this syllabus are subject to change.

Phone:1-877-995-1313

School Address/Venue(s):

2 Automatic Road Unit 110,
Brampton Ontario,
L6S 6K8
Canada

Jobs & Resumes: Brampton
Houses & Roommates: Brampton

Search other schools for Excel 2003 training resources.

A+ Certification
A+ Hardware Certification
A+ Software Certification
PC Literacy
Dreamweaver
Asp
Trucking Dispatch Specialist

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: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.