The use of Excel nowadays is inevitable, especially at most of the white-collar-type workplaces. We are using it for many purposes, like calculating a company's performance i.e. sales data, production figures etc., creating reports for visualizing something or just to store huge dataset and use it as quick as possible. Excel is a very logical software and can be used without any specific knowledge. However, knowing even the fundamentals can imply huge time saving. Therefore being good at the program can make us much more efficient and can help in performing better. On the basis of my experience, having deep knowledge of excel capabilities and knowing the logic of the software result in outstanding efficiency improvement when it comes to solving reporting tasks or creating interactive charts. Therefore my aim in this course to give you the basic excel functions and giving some hints and ideas how do they work and what kind of tricks can be done in Excel 2013.
This lecture gives important guide how to customize and personalize your excel ribbons, moreover shows you how to modify the ribbon and its tabs & groups within.
This lecture goes through the ribbon and its content, meanwhile giving some basic guide where to look at.
This lecture shows what the statusbar contains and how to customize it.
We are going to learn the following basic lookup functions: VLOOKUP, HLOOKUP and MATCH
Learning how to make the following functions: YEAR, MONTH, DAY and TODAY.
Learn about the basic useful math functions: MIN, MAX, SUM
Learn about the following functions: AVERAGE, MEAN
We are going to learn about the IF function, and some examples and tips are presented.
Learn about the following functions: LEN, LEFT, RIGHT. Moreover some extra hints are presented.
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.
In this lecture we are going to see what the Hyperlink command in the ribbon does and what can it offer for support of reporting purposes.
This lecture shows how the Table command works and presents its advantages.
This lecture shows how to use grouping and un-grouping commands from the ribbon and how can it serve your riports.
This lecture presents how to freeze your dataset so that it will be easier to handle and search in the table.
This lecture gives you insight how to protect your file, the worksheet, and how can you allow people to modify certain part of your document.
Download the example dataset that is being used in the tutorials and learn how to use basic functions. Enjoy!
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.