Excel functions to analyze and visualize data
4.2 (58 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.
2,289 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel functions to analyze and visualize data to your Wishlist.

Add to Wishlist

Excel functions to analyze and visualize data

Learn basic yet powerful excel functions for data analysis and visualization on real life data
4.2 (58 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.
2,289 students enrolled
Created by Skillfin Learning
Last updated 9/2017
English
Current price: $12 Original price: $20 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Excel functions to extract data
  • Excel functions to visualize data
View Curriculum
Requirements
  • None. The student just need a PC with MS Excel
Description

COURSE UPDATE: 25th SEPTEMBER 2016

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

Dear students,

Thanks for enrolling into our course titled "Basic excel functions to analyze large data". We have some amazing good news for you. We have updated our above course to now make your learning experience even more enriching than before. In particular, we have made the following changes:

1. Improved audio and video quality: We have completely re-recorded all lectures with enhanced audio and video features. You should see an amazingly improved sound quality in all our lectures.

2. Additional content: We have also added a couple of new lessons on additional excel functions like TRANSPOSE, IF, COUNTIF, COUNTIFS, PIE CHART, etc. This should further enhance your content learning from the course.

3. Better explanations: We have also improved the illustrations and explanations of the previous course material to help grasp the lessons in a more meaningful way.

All in all we feel this is much upgraded version of the course and should definitely excite you.

So, what are you waiting for. You are already enrolled in the course. So get set learn.

Thanks

Skillfin Learning

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

Overview: This course will help students to understand how they can use excel functions to analyze and extract information from a large data. We will practice the exercises on real data which will make the insights meaningful and practical.

Target audience: This course is most helpful for students who have graduated / analysts in a consulting company or financial services sector. As an analyst, the day to day work involves working extensively on data analysis to identify trends. This course helps such professionals to get a basic understanding how excel can help.

Materials: There is an excel exercise that we do in this course. For best learning, please download the video and do the exercise simultaneously. If possible, have external speakers connected and see the video on a large screen to simulate the class experience.

Duration: The course is about 2 hours long. Feel free to practice one function at a time before moving to the next one.





Who is the target audience?
  • College graduates
  • Financial analysts
  • Job Seekers
  • Business analysts
Compare to Other Excel Courses
Curriculum For This Course
16 Lectures
01:55:31
+
Basic excel functions to analyze large data
16 Lectures 01:55:30

Please download this file

Download the excel spreadsheet we will use in the course
00:01



Extraction of data: using VLOOKUP function
11:40

Extraction of data: using the HLOOKUP function
09:31

Extraction of data: using the INDEX and MATCH function
13:56

Extraction of data: using the IF, COUNTIF and COUNTIFS function
09:09

Presentation of data: using the LINE graph
12:33

Presentation of data: using the PIE chart
11:45

Presentation of data: using the COLUMN chart
13:03

Presentation of data: using the STACKED chart
10:56

Presentation of data: using the CONDITIONAL FORMATTING function
06:58

Practice Assignment: DIFFICULTY LEVEL - MEDIUM
00:36

Please review our course - we need your feedback
00:19

Conclusion - contact us
00:10
About the Instructor
Skillfin Learning
4.5 Average rating
355 Reviews
9,425 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.