Home » Office Productivity » Microsoft Excel – Improve your skills quickly

[Free] Microsoft Excel - Improve Your Skills Quickly

Pivot Tables, Charts, Sparklines, functions, formulas and more – in just a couple of hours – Free Course

Added on September 28, 2024 Office Productivity 2 min read

What you’ll learn

• Create Tables, PivotTables, PivotCharts and Sparklines
• Add Conditional Formatting, Filters – and even use a bit of Visual Basic for Applications
• Use SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT functions
• Find out what you need to know about Excel to continue your learning.

Requirements

• Before beginning, you will need to know how to use a Windows computer, including a mouse.
• It would be good if you have used Microsoft Excel before, but this is not essential.
• You should have MS Excel (or Office) 2007, 2010, 2013, 2016 or 365 installed on your computer.

Description

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.

Afterwards, we’ll investigate what you should know about Excel, having a look at the official Microsoft exams for a guide.