|
|
|
|
|
|
|
|
[to previous page]
[other products in "Office XP"]
|
| |
|
| Product: |
Excel XP CBT Course
Excel expert Dennis Taylor will help familiarize you and your team with the fundamentals of Excel XP. Learn cell referencing, auditing techniques, VLOOKUP functions, and much more
|
Price:
excl. VAT |
|
|
|
| Description: |
Beginning The Excel Screen Entering Data - Data Entry Techniques
- AutoFill Entry Techniques
- Erasing Data
- AutoComplete
- Undo and Re-do
Entering Formulas - Three Methods of Entering Formulas
- Repeating a Formula in Adjacent Cells
- Formulas Beyond Addition & Subtraction
Basic Excel Functions - Summation
- Recalculating Effects & Hierarchy of Operations
- Other Functions
Formatting - The Formatting Toolbar
- Adjusting Widths and Row Heights
- Numeric Formatting
Saving, Opening and Closing Files - File Save and File Save As
- Opening a File
- Creating a New Workbook
The Help System Intermediate Changing Worksheet Layout - Inserting Columns, Rows, & Cells
- Deleting Columns, Rows, & Cells
- Moving Cells
- Copying Cells
Additional Formatting - Formatting Cell Attributes & Alignment
- Borders
- Numeric Formatting
- Centering Text Across Columns
- Hiding & Unhiding Columns & Rows
Printing - Using Print Preview & Page Setup
- Printing Controls
- Using Page Break & Preview
Using Cell References - Absolute References
- Mixed References
The Tools Options Command - Show/Hide Gridlines & Formulas
- Recently Used File List
- Sheets in New Workbook
- Default Settings
| Advanced Adjusting Worksheet Views - Freeze/Unfreeze Panes
- Horizontal and Vertical Split Screens
Auditing Techniques - Using the Formula Auditing Toolbar
- Tracing Dependent Cells
- Tracing Precedent Cells
The IF and VLOOKUP Functions - The IF Functions & Relational Operators
- Using Words in IF Functions
- Using Logical Operators (AND & OR) with the IF Function
- Nested IF Functions
- Getting Data from the Table with a VLOOKUP Function
Date & Time Functions - Using Dates as Values
- Entering a Series of Dates
- Date/Time Entry Techniques
Multi-Sheet Workbooks - Renaming & Reordering Sheets
- Inserting & Deleting Sheets
- Moving, Copying, & Grouping Sheets
- Formulas Across Multiple Sheets
|
|
|
|
 |
|
|
|
|
| RCS Newsletter |
|
| Quick Links |
|
|
|
| Our Customers |
excellent:
"The CBT product is easy to use and an excellent combination of reading material, video on CD and interactive labs. "
thank you :
"Thank you! i have received the complete order today.
thank you for your swift service and i hope to be in touch soon with regards further training.
Once again thank you very much"
glad:
"I am glad to report that the CBT packages arrived successfully.
I really appreciate all the help and assistance you gave me since my initial enquiry with yourselves"
More testimonials
IT Training
Settings/Tips/Tricks
Computer Articles
Biodiesel Energy
PPE Safety Equipment
Learn English Language |
|
|
| Copyright 2002-2008 RCS Limited. All rights reserved. More
... |
