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 (£)		List price
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2003	Mon 13 Sep 2010	Southwark	5		£240	£245	£245
2007	Thu 16 Sep 2010	Bloomsbury	0	FULL			£245
2003	Fri 24 Sep 2010	Bloomsbury	8		£229	£234	£245
2007	Fri 24 Sep 2010	Limehouse (Docklands)	1		£240	£245	£245
2007	Wed 29 Sep 2010	Southwark	2		£240	£245	£245
2010	Tue 5 Oct 2010	Bloomsbury	9		£275	£280	£299
Full Schedule: See all 118 Excel Advanced course dates. Bookings currently available until 28th September 2011.

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 Features and Functions for Accountants
· The Pursuit of Excellence
· How Sharing Your Excel Data Can Help Your Business Flourish
· Radio Buttons And Check Boxes In Excel
· What's mine is yours: Sharing data in Excel

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

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms and Conditions

Exel

Exel

RE: exel

Related articles

Excel tip:

Fill formulae across a sheet