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! I promise I won't bite. :)

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

Don

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.

Latest Forum Posts

Jun 15, '18 at 4:05 am
Answers: 1
Jun 13, '18 at 9:35 pm
Answers: 1
Jun 13, '18 at 9:11 am
Answers: 1
Jun 12, '18 at 2:55 pm
Answers: 2
Jun 12, '18 at 3:03 pm
Answers: 1
Jun 8, '18 at 12:13 am
Answers: 2
Jun 10, '18 at 5:33 pm
Answers: 2

Requested Tutorials

Changing the Appearance of a UserForm
Status: requested
view details
Progress Indicator
Status: requested
view details
Data Input Template
Status: requested
view details
Employee Information Template
Status: requested
view details
Product Information Template
Status: requested
view details
CheckBox - UserForm Control
Status: requested
view details
ComboBox - UserForm Control
Status: requested
view details
CommandButton - UserForm Control
Status: requested
view details
Frame - UserForm Control
Status: requested
view details
Image - UserForm Control
Status: requested
view details
Label - UserForm Control
Status: requested
view details
ListBox - UserForm Control
Status: requested
view details
MultiPage - UserForm Control
Status: requested
view details
OptionButton - UserForm Control
Status: requested
view details
RefEdit - UserForm Control
Status: requested
view details
ScrollBar - UserForm Control
Status: requested
view details
SpinButton - UserForm Control
Status: requested
view details
TabStrip - UserForm Control
Status: requested
view details
TextBox - UserForm Control
Status: requested
view details
ToggleButton - UserForm Control
Status: requested
view details

Featured Excel Content


Excel Tip
How to use parentheses in Excel in order to create more powerful formulas and functions. Sections: Basics of Parentheses Using Parentheses with Logical Comparison Operators Using Parentheses with Functions Notes Basics of Parentheses When performing calculations or doing anything in a formula or function or operation in Excel, what is inside parent ...
 
Excel Tip
Logical comparison operators allow you to compare values in Excel to see if they are equal, not equal, greater than, or less than. The result of one of these comparisons will either be TRUE or FALSE. These operators allow you to make powerful spreadsheets in Excel and, here, I will tell you how to use these operators. List of Logical Comparison O ...
 
Excel Tip
I'll explain how dates in Excel work and then point you to many useful tutorials on how to use dates and also times in Excel. What is a Date in Excel? Dates in Excel are actually just numbers that are formatted as dates. If you take a date and select the cell and then set that cell's formatting to "General" it will look like this: Cell A1 has the ...
 
Excel Tip
The MOD function is very simple but it can be used to do wonderful things in Excel. It returns the remainder after you divide one number by another. Syntax =MOD(number, divisor) Argument Description Number The number that will be divided by another number. Divisor The number by which the first number will be divided. Example - Simple Type =MOD( Typ ...
 
Excel Tip
Here's how to remove the little dotted lines that sometimes appear on the spreadsheet. Specifically, this deals with removing or hiding the print preview lines that appear in Excel after you have adjusted a setting for printing but then gone back to the normal view of the spreadsheet. Here, you can see the annoying print preview dotted lines betwe ...
 
Excel Tip
Use a formula to count the number of unique values that are contained within a list in Excel. Steps to Count the Number of Unique Values in a List We need to enter a rather long formula, so it will be listed here in small parts. Type =SUM( Type 1/ Type COUNTIF( Select the range of data that contains the values: Type a comma and then select that sam ...
 
Excel Tip
A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions. Index and Match lookups offer you freedom, to search to the left as well as the right and to perform more complex two way lookups with ease. Performing an Index/Match lookup is confusing at first. Here, I'll show you how to do everything step by step. (before you start, m ...
 
Excel Tip
How to insert, remove, and manage page breaks in Excel. This can be rather annoying and confusing but this tutorial should clear up everything. Page breaks are what you use to separate the worksheet into different pages when you go to print it. If you don't set them, Excel will use default page breaks set to the size of a printed page, and this ...
 
Excel Tip
Quickly list all Defined Names and their Values in the worksheet without using a macro. This allows you to view and analyze all of your Defined Names and that will help you manage and troubleshoot any potential issues. Steps to List all Defined Names and Values in the Worksheet Select a cell that has enough space below it and to the side to displa ...
 
Excel Tip
How to manage Names in Excel so they are easy to view and change as needed. This is a little trick that I use to keep all of my Names in Excel in one place where I can easily access them. Names are pieces of data that can be used in formulas and functions. Names store basically anything you want, a cell reference, a formula or function, text, or ...
 
Excel Forum