Our Excel Courses

Latest Forum Posts

Need Help Improving/increase Speed of ChangeTracking Macro
Jul 2, '22 at 3:37 am
Answers: 0
Notify if an email is not sent using VBA
Jul 1, '22 at 6:46 am
Answers: 1
Save a worksheet as new workbook in current folder
Jul 1, '22 at 7:31 am
Answers: 1
Drop Down query
Jun 30, '22 at 5:14 am
Answers: 1
Please help me urgent
Jun 30, '22 at 1:28 pm
Answers: 0
Formula to apply conditional formatting to highlight specific cells based the cell to the left
Jun 28, '22 at 10:31 am
Answers: 1
incrementing numbers of added files names
Jun 27, '22 at 5:31 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

Show All Formulas in a Worksheet in Excel
Excel Tip
Display all formulas instead of their output values. This allows you to quickly troubleshoot issues in a worksheet without having to select each cell individually. Go to the Formulas tab and click the Show Formulas button: Now, your worksheet will look like this: As you can see, this lets you quickly see what formulas and functions are contained w ...
View Excel Tip
 
Case Sensitive Sorting in Excel
Excel Tip
How to perform case sensitive sorting in Excel. Select a cell within the data that you want to sort and then go to the Data tab and click Sort In the window that opens click the Options button. Put a check mark next to the Case sensitive option and hit OK. In the Sort window choose how you want to sort. Choose the column by which you want to sort. ...
View Excel Tip
 
Thermometer Chart in Excel
Excel Tip
How to create a thermometer chart in Excel. This is what we want: Steps to Create a Thermometer Chart in Excel Make sure your data is setup correctly. You need to have a cell that displays a percentage for the amount that has been completed so far.  It doesn't matter how you generate this percentage cell so long as you have it. Select the percent ...
View Excel Tip
 
Connect the Line for a Chart in Excel and Skip Blanks
Excel Tip
How to prevent a line chart from having a blank spot or also dropping to zero when there is a blank cell or a zero value that should be blank cell. Here is the problem: Connect the Line for a Line Chart Click the desired chart and then go to the Design tab that should appear and click Select Data. In the window that opens, click Hidden and Empty Ce ...
View Excel Tip
 
Open PDF from Excel
Excel Tip
How to open a PDF file from a clickable button, link, or image in Excel.  This allows you to seamlessly link PDF files with a spreadsheet. Sections: Steps to Open PDF from Excel Open a PDF when an Image or Button is Clicked Notes Steps to Open PDF from Excel Right-click the cell that contains the text that you want to use to open the PDF when it ...
View Excel Tip
 
Add Image Background to a Chart in Excel
Excel Tip
How to use an image for the background of a chart in Excel. Simple but fun way to spruce up charts. Click the desired chart, go to the Layout tab which should have appeared, click Plot Area and then click More Plot Area Options In the Fill section click Picture or texture fill and it should look like this: Click the button File to choose an image ...
View Excel Tip
 
Filter While Leaving Original Data Intact in Excel
Excel Tip
How to filter in Excel by copying the filtered data to a new location without doing anything to the original data set.  This method leaves the original data set intact without changing it or hiding any rows in order to perform the filter. Steps to Copy Filtered Data Set to New Location While Leaving Original Data Set Intact We need to first figur ...
View Excel Tip
 
Combine Data from Multiple Worksheets in Excel
Excel Tip
The easiest way to combine and consolidate data in Excel. Simple method to combine data from multiple worksheets into one worksheet.  This method has Excel do all the work for you so that you don't have to insert any formulas or functions yourself. Sections: Steps to Combine and Consolidate Data in Excel How to Consolidate Data while Keeping Link ...
View Excel Tip
 
Make Professional Looking Rounded Buttons in Excel
Excel Tip
How to make professional looking rounded buttons in Excel. This allows you to avoid using basic buttons and also to style the buttons to your content so they better blend-in with everything. Steps to Make Nice Buttons in Excel Go to the Insert tab and click the Shapes button: From the drop down menu that appears you will have many options.  To cre ...
View Excel Tip
 
Change the Name of a Chart in Excel
Excel Tip
How to change the name of a chart in Excel. This allows you to use a more intuitive chart reference when organizing charts using the Selection Pane or within VBA and macros. Rename a Chart Select the chart.  This should cause three new tabs to appear: Design, Layout, and Format. Go to the Layout tab and look all the way to the right where it says ...
View Excel Tip