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.
Students who enroll in this course will learn the most important formulas in MS Excel 2013 (also Microsoft excel 2007 , excel 2010 and excel 2016) as well as using them in the most efficient way. Moreover the course offers an excel vba section where students learn to program very useful vba code.
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 Excel Tutorials 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.Learning MS Excel in no time is possible).
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.
If the course is not helpful to you than you can use a 30 day money back guarantee. But I promise you find what you are looking for. Let's learn Excel together.
I am looking forward to working with you. See you in the first lecture.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Every journey begins with setting the goal|
Download the excel workbook to follow the course
Word of caution
|Section 2: Lets get started - Master Formulas in Excel 2013|
Conditions? No problem. Use the IF Formula
IF Function with OR / AND
How to sum with a condition
All right but what if I have several conditions?
What about counting (1)?
What about counting (2)?
max, min, small, large?
Maybe most often used - the vlookup funtion
vlookup - when to use approximate match
There is hlookup too
The match function
vlookup with more than 1 table? Impossible is nothing
Index and match function instead of vlookup
Date and Time Formula - simple but useful
sumproduct - one of my personal favourites
mean, average, averageif(s) - welcome to statistics
Excel for Finance - Future Value Function
Excel for Finance - PMT FunctionPreview
Excel for Finance - rate Function
Excel for Finance - nper Function
Excel for Finance - NPV Function
Excel for Finance - IRR Function
Excel for Finance - XIRR and XNPV
A dream comes true - Goal seek in Excel
Data tables - One of the most powerful tools in financial analysis
Data consolidation with consolidate
conditional formating with formulas
Can i set a dynamic range for my data validation list? Sure!
Forget filters - use DSUM insteadPreview
Take a look at video 36 to activate the Developper Tab in Excel!
|Section 3: Formulas done - now lets go on with MS Excel VBA!|
A few things before we start
Form Controls - A powerful tool in Excel
Congratulation! Your first own macro
Greetings from Excel
How to get the last row? Here's how!
Highlight the selected cell
Loops -saving time using the For Loop
Don't like the for loop? Use the while loop instead!
The inputbox and select case
Lonely? Excel will talk to you
Save excelsheet as a pdf
Open a website from vba
open other programs with vbaPreview
Lets get started with userforms
Transfer data from my userform into my sheets
get all filenames of a folder and save them in excel
A table of contents for my workbook with vba - awesome!
A macro recorder? Thanks microsoft
Find Data with VBAPreview
random vba code examples
|Section 4: The end of the journey? A few words from your instructor|
What I want to tell you
|Section 5: Teaser videos from my excel vba course|
find and select data in word with vba
Create Textfiles and write into them with vba
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"