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.
VLOOKUP (vertical lookup) is one of the most commonly used formulas in excel. Let's see how does it work...
HLOOKUP (Horizontal Lookup) is one of the most commonly used Excel formulas. It looks up a value based on a determined lookup figures.
Let's sum up how the SUM formula is working. It adds up the numbers or references.
Have you ever though about combining the IF and the SUM? well, i will show you how does it work...
Easiest way to calculate weighted average is the SUMPRODUCT function.
IF function is the basic and one of the most commonly used logical fundtion.
Combining IF and ERRORR wll save you from #errormessages in Excel. Let me give you an example on how does that work...
MATCH is a lookup-type of formula, but it is extremely important. I will show you how and what to use it for.
LEFT and RIGHT formulas are the basics of the text manipulation functions. This leture covers the story...
CONCATENATE function is for joining text strings or references. Crucial one, so let's start with the lecture.
Combination of COUNT and IF formula is a more advanced, but a useful one. This lecture gives an example how to use it.
Using '&' symbol gives you the same outcome as the CONCATENATE formula. Let me give you an example...
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.