|
Course Outline - Excel 2000 Training
Time: Approx 1.5 to 2 hours training per video/CD
Excel 2000 - Beginning (2 Hrs 16 Mins)
1.0 The Excel Screen (32 Mins)
1.1 The Excel Workbook & 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 Mins)
2.1 Data Entry Techniques
2.2 Auto-Fill Entry Techniques
2.3 Erasing Data
2.4 Auto Complete
3.0 Entering Formulas (26 Mins)
3.1 Three Methods of Entering Formulas
3.2 Repeating a Formula
3.3 Formulas Beyond Addition & Subtraction
4.0 Basic Functions (21 Mins)
4.1 Summation
4.2 Recalculating Effects
4.3 Averages
5.0 Formatting (13 Mins)
5.1 The Formatting Toolbar
5.2 Adjusting Column-width & Row-height
5.3 Numeric Formatting
6.0 Saving (17 mins)
6.1 File Save or File Save as
6.2 Opening a File
6.3 Closing a File
6.4 Creating a new Workbook
Excel 2000 - Intermediate (2 Hrs 5 Mins)
1.0 Changing Worksheet Layout (26 Mins)
1.1 Inserting Columns
1.2 Deleting Columns
1.3 Moving Cells
1.4 Copying Cells
2.0 Additional Formatting (6 Mins)
2.1 Formatting Cell Attributes & Alignment
2.2 Borders
2.3 Numeric Formatting
2.4 Center Text across Columns
2.5 Hiding & Unhiding Columns & Rows
3.0 Printing (25 Mins)
3.1 Using Print Preview & Page Setup
3.2 Printing Controls
3.3 Using Page Break Preview
4.0 Using Cell References (29 Mins)
4.1 Absolute References
4.2 Mixed References
5.0 Tools Options Command (18 Mins)
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
Excel 2000 - Advanced (2 Hrs 2 Mins)
1.0 Adjusting Worksheet Views (13 Mins)
1.1 Freeze/Unfreeze Panes
1.2 Horizontal & Vertical Split screen
2.0 Auditing Techniques (12 Mins)
2.1 Using the Auditing Toolbar
2.2 Tracing Dependant Cells
2.3 Tracing Precedent Cells
3.0 Using Functions (18 Mins)
3.1 Paste Function
3.2 The PMT Function
3.3 Expanding the use of standard functions
4.0 Logical Functions (30 Mins)
4.1 IF Functions & 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 Mins)
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 Mins)
6.1 Re-Naming & Re-Ordering Sheets
6.2 Inserting & Deleting Sheets
6.3 Moving
6.4 Formulas across multiple sheets
Excel 2000 - Charts (2 hrs 12 min)
1.0 Creating a Chart (32 min)
1.1 Data Selection
1.2 Single-click Chart Creation
1.3 Chart Wizard
1.4 Copying a Chart
2.0 The Charting Toolbar (16 min)
2.1 Features of the Charting Toolbar
3.0 Printing a Chart (13 min)
3.1 Printing a Chart Located on a Separate Sheet
3.2 Printing a Chart Located on a Worksheet
4.0 Shortcuts (10 min)
4.1 Creating a Shortcut on the Worksheet with Two Clicks
4.2 Add & Remove Data from an Embedded Chart
4.3 Change Row/Column Orientation
5.0 Chart Types (45 min)
5.1 Line Charts
5.2 Column Charts
5.3 Cone
5.4 Pie Charts
5.5 Other Chart Types
6.0 Formatting the X & Y Axes (6 min)
6.1 Adjusting the Scale on Column Charts
6.2 Adjusting the Scale on Line Charts
7.0 Annotation Features (7 min)
7.1 Adding Text & Arrows
Excel 2000 - Special Topics (1 hr 58 min)
1.0 Naming Ranges (21 min)
1.1 Naming a Single Cell
1.2 Naming Multiple Cells
1.3 Using Existing Names
1.4 Paste a List of Range Names in a Worksheet
1.5 Deleting Range Names
2.0 Conditional Formatting (10 min)
2.1 Formatting Based on Values & Multiple Conditions
2.2 Avoiding Overlapping Conditions
2.3 Using a Formula to Control Formatting
3.0 Cell Protection Techniques (6 min)
3.1 Unlocking Selected Cells Changes
3.2 Protecting the Worksheet to Restrict Entry to Unlocked Cells
3.3 Unprotecting the Worksheet
4.0 Annotating a Worksheet with Comments & Drawing Tools (12 min)
4.1 Inserting
4.2 Options for Printing Comments
4.3 Show/Hide Comments with the Tools Options Command
4.4 Using Drawing Toolbar
5.0 Multiple Workbooks (14 min)
5.1 Opening & Displaying Multiple Workbooks
5.2 Moving & Copying Sheets Across Workbooks
5.3 Linking Formulas Across Workbooks
5.4 Locating & Maintaining Links
6.0 Customizing Toolbars (17 min)
6.1 Adding & Removing Buttons
6.2 Economizing Buttons & Resetting Toolbars
6.3 Creating New Toolbars
7.0 Find & Replace (8 min)
7.1 Matching Entire Cells
8.0 Using Goal Seek (11 min)
8.1 Features of Goal Seek
9.0 Numeric Formatting (16 min)
9.1 The Custom Category
9.2 The Special Category
9.3 Formatting with IMPLIED-IF
Excel 2000 - Databases (2 hrs 10 min)
1.0 Data Form (13 min)
1.1 Setting up a Single Record with Formulas
1.2 Adding Records to a Database
1.3 Finding Records & Avoiding Cells Below
2.0 Data Validation (21 min)
2.1 Establishing Data Entry Criteria
2.2 Using Data Validation on Existing Data
3.0 Data Sort (24 min)
3.1 Sorting from the Menu
3.2 Sorting from the Toolbar
3.3 Multiple-Key Sorting
3.4 Sorting with Custom Lists
4.0 Data Subtotals (19 min)
4.1 Single Level Subtotals
4.2 Multiple Level Subtotals
5.0 Data Filter (29 min)
5.1 Criteria
5.2 Top-ten
5.3 Advanced Filter
6.0 Data Functions (22 min)
6.1 Sumif
6.2 Array Functions & Formulas
Excel 2000 - Tips, Tricks & Shortcuts (1 Hr 41 Mins)
1.0 Navigation Shortcuts (15 Mins)
1.1 Navigating Around a Worksheet
1.2 Navigating Multiple Workbooks
1.3 Some Useful Keyboard Shortcuts
1.4 Navigating to the Bottom of a Column
2.0 Selection Shortcuts (10 Mins)
2.1 Selecting a Range
2.2 Selecting an Entire Worksheet
2.3 Selecting Non-contiguous Ranges & Go to Special
3.0 Data Entry Shortcuts (10 Mins)
3.1 Entering System Date & Time
3.2 Copying Formulas & Results
3.3 Entering Data in a Range of Cells Data Validation
3.4 Multi-line Entries
4.0 Formula Shortcuts (8 Mins)
4.1 Displaying Formulas
4.2 Dependent & Precedent Cells
4.3 VLookup
5.0 Formatting Shortcuts (14 Mins)
5.1 Numerical Formatting
5.2 Numerical Keyboard Shortcuts
5.3 Dealing with Large Numbers
6.0 Operational Shortcuts (12 Mins)
6.1 Undoing & Repeating
6.2 File Management Shortcuts
6.3 Inserting
7.0 Data Expansion Shortcuts (7 Mins)
7.1 Numerical Series
7.2 Dates
8.0 Drag & Drop (8 Mins)
8.1 Moving, Copying & Inserting
8.2 Moving, Copying & Inserting to a Different Sheet
8.3 Moving, Copying & Inserting using a Mouse
9.0 Display Shortcuts (4 Mins)
9.1 Split Screens
10.0 Listing Unique Entries (10 Mins)
10.1 Data Filter Advanced
10.2 Capturing a Picture
Excel 2000 - Pivot Tables (1 Hr 48 Mins)
1.0 Background (10 Mins)
1.1 An Example
2.0 Creating a Pivot Table (18 Mins)
2.1 Using the Pivot Table & Pivot Chart Wizard
2.2 Viewing Pivot Tables & Pivot Charts
3.0 Manipulating the Layout (15 Mins)
3.1 Interchanging Fields
3.2 Adding & Removing Fields
3.3 Page Axis
4.0 Content & Formatting (7 Mins)
4.1 Numeric Formatting
4.2 Selecting Specific Information & AutoFormat
5.0 The Refresh Button (7 Mins)
5.1 Changing Original Data
5.2 Changing Field Names
6.0 Pivot Table Chart Sources (14 Mins)
6.1 Selecting & Manipulating Chart Data
6.2 The Pivot Chart & Pivot Table Relationship
6.3 Pivot Chart Formatting
6.4 Creating a Pivot Chart & Table Together from the Original Data
7.0 Sorting Items (9 Mins)
7.1 Sorting by Field Order & Numeric Information
8.0 Hiding & Revealing Data (13 Mins)
8.1 Drop Arrows
8.2 Hiding Inner Fields
9.0 Grouping & Ungrouping (5 Mins)
9.1 Grouping Data
9.2 Grouping by Date
10.0 Totals (8 Mins)
10.1 Displaying Totals
10.2 Adding & Removing Totals
Excel 2000 - Functions (1 Hr 49 Mins)
1.0 Statistical Functions (24 Mins)
1.1 Median & Rank
1.2 Small & Large
1.3 Count
1.4 Using Functions in a Range
1.5 Average
2.0 Analysis ToolPak (6 Mins)
2.1 Accessing more Functions
3.0 Financial Functions (10 Mins)
3.1 PMT & FV
3.2 PV & Rate
4.0 Math Functions (33 Mins)
4.1 Round
4.2 Ceiling & Floor
4.3 Odd & Even
4.4 Fact
4.5 Mod
4.6 Rand & Randbetween
4.7 Roman
5.0 Text Functions (27 Mins)
5.1 Find & Mid
5.2 Left & Concatenation
5.3 Len & Right
5.4 An Example
5.5 Upper
5.6 Trim
6.0 The Indirect Function (6 Mins)
6.1 The Indirect Function
Excel 2000 - Files & Reports (2 Hrs 26 Mins)
1.0 Workbook Management (10 Mins)
1.1 Workspaces
1.2 Assigning Passwords
1.3 Hiding Workbooks
2.0 Formatting Workbooks (12 Mins)
2.1 AutoFormat
2.2 Styles
3.0 Outlining (9 Mins)
3.1 Group & Outlining Capabilities
4.0 Templates (10 Mins)
4.1 Creating a Default Workbook Template
4.2 Creating a Custom Template
5.0 Report Manager (9 Mins)
5.1 Printing & Views 6.0 Scenario Manager (18 Mins)
6.1 Creating Scenarios
6.2 Solver
7.0 The Drawing Toolbar (45 Mins)
7.1 WordArt
7.2 Shapes
7.3 Coloring Objects & Adding Text
7.4 ClipArt
8.0 Using Excel with Other Applications (15 Mins)
8.1 Text Files
8.2 Access
8.3 Word
9.0 Hyperlinks (16 Mins)
9.1 Types of Links
|
Multimedia CD-ROM Based Training:
