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

Aug 23, '19 at 1:48 pm
Answers: 2
Aug 22, '19 at 6:43 pm
Answers: 1
Aug 21, '19 at 10:11 am
Answers: 2
Aug 17, '19 at 11:32 pm
Answers: 2
Aug 15, '19 at 12:19 pm
Answers: 1
Aug 11, '19 at 9:58 am
Answers: 1
Aug 14, '19 at 12:29 pm
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
Perform a lookup on dates and times in Excel: vlookup, hlookup, index/match, any kind of lookup. This tutorial shows you how to accurately use a lookup function on dates/times. This is important because time can be very tricky in Excel and sometimes you get positive results mixed-in with hidden negative results. The VLOOKUP() function will be used ...
 
Excel Tip
How to run a macro when a user does something within the Workbook in Excel, such as opening a workbook, closing a workbook, and other activities that are not specific to a single worksheet. As such, this tutorial differs from the Run a Macro when a User Does Something in the Worksheet in Excel tutorial. In Excel, you can set macros to run when cer ...
 
Excel Tip
IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement gives you the power to do different things in a macro depending on the outcome of a test or a condition, as it's called. This is probably the most important thing you will learn when it comes to creating a macro and programming in general. Below, I'll go over ...
 
Excel Tip
List all conditional formatting formulas in a worksheet in Excel. This allows you to quickly view and manage all of the formulas that you use for your conditional formatting rules. It will get the conditional formatting rules for the entire workbook and put them on their own new worksheet at the end of the workbook. Macro to List Conditional Format ...
 
Excel Tip
Logical operators in VBA allow you to make decisions when certain conditions are met. They allow you to check if something equals this OR that; this AND that; NOT this; and combinations of all three. When used in conjunction with IF statements, they allows you to make more complex choices in your macros and VBA. Logical Operators Operator Meaning A ...
 
Excel Tip
Macro to get data from a workbook, closed or open, over a network or locally on your computer. This is a versatile and self-contained macro that opens another workbook, gets information from it, and then closes that other workbook. This happens so fast that you won't even notice what is happening; it should feel seamless. (This technique will also ...
 
Excel Tip
How to put comments into a macro so that it's easier to understand and maintain them. Comments allow you to make notes within your macro and VBA code. These notes do not affect the execution of the macro at all and, when the macro is run, Excel pretends that the comments aren't even there. Sections: How to Make Comments in Macros When should you Us ...
 
Excel Tip
How to make a user input form in Excel and have the data stored on another worksheet at the click of a button. This method uses a simple-to-create input form that anyone can make and maintain within the worksheet and does not cover UserForms that are made in VBA and that can be quite tricky for users to create and maintain. This tutorial does use a ...
 
Excel Tip
How to open a website in the browser from Excel using a Macro and VBA. This is the same as following a link or clicking a link from the worksheet except that it will be done through a Macro. This does not open a website within Excel. Everything will still open in the browser. The Macro Here is the full macro that you need: Sub Go_to_Website() Dim i ...
 
Excel Tip
Make a particular worksheet visible using a macro in Excel. This is called activating a worksheet and is rather easy to do. Sections: Activate Worksheet by Name Activate Worksheet by Index Number Notes Activate Worksheet by Name Let's navigate to, activate, the worksheet called "Sheet2". Worksheets("Sheet2").Activate Worksheets("Shee2") is how we r ...
 
Excel Forum