Exel

The UK's most regular instructor-led training courses.
Training information: excel-courses · Excel-courses-london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyFri 3 Jul 2009, 16:13Delegate Julie said...

Julie has attended:
Excel Intermediate course

Exel

how to do subtotals with filters

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Wed 10 Mar 2010	Bloomsbury	0	FULL
2003	Wed 10 Mar 2010	Limehouse	7		£212	£217
2003	Fri 12 Mar 2010	Southwark	6		£224	£229
2003	Wed 17 Mar 2010	Bloomsbury	3		£235	£240
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	4		£224	£225
Full Schedule: See all 74 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyTue 7 Jul 2009, 09:35Trainer Amanda said...

RE: exel

Hello Julie

Thank you for your question and welcome to the forum.

The SUBTOTAL function can be used to create totals, averages etc with filtered data.

To use the function, enter it in when the data is unfiltered; then when you apply a filter you'll find that the result changes.

Use the Insert Function button (fx next to the formula bar) to insert the function SUBTOTAL, using the Help with this function link to see how it works.

Kind regards
Amanda

Mon 13 Jul 2009: Automatically marked as resolved.

· Microsoft Excel Training: Essential for Today's Employees
· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Improve Performance Of Your Excel Macros
· Tap the Power of Recorded Macros with MS Excel Courses

Please browse our web site to find out more about
excel-courses and other Microsoft training courses.

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips