The aim of this course is to show you 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 how the functions work and then give you some tips how to use them. Moreover the videos are approaching from a point of view that can be useful at your workplace, e.g. automatization in handling structures, giving solutions for report generations. 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.
Simply go through some basic date and time-related functions that will be useful for automation and reporting purposes (YEAR, MONTH, DAY, DAYS, TODAY).
Learn about using number coding for weeks, days, moreover, how to handle dates in excel (holidays included/excluded etc). Functions: WEEKDAY, WEEKNUM, WORKDAY (2).
Learn about basic Math functions in Excel (MIN, MAX, AVERAGE, MEDIAN).
Learn about advanced math functions for reporting and automation purposes (SUM, ROUND-functions, SUMPRODUCT, RAND).
Learn about logical functions e.g. IF, AND, OR, NOT.
This lecture will show you how to use some if-type functions for reporting purposes. Functions: ISBLANK, ISERR, ISERROR, plus an extra tip.
This lecture is about learning how to use functions, like SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS.
In this video the basic lookup functions are presented e.g. LOOKUP, HLOOKUP and the VLOOKUP.
This lecture shows how some advanced lookup functions work for automatizing processes. Functions: MATCH, INDEX, INDIRECT plus a hint.
This video is about some text manipulation essential functions, e.g. & and the CONCATENATE.
This video is about some advanced text manipulation functions like LEN, LEFT, RIGHT and MID.
This lecture shows how to make alphabet the easiest way in Excel.
In this lecture, the basic types of built-in charts are presented and some advices regarding their use.
In this lecture, I am going to show you what is the best way to change the data content of a graph, how can you modify its outlook, and how to handle changes in general.
This video shows how to create dynamic graphs in Excel and what kind of techniques exist to automatize plotting a chart.
This lecture gives you some basics on paste options i.e. paste values, formats etc.
In this lecture you can learn about some basic and semi-advanced paste options, what is useful during your work. Moreover some shortcuts are presented as well.
This lecture gives you the full insight into the variety of paste options Excel can offer. All the special paste options are being explained.
This lecture is about how to make hyperlinks within a document and outside of it, moreover shows how to link more excel files to each other and how to update it.
This lecture gives you detailed explanation on how to use conditional formatting, and what is the best way to use it in reports.
This lecture presents the Data Validation functionality of Excel, that helps you secure and control each of the cells' content.
In this video I am going to talk about the ControlX and the Form Control type buttons and will give you some insights about the aim of their use in general.
In this video, the Combo Box, Check Box, List Box and the Spin Button are presented with description and some guidance how to use them and what for.
This video shows you how to create a Table in Excel and what is it good for, moreover, some tips for interactivity is shown.
This video lecture gives you an insight on how to connect a randomly chosen button with a macro that you recorded. With this example I would like to give you an idea how to turn some basic long and monotone activity into a quick solution.
This lecture shows an example with the above described functions and gives an example how the functions can serve reporting purposes.
This video gives an example how some functions (SUMIF, INDIRECT, VLOOKUP etc) can be used with the aim of showing you a real life tip how you can create such structures.
This lecture shows an example how to use the advanced text manipulation function and give you a real life example for your further use.
This lecture gives you an example of how to refer to other datasets in other Excel files, while giving you some ideas, how to make reporting structures with having references to different files.
This lecture shows you a real-life example of how to use conditonal formatting for reporting purposes and in a more advanced way.
This lecture gives you an overview of how to use Data Validation built-in functionality and gives you a tip how to use it in real life.
This lecture shows you an example of how to use control boxes and buttons, and gives you an example of combining such built-in tools in Excel 2013.
This lecture presents you a more complex example of how to use list button in Excel and what kind of structures is it good for.
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.