|
|
|
|
|
|
|
|
[to previous page]
[other products in "No Longer Available"]
|
| |
|
| Product: |
Excel 2000 CBT Course
Understand the world's top spreadsheet program and prepare for MOS Certification. Learn formulas, formatting, layout, commands, functions, charts, database shortcuts, pivot tables, files and reports and much more.
|
Price:
excl. VAT |
|
|
|
Beginner The Excel Screen - The Excel Workbook & Worksheets
- Title Bar & Menu Bar
- Toolbars
- Formula Bar
- Columns & Rows
- Navigation
- Sheet Names & the Status Bar
- Mouse Pointers & Shortcut Menus
Entering Data into a Worksheet - Data Entry Techniques
- Auto-Fill Entry Techniques
- Erasing Data
- Auto Complete
Entering Formulas - Three Methods of Entering Formulas
- Repeating a Formula
- Formulas Beyond Addition & Subtraction
Basic Functions - Summation
- Recalculating Effects
- Averages
Formatting - The Formatting Toolbar
- Adjusting Column-width & Row-height
- Numeric Formatting
Saving - File Save or File Save as
- Opening a File
- Closing a File
- Creating a new Workbook
Intermediate Changing Worksheet Layout - Inserting Columns
- Deleting Columns
- Moving Cells
- Copying Cells
Additional Formatting - Formatting Cell Attributes & Alignment
- Borders
- Numeric Formatting
- Center 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
Tools Options Command - Show/Hide Gridlines
- Show/Hide Formulas
- Recently used Files List
- Sheets in New Workbook
- Default Settings
Advanced Adjusting Worksheet Views - Freeze/Unfreeze Panes
- Horizontal & Vertical Split screen
Auditing Techniques - Using the Auditing Toolbar
- Tracing Dependant Cells
- Tracing Precedent Cells
Using Functions - Paste Function
- The PMT Function
- Expanding the use of standard functions
Logical Functions - IF Functions & Relational Operators (> < >= <= = <> )
- Using Words in IF Functions
- Using IF Functions with Arithmetic Operators (* / + -)
- Using Logical Operators (AND & OR) with the IF Function
- Nested IF Functions
- Using the VLOOKUP Function to overcome Limitations of the IF Functions
Date & Time Functions - Using Dates as Values
- Entering a Series of Dates
- Date/Time entry Techniques
Multi-Sheet Workbooks - Re-Naming & Re-Ordering Sheets
- Inserting & Deleting Sheets
- Moving
- Formulas across multiple sheets
|
|
|
 |
|
|
|
|
| Quick Links |
|
|
|
| RCS Newsletter |
|
|
|
| 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-2011 RCS Limited. All rights reserved. More
... |
