Top 10 basic & advanced Excel functions you must know!
4.6 (10 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.
849 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Top 10 basic & advanced Excel functions you must know! to your Wishlist.

Add to Wishlist

Top 10 basic & advanced Excel functions you must know!

Comprehensive training for the top 10 most important Excel functions and furmulas
4.6 (10 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.
849 students enrolled
Created by Adam Holczer
Last updated 10/2016
English
Current price: $10 Original price: $35 Discount: 71% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • use the most important Excel formulas
  • use Excel more efficiently
  • be more productive at work
View Curriculum
Requirements
  • You need a computer with possibly Microsoft Excel 2013 and you are free to go.
Description

We are living in a running and crazy world, where everybody wants to grasp the most information with the least time spending on it. This is true for all of us, especially the ones would like to study and know more. 

The aim of this course is to show you the most common basic and advanced functions, their use, and some real-life example how to use it in your daily work/life. 

When I started learning Excel, I realized that it is very important to know Excel functions, but knowing them is not enough. You have to build it into your daily work and start thinking the way Excel "thinks". With this course I will focus on some real-life examples I had to face during my work and try to shed light on what Excel is capable of. The structure of the course includes some basics as well, so that if you do not have a strong basis, it still gives you guidance and a firm fund to continues and handle more complex problems.

My aim is to show you the most important and most commonly used Excel functions to help you in your daily work to be more efficient. If you would like to save some time and spend less on sitting in front of a computer and handling data in Excel, then I recommend this course for you.

Have fun with the course and let me know if you have any question.

Adam

Who is the target audience?
  • Everybody who wants to learn Excel basic & more complex formulas
  • Everybody who wants to know how the top 10 most important functions work
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
01:10:18
+
TOP 10 Excel function
10 Lectures 51:51

VLOOKUP (vertical lookup) is one of the most commonly used formulas in excel. Let's see how does it work...

Preview 07:49

HLOOKUP (Horizontal Lookup) is one of the most commonly used Excel formulas. It looks up a value based on a determined lookup figures.

HLOOKUP
05:34

Let's sum up how the SUM formula is working. It adds up the numbers or references.

SUM
02:48

Have you ever though about combining the IF and the SUM? well, i will show you how does it work...

SUMIF
05:11

Easiest way to calculate weighted average is the SUMPRODUCT function.

SUMPRODUCT
05:00

IF function is the basic and one of the most commonly used logical fundtion.

IF
06:28

Combining IF and ERRORR wll save you from #errormessages in Excel. Let me give you an example on how does that work...

IFERROR
05:30

MATCH is a lookup-type of formula, but it is extremely important. I will show you how and what to use it for.

MATCH
04:32

LEFT and RIGHT formulas are the basics of the text manipulation functions. This leture covers the story...

LEFT/RIGHT
04:40

CONCATENATE function is for joining text strings or references. Crucial one, so let's start with the lecture.

CONCATENATE
04:19
+
Bonus
2 Lectures 06:59

Combination of COUNT and IF formula is a more advanced, but a useful one. This lecture gives an example how to use it.

COUNTIF
04:53

Using '&' symbol gives you the same outcome as the CONCATENATE formula. Let me give you an example...

'&' symbol
02:06
+
Conclusion
2 Lectures 03:21
Outro
03:21

Dataset
00:00
About the Instructor
Adam Holczer
4.5 Average rating
29 Reviews
2,276 Students
6 Courses
Senior Optimization Analyst

I'm Adam, working for an oil company in sales optimization, aiming the potential sales volumes and allocation throughout the company's market. I have a strong interest in the Oil Industry, therefore I always wanted to work in the industry. after finishing Business Administration (BSc) I studied International Economics and Business in Budapest and in the Netherlands. My interest drove me back to University to study Optimization in Oil Industry in the framework of a post-graduate course. Now I am working for the biggest Oil & Gas Corporation in Central Eastern Europe as an optimization expert, supporting decision-making and analyzing the regional markets.