MS EXCEL 2003 – FOUNDATION

MS EXCEL 2003 – FOUNDATION

BY: GLOBALKNOWLEDGE PHILIPPINES, INC.

Duration: 1 Day

Course Fee: P2,995 + 12% VAT

Venue: In-house or Off-site

Schedule: Open for Enrollment

Course Outline

Getting Started With Excel
Introduction
What Is Excel?
New Features In Excel 2003
Opening Excel
Exiting Excel
Help With Excel
Finding Help
The Office Assistant
The Help Task Pane
Beginning Excel
The Standard Toolbar
The Formatting Toolbar
Working With Excel Menus
Exploring Task Panes
Excel Short-Cut Keys
The Basics Of File Management
New Workbooks
How To Open Existing Workbooks
How To Save Workbooks
How To Close Workbooks
Excel File Types
Explore Your Workbook
Switching Worksheets
The Active Cell
Selecting Cells
Exploring A Worksheet
The Zoom Feature
 

Excel Basics
Working With Excel
Columns, Rows, Cells, And Ranges
Creating Worksheet Labels
Entering And Deleting Data
Printing Your Worksheet
Basic Excel Features
What Is AutoFill?
What Is AutoSum?
What Is AutoComplete
Working With Basic Formulas
Editing Tools
Using Autocorrect
Using Spell Check
Using Find And Replace
Documenting A Worksheet With Comments
Moving Your Data
Dragging And Dropping Cells
How To Cut, Copy, And Paste Cells
How To Cut, Copy, And Paste Multiple Cells And Items
How To Use Paste Special
How To Insert And Delete Cells, Rows, And Columns
Using Undo, Redo, And Repeat
Using Smart Tags And Option Buttons
What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
 

Working With Excel
Modifying Cells And Data
Changing The Size Of Rows Or Columns
Working With The Formatting Toolbar
Adjusting Cell Alignment
Rotating Text
Creating Custom Number And Date Formats
Cell Formatting
Conditional Formatting
What Is The Format Painter
What Is AutoFormat
Cell Merging And AutoFit
Find And Replace Formatting 
Enhancing A Worksheet’s Appearance
Adding Patterns And Colors
Adding Borders
Adding Fill Effects
Working With Styles
Modifying Excel’s Toolbars
Hiding Toolbars
Showing Toolbars
Moving Toolbars
Customizing Toolbars
Working With Charts
Creating A Chart
Formatting A Chart
Manipulating A Chart
Enhancing A Chart With Drawing Tools
Enhancing Your Chart With Titles And Tables
Working With Charts And Data
Changing The Type Of Chart
Changing The Source Data
Creating 3-D Charts
Working With The Chart Axes And Data Series
Making Custom Charts

Workbook Management
Organizing Your Workbook
Inserting And Removing Worksheets
Renaming, Moving, And Color-Coding Worksheets
How To Split And Freeze A Window
Using Multiple Workbooks And Windows
Using A Watch Window
Creating A Custom View
Formatting Your Workbook
Using Headers And Footers
Inserting Page Numbers
Changing Margins And Orientation
Hiding Rows, Columns And Worksheets
Printing A Workbook
Choosing A Print Area
Setting Up Page Breaks
Choosing Paper Size And Changing Print Scale
Adding Print Titles And Gridlines
More Workbook Features
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Protecting Worksheets
Using Templates

Enroll Now!

GLOBALKNOWLEDGE PHILIPPINES, INC.

2502B West Tower, Philippine Stock Exchange Bldg.

Exchange Road, Ortigas Center, Pasig City, Philippines 1600

Tel. Nos. (632) 683-0969; 637-3657

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