Our Excel Courses

Latest Forum Posts

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
need moving tally
Mar 30, '24 at 9:14 pm
Answers: 1
problem populate data when change from row1 to row4
Mar 29, '24 at 8:38 am
Answers: 1
problem show message when match date in combobox with header
Mar 28, '24 at 5:44 am
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

Delete All Empty Rows or Blank Cells from a Range in Excel
Excel Tip
How to quickly delete all empty cells or rows from a range in Excel.  This allows you to quickly clean your data to remove worthless blank sections that only serve to annoy you and break other features in Excel, like using the quick-fill handle to copy formulas down a column. Steps to Remove Blank Cells or Rows from a Range in Excel Select the col ...
View Excel Tip
 
Make All Text Upper Case or Lower Case in Excel
Excel Tip
How to quickly change all text to upper case or lower case in Excel.  This allows you to change the case of text without having to manually type in the text. I will show you how to change the case of text and also how to make the results of the functions we will use actual text instead of function/formula output. Also, check out our tutorial on ho ...
View Excel Tip
 
Easily Compare Duplicate Values in Excel
Excel Tip
Here, I'll show you a simple technique to quickly and easily compare large lists of duplicate values.  This allows you to analyze the list in order to have better data analysis and or just to figure out which duplicates might need to be removed. Steps to Easily Analyze a List Containing Duplicate Values in Excel Import the list into Excel, or if i ...
View Excel Tip
 
Display all Formulas at Once in Excel
Excel Tip
How to view all of the formulas at once in Excel so that you can troubleshoot the spreadsheet quickly and easily. Steps to Display all Formulas at Once in Excel Go to the worksheet where you want to view the formulas (this feature is worksheet specific). Go to the Formulas tab and then click Show Formulas or use the keyboard shortcut  Ctrl + ` (th ...
View Excel Tip
 
Require a Unique List of Numbers in a Range in Excel
Excel Tip
I'll show you how to require a user to enter a unique number into a range of cells in Excel.  This feature will require that the value entered into the cell must be a number and that it must be different than any other number in that range.  To do this, we will be using data validation along with a custom formula. Create the Custom Formula The fi ...
View Excel Tip
 
RATE Function - Calculate an Interest Rate in Excel
Excel Tip
The Rate function in Excel (RATE) calculates the interest rate for a financial transaction, such as for an annuity or lump sum.  An annuity is simply an equal series of payments. You tell the RATE function the payments that are made, for how long they are made, and the present value and this function will give you the interest rate for that equati ...
View Excel Tip
 
Import a Worksheet from One Workbook to Another in Excel
Excel Tip
In Excel, you can quickly copy an entire worksheet from one workbook to another workbook.  This allows you to import data from other workbooks with ease and without having to copy/paste everything between the worksheets. Steps to Import a Worksheet from Another Workbook in Excel Make sure that you have both workbooks open, the one that has the dat ...
View Excel Tip
 
Hide Data Within a Worksheet in Excel
Excel Tip
In Excel you can actually hide data that is stored within a worksheet. This allows you to show data that is useful to a user while hiding data that you don't want them to change or that you simply don't want them to see.  This makes for more robust worksheets, as it becomes harder to mess things up and also makes for nicer looking well-kept spread ...
View Excel Tip
 
Make Your Macros Available in All Workbooks in Excel
Excel Tip
In Excel, you can make it so all of your macros can be easily accessed by any Excel workbook. To do this we need to create what is called a "personal macro workbook" and then save it.  All of the macros that we want to use in Excel will be stored within this personal macro workbook and will then be accessible by any Excel file. Steps to Make any ...
View Excel Tip
 
Print Only Specific Parts of a Worksheet in Excel
Excel Tip
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This allows you to select sections of important data to print without having to move those sections of data to other spreadsheets in order to print them. You can select a single part of a worksheet or multiple parts of a worksheet to print. ...
View Excel Tip