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.
