courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
SUBSCRIBE
Subscribe to Receive Special Offers & New Release Updates
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST UK DELIVERY
Order Today, Learn Tomorrow!

Pay as You Learn

SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted



Follow us on Facebook

Excel 2003 Training

 
Bookmark and Share
Microsoft Excel 2003 Proficient and Expert Training CDs
Excel 2003 Training
Set of 2 CDs £99.00  £29.00 + VAT
Buy Now
Multi User CD Course £198.00  £118.00 + VAT
Buy Now
 

More on Single User, Multi User & Network Licences

More on Online Training


 

PACKAGE INCLUDES

 •  2 Interactive Training CDs featuring MOS Proficient and Expert Training with
        audio, animation and software simulations.
 •  Step by Step Demonstrations.
 •  Hands-on Lab Simulations with detailed instructions.
 •  Designed to help users learn at their own pace, allowing them to repeat topics
        or jump to anywhere in the training course.
 •  Testing Modules to insure that you fully understand the subject matter.

 

COURSE INTRODUCTION

This Excel 2003 training course includes topics which cover basic spreadsheet concepts, workbook and file management, using formulas and functions, editing and formatting tools, working with graphics and charts, online collaboration, and working on the Web. Excel 2003 builds on the spreadsheet capabilities of previous versions of the program to provide powerful tools for creating and sharing professional worksheets online and on the Web.

Whether you are new to Excel, upgrading from a previous release or need to obtain your MOS certification, this course takes you step-by-step through your mastery of Excel 2003.

View Discoverware Demo Videos



 

COURSE OUTLINE


MS EXCEL 2003 PROFICIENT TRAINING CD

Excel 2003 Basics

Introducing Excel 2003
Office 2003 Overview
Screen Layout
Title Bar, Menus & Toolbars
The Task Pane
Create & Open A Workbook
What Is A Workbook?
Creating A New Workbook
Use A Template
Open An Existing Workbook
Closing A Workbook
View A Workbook
What Is A View?
Page Break Preview
Custom Views
Splitting A Worksheet
Freeze Rows & Columns
Comparing Workbooks
Save A Workbook
The Save & Save As Commands
Save A Workbook For Another Program
Print Workbooks
Print Worksheet & Workbooks
Modify Page Setup
Set Print Area
Help in Excel 2003
Microsoft Office Online
Type A Question For Help
Excel Help Task Pane
Detect And Repair

Work with Cells

Cell Basics
What Is A Cell Reference?
Select Cells
Navigating A Worksheet
Enter Data
Entering Data
What Is A Value?
What Is A Label?
Edit Data
Edit Worksheet Data
Find & Replace Data
Copy And Move Data
Copying & Moving Data
Copy & Move Data
Use The Office Clipboard
Insert & Delete Cells
Inserting & Deleting Cells

Calculate your Data

Formulas
What Is A Formula?
Create A Formula
Edit A Formula
Cell References
Types Of Cell References
Using Relative References
Use Absolute References
Mixed References
Functions
What Is A Function?
Enter A Function Manually
Insert A Function
Use A Date Function
Financial Functions
Use A Financial Function
Logical Functions
Use A Logical Function

Work with your Workbook

Modify a Worksheet
Insert/Delete Rows & Columns
Resizing Rows & Columns
Resize Rows & Columns
Hide Rows & Columns
Modify A Workbook
Insert & Delete A Worksheet
Move/Copy A Worksheet To Another
Workbook
Rename A Worksheet
Format Worksheet Tabs

Format a Worksheet

Format Characters
Formatting Text & Numbers
Format Text
Formatting Numbers
Format Numbers
Use A Custom Number Format
Format Cells
Formatting Cells
Aligning Cell Content
Align Cell Content
Merge Cells
Apply Borders & Shading
Format Painter
Clear Cell Formatting
Find & Replace Cell Formatting
AutoFormat
Use AutoFormat

Work with Graphics

Work With Graphics
Graphics In Excel
Insert Clip Art
Add Charts
Adding Charts
The Chart Wizard
Modify A Chart

