Anna has attended:
PowerPoint Introduction course
Excel Intermediate course
Word Intermediate course
Excel 2007
What do you find handy in subtotals?
RE: Excel 2007
Hi Anna
Thanks for posting this question, sorry its taken me a while to get back to you
the reason for using subtotals is so that you can find out one of many results from the sorted data
e.g. the sum, average, or count of the region column and have the result display in a different column. To find out the different function click on a cell that has the subtotal on then click the FX button on the formula bar
Then click help on this function at the bottom lefthand corner and read the information provided
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn