Our Excel Courses

Latest Forum Posts

Sep 29, '23 at 6:32 am
Answers: 1
Sep 19, '23 at 3:14 pm
Answers: 1
Sep 19, '23 at 1:43 pm
Answers: 1
Sep 17, '23 at 6:39 am
Answers: 2
Sep 14, '23 at 7:10 am
Answers: 1
Sep 13, '23 at 7:22 am
Answers: 1

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


Featured Excel Content


Excel Tip
This free Excel macro filters data to display only those records or rows that contain a value between two values. For example, you could display all of the salesmen whose sales are between $50,000 and $75,000 for the quarter. You can use any number and apply it to any data set that contains number where you need to display all of the records that a ...
 
Excel Tip
This free Excel macro allows you to quickly and easily format a selection of cells in the Currency number format in Excel. This format allows you to display a number as a currency so that readers immediately know that a number is a currency and exactly what currency it is. This macro is made to display a number in the U.S. dollar currency format bu ...
 
Excel Tip
This macro will make the text of any selected cell in excel proper case. This means that the first letter of any word in excel will be capitalized. This macro works on any selection of cells in columns, rows, or a combination of the two. Where to install the macro:  Module Convert Text in Cells to Proper Case - First Letter of Each Word Capitalize ...
 
Excel Tip
This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file extension in the macro to point to any powerpoint file on your computer and then have it open through excel. This is a cool macro which allows you to basically call on powerpoint from the excel inteface. You can attach this macro ...
 
Excel Tip
This free Excel macro filters a data set to display the bottom 10 percent of the data set in Excel. This is a great macro for data analysis in Excel because it allows you to quickly and easily filter a large amount of data in Excel in order to view the most important data. This macro is really easy to use and a great way to quickly filter your data ...
 
Excel Tip
Sort data that doesn't have headers in ascending order in Excel with this macro. This is a simple sort macro that assumes that your data does not have headers. This means that the top row of the selected range will also be sorted. Sorting in ascending order means that the macro will sort the data in alphabetical order or numerically ascending order ...
 
Excel Tip
This free Excel macro filters data in Excel based on multiple criteria for one field in the data set. This macro uses the autofilter feature and specifically filters data based on two separate criteria. This allows you to narrow down a data set based on more than one parameter and to better display specific sets of data within Excel. The two criter ...
 
Excel Tip
This macro will disable the Save As feature in excel. This means that a user will not be able to resave the workbook under a different name or even in a different location. The only option for saving is to click "Save" which will only save any changes made to the current document. Where to install the macro:  ThisWorkbook Excel Macro to Disab ...
 
Excel Tip
Reverse cell contents with this free Excel UDF (user defined function). This will mirror all cell contents regardless of the type of content contained in the cell. This includes numbers, text, or a mixture of both. The only argument for this function is the reference to the cell which you want to mirror and, as a result, this is a very easy to use ...
 
Excel Tip
This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word document on your computer. This is a small but cool macro; you can attach it to a button or checkbox and then, whenever a user clicks the button or checkbox, have a specified Microsoft word document open. You can change the word docume ...