Learn Data Analysis using Microsoft Excel Basics Fast

Why learn Data Analysis and Data Science?

According to SAS, the five reasons are

1. Gain problem solving skills

The ability to think analytically and approach problems in the right way is a skill that is very useful in the professional world and everyday life.

2. High demand

Data Analysts and Data Scientists are valuable. With a looming skill shortage as more and more businesses and sectors work on data, the value is going to increase.

3. Analytics is everywhere

Data is everywhere. All company has data and need to get insights from the data. Many organizations want to capitalize on data to improve their processes. It’s a hugely exciting time to start a career in analytics.

4. It’s only becoming more important

With the abundance of data available for all of us today, the opportunity to find and get insights from data for companies to make decisions has never been greater. The value of data analysts will go up, creating even better job opportunities.

5. A range of related skills

The great thing about being an analyst is that the field encompasses many fields such as computer science, business, and maths.  Data analysts and Data Scientists also need to know how to communicate complex information to those without expertise.

The Internet of Things is Data Science + Engineering. By learning data science, you can also go into the Internet of Things and Smart Cities.

 

This is a bite-size course to learn Data Analysis using Microsoft Excel fasts. This course will use CRISP-DM model, and we will go through Data Understanding (Data visualization, Statistics, Data analysis) and Data Preparation (Removing Missing values and removing duplicates) using Microsoft Excel.  

You will need to know some computer knowledge before learning this course and you need to know Microsoft Excel before learning also. You can learn Microsoft Excel in my course “Learn Microsoft Excel Basics Fast”. 

You can take the course as follows and you can take an exam at EMHAcademy to get SVBook Advance Certificate in Microsoft Office and Data Analysis with Excel:

– Learn Microsoft Word Basics Fast

– Learn Microsoft Powerpoint Basics Fast

– Learn Microsoft Excel Basics Fast

– Learn Data analysis using Microsoft Excel Basics Fast.

Content

1. Getting Started

2. Download Dataset

3. Read CSV

4. Data Mining Process

5. Insert Lien CHart

6. Insert Bar Chart

7. Insert Pie Chart

8. Insert Scatterplot

9. Insert Combo Chart

10. Pivot Table

11. Insert Pivot Table and Pivot Chart

12. Data Analysis Plugins

13. Data Analysis PLugins 2

14. Descriptive Statistics

15. Histogram

16. Correlation

17. Covariance

18. TTest Two Samples Paired for means

19. TTest Two Samples Equal Variances

20. TTest Two Samples Unequal Variances

21. F Test Two Samples for Variances

22. ANOVA Single Factor

23. ANOVA Two Factor WIthout Replication

24. Regression Analysis

25. Remove Duplicates

26. Remove Missing

27. Sort Data

28. Filter Data

Rating Distribution

• 1 stars: 4 votes
• 2 stars: 0 votes
• 3 stars: 1 votes
• 4 stars: 1 votes
• 5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!