Our Excel Courses

Latest Forum Posts

Edit VBA code to let it automaticlly create Folder
Nov 22, '23 at 6:00 am
Answers: 1
Open to specific sheet
Nov 22, '23 at 4:17 pm
Answers: 1
next highest value
Nov 17, '23 at 6:50 am
Answers: 2
Button on Excel to save as PDF Macro Error
Nov 16, '23 at 2:29 pm
Answers: 1
IF/ VLOOKUP in a macro
Nov 15, '23 at 9:59 am
Answers: 2
Shift down content of range of row cells in Sheet 1 when new
Nov 12, '23 at 6:08 pm
Answers: 2
VBA Help - Stuck on XLOOKUP and assigning variables
Nov 11, '23 at 12:20 am
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

Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
Excel Tip
This free Excel UDF (user defined function) allows you display the filter criteria that has been applied to a data set in Excel. This means that it will output, in text, the actual criteria used to filter the data. This allows you to quickly and easily know what criteria you are using to filter your data set. This is a great function to use if you ...
View Excel Tip
 
Sort Worksheet Tabs - Ascending or Descending Order
Excel Tip
This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. This will work to sort by number and or also alphabetically. This type of sort is conducted through a bubble sort type. This is ideal if you work with a large number of tabs or wroksheets in excel documents and you need to put them in o ...
View Excel Tip
 
Print Preview Display for Specific Worksheets in Excel
Excel Tip
This free Excel macro allows you to display the print preview mode or window in Excel for a specified Excel worksheet. This is a great macro to use with workbooks whose worksheets will not change or for templates. Where to install the macro:  Module Macro to Display Print Preview for Specific Worksheets in Excel To display the print preview mode f ...
View Excel Tip
 
Delete Only the Text from Cells
Excel Tip
This macro will delete all text from selected cells. This will not delete any other characters or numbers from any cells. That means that if you are trying to get letters out of part numbers (etc.) and you run this macro, the numbers and other characters will remain but all text will be gone. This is a great macro for scrubbing or cleaning large a ...
View Excel Tip
 
Hide Specific Comments in Excel - Comments Will Still Display on Hover
Excel Tip
Hide specific comments in Excel with this macro. Comments are still visible on hovering over the cell that contains the comment. The in cell comment will just not be visible by default. The real benefit of this macro is to hide a comment that has been previously made to appear by default within the Excel spreadsheet. Hiding a comment in Excel usin ...
View Excel Tip
 
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
Excel Tip
Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in their own tab or worksheet. No embedded charts will be deleted using this macro. Also, when you run this macro, a warning message will pop up to verify that you want to delete the worksheets or tabs. To use this macro just install it ...
View Excel Tip
 
Display the Print Window in Excel
Excel Tip
This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when you hit Ctrl+P on your keyboard or when you select Print from the file or Office Button menu. This is a great macro to use when you don't want to give users access to keyboard shortcuts or Excel menus because you can set this macr ...
View Excel Tip
 
Remove All Filtering From a Worksheet in Excel
Excel Tip
This Excel macro removes all filtering from a worksheet in Excel. This allows you to completely remove any filter now matter how complex from any worksheet in Excel. This means that the entire original data set will then be visible in Excel. How Filter Macros Work All of the elements below often appear within autofilter macros. Range This should be ...
View Excel Tip
 
Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
Excel Tip
Hide comments in Excel with this macro. Comment indicators will still appear in the cells and users will also be able to view the comments when hovering over a cell that contains a comment. This macro serves as a way to put comments back to their default behavior in Excel and is great to use when you have a lot of comments set to permanently show ...
View Excel Tip
 
Print Entire Workbook in Excel
Excel Tip
This free excel macro allows you to print the entire workbook in Excel. You can easily set this macro to a button within the spreadsheet and allow users to more easily print the entire workbook or Excel file. Where to install the macro:  Module Print Entire Workbook in Excel Macro Sub Print_Current_Workbook() 'Prints the current active workbo ...
View Excel Tip