Master MS Excel 2013 - Formulas and VBA programming
4.7 (31 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.
2,091 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master MS Excel 2013 - Formulas and VBA programming to your Wishlist.

Add to Wishlist

Master MS Excel 2013 - Formulas and VBA programming

Your personal journey to excel in excel
4.7 (31 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.
2,091 students enrolled
Created by Daniel We
Last updated 12/2015
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn Excel formulas easy
  • How to Excel - Understand and apply MS Excel efficiently
  • Excel Tutorials online
  • work most efficiently with excel formulas
  • solve any kind of problems in excel fast and easy
  • being able to apply the right Excel formula in the right situation
  • outpace your peers who have not decided to take this course
  • create useful vba code and save a lot of time
  • understand the way vba code is working
  • Learn Microsoft Excel Problem solving
  • Download Excel Tutorials excel workbook excel spreadsheet
View Curriculum
  • MS Excel 2013 (other versions also possible!)
  • You can download the course workbook in the first section

You want to excel in Excel? You want to outpace your peers? You want to enhance your skills? 

Then what you are waiting for?

As soon as you enroll in this course, you 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 you the perfect environment to increase your 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.

The course covers ( mircosoft office excel, all versions).

Who is the target audience?
  • If you want to Microsoft excel in excel this is the course to enroll
  • If you think you can't learn excel this course is a must for you, because you CAN!
  • If you have or had difficulties in working with MS excel you should enroll
  • If you want to work faster and easier with excel you should enroll
Students Who Viewed This Course Also Viewed
Curriculum For This Course
57 Lectures
Every journey begins with setting the goal
2 Lectures 03:19

Download the excel workbook to follow the course

Preview 01:52

Word of caution
Lets get started - Master Formulas in Excel 2013
32 Lectures 01:35:46
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)?

counta function

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

Array formulas

mean, average, averageif(s) - welcome to statistics

Excel for Finance - Future Value Function

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!

Take a look at video 36 to activate the Developper Tab in Excel!

Let's create a dynamic chart
Formulas done - now lets go on with MS Excel VBA!
20 Lectures 01:10:26
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

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

random vba code examples
2 pages
The end of the journey? A few words from your instructor
1 Lecture 02:10
What I want to tell you
Teaser videos from my excel vba course
2 Lectures 10:27
find and select data in word with vba

Create Textfiles and write into them with vba
About the Instructor
Daniel We
4.5 Average rating
162 Reviews
4,609 Students
17 Courses

Daniel is a 28 year old entrepreneur and consultant. He has a master degree in Economics as well as several additional qualifications and work experience in the finance and consulting industry. His passion is Data & Analytics and Machine Learning.

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"