Microsoft Excel Template as productivity tool

Last week we have a meeting, a planning meeting. A lot of thing to plan. When we do planning we usually do planning for 5 years ahead.

It takes two meetings, actually one meeting last week and two days planning workshop this week for the planning purpose.

Planning can be very time consuming.

Yesterday, i opened microsoft excel. Put all the data and began automating the process.

Guess what?

We can actually save a lot of time, just by using COUNTIF and simple mathematics in microsoft excel. Today me and some few friends, decided to make a working template by improving the excel file so that other people in our workplace can use it for planning.

Creating a .CSV File using Microsoft Excel

SUM OF 3 , 4, 5 or N largest value in a range

Yesterday i need to find the SUM of 3 largest value in a range using EXCEL. 

This is how to find the SUM of 3 largest value from 7 value in a range of 7 number. 

= SUM(LARGE (A1:A7, {1,2,3})) 

SUM is used for summation 

LARGE is used to find largest number 

Let say with this number from A1:A7 

1,2,3,4,5,6,7 

using  = LARGE (A1:A7, {1,2,3}) alone will result 

 7 (current cell ) 6 (next cell) 5(next 2 cell)  

Using  = SUM(LARGE (A1:A7, {1,2,3}))  will result in 7+6+5 = 18 in current cell