|
 Inquire about Microsoft Office 2000 and XP Training
Microsoft Excel is a powerful spreadsheet program that you can use to efficiently store and work with lists of data, calculate numbers, and create reports and charts. Excel enables you to:
- Enter and format your data, and write formulas
- Create a template to speed up your work
- make your worksheets available over the internet or intranet with Microsoft Frontpage™.
- Manage your tasks with the help of Microsoft Outlook ™.
- Consolidate data from several worksheets into one.
- Find and organize information by filtering, sorting, and subtotaling.
- Summarize and analyze data using PivotTable ® dynamic views.
- Use charting to visualize trends and relationships.
- Print the reports you require.
- Find the optimum answer by using Goal Seek and Scenario Manager to compare alternatives.
- Work simultaneously with others by sharing a workbook via your company intranet.
- plus much more . . .
Microsoft Excel 97 Training Videos and CDs Detailed Information
|
Excel 97 Set of Three CD's Beg/Inter/Adv
|
kyex7ma
|
$119.95
|
|
|
Excel 97 Set of Three Videos Beg/Inter/Adv
|
kyex7b
|
$119.95
|
|
|
All 6 Excel 97 Videos - Beg/Inter/Adv with Power Features, Tables, and Shortcuts
|
kyex7a
|
$219.95
|
|
Microsoft Excel 97 Training Videos and CD-ROMS |
|
Beginning Training Video or CD (2 hrs 20 min) #kyex71
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 Training Video or CD (2 hrs 20 min) #kyex72
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 Training Video or CD (2 hrs 23 min) #kyex73
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
Power Features Training Video (1 hr 49 min) #kyex74
1.0 Customizing Toolbars (16 min)
1.1 Basic Toolbar Features
1.2 Adding & Removing Tools
1.3 Creating a Toolbar
2.0 Arrays (21 min)
2.1 Array Formulas
2.2 Array Functions
3.0 Text Functions (22 min)
3.1 Find
3.2 Left
3.3 Mid
3.4 Concatenation
3.5 Proper Case
3.6 Edit Paste Special
4.0 More Functions (22 min)
4.1 IsError
4.2 Round
4.3 Rand
4.4 Max, Large & Small
5.0 Goal Seek (7 min)
5.1 Practical Examples
6.0 Numeric Formatting Capabilities (9 min)
6.1 Format Cells Command
6.2 Conditional Formatting
7.0 Macros (10 min)
7.1 Recording a Macro
7.2 Assigning a Command Button to a Macro
Pivot Tables Training Video (1 hr 52 min) #kyex75
1.0 Working With Data in Excel (16 min)
1.2 Sorting Data
1.3 Data Subtotals
1.4 Pivot Table Examples
2.0 Creating a Pivot Table (16 min)
2.1 Pivot Table Wizard
2.2 Pivot Table Layout
3.0 Manipulating Pivot Tables (16 min)
3.1 Moving Fields by Dragging & Dropping
3.2 Removing Fields
3.3 Page Axis
3.4 Pivot Table Toolbar
4.0 Formatting (19 min)
4.1 Adding & Formatting Fields
4.2 Refreshing Tables
4.3 Structured Selection
4.5 Auto Format
5.0 Charting from Pivot Tables (5 min)
5.1 Displaying Data from a Pivot Table in a Chart
6.0 Empty Cells & Errors (7 min)
6.1 Altering Blank Cell Display
6.2 Methods for Handling the Display or Cells with Errors
7.0 Sorting (5 min)
7.1 Using the Sorting Tools
7.2 Sorting Rearranged Cells
8.0 Hiding Data (9 min)
8.1 Hiding Fields
8.2 Showing Cell Detail
8.3 Hiding Individual Items
9.0 Grouping (6 min)
9.1 Grouping Cells
10.0 Pivot Table Display (9 min)
10.1 Understanding Subtotals & Grand Totals
10.2 Displaying Grand Totals
10.3 Displaying Subtotals
Short Cuts and New Ideas Trainig Video (1 hr 49 min) #kyex76
1.0 Navigation Shortcuts (12 min)
1.1 Moving to Worksheet Locations
1.2 Jumping to other Sheets & Workbooks
1.3 Minimizing & Maximizing Screen Displays
2.0 Command Shortcuts (5 min)
2.1 Four Ways to Undo Your Last Action
2.2 Five Ways to Repeat an Action
2.4 File Command Shortcuts
3.0 Cell Selection Tips (11 min)
3.1 Range Selection with the Keyboard
3.2 Selecting Non-contiguous Ranges
3.3 Selecting all or a Continuous Selection of Cells
4.0 Simplifying Data Entry (17 min)
4.1 Instant Date & Time Entry
4.2 Copying Cell Formula or Content from a Cell above
4.3 Entry of Same Content or Relative Formula in Scattered Locations
4.4 Controlling Line Breaks During Cell Entry
4.5 Copying a Formula down a Column & Starting a Series with one Cell
5.0 Copy/Move with Insert (13 min)
5.1 Move or Copy Combined with Insert - From the Keyboard
5.2 Moving & Copying Data to Another Sheet by Dragging
5.3 Moving, Copying & Inserting Data on Another Sheet by Dragging
6.0 Editing Tips (11 min)
6.1 Copy/Paste from the Edit Line to the Same or a Different Cell
6.2 Keystroke Shortcut to Activate Past Function During Editing
6.3 Quick Rotation Through Absolute/Relative Cycle
6.4 Deletion of Part of the Edit Line
7.0 Data Analysis (8 min)
7.1 Quick Methods of Tracing Dependent & Precedent Cells
7.2 Displaying Formulas Throughout a Worksheet
8.0 Formatting Shortcuts (10 min)
8.1 Using Trailing Commas to Suppress 000's in Long Number Entries
8.2 Decimal Display of Fractions
8.3 Fractional Display of Decimal Numbers
8.4 Keyboard Shortcuts for Dollar & Percent Sign Display
9.0 Column/Row Insert & Delete (14 min)
9.1 Single Step Method of Column or Row Insertion
9.2 Keyboard Method of Column Insertion
9.3 Hiding & Un-hiding Columns or Rows
10.0 Getting Double Use Out of Toolbar Buttons (7 min)
10.1 Using the Shift Key to Make Toolbar Buttons Perform Differently
10.2 Using New Toolbar Buttons that Can Work in Opposite Ways
11.0 Chart Sizing Tips (5 min)
11.1 Changing Chart Size & Position
|
