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

Jul 15, '18 at 10:42 am
Answers: 1
Jul 16, '18 at 10:16 am
Answers: 2
Jul 9, '18 at 4:41 am
Answers: 1
Jul 11, '18 at 11:49 am
Answers: 2
Jul 11, '18 at 10:58 am
Answers: 1
Jul 5, '18 at 6:45 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 password protect VBA code and macros in Excel so that a user cannot see the code or edit it or do anything to it at all. This allows you to safely secure your VBA code and prevent users from tampering with it or even seeing it. Steps to Password Protect VBA Code/Macros Go to the VBA Editor window by hitting Alt  + F11 Right-click the desir ...
 
Excel Tip
Simple way to open an Excel workbook using VBA and macros. Syntax Workbooks.Open ("File Path") Replace file path with the path to the file on your computer along with the full file name. Here is what it looks like in the VBA Editor window: Note: you do not always have to use the file extension of the file but it is a good practice to do so. In my ...
 
Excel Tip
How to close an Excel workbook using VBA and macros, including how to save the file before you close it or discard any changes. Sections: Selecting Which Workbook to Close Close Workbook While Saving Changes Close Workbook Without Saving Changes Let the User Decide to Save Changes or Not Notes Selecting Which Workbook to Close First, we need to tel ...
 
Excel Tip
You can change the size of the units on a chart axis, their interval, where they start, where they finish, and more. Sections: Change Vertical Axis Units Change the Horizontal Axis Notes Change Vertical Axis Units Select your chart and then go to the Layout tab and click Axes > Primary Vertical Axes and then More Primary Vertical Axis Options.. ...
 
Excel Tip
How to make the Y axis start at 0 in charts in Excel. This is a simple formatting issue. Select the Chart and go to the Layout tab (that is visible only when you select a chart). Click the Axes button and go to Primary Vertical Axis and then More Primary Vertical Axis Options... You will now be in the Format Axis window. Look to the top and next to ...
 
Excel Tip
How to make a macro stop or pause for a specified amount of time. This allows you to slow down the execution of a macro. Method 1 - Simple but Not Versatile Add this line of code anywhere in your macro where you want it to pause. Application.Wait(Now + TimeValue("00:00:01")) This will pause the macro for 1 second. The first set of zeros is hours; t ...
 
Excel Tip
How to stop a macro from running after it has started. This method uses the keyboard and has nothing to do with the programming of the macro. If the Macro is simply in a continuous loop or is running for too long you can use one of these keyboard shortcuts to kill it: Esc hit the Escape key. Ctrl + Break hit Ctrl key and then the break key, which ...
 
Excel Tip
How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or a combination of both. This is for when you need to look into each cell or do something with each cell in a range; if you just need to search for a piece of data within a range, use the Find method (link coming soon). Sections: How to Loop Through a Range of C ...
 
Excel Tip
How to use complex structured references, table formulas, in Excel. If you don't already understand how structured references work or what they do, please read our tutorial on that: using formulas with tables in Excel. Note: the examples below will show you how to make the references but won't necessarily show you useful real world examples. This ...
 
Excel Tip
Easy way to reference data tables and make formulas within a data table. This allows you to create formulas that apply to the entire table, copy easily, and are more robust than traditional formulas; these are called structured references. First, make sure your data is formatted as a table; if it's not, read this tutorial on how to create and mana ...
 
Excel Forum