Course Description
Students who enroll in this
course will learn the most important formulas in MS Excel 2013 as well
as using them in the most efficient way. Moreover the course offers a
vba section where students learn to program very useful code in vba.
I
designed the course in a way which offers students with different excel
knowledge the perfect environment to increase their skills and become
proficient with one of the most important tools microsoft has to offer.
I
use Excel 2013 but other versions of excel could be used to. The course
is structured in more than 50 Lectures with almost 3 hours of valuable
content. Any student can decide on his/her own how fast he or she wants
to complete the course.
Whether you want to work in the
banking sector, in consulting, in an industrial company or as an
entrepreneur - as long as you want to work with excel, this course
offers the best way to hone your skills.
Curriculum
Word of caution
A dream comes true - Goal seek in Excel
A few things before we start
A macro recorder? Thanks microsoft
A table of contents for my workbook with vba - awesome!
All right but what if I have several conditions?
Array formulas
Can i set a dynamic range for my data validation list? Sure!
conditional formating with formulas
Conditions? No problem. Use the IF Formula
Congratulation! Your first own macro
counta function
Data consolidation with consolidate
Data tables - One of the most powerful tools in financial analysis
Date and Time Formula - simple but useful
Don't like the for loop? Use the while loop instead!
Excel for Finance - Future Value Function
Excel for Finance - IRR Function
Excel for Finance - nper Function
Excel for Finance - NPV Function
Excel for Finance - PMT Function
Excel for Finance - rate Function
Excel for Finance - XIRR and XNPV
Forget filters - use DSUM instead
Form Controls - A powerful tool in Excel
get all filenames of a folder and save them in excel
Greetings from Excel
Highlight the selected cell
How to get the last row? Here's how!
How to sum with a condition
IF Function with OR / AND
Index and match function instead of vlookup
Let's create a dynamic chart
Lets get started with userforms
Lonely? Excel will talk to you
Loops -saving time using the For Loop
max, min, small, large?
Maybe most often used - the vlookup funtion
mean, average, averageif(s) - welcome to statistics
Open a website from vba
open other programs with vba
random vba code examples
Save excelsheet as a pdf
Section 1: Every journey begins with setting the goal
Section 2: Lets get started - Master Formulas in Excel 2013
Section 3: Formulas done - now lets go on with VBA!
Section 4: The end of the journey? A few words from your instructor
sumproduct - one of my personal favourites
The inputbox and select case
The match function
There is hlookup too
Transfer data from my userform into my sheets
vlookup - when to use approximate match
vlookup with more than 1 table? Impossible is nothing
What about counting (1)?
What about counting (2)?
What I want to tell you
What's this course about and why should I be interested?
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,
