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, Itake 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.