Our Excel Courses

Latest Forum Posts

Automatically Change Row Height with Merged Cells
May 14, '24 at 5:33 pm
Answers: 2
Using VBA to save as (export) specific worksheets
Apr 23, '24 at 6:01 pm
Answers: 3
Inserting 3 rows in between 1700 and 1900 time
Apr 23, '24 at 8:54 pm
Answers: 0
Populate information from userform to sheet
Apr 19, '24 at 2:38 pm
Answers: 1
Run-time error '1004' (VBA code cell range error)
Apr 9, '24 at 2:29 am
Answers: 1
COUNTING OCCURENCES
Apr 4, '24 at 5:52 pm
Answers: 1
change showing data on form from sheet to multiple sheets
Apr 3, '24 at 5:41 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

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
 
Stop Excel from Changing Numbers to Dates or Anything Else
Excel Tip
How to stop Excel from automatically changing numbers into anything other than what you typed, such as changing a fraction into a date when you enter it into a cell. Apostrophe Method Using the apostrophe is the preferred way to keep numbers looking the same after you enter them, at least as far as I am concerned.  This way, if someone changes the ...
View Excel Tip
 
Print the Current Date or Time in Excel
Excel Tip
How to print the current date and or time on an Excel spreadsheet. This is a simple technique that allows you to display the date and or time in the footer or header of the spreadsheet without it being visible when working in Excel. Steps to Print the Date/Time in Excel Go to the View tab and click the Page Layout button. Now, you will see the spre ...
View Excel Tip
 
Export an Excel File to a CSV File
Excel Tip
How to export an Excel file to a CSV file (comma separated values file).  This allows you to turn any Excel spreadsheet into a CSV file that you can then use to send to another person or easily upload into a database system. Steps to Export a Worksheet to a CSV File Make sure your data is positioned exactly as you want it to be positioned.  (Edi ...
View Excel Tip
 
Allow Only Certain People to Edit Specific Cells in Excel
Excel Tip
How to allow only certain people to edit certain cells or ranges in Excel. This is a security feature that you can setup so that a user has to have a specific password in order to edit parts of a worksheet.  This allows you to have more robust Excel files and to reduce the chance that someone messes-up something in the worksheet. Steps to Allow O ...
View Excel Tip
 
Enable the Analysis ToolPak in Excel
Excel Tip
How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Excel and allows you to use powerful statistical and engineering analysis features. Steps to Enable the Analysis ToolPak Click the File button (Microsoft Office Button for Excel 2007). Click Options from the left side of the menu that appears (Excel Options for E ...
View Excel Tip
 
Quickly Resize Multiple Columns or Rows at Once in Excel
Excel Tip
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows or columns, which can take a very long time. Auto-Fit Multiple Rows or Columns to the Size of the Data in Them Select the entire columns or rows that need to be resized. To do this, left-click the header, either where it says A, B, C, ...
View Excel Tip
 
Make All Numbers in a List Positive in Excel
Excel Tip
Take a list of numbers and make them all positive, regardless of whether the list contains a mixed set of positive and negative numbers, only negative numbers, or only positive numbers. In other words, this method can be applied to an entire list, without knowing that every number in that list is negative, and still get only positive values return ...
View Excel Tip