|
Provided by: 123-CBT Computer Based Training Excel 2000 User Set of 3 |
 |
Training
Provided by 123-CBT Computer Based Training
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 2.4 Auto Complete 3.0 Entering Formulas (26 Minutes) 3.1 Three Methods of Entering Formulas 3.2 Repeating a Formula 3.3 Formulas Beyond Addition and Subtraction 4.0 Basic Functions (21 Minutes) 4.1 Summation 4.2 Recalculating Effects (Change one cell and five others change) 4.3 Averages 5.0 Formatting (13 Minutes) 5.1 The Formatting Toolbar 5.2 Adjusting Column-width and Row-height 5.3 Numeric Formatting 6.0 Saving, Opening & Closing Files (16 Minutes) 6.1 File Save or File Save as 6.2 Opening a File 6.3 Closing a File 6.4 Creating a new Workbook 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 Printing (25 Minutes) 3.1 Using Print Preview and Page Setup 3.2 Printing Controls 3.3 Using Page Break Preview 4.0 Using Cell References (29 Minutes) 4.1 Absolute References 4.2 Mixed References 5.0 Tools Options Command (18 Minutes) 5.1 Show/Hide Gridlines 5.2 Show/Hide Formulas 5.3 Recently used Files List 5.4 Sheets in New Workbook 5.5 Default Settings 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 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 Logical Operators (AND & OR) with the IF Function 4.5 Nested IF Functions 4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions 5.0 Date & Time Functions (21 Minutes) 5.1 Using Dates as Values 5.2 Entering a Series of Dates 5.3 Date/Time entry Techniques 6.0 Multi-Sheet Workbooks (22 Minutes) 6.1 Re-Naming & Re-Ordering Sheets 6.2 Inserting and Deleting Sheets 6.3 Moving, Copying and Grouping Sheets 6.4 Formulas across multiple sheets
|
|
||||||||
Excel 2000 User Set of 3
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
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width and Row-height
5.3 Numeric Formatting
6.0 Saving, Opening & Closing Files (16 Minutes)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook
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 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Minutes)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Minutes)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings
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 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 Logical Operators (AND & OR) with the IF Function
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
5.0 Date & Time Functions (21 Minutes)
5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time entry Techniques
6.0 Multi-Sheet Workbooks (22 Minutes)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving, Copying and Grouping Sheets
6.4 Formulas across multiple sheets
Program:
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
2.4 Auto Complete
3.0 Entering Formulas (26 Minutes)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition and Subtraction
4.0 Basic Functions (21 Minutes)
4.1 Summation
4.2 Recalculating Effects (Change one cell and five others change)
4.3 Averages
5.0 Formatting (13 Minutes)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width and Row-height
5.3 Numeric Formatting
6.0 Saving, Opening & Closing Files (16 Minutes)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook
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 Printing (25 Minutes)
3.1 Using Print Preview and Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Minutes)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Minutes)
5.1 Show/Hide Gridlines
5.2 Show/Hide Formulas
5.3 Recently used Files List
5.4 Sheets in New Workbook
5.5 Default Settings
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 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 Logical Operators (AND & OR) with the IF Function
4.5 Nested IF Functions
4.6 Using the VLOOKUP Function to overcome Limitations of the IF Functions
5.0 Date & Time Functions (21 Minutes)
5.1 Using Dates as Values
5.2 Entering a Series of Dates
5.3 Date/Time entry Techniques
6.0 Multi-Sheet Workbooks (22 Minutes)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting and Deleting Sheets
6.3 Moving, Copying and Grouping Sheets
6.4 Formulas across multiple sheets
Modality:
CDSee Also:
611006 611007 611008
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
