The Data Analyst Skills Training course (DAST) with Excel
4.5 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
579 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Data Analyst Skills Training course (DAST) with Excel to your Wishlist.

Add to Wishlist

The Data Analyst Skills Training course (DAST) with Excel

Learn data analyst skills - data analysis, manipulation and visualization techniques in Excel.
4.5 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
579 students enrolled
Created by Skillfin Learning
Last updated 9/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 7 Articles
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Students will be able to do data analysis, manipulation and visualization in Excel
  • Students will be able to "play" with data
View Curriculum
Requirements
  • Absolutely none
  • You just need a PC
Description

                **************************    AUGUST 1, 2017 UPDATE **************************

We would like to let you know that we have updated all the Practice Assignments in The Data Analyst Skills Training with Excel course . The newly updated assignments will further help to strengthen your understanding of the different modules of the course through practical real life case examples. 

For your ease, we have also earmarked the updated Practice Assignments into varying DIFFICULTY levels i.e. EASY, MEDIUM, HARD. As usual, we will be reviewing individual assignments and provide direct feedback.

We cant wait to see your professional development and progress.

               ****************************************************************************************


Master the data analysis skills with this comprehensive The Data Analyst Skills Training (DAST) course with Excel.

  • Overview of data analytics and MS Excel
  • Data cleaning and analysis using TEXT functions in Excel
  • Data analysis and visualization using basic Excel functions
  • Data analysis and interactivity using advanced Excel functions
  • Data visualization using advanced Excel functionalities

Data analysis and visualization using Excel play a very important role in any organization.

Excel is one of the most frequently using MS applications in any organization. Professionals in almost every role use Excel as a tool for data analysis, manipulation and visualization. It is imperative to be able to use Excel for data analysis in order to be successful in daily work lives. In fact, before you can move to any other platform for data analysis, it is a must to be fully proficient in Excel since it is the oldest living platform for this purpose. With data analysis, you can turn any raw data into some meaningful business insight to drive strategic business decisions for the company. Not only this, the visualization tools further help to illustrate graphically the findings of data analysis for an effective communication with senior colleagues in the firm. Data analysis and visualization go hand in hand in modern jobs.

How is the our course different from other courses in this topic?

  • The courses are taught by global experts in the field of data analysis who have worked for large consulting and financial services companies (McKinsey and BlackRock) 
  • Comprehensive course that covers ALL what you need to know for data analysis and visualization in excel
  • Clear concise and crisp explanation of complex topics
  • There are real life illustration in all modules that imparts on the job like training.
  • There are practice exercises at end of each module to test your learning (updated for Aug 1 2017).
  • Our faculty is responsive 24x7 in resolving all your queries related to the course.

So dont wait further. Enrol in the course now. See you inside the course.

Who is the target audience?
  • Anyone who wants to learn Excel completely
  • Anyone who wants to get a Data Analyst job
  • All college graduates
  • All working professionals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
63 Lectures
06:12:05
+
Course overview
1 Lecture 03:51
+
Module 1: Overview of data analytics and MS Excel
10 Lectures 32:13

What are the key data analyst skills you need to learn?
02:54

Data analyst vs data scientist? What is the difference?
03:26

Overview of Microsoft Excel
05:06

Getting familiar with MS Excel interface
04:31

Warm up with very basic excel functionalities
07:01

Understanding formatting in excel
04:13

Recap: what did we learn Module 1?
01:16

Practice Assignment #1: DIFFICULTY LEVEL - EASY
00:36

SOLUTION TO PRACTICE ASSIGNMENT #1
00:02
+
Module 2: Data cleaning and analysis using TEXT functions
12 Lectures 59:48

Download the excel template for this module
00:34

Illustration 1: Introduction
01:45

Illustration 1: Understanding LEN, FIND, LEFT, CONCATENATE functions
15:04

Illustration 2: Understanding the TRIM and FIND function
08:35

Illustration 2: Understanding the LEFT and MID function
12:28

Illustration 3: Introduction
01:44

Illustration 3: Understanding the SEARCH function
06:26

Illustration 3: Understanding the IFERROR function
03:33

Illustration 3: Understanding the IF function
03:32

Recap: what did we learn in Module 2
00:52

Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
00:36
+
Module 3: Data analysis and visualization using basic excel functions
16 Lectures 02:00:36

Download the excel template for this module
00:34

Lets look at the data
02:55

Data analysis: Understanding the SUMIF function
08:14

Data analysis: Understanding how to calculate the growth rates
03:58

Data analysis: Understanding the VLOOKUP function
11:40

Data analysis: Understanding the HLOOKUP function
09:31

Data analysis: Understanding the INDEX and MATCH function
13:56

Data analysis: Understanding the COUNTIFS function
09:09

Data visualization: Understanding the LINE chart
12:33

Data visualization: Understanding the PIE chart
11:45

Data visualization: Understanding the COLUMN chart
13:03

Data visualization: Understanding the STACKED chart
10:56

Data visualization: Understanding the CONDITIONAL FORMATTING functionality
06:58

Recap: what did we learn in Module 3
01:03

Practice Assignment #3: DIFFICULTY LEVEL - MEDIUM
00:37
+
Module 4: Data analysis using advanced excel functions
11 Lectures 01:17:41

Download the excel template for this module
00:34

Understanding the LIST function
05:45

Understanding the OFFSET function
08:30

Understanding the SUMPRODUCT function
08:24

Understanding the GOAL SEEK functionality
08:29

Understanding the INDEX and MATCH function
18:54

Understanding the PIVOT TABLES functionality
11:14

Understanding the INDIRECT function
11:31

Recap: what did we learn in Module 4?
00:51

Practice Assignment #4: DIFFICULTY LEVEL - MEDIUM
00:37
+
Module 5: Advanced data visualization in excel
12 Lectures 01:17:17

Download the excel template for this module
00:34

Understanding the COMBINATION chart in excel
10:34

Understanding the WATERFALL chart in excel
14:16

Understanding the DYNAMIC LINE chart in excel
13:17

Understanding the AREA chart in excel
04:46

Understanding the INDEX chart in excel
10:01

Understanding the RADAR chart in excel
04:24

Understanding the SCATTER chart in excel
09:42

Understanding the BUBBLE chart in excel
06:24

Recap: what did we learn in Module 5?
00:55

Practice Assignment #5: DIFFICULTY LEVEL - MEDIUM
00:43
+
COURSE CHALLENGE #1 - DIFFICULTY LEVEL : HARD
1 Lecture 00:36
Take the course challenge now to test your overall learning
00:36
About the Instructor
Skillfin Learning
4.5 Average rating
353 Reviews
9,400 Students
11 Courses
Building skills for business and finance careers

SKILLFIN LEARNING is a leading online training provider of business and finance courses. We have a number of online courses in the area of financial modelling and business analytics enrolled into by thousands of students globally. 

Our courses provide on the job like training to help your professional advancement. Our students have successfully cracked their job interviews based on the content learning in these courses. 

The courses are very practical and are full of real life illustrations. The courses are curated by professionals who are experts in the field of finance and analytics having worked with companies like McKinsey and BlackRock globally.