Our Excel Courses

Latest Forum Posts

populate adjacent item based on selected from datavalidation
May 29, '23 at 3:45 pm
Answers: 1
Mirror two cells between worksheets and edit either way
Jun 1, '23 at 8:29 am
Answers: 1
Coherently-adjusting set of formulas based on their results
May 31, '23 at 8:44 pm
Answers: 0
Add message box if VBA cannot find correct file path
May 30, '23 at 9:49 am
Answers: 1
update stock based cell value between two sheets
May 25, '23 at 11:49 am
Answers: 1
fill blank row before insert row if there is no blank row
May 24, '23 at 3:33 pm
Answers: 1
Formula Copying Automaticly
May 24, '23 at 2:12 pm
Answers: 1

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

Delete Duplicate Values in All Versions of Excel
Excel Tip
How to delete duplicate values from a data set in all versions of Excel. This includes Excel 2003 and earlier and also Excel 2007 and later. For Excel 2007 and later, we can use a simple feature within the program, but for Excel 2003 and earlier, we must use a macro, which is provided below. Sections: Remove Duplicates in Excel 2007 and Later Vers ...
View Excel Tip
 
Freeze or Lock Specific Rows and Columns when Scrolling in Excel
Excel Tip
Prevent specific rows or columns from moving when you scroll through a spreadsheet in Excel. This allows you to keep header rows and columns in place so you can tell what each column or row is for no matter where you are in the worksheet. In Excel, this is called Freezing Panes. Sections: Steps to Lock Rows/Columns in Excel Steps to Lock Multiple R ...
View Excel Tip
 
How to Get a Free Excel Trial
Excel Tip
You can download Microsoft Office, including Microsoft Excel for a free trial period. This grants you full access to all features of the software for 60 days. This is perfect if you need to evaluate the benefit of Excel and Microsoft Office or if you just need to use Excel for a short period of time and don't want to pay hundreds of dollars for Mic ...
View Excel Tip
 
View Different Parts of a Worksheet at Once in Excel
Excel Tip
View different sections of the same worksheet when the sections are far apart.  This allows you to better work on large spreadsheets that contain a lot of data. Steps to View Multiple Different Sections of a Worksheet at Once Go to the View tab and click the Split button: Once you do that, your screen will be divided into 4 sections: You have 4 d ...
View Excel Tip
 
Easily Enter Fractions into Excel
Excel Tip
This is a very simple trick to enter fractions quickly without having to manually format anything. This allows you to quickly enter fractions in the fraction format without having to first convert them to decimals and then format it separately.  This will save you a lot of time. Steps to Enter Fractions Quickly Type a zero 0 in the cell: Hit the ...
View Excel Tip
 
3 Methods to Remove Spaces Between Text in Excel
Excel Tip
How to remove spaces from the middle of text in Excel.  This includes removing all spaces from the middle of text in a cell and removing only certain spaces from the middle of text in a cell. The methods shown below are easy to use and can be quickly applied to any size list or the entire workbook, which will save you a lot of time. Sections: Qui ...
View Excel Tip
 
Get the Current Date in Excel
Excel Tip
How to get the current date using Excel.  This method updates the date every day so that it is always accurate. To do this we will use the TODAY() function. Syntax =TODAY() There are no arguments for this function; you simply type it in as it is displayed above. List the Current Date in Excel Simply type =TODAY() into any cell where you want the c ...
View Excel Tip
 
Sparkling Christmas Tree in Excel
Excel Tip
How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas; there is no VBA or Macro required for this to work. I'll teach you how to build your own or, if you just want to skip to the good stuff, download the Excel file that accompanies this tutorial and enjoy! :) Here is what we will build: Steps to Build a Sparkli ...
View Excel Tip
 
Change the Order of Tabs in Excel
Excel Tip
How to change the order of the tabs in your spreadsheet. This is rather easy to do and makes your spreadsheets much easier to follow and understand.  There are two ways to change tab order in Excel, and both are explained below. Method 1 - Change Order of Tabs This is the easiest method when you have only a few tabs in the workbook. Left-click and ...
View Excel Tip
 
Calculate Someone's Age in Excel
Excel Tip
How to automatically calculate someone's age using Excel.  This method is simple and will update every year so that you never have to manually adjust an age in Excel. This is great when you are working with employee or customer data. I'll show you two methods to do this; which one you use depends on the setup of your data. Sections: Calculate Som ...
View Excel Tip