MS EXCEL 2003 – INTERMEDIATE

MS EXCEL 2003 – INTERMEDIATE

BY: GLOBALKNOWLEDGE PHILIPPINES, INC.

Duration: 1 Day

Venue: In-house or Off-site

Schedule: Open for Enrollment(SEtp 11/25, Oct 12/26, Nov 9/23, Dec 15/19)

Course Outline

Working With Functions And Formulas
Using Formulas In Excel
Understanding Relative And Absolute Cell References
The Basic Mathematical Operators
Using Formulas With Multiple Cell References
The Formula Auditing Bar
Fixing Formula Errors
Displaying And Printing Formulas
Practice Exercise
Exploring Excel Functions
What Are Functions?
Finding The Right Function
Some Useful And Simple Functions
Practice Exercise
Using Functions In Excel
Inserting Functions
Using Functions And Autofill To Perform Difficult Calculations
Using The If Function
Working With Nested Functions
Practice Exercise
Working With Names And Ranges
What Are Range Names?
Defining And Using Range Names
Selecting Nonadjacent Ranges
What Is Auto Calculate?
Practice Exercise
Working With Array Formulas
What Are Array Formulas
Using Basic Array Formulas
Using Functions With Array Formulas
Using The If Function In Array Formulas
Practice Exercise
Review Questions

Managing Lists
Working With Lists
What Is A List?
Creating Lists
Modifying Lists
What Is The Total Row?
Practice Exercise
Working With Records And Fields
What Are Records And Fields?
Adding Fields By Inserting Columns
Adding Records By Inserting Rows
Adding Records With A Data Form
Finding And Deleting Records
Practice Exercise
Working With Lists And Filters
Sorting A List
What Is An Autofilter
Custom Autofilters
Using An Advanced Filter
Copying Filtered Records
Practice Exercise
Using Excel As A Database
Filtering With Wild Card Characters
Validating Your Data
What Are Database Functions?
What Are Lookup Functions?
Practice Exercise
Review Questions

Working With Macros And Controls
Creating Macros In Excel
What Is A Macro?
Creating A Macro
Playing A Macro
Assigning A Shortcut Key To Macro
Macros, Buttons, And Toolbars
Practice Exercise
Excel Form Controls
What Is A Form Control?
The Form Toolbar
Adding A Control To A Worksheet
Assigning A Macro To A Control
Using Form Controls
Practice Exercise
Review Questions

Using Excel With Other Programs
Using Excel In Word
Inserting Excel Data In Word
Modifying Excel Data After Insertion
Linking Excel Data In Word
Linking An Excel Chart In Word
Practice Exercise
Using Excel With Other Programs And Files
Using Outlook To Send Excel Data
Opening An Excel File In A Different Format
Importing Data From A Text File
Importing Data From A Database
Practice Exercise
Review Questions

Enroll Now!

GLOBALKNOWLEDGE PHILIPPINES, INC.

                unit 107 g/f, beacon plaza. cor.ideal st, shaw blvd mandaluyong city

                                       Tel No. 721-4380/393-8400

Email: roselle@globalknowledgeph.com; rosellereig@gmail.com