Master MS Excel 2013 - Formulas and VBA programming
4.7 (28 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,040 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 (28 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,040 students enrolled
Created by Daniel We
Last updated 12/2015
English
Current price: $10 Original price: $30 Discount: 67% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • MS Excel 2013 (other versions also possible!)
  • You can download the course workbook in the first section
Description

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.


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
Expand All 57 Lectures Collapse All 57 Lectures 03:04:08
+
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
01:27
+
Lets get started - Master Formulas in Excel 2013
32 Lectures 01:35:46
Conditions? No problem. Use the IF Formula
02:08

IF Function with OR / AND
04:04

How to sum with a condition
03:21

All right but what if I have several conditions?
05:00

What about counting (1)?
02:18

What about counting (2)?
02:01

counta function
01:21

max, min, small, large?
02:45

Maybe most often used - the vlookup funtion
02:23

vlookup - when to use approximate match
03:32

There is hlookup too
02:05

The match function
01:46

vlookup with more than 1 table? Impossible is nothing
04:49

Index and match function instead of vlookup
03:00

Date and Time Formula - simple but useful
04:39

sumproduct - one of my personal favourites
04:17

Array formulas
01:58

mean, average, averageif(s) - welcome to statistics
02:44

Excel for Finance - Future Value Function
02:40


Excel for Finance - rate Function
02:11

Excel for Finance - nper Function
02:12

Excel for Finance - NPV Function
01:56

Excel for Finance - IRR Function
01:59

Excel for Finance - XIRR and XNPV
03:20

A dream comes true - Goal seek in Excel
02:29

Data tables - One of the most powerful tools in financial analysis
05:31

Data consolidation with consolidate
02:25

conditional formating with formulas
04:12

Can i set a dynamic range for my data validation list? Sure!
04:26


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

Let's create a dynamic chart
03:42
+
Formulas done - now lets go on with MS Excel VBA!
20 Lectures 01:10:26
A few things before we start
03:38

Form Controls - A powerful tool in Excel
03:20

Congratulation! Your first own macro
02:01

Greetings from Excel
02:59

How to get the last row? Here's how!
03:01

Highlight the selected cell
03:29

Loops -saving time using the For Loop
02:38

Don't like the for loop? Use the while loop instead!
02:34

The inputbox and select case
03:17

Lonely? Excel will talk to you
01:35

Save excelsheet as a pdf
03:01

Open a website from vba
03:43


Lets get started with userforms
06:45

Transfer data from my userform into my sheets
06:17

get all filenames of a folder and save them in excel
05:30

A table of contents for my workbook with vba - awesome!
06:45

A macro recorder? Thanks microsoft
02:50


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
02:10
+
Teaser videos from my excel vba course
2 Lectures 10:27
find and select data in word with vba
04:49

Create Textfiles and write into them with vba
05:38
About the Instructor
Daniel We
4.5 Average rating
89 Reviews
4,226 Students
10 Courses
Traveller

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"