Excel 2000 Training on CD-ROM
From 123-CBT Computer Based Training
Excel 2000 Intermediate
...Excel 2000 Intermediate
Lesson 1 : Getting To Know The Worksheet Window, Introduction, Opening Excel, Splitting Your Worksheet Vertically, Splitting Your Worksheet Horizontally, Removing The Split Bars From Your Worksheet, Freezing Panes, Unfreezing Panes, Freezing Multiple Panes, Unfreezing Multiple Panes, Hiding Columns And Rows Using The Format Menu, Hiding Columns And Rows Using
more...
Office 2000 Standard Set of 9
The Microsoft Office 2000 Standard Setincludes the following tutorial applications: Word 2000: Beginning (ID#1810) Word 2000: Intermediate (ID# 1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID# 1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) Outlook 2000: Beginning
more...
Office 2000 Professional Set of 13
...: Intermediate (ID#1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID#1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) Access 2000: Beginning (ID#1686) Access 2000: Intermediate (ID#1697) Access 2000: Advanced (ID#1704) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
more...
Excel 2000 User Set of 3
Beginning (2 Hours 16 Minutes)
1.0 The Excel Screen (32 Minutes)
1.1 The Excel Workbook and Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Minutes)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
more...
Excel 2000 - Proficient User
...Excel 2000 is an interactive productivity tool for users of Microsoft Excel 2000. Excel 2000 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 include basic spreadsheet concepts, workbook and file management, using formulas and functions, editing and formatting
more...
Excel 2000 Beginning
Beginning (2 Hours 16 Minutes)
1.0 The Excel Screen (32 Minutes)
1.1 The Excel Workbook and Worksheets
1.2 Title Bar & Menu Bar
1.3 Toolbars
1.4 Formula Bar
1.5 Columns & Rows
1.6 Navigation
1.7 Sheet Names & the Status Bar
1.8 Mouse Pointers & Shortcut Menus
2.0 Entering Data into a Worksheet (27 Minutes)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
more...
Excel 2000 Intermediate
Intermediate (2 Hours 5 Minutes)
1.0 Changing Worksheet Layout (26 Minutes)
1.1 Inserting Columns, Rows and Cells
1.2 Deleting Columns, Rows and Cells
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting (6 Minutes)
2.1 Formatting Cell Attributes and Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text across Columns
2.5 Hiding & Unhiding Columns & Rows
3.0
more...
Excel 2000 Advanced
Advanced (2 Hours 2 Minutes)
1.0 Adjusting Worksheet Views (13 Minutes)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Minutes)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Minutes)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard
more...
Office 2000 Professional Set of 13
...: Intermediate (ID#1815) Word 2000: Advanced (ID# 1818) Excel 2000: Beginning (ID#1718) Excel 2000: Intermediate (ID#1722) Excel 2000: Advanced (ID#1728) Access 2000: Beginning (ID#1686) Access 2000: Intermediate (ID#1697) Access 2000: Advanced (ID#1704) PowerPoint 2000: Beginning (ID#1758) PowerPoint 2000: Intermediate (ID#1762) PowerPoint 2000: Advanced (ID#1766) Outlook 2000:
more...
Office 2000 Standard Suite
...0: Intermediate (ID#6820) Word 2000: Advanced (ID#6821) Excel 2000: Introduction (ID#6822) Excel 2000: Intermediate (ID#6823) Excel 2000: Advanced (ID#6824) PowerPoint 2000: Introduction (ID#6825) PowerPoint 2000: Intermediate (ID#6826) PowerPoint 2000: Advanced (ID#6827) Outlook 2000 Volumes I & II (ID#6831) To review individual course descriptions, please select the corresponding
more...
SQL Server 7 0 Data Warehousing Set of 4
...e Data & Data Mining 2.2 Local Cubes 2.3 OLAP Manager & Excel 2000 2.4 Publishing to the Web 2.5 Creating Local Cubes with Excel 2000 3.0 MDX Statements (27 Mins) 3.1 What is MDX? 3.2 The MDX SELECT Statement 3.3 Axes 3.4 Sets 3.5 Functions 3.6 Additional Set Functions 3.7 Tuples 3.8 Slicer Dimensions 3.9 Calculated Members SQL 7.0 Data Warehousing Level 4 (1 Hr 32
more...
SQL Server 7 0 Data Warehousing Level 3
SQL 7.0 Data Warehousing Level 3 (1 Hr 28 Mins) 1.0 Storing & Processing Cubes (32 Mins) 1.1 MOLAP, ROLAP, & HOLAP Storage Structures 1.2 Comparing ROLAP & MOLAP 1.3 Review & Compare Storage Options 1.4 Storing Partitions & Processing Cubes 1.5 Calculated Members 1.6 The Virtual Cube, Cube Security & Roles 2.0 Analyzing Data Using Clients (28 Mins) 2.1 Navigating Warehouse Data &
more...
Office 2000 5-in-1 - Proficient
The Discover Office 2000 (5-in1) – Proficient set includes the following courses: Discover Access 2000 - Proficient (ID#7108) Discover Excel 2000 - Proficient (ID#1389) Discover PowerPoint 2000 - Proficient (ID#1402) Discover Outlook 2000 - Proficient (ID#7111) Discover Word 2000 - Proficient (ID#1410) To review individual course descriptions, please select the corresponding
more...
