Practical MS Excel

WHY CHOOSE US?

Hi there! How are you? Thanks for considering our course. There are at least 100 MS Excel courses out there. Why choose ours? Because of the following reasons:

1. We pre-selected the important Microsoft Excel elements that are highly used in practice. So you do not spend 40 hours on a massive course, only to find that what you really need 99% of the time, could be explained in a fraction of that time. We respect your time.

2. We mix the course with story telling. We integrate interesting stories to give Microsoft Excel some context. So do not expect a boring ride. Instead, expect an exciting ride. So expect context about for instance:

   • Kellog's cornflakes' weird history

   • Dutch Christmas traditions

   • Tasty Brazilian fast food

   • Albrecht brothers who founded Aldi supermarkt

   • Atari and Nintendo 

   • The Navy SEALs

   • Dutch theme park 'The Efteling'

And much much more....

STRUCTURE

This course is 2 courses in 1. 

PART 1

In the first part you learn how Excel works. What exactly?

• Pivot charts and pivot tables

• Nested IF functions

• AND function

• Combining IF & AND function

• Cross sheet referencing

• Vlookup

• Freeze panes

• List functions

• Absolute and relative cell references

• Histograms

• Pareto charts

• Multiple line charts

• Bar charts

• Chart theory

PART 2

In part two, you will learn the theory of statistical techniques for data analysis. You do not need any statistical or mathematical background. Subsequently, you learn how to execute these theories in Excel. The tools of data analytics which you will learn include for instance:

• Correlation

• Single OLS regression

• Multiple OLS regression

• Non linear regression

At the end of this course, you obtain a certification of completion.

Note: We use Excel 2016, but other versions are fine too.

Thanks for considering us. Have a great day, wherever you are.

Team SSAA