training microsoft excel - subtotals
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - Subtotals

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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.

training microsoft excel - Subtotals

resolvedResolved · Low Priority · Version Standard

replyReply Wed 22 Aug 2007, 13:57Delegate Emily said...

Emily has attended:
Excel Intermediate course
Excel Advanced course

Subtotals

What is subtotal used for?

For upcoming training course dates see: Pricing & availability

replyReply Wed 22 Aug 2007, 14:40Trainer Amanda said...

RE: Subtotals

Hi Emily

Thank you for your question.

Subtotals are used to create some kind of summary figures (e.g. totals, averages) within a list of information, and provide a grand/overall summary figure for the whole list.

Amanda

 

Excel articles

· How To Disguise Error Messages In Excel 2007/2010
· How To Add Extra Data Ranges To An Excel Chart
· Tips From Excel's 'Rarely Used' File
· Importing Excel Data Into Access
· Customize Your Gridlines And Borders In Excel 2007

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy