Excel Crash Course:
Learn Excel in Just 30 Minutes (Free)

One of the great things about Excel spreadsheets is the structure.

It’s just so mesmerizing for data-geeks (like me!).

Not a data geek? 😎

Let me fill you in.

Any Microsoft Excel spreadsheet consists of rows (horizontal) and columns (vertical).

The intersection between a row and a column forms a cell.

If you left-click on a cell and start typing, you can store information like text or numbers in a cell.

This is the foundation of everything in Excel.

This row/column grid is used to store information in thousands (even millions) of cells at once.

Using this for keeping track of information is fine…

The next topic covers a very fundamental part of Excel: how to do calculations with cells.

But before diving into that, you need to know how to use the Excel ribbon, sheets, saving files, and how to copy/paste.

If you want a quick tour of this, read my guide on ‘How to use Excel’ here.

Note: this guide is written in Excel 2019 for Windows. But you can follow along if you have Excel 2010 or newer.

Already got that covered?

Great!

Then let’s move on to doing calculations with cells using formulas.

So, you’ve got the basics of the basics covered…

Now, I’m going to blow your mind 💣

Maybe you do that yourself?

You’re breaking my heart 💔

I promise you: You don’t have to do that ever again.

Excel does everything your calculator does – only a gazillion times faster!

Just type an equal sign in a cell and start calculating.

Type your formula, hit ‘Enter’ and the result will show in the cell.

Easy-peasy, right?

Now, go burn all your calculators 🔥

Of course, you can do many types of calculations within Excel. And they all have their own symbol, called an ‘operator’.

For instance:

Use + for addition and – for subtraction (makes sense, right?)

Use / for division

Use * for multiplication

Read my guide to all specific calculations within Excel here.

Oh yeah, sorry…

A formula, on its own, is no miracle.

But it will be in a few seconds!

Formulas themselves are not real game-changers – because they’re basically big calculators.

But when you use the cells in a spreadsheet inside the formulas, that’s when it takes off!

Now, let’s take this free Excel course to the next level🚀

A reference is a cell address, that you put in a formula like this:

=100/E5

What’s the result of this formula?

I don’t know… 🤷

It depends on whatever is in cell E5.

The E5 part of the formula is a reference to cell E5, that mirrors the value in the cell.

If you type 20 in cell E5, the result of the formula is 5, as illustrated here:

This is huge!

That means you can calculate things at a much bigger scale, much faster than you ever could.

Here, I’ve found the differences between start and end values by typing =B2-A2 in cell C2 and copying it down to the cells below.

Cool, right?

That’s the sort of things you can do with references. And much more.

References are an integral part of working with Excel.

But there’s more to it than this.

Read my guide here to learn everything you need to know about references.

Until now, you’ve learned most of the crucial building blocks of working with Excel and not against it.

But there are still a few left.

Functions are one of these fundamental Excel-features you absolutely need to use.

Functions are small snippets of pre-made formula that does something specific 🔨

The SUM function sums up numbers.

The MIN function finds the lowest number in a bunch of cells.

Guess what the MAX function does?

Many of the simple (but useful) functions are almost identical.

So, when you know how to use one, you know how to use them all 👍

In the image below, I use the SUM function to sum up the values in cell D2 through D6.

Want to find the lowest value in column D?

Replace ‘SUM’ with ‘MIN’:

=MIN(D2:D6)

Cool, right?

And there are functions for all your needs and wants in Excel.

You can use functions to find averages, count stuff, work with dates, and much more!

Oh, and here are my guides to the SUM and MIN/MAX functions, if you want to dive deeper.

Eventually, you’re going to face a spreadsheet that’s too big to make any sense.

I coped with this by going to the bathroom to cry 😢

Until a friend told me a better way…

A filter turns your big dataset into a smaller dataset that shows you exactly what you’re looking for.

1. Select a cell in your dataset
2. Go to the ‘Data’ tab
3. Click the ‘Filter’ button
4. Click the small arrow next to the column you want to filter
5. Filter away the stuff you don’t want to see and click ‘OK’.

Here, I’ve filtered the dataset, so it only shows orders made by Aubrey.

In a big spreadsheet, this would’ve taken me forever to find.

Filters are great for data analysis!

Spreadsheets look inherently boring…

But they don’t have to!

With a few tricks, you can make your spreadsheet easy on the eyes in less than 60 seconds ⏱️

Follow these steps:

1. Put borders around headers
2. Change cell color in header cells
3. Insert a thousand separator in big numbers

And it’ll look like this:

Looks pretty good for a standard spreadsheet, right?

You do the coloring and the borders by selecting cells and using the formatting tools in the ‘Home’ tab.

You insert the thousand separators with number formatting, making the numbers more readable 👀

Oh, you’re in for a treat 🍭

Excel contains functions that do much more than finding totals or minimum values.

The IF function enables your formula to react to what’s in other cells and change accordingly.

Let’s use the IF function to calculate the commission for our staff.

If the price of an order is above 100,000 the commission is 5% of the price.

If the price is 100,000 or below, the commission is 3%.

The formula to calculate that is:

=IF(C2>100000,C2*0.05,C2*0.03)

In Excel, it looks like this:

Pretty cool, right?

IF brings logic to your cells. And this logic is used in many other functions as well.

Among some of the most powerful are: SUMIF, COUNTIF, and nested IF functions.