Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

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
In this tutorial I am going to look at cell alignment / arrangement. These features allow you to change how data looks WITHIN cells in Excel. To align one or more cells just select the cells you wish to align and navigate to the Alignment section of the Home tab. (For versions of Excel prior to 2007, right-click on selected cells, select Format Cel ...
 
Excel Tip
In this tutorial I am going to look at Number formatting. Number formatting allows you to change how numbers are displayed in Excel, anything from currencies to times to dates, decimals, percentages, and more. As an example I will go back to the table of data from the previous tutorial and make various Number formatting changes. First I will change ...
 
Excel Tip
The Find & Replace works much the same way as Find and is located in the same place. (Find & Select drop down on the Home tab) You can even just open up Find (Ctrl + F) and select the Replace tab:   All you need to do is enter what you are looking to find in the Find what box then what you are looking to replace it with in the Replace with ...
 
Excel Tip
In this tutorial I will cover how to use the various formatting tools in Excel. The Formatting tools are located on the Home tab/ribbon (for versions prior to 2007 formatting is accessed by right clicking and selecting Format Cells): To demonstrate the various formatting options I am going to edit this basic table of sales orders: First I am going ...
 
Excel Tip
Finding specific records and/or cells is easy when using the Find tool in Excel. It is located within the Find & Select drop down on the Home tab. Just click on Find within that drop down (Ctrl + F works too) and the following window will open: To use Find you simply type the data you are looking for into the Find what text box. Above, I am lo ...
 
Excel Tip
Ill show you three different ways to create an array in Excel VBA and Macros and how to get the data out of those arrays. Arrays are types of variables that can hold multiple separate values.  This allows you to store a lot of data in one variable so that you can later go through the variable and use what you need.  This is much better than creat ...
 
Excel Tip
I'll show you the easy and simple way to sum time past 24 hours in Excel.  All we really have to do is to change the format of the desired cell. The quick answer is to use the number format [h]:mm:ss Below, I will give a more in depth explanation of how this works. Here, we have a list of start and finish work times stored in Excel.  There is als ...
 
Excel Tip
The Selection Pane is a very useful tool in Excel that allows you to view all of the objects, shapes, charts, pictures, etc. in an worksheet. It is really easy to get there when one of these items is visible: click the item, click the Format tab that appears, then click Selection Pane. When no objects are visible, you can still get to the Selection ...
 
Excel Tip
In order to combine a cell that has a date with a cell that has a time, using a Macro and VBA in Excel, you must sum the data. For instance, if you have one cell formatted as a date and another cell formatted as a time and you want to combine them into a single cell with the date and time together, you cannot simply concatenate the data. If the dat ...
 
Excel Tip
In Excel, you can add shapes, images, objects, photos, and all sorts of items to the spreadsheet. The problem is that sometimes these items can be hidden or can overlap each other such that you cant find them. But, there is a really great tool that allows you to view all of the objects that you have in your worksheet, its called the Selection Pane. ...