Our Excel Courses

Latest Forum Posts

Combobox Worksheet Selection not populating Listbox
Jan 30, '23 at 5:08 pm
Answers: 1
Timer Vs Open Other Excel
Jan 30, '23 at 1:24 pm
Answers: 1
Read .csv data without opening excel & Compare
Jan 30, '23 at 3:41 pm
Answers: 0
Automatically Timestamp Entries in Excel (DELETE)
Jan 29, '23 at 11:44 am
Answers: 1
Update Second UserForm Combobox Selection worksheet Info
Jan 27, '23 at 12:41 pm
Answers: 1
Excel formula and function
Jan 27, '23 at 1:44 am
Answers: 1
Populate Combox then Listbox by selection
Jan 24, '23 at 4:23 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

Quickly Convert Formulas into Their Output Values in Excel
Excel Tip
This tutorial teaches you how to convert a formula or function into its displayed output in Excel. This is very important and useful when you want to freeze a formula or function so that its output value cannot change. There is a very simply set of keyboard shortcuts that allows you to do this: First, select the desired functions/formulas then hit ...
View Excel Tip
 
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Excel Tip
In Excel you can store values in Defined Names.  Often people use a Defined Name to refer to a cell on a worksheet but that is just one small use for Defined Names. You can store text, numbers, formulas, and functions inside of a Defined Name all without referencing any cell in the worksheet or workbook. This allows you to hard-code values into a ...
View Excel Tip
 
Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt)
Excel Tip
In this tutorial I am going to show you how to add, edit, and manage Business oriented diagrams, charts, and shapes to your Excel worksheet.  This specifically deals with the SmartArt feature of Excel. This feature is located on the Insert tab. To add SmartArt just click the logo to bring up the SmartArt pop-up window. To insert a SmartArt object, ...
View Excel Tip
 
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Excel Tip
In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as well as adding text to them. Adding Shapes to a Workbook in Excel To access shapes you navigate to the Insert tab then the Shapes dropdown from the Illustration section. To insert a shape just click on the desired shapes icon and the cursor will then change t ...
View Excel Tip
 
Calculate the Difference Between Time Greater than 24 Hours in Excel
Excel Tip
Ill show you how to calculate the difference between two times in Excel when that difference will add up to more than 24 hours of time. This is very similar to the tutorial on summing time greater than 24 hours here on Teachexcel.com. Here is an example of the problem with the wrong and right output displayed: To solve the problem, we simply need ...
View Excel Tip
 
Highlight Rows that Meet a Certain Condition in Excel
Excel Tip
In this tutorial I am going to cover how to highlight rows that meet a certain condition. To do this I use the Conditional Formatting tool. I will demonstrate some features of this advanced and powerful Excel tool. The Conditional Formatting dropdown is accessed from the Home tab: Conditional formatting involves applying a rule to the value of a ce ...
View Excel Tip
 
How to Arrange Data within Cells in Excel
Excel Tip
In this tutorial I am going to look at cell alignment / arrangement. These features allow you to change how data looks WITHIN cells in Excel. To align one or more cells just select the cells you wish to align and navigate to the Alignment section of the Home tab. (For versions of Excel prior to 2007, right-click on selected cells, select Format Cel ...
View Excel Tip
 
Display Numbers, Dates, & Times in the Correct Format in Excel
Excel Tip
In this tutorial I am going to look at Number formatting. Number formatting allows you to change how numbers are displayed in Excel, anything from currencies to times to dates, decimals, percentages, and more. As an example I will go back to the table of data from the previous tutorial and make various Number formatting changes. First I will change ...
View Excel Tip
 
How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More
Excel Tip
In this tutorial I will cover how to use the various formatting tools in Excel. The Formatting tools are located on the Home tab/ribbon (for versions prior to 2007 formatting is accessed by right clicking and selecting Format Cells): To demonstrate the various formatting options I am going to edit this basic table of sales orders: First I am going ...
View Excel Tip
 
Excel VBA - Create an Array - 3 ways
Excel Tip
Ill show you three different ways to create an array in Excel VBA and Macros and how to get the data out of those arrays. Arrays are types of variables that can hold multiple separate values.  This allows you to store a lot of data in one variable so that you can later go through the variable and use what you need.  This is much better than creat ...
View Excel Tip