Microsoft Excel – Improve your skills quickly
Welcome to this course about Microsoft Excel. You can use any version of Excel in this course, whether it is Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.
A lot of people use some of the features in Excel and just muddle through – not many use all of the functions.
In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.
-
Learn more about formatting, filters and conditional formatting – they can improve the presentation of your spreadsheets with just a few clicks.
-
Create tables, PivotTables, Chart, PivotCharts and Sparklines – create analyses very quickly.
-
Find out how powerful Visual Basic for Applications (VBA) is – automate your code.
-
And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT – translated into 15 different languages.
There are also a couple of Practice Activities, so that you can do these exercises and see how much you have learned.
In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features – and you’ll find out how much more you can learn.
Afterwards, we’ll investigate what you should know about Excel, having a look at the official Microsoft exams for a guide.
Improve your Skills
Improve your Functions
-
4
FormattingFormatting turns a badly presented spreadsheet into a good one. Let's see some tips.
-
5
Filters
Sometimes you don't want to see all of the data. Let's focus on particular rows using a filter.
-
6
Conditional Formatting
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.
-
7
Tables
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.
-
8
PivotTables
PivotTables sound horrific, but are an easy way to summarise data. Let's see how easy they are to create.
-
9
Graphs and PivotCharts
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.
-
10
Sparklines
Sometimes a big chart is too much. Let's see how sparklines are like small charts.
-
11
Visual Basic for Applications (VBA)
Let's take a plunge into the wild side, and see what automation can do for your spreadsheet.
-
12
Practice Activity Number 1Let's see if you can remember the last few videos.
Conclusion
-
13
SUM, AVERAGE, COUNT
Let's start our look at functions with some of the summarising functions.
-
14
SUMIF, AVERAGEIF, COUNTIF
But what if you don't want to add up all of the data. Let's add some criteria.
-
15
VLOOKUP
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.
-
16
OFFSET
Arrrr - we be on a treasure hunt, we be. Start at this cell, go down 2 and across 3. OFFSET marks the spot, arrr.
-
17
INDIRECT
An companion to OFFSET, INDIRECT is another way to indirectly refer to cells, using strings.
-
18
Practice Activity Number 2
Let's see if you can use these functions. Good luck!
Related Courses
