Practical Microsoft Excel + Microsoft Excel data analysis

• In part 1 we will teach you the Excel skills that are in demand in practice.
• In part 2 we will teach you data analysis skills so you to find patterns and relationships in data that you can use to improve your business.
• How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)
• You will learn by cases. We use cases from television shows, famous supermarkets, food history , famous rock bands etc.

2 in 1: Microsoft Excel: Practical MS Excel + MS Excel data analysis

WHYCHOOSEUS?

Hi there! How are you? Thanks for considering our Microsoft Excel course. There are at least 100 MS Excel courses out there. Why choose our MS Excel? 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 MS Excel 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 MS Excel 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 MS Excel works. What exactly?

• MS Excel: Pivot charts and pivot tables

• MS Excel: Nested IF functions

• MS Excel: AND function

• MS Excel: Combining IF & AND function

• MS Excel: Cross sheet referencing

• MS Excel: Vlookup

• MS Excel: Freeze panes

• MS Excel: List functions

• MS Excel: Absolute and relative cell references

• MS Excel: Histograms

• MS Excel: Pareto charts

• MS Excel: Multiple line charts

• MS Excel: Bar charts

• Chart theory

PART2

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

• Correlation with MS Excel

• Single OLS regression with MS Excel

• Multiple OLS regression with MS Excel

• Non linear regression with MS Excel

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

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

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

Team SSAA