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

Nov 15, '18 at 8:38 am
Answers: 1
Nov 14, '18 at 12:28 pm
Answers: 1
Nov 13, '18 at 11:13 am
Answers: 1
Nov 12, '18 at 11:03 am
Answers: 0
Nov 12, '18 at 8:26 am
Answers: 0
Nov 11, '18 at 9:44 am
Answers: 1
Nov 11, '18 at 3:33 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
With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily analyse your data in Excel. This gives you the power to use one simple Vlookup formula to simultaneously search through every single worksheet in Excel, or just a selected few worksheets. The syntax of this function is eactly the same as for the regular Vlookup ...
 
Excel Tip
This macro will print every embedded chart in the active workbook. If you have an embedded chart in any worksheet within the workbook, it will be printed. This macro will print the charts on separate pages so that each chart will be on its own page. Where to install the macro:  Module Print all Embedded Charts in the Workbook Sub PrintEmbedde ...
 
Excel Tip
This free Excel macro allows you to apply filter settings to a data set, list, or range of data in Excel. This will not actually filter the data but it will put the filter "arrows" into the header row of the data set. This lets people know that the data set is ready to be filtered and makes it easier to filter the data when needed. If you already h ...
 
Excel Tip
This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete every row with an identical cell which is underneath the first occurrence. The first instance will still remain, but all identical cells in the rows underneath the original cell will be deleted. In order to run the macro, you ne ...
 
Excel Tip
This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and worksheet. When the macro runs, it prompts you to select which excel files from your computer you would like to combine and, once you select them and press ok, this macro will pull data from pre-specified worksheets in the selected workb ...
 
Excel Tip
This UDF (user defined function) calculates the Future Value of Compound Interest in Excel. The mathematical formula that is behind this function is PV * (1 + r) ^ N. This is a great function to include in your workbook if you often work with financial calculations such as the future value of invested sums of money or other assets. This adds funct ...
 
Excel Tip
This Excel macro filters data in Excel without the filter "arrow" appearing in the column that is being filtered. This macro can be used to make a filtered data set appear more aesthetically pleasing ot to simply to try mask the fact that data has been filtered or make it harder for the user to re-filter the data in Excel. However you want to use t ...
 
Excel Tip
This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week in the year on which a particular date falls. This UDF allows you to use the WEEKNUM function (standard in Excel 2007) in previous versions of Excel and across different regional versions or languages of Excel. This function is exactly the same as the WEEKNUM() fu ...
 
Excel Tip
This free Excel macro will print the current active worksheet in Excel. This means that whatever sheet you are currently viewing will be printed. This is a good macro to use to ensure that a user is always able to quickly print the current worksheet, even if menu functionality in Excel has been disabled. Where to install the macro:  Module Ma ...
 
Excel Tip
This macro allows you to enter any text or number, that you specify, in a cell on which you double-click. In the example macro below, an X will be entered into any cell on which you double-click. This can be very useful for filling out forms or "ckecking-off" a list of things to do in excel. It is much easier than typing the same thing over and ov ...
 
Excel Forum