COURSE DESCRIPTION
This course is for people who
already have a basic understanding of excel. We will learn how to work
with different functions and alleviate daily tasks. Because of the
importance,I will include a chapter of financial functions as well. 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.
CURRICULUM
XIRR & XNPV
Alternatives to dropdown lists - buttons
array functions
basic functions
basic statistic functions
choose function
conditional formating
Cost minimizing using the Excel Solver
countif function
countifs function
data consolidation
days and time functions
Duration function
dynamic excel charts
dynamic range for dropdown list
Dynamics
Excel File
Excel Solver
Excle File for the course
financial functions
Future Value function
Goal Seek function
hlookup function
if function basic
if function with or() and and()
index and match function
IRR function
match function
max, min, small and large and transpose functions
mean, average, averageif, averageifs
Net Present Value function
nper function
Offset function for different Growth scenarios
Pivottables and Slicer
PMT function
random numbers and norm.inv function
Rate function
solver addin activation
start (+ downloadable excel file for the course)
sumif function
sumifs function
sumproduct function
The End - Thank you
vlookup approximative match
vlookup function
vlookup with more tables
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
