|
Courses - Microsoft
Excel |
 |
Learn Microsoft
Excel
If you're looking for
Microsoft Excel training,
you've come to
the right place.
Our instructor, Richard Rost, has been
teaching Excel in the classroom since 1994.
Complete
Topic Index
More Free Lessons in our
Tips & Tricks Section
|
|
| |
 |
Click for more
information on any course |
|
 |
|
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... |
 |
|
|
| |
|
Using Microsoft Excel 1 |
| |
|
AutoFill, Sorting Data, Creating a Calendar, Resizing,
Charting & Graphing, Formatting, 3D Rotations, more. |
| 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, and more.
More... |
 |
|
|
| |
|
Using Microsoft Excel
2 |
| |
|
Page Setup, Print Options, Headers & Footers, Margins,
Income & Expense, Working Between Multiple Sheets, more. |
| 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... |
 |
|
|
| |
|
Using Microsoft Excel 3 |
| |
|
Format Cells, Number Formatting, Cell Alignments,
Conditional Formatting, Financial Calculator, and more. |
| 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... |
 |
|
|
| |
|
Intermediate
Excel 1 |
| |
|
IF Function, Relative v. Absolute References, Referencing
values on other sheets, Linking to Word, and more. |
| 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... |
 |
|
|
| |
|
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... |
 |
|
|
| |
|
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... |
 |
|
|
| |
|
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... |
 |
|
|
| |
|
Excel
Data Analysis 3 |
| |
|
Styles, Grouping & Outlining, Manual Grouping,
Grouping Tips & Tricks, Data Validation, More. |
| 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... |
 |
|
|
| |
|
Excel
Data Analysis 4 - PivotTables Part 1 |
| |
|
What is a PivotTable, Creating PTs, Pivoting Data, Sales
Log, Sorting PT Data, Filtering, Refreshing, Page Fields |
| In Excel 223 and
224 we study 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... |
 |
|
|
| |
|
Excel
Data Analysis 5 - PivotTables Part 2 |
| |
|
Grouping PT Data, Group Dates, Subtotals, Field Settings,
Formatting, Calculated Fields/Items, Base Fields, More! |
| In Excel 223 and
224 we study 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... |
|
|
|
| |
|
Intermediate Excel
230 |
| |
|
Multisheet (3D) Ranges, Go To Special, Advanced Find
And Replace, AutoRecover, Passwords, Templates, More. |
| 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, and lots more.
More... |
 |
|
|
| |
|
Intermediate Excel
231 |
| |
|
Error Handling, Specific Error Messages, Logical Functions,
Auditing Toolbar, Circular References, Hide Errors, More |
| 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. Lots more.
More... |
 |
|
|
| |
|
Intermediate Excel
232 |
| |
|
Custom Number and Date Formats, Scaling Values,
Text Manipulation Functions, Concatenation, More. |
| 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... |
 |
|
|
| |
Excel 301 |
|
UNDER
DEVELOPMENT |
Join our MAILING LIST to be
notified when this course
is released, and for other special offers and discounts. |
|
|
| |
Excel
Seminar
|
Online seminar for beginner to
advanced students
Video from our Live Excel Seminar |
|
| |
|
Click for more
information on any course |
|
|
You will learn how to build spreadsheets the
way they should be built.
