- Регистрация
- 27 Авг 2018
- Сообщения
- 35,757
- Реакции
- 465,801
- Тема Автор Вы автор данного материала? |
- #1
![Excel-A-Z-Data-Analytics-Theory-Application-Accredited-Course.jpg](https://freecoursesite.us/wp-content/uploads/2019/08/Excel-A-Z-Data-Analytics-Theory-Application-Accredited-Course.jpg)
- How to work with Excel in general (version is not very important)
- Statistical theory for data analysis
- How to apply the statistical theory for data analysis in MS Excel 2016 (other versions are also fine)
- Preferably you have the 2016 Windows MS Excel installed on your laptop
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:
- 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.
- 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'
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
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
Note: We use Excel 2016, but other versions are fine too.
Thanks for considering us. Have a great day, wherever you are.
Team SSAA
Who this course is for:
- IT professionals
- Healthcare professionals
- Financial professionals
- Basically anyone who is dealing with information and has the need to structure and analyse that info
- Business professionals
DOWNLOAD: