Learn basic excel functions to analyze large data

This course helps you to understand how you can use some basic excel functions in extracting and presenting information.
3.9 (52 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,281 students enrolled
Instructed by Skillfin Learning Business / Finance
25% off
Take This Course
  • Lectures 16
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description



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.


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.

What are the requirements?

  • This course requires a basic understanding and navigation of excel. The students should ideally watch the session and solve the exercises simultaneously.

What am I going to get from this course?

  • Extract and present information from a large data set. The similar exercises can be applied in practical job situations when there is a need to understand trends in an industry or a country.

Who is the target audience?

  • This course is most helpful for fresh graduates and analysts in a consulting or financial services company. The course is not meant for advanced professionals.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Basic excel functions to analyze large data
Introduction - brief overview on the course

Please download this file

The dataset we will analyze in this course
Extraction of data: Using the SUMIF function
Extraction of data: using VLOOKUP function
Extraction of data: using the HLOOKUP function
Extraction of data: using the INDEX and MATCH function
Extraction of data: using the IF, COUNTIF and COUNTIFS function
Presentation of data: using the LINE graph
Presentation of data: using the PIE chart
Presentation of data: using the COLUMN chart
Presentation of data: using the STACKED chart
Presentation of data: using the CONDITIONAL FORMATTING function
Practice exercise
Please review our course - we need your feedback
Conclusion - contact us

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Skillfin Learning, Learn from the experts in financial modeling and analytics

Hey there, welcome to our online courses.

Skillfin Learning is a group of corporate finance and business analytics professionals who have extensive experience and world class expertise in practical financial modeling applications in real world. We have been associated with large consulting and financial services organizations and understand the content requirement from analysts/professionals who can excel in this field. Our aim is to spread the learning in financial modeling and business analysis skills to whoever is keen to learn.

Our courses are comprehensive to impart skills around financial modeling and analytics i.e. excel, financial analysis and valuation. All our courses are practical and illustrations based that gives an on the job like training to our students. 

We remain committed to help you in your professional learning experience and development. You have access to our expertise 24 x 7 on all the courses you subscribe to.

Our courses are listed below. Look forward to seeing you inside.

Ready to start learning?
Take This Course