Our Excel Courses

Latest Forum Posts

Make a payment amount appear in a blank cell on a chosen dat
Dec 3, '22 at 7:25 pm
Answers: 2
skip blank cells when copy data from specific range
Dec 2, '22 at 12:13 pm
Answers: 1
Conditional formatting using cell summation
Dec 2, '22 at 5:52 am
Answers: 1
copy to the bottom repeatedly when running macro continuously
Nov 30, '22 at 4:42 pm
Answers: 1
copy specific ranges from sheet to another
Nov 29, '22 at 2:58 pm
Answers: 2
How to batch transpose groups to columns when groups take up various rows
Aug 11, '20 at 5:05 pm
Answers: 2
Past to cell instead of a msg box
Nov 26, '22 at 6:26 pm
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

Delete Rows in Excel if Completely Empty
Excel Tip
This macro will delete only completely blank rows in an excel spreadsheet. It allows you to make a selection of rows, run the macro, and then will delete only rows that have no data. This is a great macro if you receive data that has only some empty cells but the columns next to the empty cells are still important. Where to install the macro:  Mod ...
View Excel Tip
 
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Excel Tip
This Excel macro filters data in Excel to display results that contain 1 of 2 possible values. This macro uses the xlor operator and that means that a result can contain one value OR another value. This is a great macro to use to narrow long lists or data sets down to compare two separate items side by side. To use this macro simply replace the "En ...
View Excel Tip
 
Generate a Non-Repeating List of Random Numbers in Excel - UDF
Excel Tip
Generate a series of non-repeating random numbers in Excel with this UDF (user defined function). This is a great function to use with statistical analysis and any other situation where you need to generate non-repeating random numbers. This is a very easy to use function and only has three arguments: one for the lowest possible random number; one ...
View Excel Tip
 
Output the File Path to and Name of a Workbook in Excel - UDF
Excel Tip
Free Excel UDF (user defined function) that displays the full file path and name of an Excel workbook. This function is very easy to use since it requires no arguments in order to function. It is a very simple and easy way to return the location of the current workbook including the workbook's name and file extension. There are many different reaso ...
View Excel Tip
 
Make Text Uppercase
Excel Tip
This macro will change all text within the selected cells to uppercase. It works only on selected cells within Microsoft Excel and it will work on ranges that include rows, columns, and both at the same time. Where to install the macro:  Module Converts Text in Cells to Uppercase Sub Uppercase() 'This will make the text of any selection of cells u ...
View Excel Tip
 
Remove (Delete) Hyperlinks from Worksheets
Excel Tip
This macro will remove all hyperlinks from the active worksheet. It will delete the hyperlinks but it will not delete the text of the link. This means that you will still have all of the text left over but without the links to the websites. This is a great macro to use in excel if you import a lot of data from the web or if you import lists of emai ...
View Excel Tip
 
Automatically Highlight the Active or Selected Cell
Excel Tip
This macro will highlight the active cell in any excel spreadsheet with a color selected in the code. This means that any cell you select will be highlighted in a way that fills the cell in with color. This will also highlight any selection of cells from one to as many as you select and once you click away the highlight will disappear. This is grea ...
View Excel Tip
 
Print All Charts That are in a Worksheet
Excel Tip
This macro will print all of the embedded charts which are on the current active worksheet. Each chart will be printed on a separate page. Where to install the macro:  Module Print All Embedded Charts in a Worksheet Sub PrintEmbeddedChartsinWORKSHEET() 'Prints all embedded worksheets that are on the active worksheet'      ...
View Excel Tip
 
Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
Excel Tip
This free Excel UDF (user defined function) allows you display the filter criteria that has been applied to a data set in Excel. This means that it will output, in text, the actual criteria used to filter the data. This allows you to quickly and easily know what criteria you are using to filter your data set. This is a great function to use if you ...
View Excel Tip
 
Sort Worksheet Tabs - Ascending or Descending Order
Excel Tip
This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. This will work to sort by number and or also alphabetically. This type of sort is conducted through a bubble sort type. This is ideal if you work with a large number of tabs or wroksheets in excel documents and you need to put them in o ...
View Excel Tip