Our Excel Courses

Latest Forum Posts

Using VBA to save as (export) specific worksheets
Apr 23, '24 at 6:01 pm
Answers: 2
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
Loop through closed workbooks, copy range and paste
Mar 28, '24 at 8:55 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

Print Comments in Excel
Excel Tip
How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within the worksheet and how to print them at the end of the worksheet all in one place. Steps to Print Comments Go to the Page Layout tab and click the little button in the bottom right corner of the Page Setup section. In the window that op ...
View Excel Tip
 
Shade Every Other Row in Excel Quickly
Excel Tip
How to shade every other row in Excel quickly without using the Table feature. This method is for when you simply want to shade the rows and nothing more; when you do not want to convert your data to a Table type in Excel. Sections: Steps to Shade Every Other Row in Excel Quickly Remove Background Shading Remove Lines From Between the Cells Notes S ...
View Excel Tip
 
Run a Macro When you Click a Button in Excel
Excel Tip
Make a macro run when you click a button in the worksheet in Excel. This allows you to create a button and put it anywhere in the spreadsheet and then to have a macro run when that button is clicked. Steps to Have a Macro Run When a Button is Clicked Create the button.  Go to the Insert tab and click the Shapes button and select the desired butto ...
View Excel Tip
 
Increment a Value Every X Number of Rows in Excel
Excel Tip
(New Easier Version for Excel 2010 and Later) How to increment a value, number, percent, etc. every so many rows in Excel. This tutorial teaches you how to build the formula needed to increment a value or, really, do anything every so many rows in Excel. Section: The Formula That Knows in Which Row You are in Excel How to Increment a Value Based on ...
View Excel Tip
 
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Excel Tip
How to calculate the number of periods required for an investment in order to get the desired return.  The number of periods required for the investment tells you how long the investment must last.  This is based on a constant interest rate, a present value, and an optional future value. Syntax =NPER(rate, pmt, pv, [fv], [type]) Argument Descript ...
View Excel Tip
 
Delete All Rows that Contain a Specific Value in Excel
Excel Tip
Quickly find all rows in Excel that contain a certain value and then delete those rows. This is a simple technique for quickly searching an entire worksheet to locate specific rows that you can then delete without having to individually search a data set and delete each row. Steps to Delete All Rows that Contain a Specific Value Go to the workshee ...
View Excel Tip
 
Top Excel Keyboard Shortcuts to Increase Productivity
Excel Tip
I'll show you the top keyboard shortcuts for Excel that are sure to increase your productivity. These shortcuts are easy to learn and are ones that I use almost every day. Move Between Worksheets Ctrl + Page Down Move to the next worksheet to the right. Ctrl + Page Up Move to the next worksheet to the left Move Up, Down, Left, or Right After Enteri ...
View Excel Tip
 
Split Text into Multiple Cells in Excel
Excel Tip
How to split text from one cell into multiple cells quickly and easily in Excel.  This includes how to split names, part numbers, really anything you want.  You can split the text based on spaces in the text, commas, periods, or anything you specify. We will use the Text to Columns feature to do this. Desired Result: Steps to Split Text into Mult ...
View Excel Tip
 
Quickly Copy Cell Formatting to Other Cells in Excel
Excel Tip
How to copy all of the formatting of a single cell to other cells in the spreadsheet without having to re-apply each formatting element separately.  This will save you a lot of time when formatting spreadsheets. Steps to Quickly Copy Cell Formatting to Other Cells Select the cell that contains the formatting that you want to replicate: On the Home ...
View Excel Tip
 
Show Fewer Decimal Places Without Losing Precision in Excel
Excel Tip
How to show a smaller number that looks better without sacrificing decimal places or precision in the actual number. This has to do with formatting a number instead of actually rounding it.  The great thing about this is that when we format the number to have fewer decimal places, it will visually round the number for us while keeping the actual n ...
View Excel Tip