Microsoft Excel Tutorials: Free, actionable, and updated.

Right below you find find our latest Excel tutorials (+20!).
They all include practical examples, exercise files, and are updated for the latest version of Excel (2016).

Grouping and Outlining in Excel

2017-08-23T11:44:50+00:00

Grouping and Outlining in Excel Spreadsheets often have different levels of data. And those levels can be difficult to parse when you're trying to read them. That's where grouping and outlining comes in. Grouping cells can make your data easier to read, and it can even help you automate some addition within the outline. [...]

Grouping and Outlining in Excel 2017-08-23T11:44:50+00:00

How to AutoFit in Excel: Adjust Rows and Columns in a Snap

2017-08-23T11:33:16+00:00

How to Autofit in Excel: Adjust Rows and Columns in a Snap Adjusting column widths and row heights in Excel can make for a much nicer looking spreadsheet. No need for cells that get cut off! (Or, for that matter, cells that have a lot of extra space.) And if you learn to quickly [...]

How to AutoFit in Excel: Adjust Rows and Columns in a Snap 2017-08-23T11:33:16+00:00

How to Strikethrough in Excel (+shortcut)

2017-08-23T11:22:06+00:00

How to Strikethrough in Excel Excel is great with text, but it's not always clear how to get the formatting you want. This is especially true for strikethrough:) Fortunately, adding strikethrough in Excel is super easy—once you know how to do it. Let's take a look... Table of Contents 1: Adding strikethrough in [...]

How to Strikethrough in Excel (+shortcut) 2017-08-23T11:22:06+00:00

Save Tons of Time: How to Create Named Ranges in Excel

2017-08-23T11:13:11+00:00

Save Tons of Time: How to create Named Ranges in Excel Most of the time, we use cell references in our formulas. And most of the time, that works well. But Excel's ability to name cells and ranges can save you huge amounts of time when you're entering formulas. And they can help you [...]

Save Tons of Time: How to Create Named Ranges in Excel 2017-08-23T11:13:11+00:00

Customizing Excel’s Quick Access Toolbar

2017-08-23T11:04:40+00:00

Customizing Excel's Quick Access Toolbar The Quick Access Toolbar is easy to overlook. But by customizing it to your liking, you can access some of your most often-used commands faster than ever. If you use the same buttons in the Ribbon on a regular basis, the Quick Access Toolbar can save you a lot of [...]

Customizing Excel’s Quick Access Toolbar 2017-08-23T11:04:40+00:00

How to Insert Tables and Data From Excel into Microsoft Word

2017-08-23T10:49:10+00:00

How to Insert Tables and Data From Excel into Microsoft Word Microsoft Word is great for working on documents—but not so great with tables. If you want to put a table into a Microsoft Word document, you can work with Word's built-in table tools, or you can insert data directly from Excel. Guess which [...]

How to Insert Tables and Data From Excel into Microsoft Word 2017-08-23T10:49:10+00:00

Need a Random Number Generator in Excel? Here are 2 Ways to do it

2017-08-10T11:13:25+00:00

Need a Random Number Generator in Excel? Here are 2 Ways to do it You might be surprised at how often you need to generate random numbers in Excel. Maybe it's for an experiment or some type of hypothetical calculation. Or for whipping up a spreadsheet full of mock data. No matter the reason, [...]

Need a Random Number Generator in Excel? Here are 2 Ways to do it 2017-08-10T11:13:25+00:00

How to Master the AND or OR Logical Functions in Excel

2017-08-10T08:47:34+00:00

How to Master the AND and OR Logical Functions in Excel Most of Excel's functions deal with numbers and making calculations with them. But some functions have a different purpose: they resolve logical statements and display specific values based on the results. This might sound complicated, but it's actually pretty simple. And it can be extremely useful. [...]

How to Master the AND or OR Logical Functions in Excel 2017-08-10T08:47:34+00:00

How to Make a Table in Excel In 60 seconds or less (+free exercise file)

2017-08-10T12:42:49+00:00

How to make a Table in Excel in 60 seconds (or less) Most Excel data is in the format of a table... But if you tell Excel that a specific set of data should be considered a single table, you open up many new possibilities! Excel tables let you do a lot of cool [...]

How to Make a Table in Excel In 60 seconds or less (+free exercise file) 2017-08-10T12:42:49+00:00

How to use Flash Fill and Auto Fill in Excel

2017-08-10T09:24:21+00:00

How to Use Flash Fill and Auto Fill in Excel Spreadsheets often include a lot of repetitive data. Sometimes it's a sequence of dates. Or a specific series of numbers pulled out of longer sequences. It might be a database of email addresses. Whatever it is, it can take a long time to get [...]

How to use Flash Fill and Auto Fill in Excel 2017-08-10T09:24:21+00:00

Send this to a friend