Excel 2003

Home > ** Buy One Get One Free ** >

Excel 2003 Beginner to Advanced Training CDs

List Price: £79.00 (£94.80 inc VAT)
Our Price: £48.00 (£57.60 inc VAT)

Product Code: CAMCA046

Qty:

Description

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.

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

Share your knowledge of this product. Be the first to write a review »

TRAINING CATEGORIES

Top Selling Courses

MORE CATEGORIES

PACKAGE INCLUDES

COURSE INTRODUCTION

COURSE OUTLINE