Excel Crashcourse Intermediate & Advanced
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: basic functions|
start (+ downloadable excel file for the course)Preview
if function basicPreview
if function with or() and and()Preview
max, min, small and large and transpose functionsPreview
vlookup approximative match
vlookup with more tables
index and match function
days and time functions
Pivottables and Slicer
Alternatives to dropdown lists - buttons
|Section 2: financial functions|
Future Value function
Net Present Value function
XIRR & XNPV
Goal Seek function
Offset function for different Growth scenarios
|Section 3: Dynamics|
dynamic range for dropdown list
dynamic excel charts
|Section 4: basic statistic functions|
mean, average, averageif, averageifs
random numbers and norm.inv function
|Section 5: Excel Solver|
solver addin activation
Cost minimizing using the Excel Solver
The End - Thank you
Daniel is a 26 year old entrepreneur and business man. 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"