Our Excel Courses

Latest Forum Posts

sum values in multiple textboxes on userfrom without button
Aug 11, '22 at 5:28 am
Answers: 1
Filter Status Active with the date and Replace header column
Aug 10, '22 at 4:07 am
Answers: 1
Calculate Value In A Single CEll
Aug 10, '22 at 4:47 am
Answers: 1
Copy
Aug 9, '22 at 9:46 am
Answers: 0
Run-time error ‘-2147024773 (8007007b)’: Doucument not saved
Aug 6, '22 at 11:28 am
Answers: 1
Follow up question about scanning barcodes
Aug 2, '22 at 3:46 pm
Answers: 1
merge duplicates data for each sheet separately
Aug 2, '22 at 5:28 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

Put Data into a Worksheet using a Macro in Excel
Excel Tip
How to input data into cells in a worksheet from a macro. Once you have data in your macro and you do something with it, you need to be able to put it back into Excel so you can see it or store it. This tutorial assumes that you have read and are familiar with the last tutorial: Get Data from the Worksheet into a Macro in Excel Sections: Putting Da ...
View Excel Tip
 
Get Data from the Worksheet into a Macro in Excel
Excel Tip
Here, you'll learn how to get information from the Excel worksheet into a macro so you can do something with it. One of the most important things with macros is getting information from the user, and the most often used method is to get it from a cell in the worksheet. There are two steps required to do this: reference a cell that contains the data ...
View Excel Tip
 
What is a Macro in Excel?
Excel Tip
This is the first step to learning about Macros for Excel and how to use them.  What is a Macro?   A macro is a small program that you make in Excel that automates tasks. Basically, this "thing", the macro, can save you hours of time. You can create macros that do almost anything in Excel and even other Microsoft Office programs. How can Macros ...
View Excel Tip
 
Excel VBA MsgBox - Message Box Macro
Excel Tip
Create a pop-up message box in Excel using VBA Macros. This allows you to show a message to the user and to get input back, depending on which buttons were clicked in the pop-up message. To output a message in Excel, we use the MsgBox function. Below, you will find many examples that should suit your needs. Sections: Syntax Example 1 - Output Basic ...
View Excel Tip
 
VBA Comparison Operators
Excel Tip
VBA comparison operators are used to compare values in VBA and Macros for Excel. List of VBA Comparison Operators Comparison Operator Meaning < A < B - Checks if A is LESS THAN B. > A > B - Checks if A is GREATER THAN B. <= A <= B - Checks if A is less than or equal to B. >= A >= B - Checks if A is greater than or equal to B ...
View Excel Tip
 
Countdown Timer in Excel
Excel Tip
How to create a countdown timer in Excel. This allows you to display a timer in whatever cell you want and it will count down until it reaches zero. I also included a method to stop or pause the timer. To create the countdown timer, a macro will be used. However, this tutorial does not require any previous knowledge of macros or VBA in Excel. If y ...
View Excel Tip
 
Simple Excel Function to Combine Text with a Separator
Excel Tip
Excel function that makes combining text very easy. This function is simpler and better than the CONCATENATE function. This function is a UDF and this tutorial assumes that you have a basic understanding of those. You can learn about them here: User Defined Functions (UDF) in Excel Sections: Syntax Create the Function and Install It Usage Examples ...
View Excel Tip
 
Simple Excel Function to Extract a Word or Text from a Cell
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 ...
View Excel Tip
 
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
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 ...
View Excel Tip
 
Loop through a Range of Cells in a UDF in Excel
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 ...
View Excel Tip