Our Excel Courses

Latest Forum Posts

Alternative to Sumifs (Computation Slowdown)
Jan 19, '25 at 12:04 pm
Answers: 2
Check if a cell contains text before continuing with formula
Jan 14, '25 at 7:42 pm
Answers: 1
populate data in listbox across sheets
Jan 8, '25 at 4:23 am
Answers: 1
Find the last Inv No. On Invdata sheet and copy to a cell
Dec 30, '24 at 7:41 pm
Answers: 1
show data in listbox based on sheet name in combobox
Dec 24, '24 at 5:18 am
Answers: 1
Attach file to email
Dec 20, '24 at 1:50 am
Answers: 1
Need to copy sheet from a macro workbook and save as .xlsx
Dec 17, '24 at 7:31 am
Answers: 2

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

Quickly Replace A Lot of Data in Excel
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 ...
View Excel Tip
 
How to Quickly Find Data Anywhere in Excel
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 ...
View Excel Tip
 
Introduction to Using Filters to Refine Data in Excel
Excel Tip
Filtering allows you to hide rows of data which you are not interested in so that you can easily look at the rows you want to see. Its as easy to use as sorting and can be basic or very complicated depending on how you use it. In this tutorial I will just go through basic filtering. To filter a table you just select the column headings or the whole ...
View Excel Tip
 
Excel Time - Summing Time Greater than 24 Hours
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 ...
View Excel Tip
 
Sorting Data by Date, Text, or Number in Excel
Excel Tip
Sorting Data can be done with a few quick clicks of the mouse. I have used the same data as the previous 2 tutorials but have also added a Date Added column to demonstrate the sorting of dates. I will start by sorting alphabetically by Forename. To do this I first select the column I wish to sort.   I then select the sorting from 1 of 3 places. Th ...
View Excel Tip
 
How to View the Selection Pane in Excel When there are No Visible Objects
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 ...
View Excel Tip
 
How to import Text Files (CSV) into Excel
Excel Tip
Text files in CSV format are one of the easiest ways to store and transfer data as it is one of the most compatible files to use. Even a basic text editor such as Notepad can understand them, although this is not recommended when you have 1,000s or even 10,000s of lines of text stored as it gets a bit confusing to read/navigate, and this is why you ...
View Excel Tip
 
Join a Date and Time into a Single Cell using VBA Macros in Excel
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 ...
View Excel Tip
 
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Excel Tip
Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forenames, surnames and ages. As you can see I have surnames in column D but this would be better off in column B. I need to move the cells in D1:D4 to cells B1:B4.   I start by selecting the cells I want to move. (D1:D4) I then move the mouse over the border of my s ...
View Excel Tip
 
How to View, Arrange, or Hide All Shapes, Charts, Pictures, Etc. in Excel
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. ...
View Excel Tip