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

Site Update in Progress...

We are currently implementing massive changes on the back-end. You should not notice any changes to the website, but, if you do notice anything that is now not working or seems odd, please use the Contact link to message us and let us know.

Thanks! 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 19, '18 at 4:41 pm
Answers: 1
Jun 19, '18 at 5:16 am
Answers: 1
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

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 add, manage, and remove trendlines in Excel Trendlines allow you to show trends in charts that might be otherwise difficult to notice.  Basically, this is mostly used as a visual aid to illustrate an upward, downward, or flat trend over varying data points in a chart. Sections: Add a Trendline to a Chart Manage a Trendline Remove a Trendli ...
 
Excel Tip
Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it should take no more than 5 minutes to make a Gantt Chart. Setup your data.  For a Gantt chart, you need to have one column of data that states when a task will begin and one column next to it that states how long that task will take or last. Go to the Insert tab ...
 
Excel Tip
How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance of a data point in a chart.  Maybe the values on the chart are an estimate and are within a 5% margin of error, this technique allows you to show that. Sections: Add Error Bars to Charts in Excel Change the Error Bars Size/Calculation ...
 
Excel Tip
Find the Min or Max value in a range and, based on that, return a value from another range. This is an advanced lookup tutorial that uses the INDEX and MATCH functions. This is a step-by-step tutorial but, if you want more information on INDEX/MATCH lookups and how to do them, check out our tutorial on that here: Index and Match Lookup in Excel St ...
 
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 ...
 
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 Forum