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 commonly used combination of 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.
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.
This lecture shows the combination of 2 settings with its upsides on interactivity:
- data validation in a cell
- combining it with LOOKUP-type functions (in this example: VLOOKUP)
This lecture shows how to handle error messages in a dataset.
This lecture is about combining 2 important formulas showing you how to automatize the lookup formulas by nesting them:
- MATCH function and its use
- HLOOKUP and its use
This lecture is connected to the error message hiding lecture (lecture #5). Using IF and ISBLANK function can help you to filter out blank cells in a dataset.
Nesting IS and ISBLANK formulas, moreover use OR function could help you filter out even more errors in your dataset.
This lecture is about how to extend the single IF function in case you have not only 2 outcomes (true or false) but more option to choose from.
This video lecture is about the extension of a data structure/formula combination by simply using VLOOKUP function.
This lecture is about nesting INDEX and MATCH formula, which is similar to LOOKUP-types, however, more precise and stable. Check out the video for more.
For extracting figures from a database, the must is a unique identifier. This lecture shows you how to create such lookup value with combining LEFT and CAPITAL function.
This lecture is similar to the lecture #12, with extension of how to create more complex unique identifier with using text manipulation functions and CONCATENATE formula.
This lecture shows the nesting of text manipulation formulas (LEFT, CAPITAL) and IF function.
This lecture shows the nesting of text manipulation formulas (LEFT, CAPITAL) and VLOOKUP function.
This video lecture is about the combination of text manupulation functions, and how to handle text strings in Excel.
This lecture is showing a case study on how to combine time formulas (NOW, HOUR and MINUTE function). By using these formulas you can extract interactive and interesting data structures and graphical design.
The list box is a control panel from the developer settings of Excel, which enables you to control any formulas in an interactive way. Find out more in the tutorial.
This lecture is the extension of the previous, with an example of how to use list box control panel in combination of VLOOKUP, and how to make your structure more understandable and interactive.
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.