Microsoft Excel - Improve your skills quickly

Formatting turns a badly presented spreadsheet into a good one. Let's see some tips.

Sometimes you don't want to see all of the data. Let's focus on particular rows using a filter.

Wouldn't it be nice if the computer could automatically highlight cells according to specific criteria. Well, it can! Let's find out about Conditional Formatting.

Tables can enable the computer to add a few bells and whistles to your data - no effort. Let's find out what tables are and how you can use them.

PivotTables sound horrific, but are an easy way to summarise data. Let's see how easy they are to create.

If a picture tells a thousand words, how many does a good graph use? And how can you combine that with PivotTables to summarise the data. Let's find out about Charts and PivotCharts.

Sometimes a big chart is too much. Let's see how sparklines are like small charts.

Let's take a plunge into the wild side, and see what automation can do for your spreadsheet.

Let's see if you can remember the last few videos.

Let's start our look at functions with some of the summarising functions.

But what if you don't want to add up all of the data. Let's add some criteria.

What if you want to lookup data in one column based on another column - and how is VLOOKUP different to SUMIF? Let's find out.

Arrrr - we be on a treasure hunt, we be. Start at this cell, go down 2 and across 3. OFFSET marks the spot, arrr.

An companion to OFFSET, INDIRECT is another way to indirectly refer to cells, using strings.

Let's see if you can use these functions. Good luck!

What much should you know about Excel? Let's find out from Microsoft.

I hope you enjoyed the course. Goodbye for now.

I'm hoping this course has been useful to you. But how can you continue learning about Excel? Here's some suggestions.

Additionally, you can add anything you want into spreadsheets - but what if that is not what you want. Maybe you only want someone to enter dates into a cell. Let's find out about data validation, and how you can add messages, to be displayed whenever you click into a particular cell.