Excel For Business 2003

Click Here for Information on Live Virtual Online Class Training!

"Free Retakes for Life!" of that version
Any Upgraded version of the class taken is offered at 75% off Original Price!
Manual to keep w/ access to student files
Access to Online Video Training Tutorials (NEW!)
Free forum support for after class
Mousepad with shortcuts to keep
Hands on, goal based
Small Classes of 3 to 6 people
Fast NEW computers! (Windows w/ 8GB of ram or MacBook Pros)
Comfortable chairs, convenient location
Patient, Fun, Experienced Trainer
We provide coffee, tea, water

When you are finished with this class you will be able to:

Create and manipulate advanced charts
Understand how to manage Excel databases
Create complex formulas
Format text and numbers
Efficiently maneuver around Excel
Understand how to use any predefined functions
Feel confident when printing large spreadsheets

Examples of people who will benefit greatly from this class:

Those seeking to feel comfortable with most Excel office tasks
Those looking to interview for positions that require up to an intermediate level of Excel

Materials

Detailed reference sheet of everything covered
Multiple XLS and XLT examples for in class and after class
Shortcut sheet
Resource sheet

Course Outline

Lesson 1-Introduction: Navigation and Entering Data
Excel’s Purpose
Saving Files
The Excel Application Workspace
Getting Familiar with Your Workspace
Changing the Default Options
Always Showing Full Menus
Adding/Removing Toolbars
Moving Toolbars
Navigating Within a Workshet
Navigating Between Worksheets
Selecting Range of Cells
Entering Data
Editng Data
Deleting Data
Moving and Copying Data using the Mouse
Moving and Copying Data Using Cut, Copy and Paste
Paste Special Options
Data Series and The AutoFill Handle
Using Auto-fill

Lesson 2-Creating Content
Creating formulas
Common Operators
Using Functions
Using Relative and Absolute Cell Addressing
Creating 3-D Formulas (optional)

Lesson 3-Formatting
Fonts, Font Sizes, Font Styles, and Font Colors
Alignment
Indenting text
Sizing Rows and Columns
Wrapping Text in a Cell
Centering Text across cells
Formatting Values
Borders
The Format Painter
Conditional Formats

Lesson 4- Databases
Sorting
Forms
Adding and Autofilter
Subtotals

Lesson 5-Printing &Workbook Management
Controlling Output: The page setup Command
Force a Page Break
Workbook Management
Viewing Data and Worksheet Management

Lesson 6-Charts
Creating a Chart
Parts of the Chart
Modifying a Chart
Common Changes
Using Pie Charts
Adding a Secondary Value Axis (optional)
Adding Trendlines (optional)

Download PDF