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

Jan 14, '21 at 11:55 am
Answers: 1
Jan 14, '21 at 4:52 am
Answers: 1
Jan 12, '21 at 7:33 pm
Answers: 2
Jan 13, '21 at 4:24 pm
Answers: 1
Jan 11, '21 at 4:57 pm
Answers: 2
Jan 11, '21 at 1:59 pm
Answers: 1
Jan 7, '21 at 1:42 pm
Answers: 2

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
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 ...
 
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 ...
 
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 ...
 
Excel Tip
Adding, removing and rearranging columns is as easy as resizing. You just select your columns or rows, right click and then select Insert.   When adding rows, all of the rows in your selection are moved downwards and the new rows are placed above them.   This also works with columns and with more than one column/row at once. When columns are adde ...
 
Excel Tip
In Excel, you can create a comment for any cell in the worksheet. The problem is that these comments are hard to find later when you need to see what was written.  Here, Ill show you a few quick and simple ways to find all of the comments in a worksheet in Excel and all without using a macro. Here is a worksheet with comments:   As you can see, ...
 
Excel Tip
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse to the left or right. Below I resized column A so that all of the text will fit into 1 cell.   You can also do this by right clicking on a column and selecting Column Width You then enter the width into the message box that pops up li ...
 
Excel Tip
In the previous tutorial I talked about the Redo button in Excel and how using Ctrl + Y can be used to do the same thing. I also mentioned that Ctrl + Y has an additional functionality to repeat actions as well as redo. So if I change the colour of the text in cell  A1, click on cell B2 and press Ctrl + Y. The action of formatting the text in cell ...
 
Excel Tip
How to remove gridlines from a part of a worksheet in Excel instead of the entire worksheet or workbook. This is important when you want the gridlines to be everywhere on the worksheet except for designated areas and it is really easy to do with a quick formatting trick in Excel. Here is a worksheet with gridlines removed from only part of the wor ...
 
Excel Tip
Entering data into Excel is exactly the same across all Excel versions and can be done in a number of different ways. The first way you can enter data into Excel is using the formula bar. First you click on a cell, A1 for example and then you click on the formula bar so that the cursor appears within it.   You can now type using the keyboard to en ...
 
Excel Tip
The IF statement is a simple yet powerful tool. Today we will go through how the IF function works and some useful examples of where it can be used. The IF function specifies a test to perform. It then returns a response based on the outcome of that test. There is only 2 possible outcomes of the test. It can either validate true or false. To bette ...
 
Excel Forum