Our Excel Courses

Latest Forum Posts

How to add tab link into VBA results
Jun 23, '22 at 4:11 am
Answers: 2
Make resultant cell blink
Jun 23, '22 at 7:08 am
Answers: 1
Why does it keep saying this?
Jun 22, '22 at 3:13 pm
Answers: 1
Date Range Search Across multiple tabs?
Jun 21, '22 at 10:14 am
Answers: 1
VBA Combobox autofill
Jun 20, '22 at 10:58 pm
Answers: 0
Wrapping Sum into Vlookup and Getpivotdata
Jun 20, '22 at 4:51 am
Answers: 0
how exclude item in combobox based on word in another column
Jun 19, '22 at 6:35 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

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
 
Make a Transparent Chart in Excel
Excel Tip
How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mouse over the chart and it will tell you if you are over the Chart Area or the Plot Area etc. Right-click the background of the chart when you are over the Chart Area and click Format Chart Area... A window will open.  In the Fill secti ...
View Excel Tip
 
Add, Manage, & Remove Trendlines in Charts in Excel
Excel Tip
How to add, manage, and remove trendlines in Excel Trendlines allow you to show trends in charts that might be otherwise difficult to notice.  Basically, this is mostly used as a visual aid to illustrate an upward, downward, or flat trend over varying data points in a chart. Sections: Add a Trendline to a Chart Manage a Trendline Remove a Trendli ...
View Excel Tip
 
Create Gantt Chart in Excel Easily
Excel Tip
Easy step-by-step guide to creating a Gantt Chart in Excel. Following these steps, it should take no more than 5 minutes to make a Gantt Chart. Setup your data.  For a Gantt chart, you need to have one column of data that states when a task will begin and one column next to it that states how long that task will take or last. Go to the Insert tab ...
View Excel Tip
 
Error bars in Charts in Excel
Excel Tip
How to add, manage, and remove error bars in charts in Excel. Error bars allow you to show the potential variance of a data point in a chart.  Maybe the values on the chart are an estimate and are within a 5% margin of error, this technique allows you to show that. Sections: Add Error Bars to Charts in Excel Change the Error Bars Size/Calculation ...
View Excel Tip
 
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Excel Tip
Find the Min or Max value in a range and, based on that, return a value from another range. This is an advanced lookup tutorial that uses the INDEX and MATCH functions. This is a step-by-step tutorial but, if you want more information on INDEX/MATCH lookups and how to do them, check out our tutorial on that here: Index and Match Lookup in Excel St ...
View Excel Tip
 
Using Parentheses in Excel
Excel Tip
How to use parentheses in Excel in order to create more powerful formulas and functions. Sections: Basics of Parentheses Using Parentheses with Logical Comparison Operators Using Parentheses with Functions Notes Basics of Parentheses When performing calculations or doing anything in a formula or function or operation in Excel, what is inside parent ...
View Excel Tip