SERVER UPDATE NOTICE

Hi everyone,

Apparently, the server for this website needs to be upgraded and, of course, everything is happening rather last-minute. The upgrades should be complete by the end of this week and everything should be working without issue, except for the Search feature, that may take a little longer to get back online.

I'm sorry for any inconvenience this may cause! If you notice any problems using the site, please click the Contact link at the top of the page and let me know!

Regards,
Don

Premium Excel Course Now Available!

Build Professional - Unbreakable - Forms in Excel

45 Tutorials - 5+ Hours - Downloadable Excel Files

Instant Access! - Lifetime Access!

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! I promise I won't bite. :)

(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 17, '19 at 4:58 am
Answers: 1
Jan 16, '19 at 11:15 am
Answers: 1
Jan 14, '19 at 7:51 pm
Answers: 2
Jan 14, '19 at 10:41 am
Answers: 2
Jan 12, '19 at 1:17 pm
Answers: 1
Jan 12, '19 at 2:10 am
Answers: 1
Jan 8, '19 at 11:47 am
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
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 loo ...
 
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 ...
 
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 Forum