How To Manage Daily Activities in Excel

We all do plenty of transactions daily or in other words buy or sell something.

It is always better to have track all the expenditures we did in excel but the point,how to calculate the values
excel provides plenty of good features like autosum etc

say for e.g we have recorded some of the things we bought in with price now we want to calculate the sum of it

we can do so as below
first list all the items with price as shown below

Now as we can see that in the second column we have the all values of all items and we want to calculate is sum to do that we can proceed as below

Click on the B8 Box and goto Fx line here right the values as shown 

Now press enter key the values from B2 to B7 column will be added to calculate the sum with formula and shown in Total line or column B8 as we wanted as shown

Now this will is very easy right  but I am going to show one more way to achieve the auto sum for all the item

Another way to achieve our SUM goal in excel sheet is the quick short cut way

Just click and choose all the cell we want to add and on extra where we want output as shown in the below figure

now we can see the cells highlighed with extra cell where we want sum of above cells and then click on the autosum next to Filter button and SUM is shown as below

Thus above the very easy ways of achieving the goal of adding values in excel for calculations

Hope you guys liked it.We will explore more later.