| |
| |
Microsoft Excel Tutorials
For
Excel 2000, XP, and 2003
|
| |
|
Beginner Lessons |
 | Excel 101 |
$1 | Introduction to
Microsoft Excel |
| |
 | | Getting started, Entering & Editing Data, Formatting, Basic Math, Simple Functions, Copy & Paste, Saving. You will learn all of the basics of Excel. We'll talk about the
different parts of the screen, how to enter and edit data, how to
perform mathematical calculations, how to use functions like SUM
and AVERAGE, and how to cut, copy, and paste.
More info. |
|
| Excel 102 |
$1 |
Using Microsoft Excel 1 |
| |
 | |
AutoFill, Sorting Data, Creating a Calendar, Resizing, Charting & Graphing, Formatting, 3D Rotations. You will learn how to
use the AutoFill feature to create a functional calendar. You
will learn how to properly Sort data using multiple sorting
techniques. You will learn about charting and graphing, 3D
rotations. More info. |
|
|
Excel 103 |
$5.99 |
Using Microsoft Excel 2 |
| |
 | |
Page Setup, Print Options, Headers & Footers, Margins,
Income & Expense, Working Between Multiple Sheets. We will set up an
Income and Expense Report sheet, learn how to work with large
spreadsheets by freezing panes and splitting sheets, work with page
setup, margins, layout, headers, footers, sheet tabs, and more
formatting options. More info. |
|
|
Excel 104 |
$9.99 |
Using Microsoft Excel 3 |
| |
 | |
Format Cells, Number Formatting, Cell Alignments, Conditional Formatting, Financial Calculator. We will set up a
Monthly Sales Log, work with cell formats, alignments, rotations,
conditional formatting, and AutoFormats. We will build a Financial
Loan Calculator, and show you how to protect your worksheets and
lock cell contents. More info. |
|
|
Intermediate Lessons |
|
Excel 201 |
$12.99 |
Intermediate
Excel 1 |
| |
 | |
IF Function, Relative v. Absolute References, Referencing
values on other sheets, Linking to Word. In our first
Intermediate course, you will begin to learn how to make Excel
smart. We'll learn the IF function, to let Excel make
decisions. You will see how to share data between two sheets, and
how to look up values from other workbook files.
More info. |
|
|
Excel 202 |
$19.99 |
Intermediate
Excel 2 |
| |
 | |
Named Cells & Ranges, Nested IF Functions,
VLOOKUP and HLOOKUP functions, lookup tables. You will learn how to work with named cells and named ranges.
You will learn how to get more control of Excel using Nested IF
functions. You will also learn about the powerful VLOOKUP
function which can be used to look up values in sub tables.
More info. |
|
|
Excel 220 |
$19.99 |
Excel
Data Analysis 1 |
| |
 | |
Creating and Formatting Data Lists, Data Entry Forms. Advanced Data Sorting Techniques, Customizing Toolbars. We
begin our look at Data Analysis. We'll learn about Data Lists,
formatting those data lists, Data Entry Forms, advanced list
sorting techniques, and customizing toolbars for use with data analysis.
The first class in a five-part series.
More info. |
|
|
Excel 221 |
$19.99 |
Excel
Data Analysis 2 |
| |
 | |
AutoFilter, Custom AutoFilter, Advanced Filtering, Sending Late Notices, Custom Views, Subtotal Function, Subtotals. We
continue our Data Analysis series with the AutoFilter feature,
custom filtering, advanced record filtering, sending late notices
to customers, custom views, the SubTotal function, and creating
automatic subtotals on our sheets. More
info. |
|
|
Excel 222 |
$19.99 |
Excel
Data Analysis 3 |
| |
 | |
Styles, Grouping & Outlining, Manual Grouping, Grouping Tips & Tricks, Data Validation, We learn about styles, grouping and outlining, data validation,
and lots more. We'll learn how to create drop-down lists, check
what information users are entering into our sheets, and yell at them if
they enter something wrong. More info. |
|
|
Excel 223 |
$19.99 |
Excel
Data Analysis 4 - PivotTables 1 |
| |
 | |
What is a PivotTable, Creating PTs, Pivoting Data, Sales Log, Sorting PT Data, Filtering, Refreshing, Page Fields. In Excel 223
we begin studying one of the most powerful features in Excel: Pivot Tables,
plus filtering, grouping, subtotals, calculated fields, base fields, and
much more. Don't miss this double-class.
More info. |
|
|
Excel 224 |
$19.99 |
Excel
Data Analysis 5 - PivotTables 2 |
| |
| |
Grouping PT Data, Group Dates, Subtotals, Field Settings, Formatting, Calculated Fields/Items, Base Fields. In Excel
224 we continue looking at one of the most powerful features in Excel: Pivot Tables,
plus filtering, grouping, subtotals, calculated fields, and base
fields. More info. |
|
|
Excel 230 |
$19.99 |
Intermediate Excel
230 |
| |
 | |
Multisheet (3D) Ranges, Go To Special, Advanced Find
and Replace, AutoRecover, Passwords, Templates. You will learn how to create Templates for things like invoices
and sales reports, plus multisheet (3D) ranges, go to special, advanced
find & replace, AutoRecover, password protection.
More info. |
|
|
Excel 231 |
$19.99 |
Intermediate Excel
231 |
| |
 | |
Error Handling, Specific Error Messages, Logical Functions, Auditing Toolbar, Circular References, Hide Errors. You will how to deal
with all of the Errors that Excel will throw at you. We'll learn
specific error messages, syntax errors, and logical errors. You will
learn how to use the Auditing Toolbar to trace errors, and how to
deal with Circular References.
More info. |
|
|
Excel 232 |
$19.99 |
Intermediate Excel
232 |
| |
 | |
Custom Number and Date Formats, Scaling Values, Text Manipulation Functions, Concatenation. You will how to create
custom number and date formats, display fractions, inches,
etc. We will learn Text Manipulation functions like Left, Right,
Upper, etc. You will see how to split and put together different text
strings. You'll learn lots of new functions.
More info. |
|
|
Excel Seminars |
|
|
|
|
Advanced Lessons |
|
Advanced
Developer
VBA |
We are currently
in the process of developing new Expert, Advanced, and
Developer-level courses for Microsoft Excel 2010. If you would
like to be notified when they are available, sign up for our
Mailing List. You can check our
Production Schedule
for a timeline.
Remember, if you purchase any of our older Excel
2003 tutorials above, you will get a
FREE UPGRADE once the 2010 version is released.
|
|
|
| |
|
Click here
for Excel 2007
or Excel 2010
tutorials. |
| |
|
|
