Bitstop, Inc. My Account  Cart Contents  Checkout  
  Top » Catalog » Training & Certification » CBTs » My Account  |  Price Settings  |  Cart Contents  |  Checkout   
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Categories
Accesories->
Bargain/Sale
Computers-Desktop->
Computers-Server->
Furnitures->
Giveaways
Hardware->
Limited Auction Sale
Mobile Computing->
Networking->
Office Automation->
Paper Products
POS Systems
Presentation Equipment
Ribbons,Inks& Toners Other consu->
Training & Certification->
  Books & Related Items
  CBTs
  EC Council
  Languages
  Tutorials
Warranty
Software->
What's New?

HDSEA4TBDS Hardisk Seagate 4TB Sata Barracuda
Please log in for prices 
Manufacturers
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Excel '97 Training CD Please log in for prices


Detailed Course Outlines: 
 
Beginning (2 hrs 20 min) 
1.0 Introduction to Excel (22 min)
1.1 Orientation
1.2 Tools
1.3 The Worksheet
1.4 Using the Keyboard to Navigate
2.0 Data Entry (39 min)
2.1 Text
2.2 Selecting Cells
2.3 Values
2.4 Entering Formulas
2.5 Auto-Sum for Totals
2.6 The Average Function
3.0 Changing Worksheet Appearance (14 min)
3.1 Simple Formatting
3.2 Fill & Font Colors
3.3 Undo
3.4 Borders
 4.0 File Management (14 min)
4.1 Saving Your Work
4.2 Opening a File
4.3 Creating a New Workbook
4.4 Closing a File
5.0 Additional Formulas (20 min)
5.1 Cumulative Totals
5.2 % Change
5.3 Formula Symbols
5.4 Editing Formulas
5.5 Auto Calculate Feature
6.0 Formatting Features (14 min)
6.1 Changing the Font Type & Size
6.2 Inserting Rows & Columns
6.3 Copying & Moving Data in a Worksheet
7.0 Printing Worksheets (13 min)
7.1 Print Review
7.2 Printing Selections
7.3 The Print Button & Exiting Out of Excel
 
Intermediate (2 hrs 20 min)  
1.0 Build In Functions (12 min)
1.1 PMT Financial Function
1.2 Paste Function Tool
2.0 Dates & Times (17 min)
2.1 Date Functions
2.2 Changing Date Displays
2.3 Time Functions
3.0 Setting Defaults (11 min)
3.1 Tools Options
4.0 Multi-Sheet Workbooks (23 min)
4.1 Inserting & Re-naming Sheets
4.2 Copying Worksheets
4.3 Formulas that Work Across Worksheets
4.4 Grouping Worksheets
 5.0 Cell Reference (17 min)
5.1 Absolute Reference
5.2 Mixed Reference
6.0 Format Cells Command (15 min)
6.1 Changing Text Appearance
6.2 Adding Borders
6.3 Adding Color
7.0 Charts (42 min)
7.1 Creating a Chart
7.2 Placing & Modifying Your Chart
7.3 Formatting a Chart
7.4 Shortcuts & Tricks
7.5 Pie Charts
 
Advanced (2 hrs 23 min) 
1.0 Logical Function (34 min)
1.1 If Statement
1.2 Modifying the If Statement
1.3 Vertical Lookup
1.4 Horizontal Lookup
2.0 Split Screen Techniques (11 min)
2.1 Horizontal Split
2.2 Freeze Panes
2.3 Vertical Slit
2.4 Creating a Double Freeze
3.0 AutoFill Techniques (15 min)
3.1 AutoFill
3.2 Dates Using AutoFill
3.3 Series Extension
4.0 Data Validation Techniques (13 min)
4.1 Validating Data
4.2 The Auditing Toolbar & Keyboard Shortcuts
 5.0 Excel Databases(35 min)
5.1 Sorting Data
5.2 Sorting From the Toolbar
5.3 Data Sort Command
5.4 Creating Subtotals
5.5 Filtering
6.0 Range Names (9 min)
6.1 Naming Cells
7.0 Additional Charting Capabilities (24 min)
7.1 Formatting the X & Y Axis
7.2 Changing the Chart Style
7.3 Changing Line Attributes
7.4 Utilizing Drawing Tools 


This product was added to our catalog on Tuesday 21 January, 2003.

Reviews

Shopping Cart
1 x Bitstop Wall Clock
1 x Bitstop CPU Carrier
P1,125.00
Manufacturer Info
Keystone Learning Systems
Keystone Learning Systems Homepage
Other products
Notifications
NotificationsNotify me of updates to Excel '97 Training CD
Tell A Friend
 

Tell someone you know about this product.
Reviews
Write ReviewWrite a review on this product!
Secured by ChainedSSL

This site is for registerd Bitstop Dealers only. Powered by Bnshosting
Computer Store for computer Hardwares, Softwares, Licenses, Printers, Hard disk, Memory, PCs, Laptops, Notebooks books and training videos
-