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! :)

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

Don

Latest Forum Posts

Aug 4, '21 at 10:43 am
Answers: 0
Aug 2, '21 at 1:33 pm
Answers: 1
Jul 29, '21 at 12:29 am
Answers: 1
Jul 30, '21 at 7:51 am
Answers: 1
Jul 29, '21 at 6:28 am
Answers: 1
Jul 29, '21 at 5:55 am
Answers: 1
Jul 27, '21 at 7:17 am
Answers: 0

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.

Featured Excel Content


Excel Tip
Excel function that makes it easy to extract a word or text from a cell in Excel. This is a single function! It does NOT require a complex formula or nested functions or anything like that. To use this function, we first need to create it using a UDF, User Defined Function. You can learn about this kind of function here: User Defined Functions in E ...
 
Excel Tip
This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods to insert a check-mark into Excel, including using Macros/VBA and a UDF, or User Defined Function. Sections: Basic Method to Insert a Check Mark into Excel VBA Method to Insert a Check Mark into Excel UDF that Inserts a Check Mark into Excel Notes Basic Metho ...
 
Excel Tip
How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is almost the same as doing it for a basic macro, but getting the input is different. If you don't know what a UDF is, view this tutorial to learn more: Custom Functions in Excel - UDF Sections: Loop through a Range of Cells in a UDF Working Function Final Code No ...
 
Excel Tip
Use AutoCorrect to change the text a user enters into something funny. This is a great little prank to use on co-workers. It makes it so that every time they enter a specific word, it will automatically change to another word, a word that you choose. Go to the File menu and then click Options. For Excel 2007, Office button > Excel Options. Go to ...
 
Excel Tip
How to create and use a function that removes all text or all numbers from a cell, whichever you want. To do this, we will create a UDF or User Defined Function in Excel. But, I won't make you start from scratch; if you want to get the functions right away, simply download the Excel file attached to this tutorial and copy the code for yourself or g ...
 
Excel Tip
Create a dynamic chart in Excel that displays only the data you want. You can filter it and sort it in order to drill-down into the data and get a visual representation of everything. This is a fairly simply concept that will make your charts come to life when and how you need them to. Sections: Basic Data Setup Filter Data on a Chart Sort Data on ...
 
Excel Tip
How to create a custom worksheet function in Excel. These are called User Defined Functions, or UDF, and they are amazing. You can create your very own function that does whatever you want it to, almost. To make these functions we just need a little bit of VBA since they are basically macros. Sections: Steps to Create a UDF in Excel Adding Argument ...
 
Excel Tip
How to stop the annoying formatting window, the "Mini Toolbar" from appearing when you select text in Excel. The problem: I hate that thing more than words can describe and here is how to turn it off. Kill the Mini Toolbar Go to the File menu and click Options Go to the General section, it should show by default, and then look to the top and un-ch ...
 
Excel Tip
How to make clickable links within Excel that point to other locations within the same spreadsheet. This allows you to quickly navigate through large spreadsheets. You can create a title worksheet and include links from there to any other worksheet and specific cells within the worksheet. Right-click the cell where you want the link to appear and ...
 
Excel Tip
How to highlight the rows of the top and bottom performers in a list of data. This allows you to quickly identify who or what is performing well and performing badly. In addition, you will learn how to sort this data so it appears next to each other so you can clearly see and compare the differences. Sections: Highlight Top and Bottom Performers S ...
 
Excel Forum