Our Excel Courses

Latest Forum Posts

Locating Module for Macro
Feb 23, '25 at 1:52 pm
Answers: 2
using Average function to populate in price column on form
Feb 17, '25 at 7:33 am
Answers: 2
Unexpected @ symbol added to my formula
Feb 12, '25 at 6:50 pm
Answers: 1
Excel Color Index - handy tool
Jan 30, '25 at 11:29 pm
Answers: 0
update condition by ignoring previous month on userform
Jan 29, '25 at 3:11 am
Answers: 0
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

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

Loop Through an Array in Excel VBA Macros
Excel Tip
I'll show you how to loop through an array in VBA and macros in Excel.  This is a fairly simple concept but it can be a little tricky. First, I'm assuming you already know what an array is and how to create and array in VBA [LINK to Article]. Now, that you know that, let's get to looping though arrays. There are two main ways to loop through all ...
View Excel Tip
 
PV Function - Get the Present Value in Excel
Excel Tip
The Present Value (PV) function in Excel will return the current value of an investment.  This calculates the current value of a series of future payments, a future lump sum value, or both combined. This is a simple, yet powerful function, giving you the ability to understand how much money you need for something in the future, or simply how much ...
View Excel Tip
 
Stop Formula Calculation in Excel - Increase Worksheet Performance
Excel Tip
I'll show you how to stop formulas and functions from performing their calculations and updating in Excel. This may seem trivial, but it will save you a lot of time when you are dealing with complex Excel files with thousands of formulas that are linked to other Excel files or with thousands of complex array formulas.  This is because these types ...
View Excel Tip
 
Prevent a User from Changing Any Data in Excel
Excel Tip
I'll show you how to lock a spreadsheet so that nothing can be changed in it. This is a great feature to use when you want to present data without allowing for it to be potentially corrupted or altered. The result of this action is that it will prevent a user from doing almost anything with your data unless they know how to unlock it and know your ...
View Excel Tip
 
Prevent Charts from Printing in Excel
Excel Tip
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to hide a chart to better showcase data or for any other reason. Here is our sample spreadsheet (download it from the side-menu to follow along): Steps to Prevent a Chart from Printing in Excel Right-click the side of the chart and click ...
View Excel Tip
 
Print Gridlines in Excel
Excel Tip
I'll teach you how to show gridlines for Excel when you print your files. This is a neat little feature that will allow you to have a printed version of your Excel file that looks more like what you will see on your computer without having to manually create borders. Here is our sample worksheet: When we go to print preview it will look like this: ...
View Excel Tip
 
Add Notes and Comments to Cells in Excel
Excel Tip
Did you know that you can add notes and comments to any cell in Excel?  You can write reminders, important notes, things to look out for, whatever you want, and place it in a note style comment for specific cells. Here is an example of a comment in Excel: You can see that cell B2 has what looks like a sticky note attached to it and this is the co ...
View Excel Tip
 
Hide the Excel Interface and Show Only Data
Excel Tip
I'm going to show you how to remove almost every interface from Excel and streamline the program so that the data is all people can focus on. This is the result we want: Steps to Hide the Excel Interface Minimize the Ribbon Menu Right-click any title from the Ribbon Menu and then select the Minimize the Ribbon option, or simply double-click the ti ...
View Excel Tip
 
FV Function - Get the Future Value in Excel
Excel Tip
The Future Value function (FV) in Excel will return the future value of an investment based on a particular interest rate.  The future value of the investment can be calculated when there is a single lump sum payment, a series of payments, or a lump sum payment with a series of payments. This is a corner stone of many financial calculations and i ...
View Excel Tip
 
Change the Default Number of Worksheets Created in a New Excel Workbook
Excel Tip
Learn how to change the number of worksheets that are in new Excel workbooks. Excel workbooks always have 3 worksheets to start with and here is how you change that. Here is the default new workbook with its three worksheets: Change Default Number of Sheets in Excel Workbook Go to the File menu for Excel 2010 or later, the Office button for Excel ...
View Excel Tip