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

Oct 27, '21 at 8:34 am
Answers: 1
Oct 26, '21 at 11:18 am
Answers: 1
Oct 25, '21 at 11:33 am
Answers: 1
Oct 25, '21 at 5:43 am
Answers: 1
Oct 22, '21 at 12:45 pm
Answers: 1
Oct 22, '21 at 9:30 am
Answers: 1

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
This macro will convert every formula in an entire workbook into its respective value. This is basically a quick way to replace to do a copy-paste values except that nothing is moved or re-arranged. Just make sure to remember that this one will not only work on the active sheet, but on the entire open workbook. This is a good thing to use if you a ...
 
Excel Tip
This free Excel macro filters data to display results that end with certain words, text, or characters. This is a very easy to use and helpful macro in Excel which allows you to quickly and easily display subsets of data in Excel. It is important to note that in order to properly use this macro you must replace the "Enter Criteria Here" with the te ...
 
Excel Tip
Sort data in Excel that doesn't have headers using a macro. This Excel macro assumes that your data set does not have any headers or rows above the database that describe the contents of the column. The data is sorted in descending order. This means that is is in Z - A and 10 - 1 order. The last letter of the alphabet first and the highest number i ...
 
Excel Tip
This free Excel macro formats a selection of cells as Text in Excel. This macro applies the Text number format to cells in Excel. This means that all contents of a cell are treated as text and, though you can display numbers in the same cells, text is formatted to align to the left of a cell. This means that numbers with text formatting will appear ...
 
Excel Tip
This free Excel UDF allows you to get the numbers out of a cell that contain both text and numbers. This is a great function for splitting numbers and text from cells and can help you with many of your text manipulation / extraction needs. This is especially helpful when separating product id numbers and names and conducting inventory management w ...
 
Excel Tip
This free excel macro allows you to open any program on your computer from excel. You can open a media player, file viewer, image editor, internet browser, PowerPoint, Word, Outlook, or any other program on your computer. This is a really useful macro to, in essence, combine excel's functionality with that of another program. The vba code below ca ...
 
Excel Tip
This Excel macro filters data in Excel in order to display the top 10 items from the data set. The macro uses the autofilter feature and xltop10items operator in Excel. The top 10 items from a list applies to number formatting in Excel and means the top ten highest values or numbers within the list. This is a good way to narrow down results in Exce ...
 
Excel Tip
Send Emails from Excel Course This macro will send the current workbook in an email through Microsoft Outlook. The Macro allows you to send the most recently saved version of the excel file you are working in as an attachment. You must use the email client Outlook and you will need to have an internet connection. The specifics of the email are all ...
 
Excel Tip
This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first word from a sentence or just a string of words or characters. This is a really easy to use function and very helpful when working with text manipulation in Excel. There are two arguments, text and separator. The separator argument is op ...
 
Excel Tip
This Excel macro allows you to filter a data set on multiple columns and criteria at once. This means that you can filter the data based on values in column A and then Column B etc. You can also have separate criteria for every column. This allows you to be able to narrow your data sets down to just exactly what you need to view; this is similar to ...
 
Excel Forum