Advanced Excel functions to analyze large data

Learn how to use some advanced functions in excel to analyze and derive meaningful insights from large data set.
4.4 (41 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.
1,954 students enrolled
Instructed by Skillfin Learning Business / Finance
$19
$20
5% off
Take This Course
  • Lectures 15
  • Length 1.5 hours
  • Skill Level All Levels
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 1/2016 English

Course Description

We have added more practice exercises for your learning. If you have any queries regarding the same, feel free to post on discussion board or email us.

What is this course about?

This course is about learning advanced excel functions to help analyze large data. This course teaches you how you can make flexible financial models, derive insights from large data set and summarize information from large data.

How is the course taught?

As with all our courses, we have followed an illustration based approach to teach these advanced excel functions. There are examples from practical situations that we leverage to teach all the advanced excel functions. We strongly recommend that you carry out the practical exercises along with the instructor so that we can have the same setup.

Why take this course?

This course is going to be very useful to you if you are financial analyst, job seeker in financial modeling roles or college students. This course has one of the richest content in helping somebody learn about advanced excel functions. We are confident if you sign up for the course, you can learn something very practical on how to apply advanced excel functions.

What functions are we going to learn?

We are going to learn about the following functions-

1) List

2) Offset

3) Sumproduct

4) Goal-seek

5) Index Match (3 dimensional data)

6) Pivot tables

7) Indirect

All functions are taught with some examples

How long will the course take?

The course is around an hour long but if you practice the exercises, it make take you around 3 hours to completely learn the entire course.

What are the requirements?

  • The students are expected to basic understanding of MS Excel and its interface. It is also recommended that you sign up for our other course titled: Basic excel functions to analyze large data.

What am I going to get from this course?

  • apply advanced excel functions to large data to derive meaningful insights and make flexible models.
  • Prepare for job interviews for technical questions on excel function and financial modelling

What is the target audience?

  • This course is meant for job seekers, current and prospective financial analyst and college students.

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.

Curriculum

Section 1: Advanced excel functions to analyze large data
Introduction
Preview
02:57
Download the excel template for the exercises
Article
Understanding the list function
Preview
05:45
Understanding the offset function
Preview
08:30
Understanding the sumproduct function
08:24
Understanding goal seek functionality
08:29
Understanding index-match function
18:54
Understanding the pivot function
11:14
Understanding the indirect function
11:31
Article

Now is the time to apply your learning of the previous lectures. Use the one or more of the above functions to solve this practice exercise.

Practice exercise 2
Article
Practice exercise 3
Article
Solutions to the practice exercises
Article
Please review our course - we need your feedback
Article
Queries - contact us
00:10

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