Search TeachExcel.com
Video Tutorials, Free Macros, Shortcuts, and More...
Home
Video Tutorials
Free Macros
Keyboard Shortcuts
Forum
Contact
Main Menu
  • Home
  • Video Tutorials
    • Arrays
    • Charts & Graphs
    • Financial Functions &
    • Models
    • Formatting
    • Formulas
    • Data Analysis Tools
    • Import / Export / Link
    • Lists & Forms
    • Macros
    • Printing
    • Security
    • Tips & Tricks
  • Free Macros
  • Excel 2007 Resources
  • Keyboard Shortcuts
  • Forum
  • Contact/About
Tips
Create your first Formula
Create your first Chart or Graph
Password protect your Workbook
Hide Rows, Columns, and Tabs
Using Conditional Formatting
Buy Microsoft Office Excel 2007 here!
   New and Updated Macros         Macros added December 1
Hide Formulas but Display Cell Contents
Delete Empty Columns
Delete All Text from Cells
Reverse Cell Contents
Remove All Hyperlinks from Worksheets
Highlight Cells with Formulas
Automatically Highlight the Selected Cell
Delete Broken Named Ranges
Interested in Online Excel Courses? (Not an Ad!)
            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
   Macros  - Free
     Reverse Order of Data in Rows & Columns
     Delete Only Completely Empty Rows
     Protect/Unprotect all Worksheets at Once
more...
  Keyboard Shortcuts
Stop wasting time and learn how to use all of Excel's Keyboard Shortcuts.


Past Spotlights

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

Excel 2003 VS. Excel 2007This 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."



Most Recent Tutorials
Nov. 25
Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)
Absolute and Relative Cell References & INDIRECT() Function
Sep. 20
Bond Pricing and Valuation
Calculate the Future Value of a Retirement or Savings Plan
Calculate the Net Present Value of Future Cash Flows
Build a Loan/Mortgage Payment Calculator
Calculate Interest and Principal Payments on a Loan
Sep. 10
FIND() LEN() Functions - Extract Text from Cells - Intermediate
FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED
VLOOKUP() Between Separate Worksheets and Workbooks
Contact | Privacy Policy | Disclaimer
Copyright© 2008 TeachExcel.com