Advanced Excel functions to analyze large data

 14 / 1 / 2016  543  0 Digital Literacy

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.

Login or Register as a member to start the course.

Comments

No comments found.

Leave a Comment

 
 
 
Post Comment