Search TeachExcel

Free Excel Training!

Help me create the best free Excel training experience on the web!

Today, I launch the Requested Tutorials feature that you can see below. Using this feature, I want to work with you to create the content that you want.

We start-off with a brand new course for UserForms in Excel. The goal is to create an expectional training guide for building UserForms in Excel so that you never have to pay to learn this material.

View the UserForms course outline in this blog post and feel free to leave your feedback there.

I need your help to create the content, and I look forward to working with you in a collaborative manner in order to create an extensive, open, and free learning experience for everyone!

Sign-in to your account today and submit a tutorial! :)

(Blog post about our future and how we want to work with you to create the best possible learning experience.)

Don

Latest Forum Posts

May 5, '21 at 9:54 am
Answers: 3
May 5, '21 at 10:06 am
Answers: 2
May 5, '21 at 10:27 am
Answers: 0
May 3, '21 at 7:50 pm
Answers: 0

Our YouTube Channel is Back!

Over 250 Video Tutorials and Counting!
  • Updated every week!
  • Step-by-step tutorials.
  • Excel workbooks included for all new tutorials.

Featured Excel Content


Excel Tip
The OR function in Excel checks if ANY argument in it evaluates to TRUE.  If anything evaluates to TRUE, then the function will return TRUE; to return FALSE, every argument in the function must evaluate to FALSE.  Even if only one argument in this function evaluates to TRUE, the function will return TRUE. This is the sister function to the AND fu ...
 
Excel Tip
The AND function in Excel checks if every argument you put in it evaluates to TRUE.  If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE. This is the sister function to the OR function. This is a very useful function and it is often used in con ...
 
Excel Tip
How to use the Vlookup function to return a result that falls within a range of numbers, such as a weight or quantity or even tests or grades. This allows you to, for example, return the letter A for a score of 90 - 100 on a test. Here, it is assumed that you are at least partly familiar with the Vlookup function.  If you want to learn more about ...
 
Excel Tip
How to make Excel automatically add row shading to every other row when you add data to the spreadsheet. This does NOT use the Table feature in Excel.  This tutorial will show you how to use a formatting method to achieve automatically alternating row colors. Steps to Automatically Shade Alternating Rows When Data is Added to a Spreadsheet Select ...
 
Excel Tip
How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within the worksheet and how to print them at the end of the worksheet all in one place. Steps to Print Comments Go to the Page Layout tab and click the little button in the bottom right corner of the Page Setup section. In the window that op ...
 
Excel Tip
How to shade every other row in Excel quickly without using the Table feature. This method is for when you simply want to shade the rows and nothing more; when you do not want to convert your data to a Table type in Excel. Sections: Steps to Shade Every Other Row in Excel Quickly Remove Background Shading Remove Lines From Between the Cells Notes S ...
 
Excel Tip
Make a macro run when you click a button in the worksheet in Excel. This allows you to create a button and put it anywhere in the spreadsheet and then to have a macro run when that button is clicked. Steps to Have a Macro Run When a Button is Clicked Create the button.  Go to the Insert tab and click the Shapes button and select the desired butto ...
 
Excel Tip
(New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial teaches you how to build the formula needed to increment a value or, really, do anything every so many rows in Excel. Section: The Formula That Knows in Which Row You are in Excel How to Increment a Value Based on ...
 
Excel Tip
How to calculate the number of periods required for an investment in order to get the desired return.  The number of periods required for the investment tells you how long the investment must last.  This is based on a constant interest rate, a present value, and an optional future value. Syntax =NPER(rate, pmt, pv, [fv], [type]) Argument Descript ...
 
Excel Tip
Quickly find all rows in Excel that contain a certain value and then delete those rows. This is a simple technique for quickly searching an entire worksheet to locate specific rows that you can then delete without having to individually search a data set and delete each row. Steps to Delete All Rows that Contain a Specific Value Go to the workshee ...
 
Excel Forum