Excel Crashcourse Intermediate & Advanced
4.2 (9 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.
625 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Crashcourse Intermediate & Advanced to your Wishlist.

Add to Wishlist

Excel Crashcourse Intermediate & Advanced

The tool to support your career as a financial professional, an accountant, an entrepreneur, ....
4.2 (9 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.
625 students enrolled
Created by Daniel We
Last updated 8/2014
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • solve nearly all problems
View Curriculum
Requirements
  • Excel 2007 / 2010 / 2013
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!

Who is the target audience?
  • everyone who has a least worked with basic excel before
Students Who Viewed This Course Also Viewed
Curriculum For This Course
39 Lectures
01:53:48
+
basic functions
21 Lectures 58:41



sumif function
01:29

sumifs function
02:45

countif function
02:05

countifs function
02:07



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
+
financial functions
11 Lectures 29:47
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
+
Dynamics
2 Lectures 12:22
dynamic range for dropdown list
05:57

dynamic excel charts
06:25
+
basic statistic functions
2 Lectures 06:39
mean, average, averageif, averageifs
04:43

random numbers and norm.inv function
01:56
+
Excel Solver
3 Lectures 06:19
solver addin activation
00:42

Cost minimizing using the Excel Solver
04:30

The End - Thank you
01:07
About the Instructor
Daniel We
4.6 Average rating
195 Reviews
4,981 Students
19 Courses
Traveller

Daniel is a 28 year old entrepreneur ,data scientist and web analyst consultant. He holds a master degree as well as other major certificates from Google and others.

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.

"In order to do the impossible you need to see the invisible"