Automate your Work

AutoFill
What Is AutoFill?
Use AutoFill
AutoComplete
Using AutoComplete
AutoCalculate
Use AutoCalculate

Collaborate with Others

Collaborate On Workbooks
Distributing Workbooks
E-Mail A Workbook
Work With Comments
Add Comments To A Worksheet


MS EXCEL 2003 EXPERT TRAINING CD

Customise Excel 2003

Advanced Features & Customization
Advanced Features In Excel 2003
Customizing Excel 2003
Customize Menus
The Menu Bar
Creating Custom Menus
Customize Toolbars
Toolbars
Customize A Toolbar
Create A New Toolbar

Calculate your Data

Work With Named Ranges
Using Named Ranges
Range Naming Rules
Create Range Names Using Labels
Define Range Names For Data Without Labels
Use A Named Range In A Formula
Viewing Named Ranges In a Worksheet
Use Subtotals
Add Subtotals To A Worksheet
Use Lookup Functions
What Is A Lookup Function?
The VLOOKUP Function
Use The VLOOKUP Function
Find & Correct Errors
Auditing Worksheets
Trace Precedents & Dependents
Trace Errors
Use Data Validation
Circle Invalid Data

Manage and Analyse Data

Create & Filter Lists
What Is A List?
Use A Data Form
Use The List Feature
AutoFilter & Advanced AutoFilter
Sort List Data
Sort Data
Subtotal Columns
Outline A Worksheet
Using Outlines30
Add & Remove An Outline
Outline A Worksheet Manually
Query External Databases
Use The Query Wizard
XML Documents
What Is XML?
Save A Workbook As An XML Document
Goal Seek & Solver
Use Goal Seek
Use Solver
Scenarios
What Is A Scenario?
Create & View Scenarios
Link & Consolidate Data
Data Consolidation
Consolidate Data
Link Consolidated Data
Consolidate Data From Multiple Workbooks
PivotTables & PivotCharts
Using PivotTables & PivotCharts
Create A PivotTable
Modifying A PivotTable
Create A PivotChart

Format a Workbook

Conditional Formatting
What Is Conditional Formatting?
Use Conditional Formatting
Styles
What Is A Style?
Create & Apply A Style

Use Macros

Create Macros
What Is A Macro?
Record A Macro
Absolute Vs. Relative Recording
Work With Macros
Assign A Macro
Edit A Macro
Step Into A Macro
Macro Security

Manage Data and Workbooks

Link & Consolidate Data
Data Consolidation
Consolidate Data
Link Consolidated Data
Consolidate Data From Multiple Workbooks
Import & Export Data
Use The Office Clipboard
Import Data From Text Files
Import Data From Other Applications
Import Data From The Web
Export Data To Other Applications
 

Collaborate with Others

Share Workbooks
Create A Shared Workbook
Resolve Conflicts
Track Changes In A Shared Workbook
Track Changes
View The Change History
Workbook Protection & Properties
Worksheet Protection
Protect Cells In A Worksheet
Apply Workbook Protection
Apply Password Protection
Workbook Properties
Change Workbook Properties

Excel and the Web

Create Web Pages
Publish A Worksheet To The Web
Create Hyperlinks
Publish A PivotTable To The Web
Using Smart Tags To Retrieve Web Data

 
 
Print Image Printer friendly version   
Top of page
A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CVISION NEWS  CONTACT US   SITEMAP  

MCITP Training Courses  MCPD Training Courses  MCTS Training Courses
MCITP Database Developer Training Courses  MCITP Database Administrator Training Courses
Flash Tutorials & Training Courses  MCSE CBT Training Adobe Photoshop Tutorials & CBT Training Microsoft Certification Training

CareerVision
61 Caroline Street, Birmingham, B3 1UF, UK
Tel: 0121 248 2400, Fax: 0121248 2800,
Email: sales@cvision.co.uk |Web: www.cvision.co.uk

red arrow Website design by Aimpro UK red arrow Terms