|
More on Single User, Multi User & Network Licences
More on Online Training
PACKAGE INCLUDES2 Interactive Training CD-ROMs 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 course. Testing Modules to insure that you fully understand the subject matter.
COURSE INTRODUCTIONExcel 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. Topics 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.
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
|
COURSE OUTLINE
MS EXCEL 2003 PROFICIENT TRAINING CDExcel 2003 BasicsIntroducing 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 CellsCell 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 DataFormulas
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 WorkbookModify 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 WorksheetFormat 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 GraphicsWork With Graphics
Graphics In Excel
Insert Clip Art
Add Charts
Adding Charts
The Chart Wizard
Modify A Chart
| Automate your WorkAutoFill
What Is AutoFill?
Use AutoFill
AutoComplete
Using AutoComplete
AutoCalculate
Use AutoCalculate
| Collaborate with OthersCollaborate On Workbooks
Distributing Workbooks
E-Mail A Workbook
Work With Comments
Add Comments To A Worksheet
|
COURSE OUTLINE
MS EXCEL 2003 EXPERT TRAINING CDCustomise Excel 2003Advanced 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 DataWork 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 DataCreate & 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 WorkbookConditional Formatting
What Is Conditional Formatting?
Use Conditional Formatting
Styles
What Is A Style?
Create & Apply A Style
| Use MacrosCreate 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 WorkbooksLink & 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 OthersShare 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 WebCreate Web Pages
Publish A Worksheet To The Web
Create Hyperlinks
Publish A PivotTable To The Web
Using Smart Tags To Retrieve Web Data
|
|