Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Adding up rows or columns without seeing formulas

Highlight a column or row and click the Autosum button. This gives you your answer without showing the formula.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.