Master MS Excel 2013 - Formulas and VBA programming

join me on the journey to excel in excel 2013 and beyond
4.7 (25 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.
1,856 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 57
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course Description

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.


What are the requirements?

  • MS Excel 2013 (other versions also possible!)
  • You can download the course workbook in the first section

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Every journey begins with setting the goal
01:52

Download the excel workbook to follow the course

Word of caution
01:27
Section 2: Lets get started - Master Formulas in Excel 2013
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 - PMT Function
Preview
01:44
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
Forget filters - use DSUM instead
Preview
02:48
03:42

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
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
open other programs with vba
Preview
02:23
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
Find Data with VBA
Preview
04:40
random vba code examples
2 pages
Section 4: The end of the journey? A few words from your instructor
What I want to tell you
02:10
Section 5: Teaser videos from my excel vba course
find and select data in word with vba
04:49
Create Textfiles and write into them with vba
05:38

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniel We, Traveller

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"

Ready to start learning?
Take This Course