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

Apr 23, '18 at 11:37 am
Answers: 2
Apr 23, '18 at 9:38 pm
Answers: 0
Apr 23, '18 at 2:18 pm
Answers: 1
Apr 23, '18 at 1:34 pm
Answers: 1
Apr 21, '18 at 8:31 am
Answers: 2
Apr 17, '18 at 2:34 pm
Answers: 1
Apr 19, '18 at 8:12 am
Answers: 1

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 split text from one cell into multiple cells quickly and easily in Excel. This includes how to split names, part numbers, really anything you want. You can split the text based on spaces in the text, commas, periods, or anything you specify. We will use the Text to Columns feature to do this. Desired Result: Steps to Split Text into Multip ...
 
Excel Tip
How to copy all of the formatting of a single cell to other cells in the spreadsheet without having to re-apply each formatting element separately. This will save you a lot of time when formatting spreadsheets. Steps to Quickly Copy Cell Formatting to Other Cells Select the cell that contains the formatting that you want to replicate: On the Home ...
 
Excel Tip
How to show a smaller number that looks better without sacrificing decimal places or precision in the actual number. This has to do with formatting a number instead of actually rounding it. The great thing about this is that when we format the number to have fewer decimal places, it will visually round the number for us while keeping the actual nu ...
 
Excel Tip
How to round a number up or down and also to a specified number of decimal places in Excel. This will allow you to create more useful mathematical functions and formulas. Don't forget to download the accompanying workbook to follow along. Sections: Round a Number Up in Excel Round a Number Down in Excel Round a Number to a Specified Number of Digi ...
 
Excel Tip
How to calculate the payment amount for a loan or similar financial instrument that has a series of constant payments and a constant interest rate. This works great when calculating how much you will pay for a loan. You will be able to find out the size of the payments that you will make, including interest and principal. Syntax PMT(rate, nper, pv ...
 
Excel Tip
How to limit the amount that a user can enter into a range of cells in Excel. This works great for budgeting worksheets and really any type of worksheet where you need to force a user to keep values within a certain range or limit. To achieve this result, we will use the Data Validation feature of Excel. Here is our sample budget spreadsheet: Step ...
 
Excel Tip
How to generate random whole numbers (integers) that are between two numbers. This allows you to set a minimum and maximum possible value and then generate random numbers within that range. Make sure to download the accompanying workbook to follow along. Sections: Steps to Generate Random Numbers within a Range in Excel Quickly Make a List of Rand ...
 
Excel Tip
How to prevent a user from entering any spaces within text in Excel. This allows you to keep data clean when a user is entering something in Excel and helps to prevent data corruption. We will use data validation in Excel in order to achieve this result. Steps to Prevent Spaces Being Entered in Text in a Range in Excel Create the custom formula th ...
 
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 colu ...
 
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 how ...
 
Excel Forum