Today I’m going to cover one of the most important functions in Excel, and probably going to be one of your favorite functions as well. It is VLOOKUP.
What VLOOKUP allows you to do is that if you've got 2 tables and you got 1 common field in these 2 tables, you can pull data from one table into the other table. Meaning that you can look up this common field from table 1, find it in table 2 and return any other field from table 2.
Most of us are working with dates in Excel everyday, and knowing those useful functions will save you a lot of time and effort.
There are a lot of Date functions in Excel, but I will go through the most useful ones.
SUM, COUNT, AVERAGE and their IFs - the basic Excel functions you can't live without (including a video tutorial)
Today I’ll be talking about some of the most basic yet important functions in Excel.
You actually can’t start using Excel without learning these functions first. It’s like when you first go to school and learn how to add and subtract.
These functions are SUM, COUNT, AVERAGE, SUMIF, COUNTIF, AVERAGEIF.
In this example, I will show you how I used Excel to decide which car to buy.
Step 1: you need to identify a list of cars to choose from (based on price budget, features, etc...)
Step 2: you need to identify the criteria that matters when choosing a car. The criteria I put here are: Price, Options, Space, Safety, Service, Spares, Performance and Resale. Feel free to add/remove other criteria of your interest.
The easiest way to visualize a project plan to better track it is to use a "Gantt Chart"
Since there is no ready-made Gantt Chart in Excel 2016, I will show you how to do it step by step to get the same chart in the picture.
Step 1: Input all the project phases with a start date and end date for each phase.
Step 2: Add another column for the Duration where the values there are the difference between the end date and start date