Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

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
 QuickStart Seminar Online seminar for beginner to advanced students Video from our Live Excel Seminar. More info.
 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.

 Check out these other pages that may be of interest to you:
 4/17/2023 Military Time Import 4/12/2023 Timestamp 4/7/2023 Excel VBA 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab