Cells Training on CD-ROM - Training Resources
Cells Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Word 2002 Advanced
...apping Borders & Shading Entering Data In A Table Merging Cells Splitting Cells Using AutoSum Inserting A Row Calculating An Average Manually Resizing Rows & Columns Distributing Columns & Rows Specifying Exact Size For Rows & Columns Applying An AutoFormat Inserting A Chart Importing Data Into Microsoft Graph Modifying A Datasheet Chart Options Resizing A Chart Previewing Your Work Lesson 2:
more...
Word 2002 Advanced
Excel 2000 Intermediate
...sheet 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 Printing (25 Minutes) 3.1 Using Print Preview and Page Setup 3.2
more...
Excel 2000 Advanced
...tes) 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 functions 4.0 Logical Functions (30 Minutes) 4.1 IF Functions and Relational Operators (> = ) 4.2 Using Words in IF Functions 4.3 Using IF Functions with Arithmetic Operators (* / -) 4.4 Using
more...
Excel 2000 User Set of 3
...sheet 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 Printing (25 Minutes) 3.1 Using Print Preview and Page Setup 3.2
more...
Dreamweaver MX Fundamentals
Macromedia Dreamweaver MX Fundamentals is the first in a series of tutorials from Virtual Training Company for Dreamweaver MX. The author of this series, Mark Fletcher, is a member of Team Macromedia for Dreamweaver. Tap into his extensive knowledge as he takes you step-by-step through the creation of a web site. He will show you how to add text and graphics, work with frames and framesets, apply
more...
Word 2000 Intermediate
...onal Lines In A Table, Deleting A Nested Table, Selecting Cells, Inserting Table Data Into A Chart, Resizing A Chart, Changing Chart Types, The Chart Type Dialog Box, Customizing Chart Components, The Format Plot Area Dialog Box, The Format Axis Dialog Box, Reviewing Your Work, Inserting A Picture From A File, Conclusion Lesson 3: Editing And Printing Options, Applying Basic Formatting To A
more...
Word 2000 Advanced
...rties, Copying And Pasting Text Within A Table, Splitting Cells, Deleting the Contents of A Cell, Merging Cells, Nested Tables, Inserting A Column, Merge Cells In A Column, Change Text Direction, Using AutoSum, Perform Calculations In A Table, Formatting Table Borders, The Borders And Shading Dialog Box, Applying Autoformatting To A Table, Resizing A Table, Creating A Chart From Table Data,
more...
Excel 2000 Introduction
... Cell, The Name Box, Resizing Columns, Selecting Multiple Cells, Selecting Non-Adjacent Cells, Applying Formatting Changes To Multiple Cells, Deselecting A Range Of Cells, Inspecting Changes, Inserting Rows, Inserting A Column, Entering Formulas Into A Spreadsheet, The AutoFill Command, The Average Function, Formatting Decimal Places, The Number Tab, Office Assistant Tip, Inserting A Row,
more...
Excel 2000 Intermediate
... Removing A Column, Inserting Multiple Columns, Inserting Cells, Cell Descriptions, Review Lesson 2: The Function Wizard, Introduction, The Function Wizard, Calculating An Average, Calculating A Median, Calculating A Standard Deviation, Creating A Chart, Formatting Chart Components, Changing The Fill Color, The Gradient Tab, Selecting A Gradient, The Texture Tab, The Pattern Tab, The Picture
more...
Excel 2000 Advanced
...ate, Save A Template As A Workbook, Locking And Unlocking Cells, Hiding Proprietary Formulas, Protecting A Worksheet, Protecting A Worksheet, Protecting Cells, Unprotecting A Worksheet, Hiding Cell Contents, Display Hidden Contents, Password Protecting A Sheet, Removing Password Protection, The Scenario Manager, Creating Scenarios, Displaying Finished Scenarios, Creating A Summary Report,
more...
Excel 2002 Basic
... Values The Name Box Resizing A Column Selecting Adjacent Cells Selecting Non Adjacent Cells Formatting Multiple Cells Centering Text Drawing A Border Erasing A Border Applying A Border To Multiple Cells Applying A Fill Deselecting Cells Inspecting Changes Inserting A Row The Insert Options Button Inserting A Column Entering Formulas In A Worksheet The AutoFill Handle The AutoFill Options
more...
Excel 2002 Intermediate
...Formatting Numbers The Go To Dialog Box Naming A Range Of Cells Inserting A Range of Cells Defining A Name Selecting A Named Range Deleting A Range Saving Your Work Lesson 2: Functions, Formulas, & Charts Introduction Lesson Objectives Opening A Workbook The Function Wizard Searching For A Function Categories Of Functions Getting Help On A Function Copying An Example To A Worksheet The AVERAGE
more...
Excel 2002 Advanced
...lates Saving A Template As A Workbook Locking & Unlocking Cells Hiding Proprietary Formulas Protecting A Worksheet Selecting Permissions Verifying Protection Unprotecting A Sheet Hiding Cell Contents Displaying The Contents Of Hidden Cells Password Protecting A Sheet Removing Password Protection Protecting A Workbook Controlling Access To A Workbook The Scenario Manager Creating Scenarios
more...
Excel XP Essentials Set of 3
...of Entering Formulas 3.2 Repeating a Formula in Adjacent Cells 3.3 Formulas Beyond Addition & Subtraction 4.0 Basic Excel Functions 4.1 Summation 4.2 Recalculating Effects & Hierarchy of Operations 4.3 Other Functions 5.0 Formatting 5.1 The Formatting Toolbar 5.2 Adjusting Widths & Row Heights 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files 6.1 File Save & File Save
more...
FrontPage 2000 Vol 1 and Vol 2
... A Field Adding Radio Buttons Form Fields Placed In Table Cells Push Button Properties Form Properties Form Results Destination Options Selecting A Results File Format E-mail Results Options Confirmation And Input Error Pages Gathering Information About The User's System Viewing Form Results Organizing Our Files The Images Folder Spell Checking The Entire Web Using The Web's Reports View The
more...
InDesign 2 0
...Palette Convert / Add and Import Tables Selecting Table Cells Adding Rows and Columns Table Palette Options Table Coloring Options Cell Options Cell Fill and Stroke Colors Colors Palette Swatches Palette Gradient Swatches Gradient Palette Applying Color to Text Swatches Vs. Color Palette Pantone Spot Color Tint Swatch Vector Graphics Vector vs. Raster Pen Tool Basics
more...
Dreamweaver 4 Fundamentals
... Drawing Nested Layouts Moving and Resizing Formatting Cells & Tables Layout Widths Create an Autostretch Table Spacer Images Remove Nesting Layout View Preferences Netscape Issues Tables Inserting Tables Adding Content Selecting Elements Importing Tabular Data Resizing Table Elements Alignment Adding Color Background Images Adding Headings Adding Rows & Columns
more...
PageMaker 7
...tro to Table Entering data Importing Data Selecting Cells Formatting Text Cell Width and Height Adding and Deleting Rows and Columns Formatting Cell Outlines Formatting Fills Final Formatting Exporting Tables Linking and Updating Printing Intro to Printing Printing Options I Printing Options II Printing Separations Exporting to PDF Saving For Service Bureau
more...
Excel 2002 Intermediate
...rmatting Numbers The Go To Dialog Box Naming A Range Of Cells Inserting A Range of Cells Defining A Name Selecting A Named Range Deleting A Range Saving Your Work Lesson 2: Functions, Formulas, & Charts Introduction Lesson Objectives Opening A Workbook The Function Wizard Searching For A Function Categories Of Functions Getting Help On A Function Copying An Example To A
more...
Excel 2000 Intermediate
... Removing A Column, Inserting Multiple Columns, Inserting Cells, Cell Descriptions, Review
Lesson 2 : The Function Wizard, Introduction, The Function Wizard, Calculating An Average, Calculating A Median, Calculating A Standard Deviation, Creating A Chart, Formatting Chart Components, Changing The Fill Color, The Gradient Tab, Selecting A Gradient, The Texture Tab, The Pattern Tab, The
more...
Excel 2002 Basic
...lues The Name Box Resizing A Column Selecting Adjacent Cells Selecting Non Adjacent Cells Formatting Multiple Cells Centering Text Drawing A Border Erasing A Border Applying A Border To Multiple Cells Applying A Fill Deselecting Cells Inspecting Changes Inserting A Row The Insert Options Button Inserting A Column Entering Formulas In A Worksheet The AutoFill Handle The
more...
Word 2002 Advanced
...ing Borders & Shading Entering Data In A Table Merging Cells Splitting Cells Using AutoSum Inserting A Row Calculating An Average Manually Resizing Rows & Columns Distributing Columns & Rows Specifying Exact Size For Rows & Columns Applying An AutoFormat Inserting A Chart Importing Data Into Microsoft Graph Modifying A Datasheet Chart Options Resizing A Chart Previewing Your
more...
InDesign 2 0
...Palette Convert / Add and Import Tables Selecting Table Cells Adding Rows and Columns Table Palette Options Table Coloring Options Cell Options Cell Fill and Stroke Colors Colors Palette Swatches Palette Gradient Swatches Gradient Palette Applying Color to Text Swatches Vs. Color Palette Pantone Spot Color Tint Swatch Vector Graphics Vector vs. Raster Pen Tool Basics
more...
Dreamweaver 4 Fundamentals
... Drawing Nested Layouts Moving and Resizing Formatting Cells & Tables Layout Widths Create an Autostretch Table Spacer Images Remove Nesting Layout View Preferences Netscape Issues Tables Inserting Tables Adding Content Selecting Elements Importing Tabular Data Resizing Table Elements Alignment Adding Color Background Images Adding Headings Adding Rows & Columns
more...
PageMaker 7
... to Table Entering data Importing Data Selecting Cells Formatting Text Cell Width and Height Adding and Deleting Rows and Columns Formatting Cell Outlines Formatting Fills Final Formatting Exporting Tables Linking and Updating Printing Intro to Printing Printing Options I Printing Options II Printing Separations Exporting to PDF Saving For
more...
Publisher 2000 Set of 3
Publisher 2000 Basics (1 Hour 46 Minutes) 1.0 Getting Started (23 Minutes) 1.1 Creating a New Publication 1.2 Exploring the Publisher Desktop 1.3 Navigating about a Publication 1.4 Zooming in and Out 1.5 Saving Your Work 1.6 The Save Reminder 1.7 Closing and Opening a Publication 2.0 Using the Objects Toolbar (15 Minutes) 2.1 Changing the Placement of the Objects Toolbar 2.2
more...
Excel 2000 User Set of 3
...eet 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 Printing (25 Minutes)
3.1 Using Print Preview and Page
more...
Publisher 2000 Advanced
Publisher 2000 Advanced (1 Hour 50 Minutes)
1.0 Advanced Graphic Techniques (31 Minutes)
1.1 Cropping a Picture
1.2 Inserting Pictures From the Web
1.3 Finding Clips with Keywords
1.4 Scaling Pictures
1.5 Re-Coloring Pictures
1.6 Rotating Pictures
1.7 Adding Borders and Shadows
1.8 Customizing the Clip Art Gallery
2.0 Border Art (6 Minutes)
2.1 Creating Border Art
2.2
more...
Excel 2000 Intermediate
...eet 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 Printing (25 Minutes)
3.1 Using Print Preview and Page
more...
Excel 2000 Advanced
...
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 functions
4.0 Logical Functions (30 Minutes)
4.1 IF Functions and Relational Operators (> =
)
4.2 Using Words in IF Functions
4.3 Using IF Functions with Arithmetic
more...
Excel 2002 Advanced
...tes Saving A Template As A Workbook Locking & Unlocking Cells Hiding Proprietary Formulas Protecting A Worksheet Selecting Permissions Verifying Protection Unprotecting A Sheet Hiding Cell Contents Displaying The Contents Of Hidden Cells Password Protecting A Sheet Removing Password Protection Protecting A Workbook Controlling Access To A Workbook The Scenario Manager Creating
more...
WordPerfect 9 Intermediate
...a From One Cell To Another, Copying A Formula To Multiple Cells At Once Lesson 7: Adding A Footnote, Adding A Bookmark, Formatting Footnote Text, Changing The Font Face Of Footnote Text, Changing The Font Size Of Footnote Text, Changing The Color Of Footnote Text, Changing Line Separator Settings, Editing A Footnote, Deleting A Footnote, Restart Footnote Numbering In Every Page, Placing
more...
Quattro Pro 9 Introduction
...heet Tabs, The Application Bar, Opening A File, Exploring Cells, Using Scroll Bars, The File Menu, The Edit Menu, The View Menu, The Insert Menu, The Format Menu, The Tools Menu, The Window Menu, The Help Menu, Navigating Through The Cells, Navigating Through Spreadsheets, The Objects Sheet, Using Help, Accessing The System Information, Closing Quattro Pro Application
Lesson 2:
more...
Quattro Pro 9 Intermediate
...assword, Opening The High Level Password File, Protecting Cells, Unprotecting A Part Of Protected Spreadsheet, Using Conditional Color Lesson 5: Introduction, Opening An Existing File, Preparing A Macro Area For Storing Macros, Record A Macro, Naming Macros, Playing A Macro, Copying A Macro, Debugging A Macro, Editing Macro Cells From The Debugger, Exiting From The Debugging Mode, Naming
more...
Quattro Pro 9 Advanced
... @VLOOKUP - First Argument, Applying @VLOOKUP To Multiple Cells, @VLOOKUP - Fourth Argument, @HLOOKUP Function, @MAXLOOKUP And @MINLOOKUP Function, @MINLOOKUP Function, What-If Tables, One-Variable What-If Table, Selecting Table Range, The Input Cell, Using The What-If Expert, The Invoking Expert, Expert - Formula Cell, Expert - Input Cell, Table Cells, Two Variable What-If Tables, Row Input
more...
Excel XP Proficient Expert
... XP - Ask A Question - Microsoft Excel Help Work With Cells Cell 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 &
more...
From Easy Software Products
Learn how to use Excel 2004 for MAC

A powerful and flexible spreadsheet program designed specifically for Mac OS X, Excel 2004 makes it easier than ever to analyze, report, and share your data. The new tools in this version give you more control over your spreadsheets, and the enhanced charting tools give you more dynamic ways to display your information. Instruction by Robert Thell.
more...
