New and Updated Macros         Macros added December 1

            TeachExcel.com is considering offering online courses in Excel.
         Let us know your thoughts on such an offering, if you would be interested
           in such a thing and also what you would want from it.
     Visit our online poll to vote and post your thoughts: Poll and Forum.
       Or
     Email us at:    OnlineCourses@TeachExcel.com

New Macros

Print Embedded Worksheets           Delete Duplicate Rows
Disable "Save As"                          Get Source Data from Charts
Send Emails From Lists                 Delete Rows Based on their Contents
more...

Excel 2003 Versus Excel 2007

This is a comparison of Excel 2003 and Excel 2007.
Excel 2007 has Excel 2003 beat on features and graphics.
But the issue of usability prevents Excel 2007 from being an obvious upgrade.

Forum

Newly completed forum. Check it out for quick answers to all your questions as well as to post suggestions for future tutorials or additional content you feel should be on the site.

Link Cells from Different Workbooks       

How to link cells between different excel workbooks. Also, How to update, break, and change links between seperate workbooks.

VLOOKUP() - What is it and how to use it       (Updated Aug. 22, 2008)

VLOOKUP() searches through columns of data to return a desired value. This tutorial explains what the VLOOKUP() function is and how and why you would want to use it.

Using AND() OR() IF() Statements/Formulas       (Updated Aug. 19, 2008)

Explains what the AND() and OR() functions are and what they do and then shows you how to use the AND() OR() and IF() statements and formulas together in excel.

Macro - Protect/Unprotect All
Worksheets Simultaneously       (Updated Aug. 13, 2008)

Allows you to protect and unprotect every worksheet in a workbook at once. Saves time and is very convenient when protecting your data.

Macro - Transpose Data       (Updated Aug. 12, 2008)

VBA code which creates a macro in excel letting you transpose data quickly and easily."