Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 
Microsoft Excel Tutorials
For Excel 2000, XP, and 2003
 
Beginner Lessons
Excel 101 $5.99Introduction 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 $9.99 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 $9.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 $12.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 $19.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
QuickStart Seminar Online seminar for beginner to advanced students
Video from our Live Excel Seminar.
More info.
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.

 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP