Monday, July 28, 2008

How To Do You Control Tech Deck



figures horizontally is easy.

1 - Load the data
2 - Click in the cell where the result will be (example: F2)
3 - Click on the symbol AutoSum
4 - ENTER
5 - Ready!

CLICK on image to enlarge.

Tuesday, June 17, 2008

Cp Right Before Menstruation

horizontal sum autofilter subtotal and customer spending

(Click image to enlarge)
This return to law firm costs amount to bill each client still loading the data in a disorderly manner.

formula = SUBTOTAL (9, A3: A494, D3: D22) that appears in the formula bar partial sum totals per customer.

In the title bar added a AutoFilter .

When choosing a client from the list, for example, "Camino del Sol" - EXCEL shows the total for that client.


AutoFilter tool to extract valuable information, for example, and in this case, the total spent between two dates or 3 more customers owe us.