We are aware of issues with the site and purchases not going through. This is due to a server upgrade and we are working with the hosting company to have it fixed asap. Sorry for the inconvenience!
We've created a streamlined course platform for easier browsing and purchasing.
Access all Excel training courses with a simpler checkout process and better course management.
Download course videos for offline viewing
Pay with Credit Card, PayPal, Klarna, and more
Current course owners get free access - contact us!
Learn how to make your own Macros in Excel, no experience required! This is a programming course that will take you from Beginner to Expert in VBA and save you hours of time working in Excel!
How to send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.
How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.
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
Site Update
We are aware of issues with the site and purchases not going through. This is due to a server upgrade and we are working with the hosting company to have it fixed asap. Sorry for the inconvenience!
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 ...
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 ...
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: ...
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 ...
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 ...
This is a simple way to get more space in Excel, reduce clutter, and streamline the interface by minimizing the big Ribbon Menu. Here is the regular interface: Here is the minimized Ribbon Menu interface: How to Minimize the Ribbon Menu in Excel Double-Click anywhere on the titles of the Ribbon Menu That's it! Now, if you ever want to access the M ...
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 ...
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 ...
I'll show you how to completely remove the entire Quick Access Toolbar from Excel. This will allow you to have a streamlined Excel interface and to prevent users from accessing menu shortcuts. This method will also remove the Ribbon Menu and either the File or Office buttons from the top of the window, depending on your version of Excel. Here is ...
I'll show you how to hide worksheets in Excel so that a user cannot see them but you can still access data on them. This method is the simplest way to hide a sheet and it will still allow you to easily access it when you need to. This is especially good when you want to hide a source data tab or simply reduce clutter in the workbook. Hide a Work ...