Our Excel Courses

Latest Forum Posts

add specific currency in textbox based on optionbutton
May 25, '22 at 8:48 am
Answers: 1
Formatting output of Search Entire Workbook and display a column with 16-digit numbers
May 24, '22 at 1:48 am
Answers: 1
populate values in textboxes based on data sheet
May 23, '22 at 4:33 pm
Answers: 1
Activex text box in shared environment
May 23, '22 at 8:54 am
Answers: 1
If all of column B says then D and E need to say
May 20, '22 at 1:00 pm
Answers: 1
application defined error or stop without extract data
May 19, '22 at 12:03 pm
Answers: 0
Conditional Formatting-Icon Sets using 0 to 3 numbers
May 17, '22 at 7:46 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

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
 
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Excel Tip
How to find a date that is so many days before or after a specified date, excluding weekends and any holidays. This allows you to get an accurate estimate of when work will be completed, a package delivered, invoicing, and more. To achieve this, we use the WORKDAY() function in Excel. Syntax =WORKDAY(start_date, days, [holidays]) Argument Descripti ...
View Excel Tip
 
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Excel Tip
Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allows you to use your dates to perform more complicated calculations, such as working hours and compensation, scheduling, shipping, and many other types of calculations where it is important to know on what day of the week a date falls. For this, we use the WEEKDAY ...
View Excel Tip
 
Get the Number of Workdays Between Two Dates in Excel
Excel Tip
How to calculate the total number of working days between two dates in Excel.  This allows you to exclude all weekends, holidays, and any other dates that you specify. This is an invaluable method to use when calculating payment schedules, shipping dates, and much more in Excel. To do this we will use the NETWORKDAYS() function. Syntax =NETWORKDAY ...
View Excel Tip
 
TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel
Excel Tip
This allows you to make sure that there are no hidden spaces at the start or end of the text in a cell and also that there are no extra ones in the middle of the text.  In regards to extra spaces in the middle of text, it will convert all double or triple or more spaces into a single space. Though this may seem trivial, spaces around your text can ...
View Excel Tip
 
Get the Last Day of the Month in Excel
Excel Tip
How to get the last day of the month, including the date and day of week, for any date in Excel.  This method allows you to use any date and get the last day of the month for the month of that date or a future month or a month in the past.  This is very helpful when dealing with scheduling and time related scenarios in Excel. We will use the EOMO ...
View Excel Tip
 
Print All Worksheets at Once in Excel
Excel Tip
How to print all worksheets at once from Excel. This saves you the time of having to go to each sheet individually to print. Hit Ctrl + P to get to the print screen. Click where it says Print Active Sheets and select the option Print Entire Workbook. That's it! It's as simple as that. Notes There are a lot of different printing options for Excel.  ...
View Excel Tip