Excel Weekly News from Contextures May 28, 2013

New AGGREGATE function + more Excel tips

If you're back at your desk after a long weekend, I hope you relaxed, and stayed away from the computer. Maybe you got out to the countryside, like the rustic location in my photo this week, at the end of the newsletter.

In this week's Excel news, you'll see how to total a filtered list with the new AGGREGATE function, change the report filter layout in a pivot table, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Total Filtered Data with AGGREGATE Function

If you're using Excel 2010 or Excel 2013, there is a new function -- AGGREGATE -- that is better than the old SUBTOTAL function.

It has 19 built-in functions, including MEDIAN, LARGE and SMALL, compared to the 11 functions in SUBTOTAL.

Also, it has options for what to ignore in the data, so you can ignore errors, as well as hidden data.

Click here to see the details and to watch the short video: Sum a Filtered List with AGGREGATE Function

Change the Report Filter Layout

Instead of showing the pivot table report filters in a single column, you can change a setting, to show the filters in multiple columns.

Click here to see the details, and to watch the video: Create a Simple Calculated Field

Did Excel Help Your Career?

Last week, someone emailed me with a lovely story about how Excel, and pivot tables, had made a tremendous difference in a young woman's career.

With their permission, I shared that story on my Contextures blog, and readers have added their own stories in the comments. I hope that the stories will inspire you too!

Click here to read the story: Did Excel Help Your Career?

More Excel Tips

Here are a few more Excel articles that I read this week, that you might find useful:

Video: Change Column Headings to Letters

When you open an Excel file, you might see numbers -- 1, 2, 3 -- across the column headings, instead of letters -- A, B, C. To see why this happens, and how to switch the column headings back to letters, please watch this short video tutorial.

If you'd like the written instructions, please visit my Contextures blog: Excel Column Headings Show Numbers

Needs a Few Repairs

Even though I live in a big city, there is farmland only a few minutes away. On one of our recent drives, we passed this run down barn and shed. The barn could use a coat of paint, and a few repairs, but it does give a rustic look to this farm property.


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.