Our Excel Courses

Latest Forum Posts

Using VBA to save as (export) specific worksheets
Apr 23, '24 at 6:01 pm
Answers: 2
Inserting 3 rows in between 1700 and 1900 time
Apr 23, '24 at 8:54 pm
Answers: 0
Populate information from userform to sheet
Apr 19, '24 at 2:38 pm
Answers: 1
Run-time error '1004' (VBA code cell range error)
Apr 9, '24 at 2:29 am
Answers: 1
COUNTING OCCURENCES
Apr 4, '24 at 5:52 pm
Answers: 1
change showing data on form from sheet to multiple sheets
Apr 3, '24 at 5:41 pm
Answers: 1
Loop through closed workbooks, copy range and paste
Mar 28, '24 at 8:55 pm
Answers: 1

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


Featured Excel Content

Quickly Resize Multiple Columns or Rows at Once in Excel
Excel Tip
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows or columns, which can take a very long time. Auto-Fit Multiple Rows or Columns to the Size of the Data in Them Select the entire columns or rows that need to be resized. To do this, left-click the header, either where it says A, B, C, ...
View Excel Tip
 
Make All Numbers in a List Positive in Excel
Excel Tip
Take a list of numbers and make them all positive, regardless of whether the list contains a mixed set of positive and negative numbers, only negative numbers, or only positive numbers. In other words, this method can be applied to an entire list, without knowing that every number in that list is negative, and still get only positive values return ...
View Excel Tip
 
Count the Number of Cells that Start or End with Specific Text in Excel
Excel Tip
How to count cells that match text at the start or the end of a string in Excel. If you want a fuller explanation of counting cells that match a string, you can view our other tutorial on counting the number of cells that contain specific text in excel. Sections: Steps to Count Cells that Contain Specific Text at the Start or the End of the Cell Us ...
View Excel Tip
 
Get the Row or Column Number of a Cell in Excel
Excel Tip
How to get the row or column number of the current cell or any other cell in Excel. This tutorial covers important functions that allow you to do everything from alternate row and column shading to incrementing values at specified intervals and much more. We will use the ROW and COLUMN function for this.  Here is an example of the output from thes ...
View Excel Tip
 
OR Function - Check if Any Argument is True
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 ...
View Excel Tip
 
Count the Number of Cells that Contain Specific Text in Excel
Excel Tip
How to count the number of cells that contain specific text within a spreadsheet in Excel. I'll show you how to count cells that match exactly a string or that contain part of a string. Sections: Count Cells that Exactly Match a String Count Cells that Contain a Particular String Anywhere within the Cell Notes Count Cells that Exactly Match a Strin ...
View Excel Tip
 
AND Function - Check if All Arguments are True
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 ...
View Excel Tip
 
Vlookup with a Range of Numbers in Excel
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 ...
View Excel Tip
 
Automatically Shade Every Other Row When You Add Data in Excel
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 ...
View Excel Tip
 
Print Comments in Excel
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 ...
View Excel Tip