Excel Crashcourse Intermediate & Advanced

The tool to support your career as a financial professional, an accountant, an entrepreneur, ....
3.6 (5 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.
605 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 39
  • Length 2 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 12/2013 English

Course Description

MS Excel is a "must have" skill in most of computer related working environments today. Even if you don't think it is relevant for you, I promise after finishing the course you will realize the opportunities MS Excel has to offer to you. If you aspire a job in the finance industry, as an accountant, or you would like to become an entrepreneur, the course will be helpful to achieve your goals. Consider the course as an important tool to support you in your career. The course is for people who already have at least basic understanding of MS Excel. We will learn how to work with different functions to alleviate all kinds of daily tasks. You will be able to download the spreadsheet. After finishing this course, you will have mastered the advanced features and functions of Excel.

Here I use Microsoft Excel 2010 but you can also use 2007 or 2013. There are not too many differences between the versions!

What are the requirements?

  • Excel 2007 / 2010 / 2013

What am I going to get from this course?

  • solve nearly all problems

What is the target audience?

  • everyone who has a least worked with basic excel before

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: basic functions
start (+ downloadable excel file for the course)
Preview
03:30
if function basic
Preview
01:14
if function with or() and and()
Preview
04:31
sumif function
01:29
sumifs function
02:45
countif function
02:05
countifs function
02:07
max, min, small and large and transpose functions
Preview
02:26
vlookup function
Preview
01:09
vlookup approximative match
02:09
match function
01:31
choose function
01:09
vlookup with more tables
05:13
hlookup function
01:36
index and match function
03:02
days and time functions
03:55
sumproduct function
04:59
array functions
02:40
Pivottables and Slicer
04:49
conditional formating
03:56
Alternatives to dropdown lists - buttons
02:26
Section 2: financial functions
Future Value function
03:19
PMT function
02:41
Rate function
02:05
nper function
02:18
Net Present Value function
01:34
IRR function
02:11
XIRR & XNPV
03:35
Duration function
01:55
Goal Seek function
03:18
Offset function for different Growth scenarios
03:45
data consolidation
03:06
Section 3: Dynamics
dynamic range for dropdown list
05:57
dynamic excel charts
06:25
Section 4: basic statistic functions
mean, average, averageif, averageifs
04:43
random numbers and norm.inv function
01:56
Section 5: Excel Solver
solver addin activation
00:42
Cost minimizing using the Excel Solver
04:30
The End - Thank you
01:07

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniel We, Traveller

Daniel is a 28 year old entrepreneur and consultant. He has a master degree in Finance and Acounting as well as several additional qualifications and work experience in the finance and consulting industry.

He is committed to support other people by offering them educational services to help them accomplishing their goals and becomming the best in their profession.

"Life is a journey, and I will give my best to help you on your way to your goals"

Ready to start learning?
Take This Course