One of the most common used and very useful function in MS Excel is Vlookup function.
Lets look at some small example
Here we have data with number of passengers carried by air transport in 2016 by a few countries in Europe.
MS Excel: Max If without If
When will start looking for advice how to make Max If formula in MS Excel, most of the time you will get this example:
{=MAX(IF(criteria_range=criteria, value_range))}
Where those curly brackets mean that this formula is an array formula. And while it is only one IF criteria, formula look fine. But lets add second criteria and we will get this formula:
Dynamic Pie Chart
Here we have a simple table with meals and nutrients of those meals in grams. Lets say we want show proportion of those nutrients using Pie Chart.
MS Excel Dynamic Drop Down List
Very good feature to have in MS Excel is a dynamic drop down list when it is possible to add additional options to drop down with less efforts. So how to do it.
First of all lets make a source which will feed our drop down list. I decided to have some fruits in my drop down list.
Progress Bar Chart
Here is one of the charts how to make date to look more interesting. With kind of chart we can show the progress of sales in different branches or any other progress between several competitors.
At the beginning let’s have simple table with 7 columns. In the first column should be names of the variables you want to compare. In the second column should target for every variable. In the third column are fulfillment to date. In the fourth column is progress. So basically in cell E4 is C4 divided by B4. In the fifth column is length of the progress bar (blue bar). As you can see it is one percent less than the progress as i chose to have slider 2 percents of the whole progress and it is fill by brown color. So that’s what it shows in the F. And finally in the column G is length of the whole progress bar.