|
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 XP 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 XP.
|
COURSE OUTLINE
|
MS EXCEL XP PROFICIENT TRAINING CDExcel XP BasicsIntroducing Excel XP
Excel XP Capabilities
Screen Layout
The Task Pane
Title Bar, Menus & Toolbars
Create & Open A Workbook
What Is A Workbook?
Creating A New Workbook
Use A Template
Open An Existing Workbook
Save A Workbook
Use The Save & Save As
Commands
Save A File For Use In Another Program
View A Workbook
Normal View
Page Break Preview
Create Custom Views
Change Zoom Setting
Split A Worksheet
Freeze Rows & Columns
Print Workbooks
Print Worksheets & Workbooks
Modify Page Setup
Set Print Area
Help In Excel XP
Ask A Question
Microsoft Excel Help
| Work with CellsCell Basics
What Is a Cell Reference?
Select Cells
Enter Data
Entering Data
What Is A Value?
What Is A Label?
Edit Data
Edit Worksheet Data
Find & Replace Data
Use The Go To Command
Copy & Move Data
Copying & Moving Data
Copy & Move Data
Use The Office Clipboard
Insert & Delete Cells
Insert & Delete Cells
Work With Subsets Of Data
Use AutoFilter
| Work with your WorkbookModify A Worksheet
Insert/Delete Rows & Columns
Adjust Row & Column Size
Hide Rows & Columns
Modify A Workbook
Insert/Delete A Worksheet
Move A Worksheet To Another
Workbook
Rename A Worksheet
Format Worksheet Tabs
Link & Consolidate Data
What Is A Link? Link Worksheets Use 3D References
| Format a WorksheetFormat Characters
Formatting Text & Numbers
Format Text
Number Formats
Format Numbers
Format Cells
Aligning Cell Content
Align Cell Content
Merge Cells
Clear Cell Formatting
Apply Borders & Shading
Find & Replace Cell Formatting
AutoFormat
Use AutoFormat
Styles
Styles In Excel XP
Create & Apply A Style
| Work with GraphicsAdd Graphics
Graphics In Excel XP
Insert Clip Art
Add Charts
What Is A Chart?
Create A Chart
Modify A Chart
Print A Chart
| Calculate your DataFormulas
What Is A Formula?
What Is Formula Syntax?
Create A Formula
Edit A Formula
Cell References
Types Of Cell References
Use Relative References
Use Absolute References
Mixed References
Functions
What Is A Function?
Get Help With Functions
Enter A Function
Use A Date Function
Financial Functions
Use A Financial Function
Logical Functions
Use A Logical Function
| Share InformationDistribute Workbooks
E-mail A Workbook
Use Comments
Add Comments To A Worksheet
Excel XP & The Web
What Is HTML?
Save A Worksheet As A Web Page
What Is A Hyperlink?
Create A Hyperlink
|
MS EXCEL XP EXPERT TRAINING CDCustomise Excel XPIntroducing Excel XP
What Is Excel XP
Why Customize Excel XP
Customize Menus
The Menu Bar
Create A Custom Menu
Customize Toolbars
Toolbars
Customize A Toolbar
Macros
What Is A Macro?
Record A Macro
Edit A Macro
Assign Macro To A Toolbar Or Menu
| Work with your WorkbookCreate & Open Workbooks
Workbook Templates
Create & Save A Workbook Template
Edit A Workbook Template
Use Data Validation
Import & Export Data
Use the Office Clipboard
Import Data From Text Files
Get Data From A Web Page
Use Data From Other Applications
Publish A Worksheet
Export To Other Applications
Work With Multiple Workbooks
Use A Workspace
Data Consolidation
Consolidate Data
Link Consolidated Data
Consolidate Data From Multiple Workbooks
| Format a WorksheetFormat Characters
Formatting Text & Numbers
Apply Number Formats
Create Custom Number Formats
Use Conditional Formatting
Conditional Formatting
Use Conditional Formatting
| Calculate your DataWork with Named Ranges
Using Range Names
Range Naming Rules
Create Range Names Using Row Or Column Labels
Define Range Names For Data Without Labels
Use A Named Range In A Formula
View & Go To Named Ranges In a Workbook
Use Lookup Functions
Lookup Functions
The VLOOKUP Function
Use The VLOOKUP Function
Use Subtotals
Add Subtotals To Worksheets
Audit Worksheets
The Auditing Toolbar
Trace Precedents & Dependents
Trace Errors
Circle Invalid Data
| Manage and Analyse DataOutline A Worksheet
Using Outlines
Add & Remove An Outline
Outline A Worksheet Manually
Apply Data Filters
Use AutoFilter
The Advanced Filter
Query External Sources
Use The Query Wizard
What Is Xml?
Create A Web (XML) Query
Use What-If Analysis
Using Scenarios
Create & Display Scenarios
Create A Trendline
Data Analysis & PivotTables
Create A PivotTable
Modifying A PivotTable
Create A PivotChart
| Collaborate with OthersShare Workbooks
Create A Shared Workbook
Resolve Conflicts
Merge Shared Workbooks
Track Changes In Shared Workbooks
Track changes
View The Change History
Workbook Protection & Properties
Worksheet Protection
Protect Cells In A Worksheet
Apply Workbook Protection
Apply Workbook Password Protection
Workbook Properties
Change Workbook Properties
|
|