Microsoft Excel 2003 Training
 Our Microsoft Excel Training teaches you about spreadsheet capabilitiesof
the software and the powerful tools for creating and sharing professional worksheets online and on the Web. Our training covers 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.
Our Microsoft Office Excel Training combines audio, animation, and software simulation with a unique user interface to make the "discovery" of computer
programs both effective and entertaining. The products are also designed to help users learn at their own pace, allowing them to repeat topics or jump to
anywhere in the course. You will find our interface is intuitive and easy to use: The Main Menu displays all the categories within the course. The topics
within each category provide detailed explanations and examples, as well as hands-on exercises, so users can practice what they're learning. After
completing all the topics in a category, users can find out how much they've learned by taking the Category Quiz. They can also test their overall
knowledge of Excel 2003 at any time by accessing the global Test feature. Our unique Glossary provides a quick reference of terms. In many cases, users can jump directly to the exact portion of the
course for a more detailed explanation. A detailed Help function is always available to ensure users never lose their way.
 |
Our Training Course Features
- Training done in full multi-media flash format
- Over 12 hours of training
- Covers Beginner to Advance Levels
- Interactive Exercises- allows you to practice what you have learned
- Review Questions
- Microsoft Office 2003 Software not required
- Covers 100% of the objectives of Microsoft's requirements for Office training
MOS Microsoft Office Specialist
- Available as single user CD-ROMs, Online, DVDs, Library License and Network Version
- Used by Thousands of Companies -
- Inquire about our Network Licenses and Learning Management Software (LMS).
Please Note***Demo requires a popup window.
Please turn off your Browser's popup blocker as well
as the popup blocker in your Google toolbar if you have one running.
Microsoft Office Excel 2007
|
Microsoft Excel 2003 Training CDs
Single License
|
dsec03cd
|
$99.95
|
|
|
Microsoft Excel 2003 Training CDs
Library License Details
|
dsec03lb
|
$299.95
|
|
|
Microsoft Office 2003 Training On CD-ROMs Access, Excel, Oulook, PowerPoint and Word
|
dsof03cd
|
$369.95
Sale $229.95
|
|
Library License- This licensing allows you to train an unlimited amount of users on a single computer or for the training to be
kept at a single location and individuals would take the training CDs to their individual computer or workstation to do their training
. The Training CDs can not be loaded to a server, installed on the internet or intranet.
Microsoft 2003 Excel Training Course contains the Following
|
Proficient Level
|
Expert Level
|
|
EXCEL 2003 BASICS
Introducing Excel 2003
Office 2003 Overview
Excel 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 Use In 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
Insert & Delete 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
|
CUSTOMIZE EXCEL 2003
Advanced Features &
Customization
Advanced Features
Customizing Excel
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 & ANALYZE 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 WORKSHEET
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 & 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 & 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
|
|
