Advanced Excel functions
4.3 (49 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,968 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel functions to your Wishlist.

Add to Wishlist

Advanced Excel functions

Learn advanced excel functions to extract information from large data, aggregate data meaningfully & make dynamic models
4.3 (49 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,968 students enrolled
Created by Skillfin Learning
Last updated 2/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 6 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Extract information from large data
  • Aggregate large data meaningfully
  • Build dynamic and flexible models
View Curriculum
Requirements
  • None. The student just need a PC with MS Excel
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.

Who is the target audience?
  • Business and finance students
  • Financial and business analysts
  • Job seekers in finance roles
Students Who Viewed This Course Also Viewed
Curriculum For This Course
15 Lectures
01:16:54
+
Advanced excel functions to analyze large data
15 Lectures 01:16:54

Download the excel template for the exercises
00:03



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

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 1
00:10

Practice exercise 2
00:10

Practice exercise 3
00:10

Solutions to the practice exercises
00:04

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

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