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).

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

How to use the RANK function in Excel

2017-08-10T11:30:16+00:00

How to use the RANK function in Excel Like the INDEX and MATCH functions, RANK gives you information on where a particular value falls in a list. And at first, it might not seem like a very useful function. But once you get the hang of it, you can start using RANK to get some [...]

How to use the RANK function in Excel 2017-08-10T11:30:16+00:00

Format Painter in Excel – Copy Formatting Quickly

2017-08-10T12:27:44+00:00

Copy Formatting Quickly with Excel's Format Painter Cell formatting can be very useful in Excel. In addition to making your spreadsheet nicer to look at, you can conditionally format cells, use formats in your searches, and even filter by format. These features are great, but sometimes you just want to get a lot of [...]

Format Painter in Excel – Copy Formatting Quickly 2017-08-10T12:27:44+00:00

Send this to a friend