This
course will help you maximize your understanding of the
world's top spreadsheet program while helping you prepare
for MOUS Certification. Learn formulas, formatting, layout,
commands, functions, charts, database shortcuts, pivot
tables, files and reports and much more.
Excel
2000 (Beg/Int/Adv):
3
Fully-Interactive CD-ROMs or Video Tapes
Free
Shipping (in U.S.)
Online:
$149.00
Excel
2000 (Set of 10):
10
Fully-Interactive CD-ROM's or Video Tapes
Free
Shipping (in U.S.)
Online:
$449.00
Order
with absolute confidence, all Order pages...
Detailed Course
Outline
Beginning
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
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
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
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
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
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
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
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 & Rand between
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
Meet
the Trainer
Dennis P. Taylor has spent over 14 years presenting PC software
training to individuals in classrooms and seminars, including
employees at Amoco, IBM, and many other companies. He specializes
in spreadsheet software and has co-authored several books
for spreadsheets. Five years ago he turned his attention to
Excel spreadsheets and has become an Excel training specialist.
Dennis brings a combination of in-depth knowledge and training
experience to this course. Watch and learn in minutes with
Dennis.
Order
with complete confidence, all Order pages...
Aaron's Computer Training is your online source
for MCSE and A+ Certification computer training courses. We
also offer a complete suite of computer training certification
beyond A+ and MCSE Certification. Some of our most popular
classes are: Microsoft Office, MOUS, Linux, and Oracle.
Call
for Orders or Questions:1-800-617-5586
Toll Free ! Customer Service Hours: 9:00am-5:00pm,
eastern time, Monday - Friday aarons@aarons-computer-training.com
Excel
2000
This
course will help you maximize your understanding of the
world's top spreadsheet program while helping you prepare
for MOUS Certification. Learn formulas, formatting, layout,
commands, functions, charts, database shortcuts, pivot
tables, files and reports and much more.
