Our Excel Courses

Latest Forum Posts

Automatically Copy New Data to Another Worksheet
Sep 21, '22 at 1:14 pm
Answers: 1
getting data from sheet to multiple sheets before TOTAL row
Sep 21, '22 at 11:54 am
Answers: 1
Speed up macro to merge many similar cells on defined worksheets
Sep 18, '22 at 9:49 am
Answers: 1
Display Message Box Value from Macro in Word Bookmarked Cell
Sep 18, '22 at 9:30 am
Answers: 1
New VLOOKUPWORKBOOK
Sep 13, '22 at 6:01 pm
Answers: 1
Distributing costs based on population size
Sep 14, '22 at 7:34 am
Answers: 1
How to Refer a Input from InputBox in vba
Sep 15, '22 at 11:40 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

Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
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 ...
View Excel Tip
 
Disables the "Save As" Feature in Excel
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 ...
View Excel Tip
 
Reverse the Contents of a Cell in Excel - UDF
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 ...
View Excel Tip
 
Open a Word Document from Excel
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 ...
View Excel Tip
 
Format Cells in The Short Date Number Format in Excel
Excel Tip
This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format displays the date like this: m/d/yyyy. The date is only in numbers and the month is the first number, day of month the second number, and the year represented in 4 digits is the last number. This macro is a great piece of vba code to use ...
View Excel Tip
 
Hide Formulas in a Worksheet and Prevent Deletion
Excel Tip
This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected like a regular protected worksheet in excel; this means that you can still add content to the workbook without a problem and you can edit everything as long as it is not a formula. You can enter a new formula but you cannot then dele ...
View Excel Tip
 
Sort Data With Headers in Ascending Order in Excel
Excel Tip
Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it. This means that you data has a row that labels what the data underneath it is or stands for in the worksheet. The header row will not be sorted; however everything underneath that row will be sorted. Header rows are assumed to be ...
View Excel Tip
 
Delete Hidden Rows in a Workbook
Excel Tip
This macro will delete hidden rows from every worksheet in an entire workbook. However, note that this will only delete one hidden row from a group at once. This means that if you have rows 3-9 hidden on a sheet and rows 45-55 hidden on the same sheet, the last hidden rows (row 9 and row 55) will be deleted on that worksheet. This means that the e ...
View Excel Tip
 
Close a Workbook after a Time Limit is Reached
Excel Tip
This macro will automatically close the workbook in which it is located after that workbook has been opened for a certain period of time. This is a great feature when you are sharing workbooks that can't be open at the same time on more than one computer; in that situation this macro ensures that if someone forgets to close the file, it will autom ...
View Excel Tip
 
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Excel Tip
This free Excel macro illustrates all of the possible parameters and arguments that you can include in the PrintOut Method for Excel Macros and VBA in Excel. All of the arguments are explained below as well as how to use each argument and why you might want to use each argument. After reading this page, you will be able to create your own printing ...
View Excel Tip