excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

Excel 2007

resolvedResolved · Low Priority · Version 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:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected cells.

View all Excel hints and tips


Server loaded in 0.1 secs.