Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Advanced filter

microsoft excel training day courses near kent - Advanced filter

ResolvedVersion Standard

Thu 6 Dec 2007, 17:03 Delegate Maurice said...

Maurice has attended:
Excel Intermediate course

Advanced filter

How do you advance filter

Thu 13 Dec 2007, 16:45 Trainer Amanda said...

RE: Advanced filter

Hi Maurice

Thank you for your question, and apologies for the delay in replying.

To create an advanced filter, you need to have criteria set up so that Excel knows what to show in the filter results.

The criteria consists of the heading of the column you are getting Excel to look in; and what value you want it to find in that column. You can have multiple headings and values as part of your criteria.

For a simple and illustrated example of how to set up an advanced filter please see http://www.contextures.com/xladvfilter01.html

I hope this helps.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

microsoft excel training day courses near kent - Advanced filter

Advanced filter

RE: Advanced filter

Excel articles

Excel tip:

Sum Up All the Values in A Column