Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Apr 16, 2013

Did you get the ice storm in your area last week? Just when we thought that spring had finally arrived here in Canada, another blast of winter blew through. You can see my photo at the end of the newsletter.

In this week's Excel news, you'll see how to show multiple grand totals in a pivot table, highlight duplicate records, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Create an Excel Table from a List

Instead of a simple list, use a formatted Excel table for extra features. A table is a great data source for a pivot table, and has many benefits:

  • easy to set up
  • makes it easy to sort, filter, format, and expand your list.
  • refer to the table’s fields in your formulas, and the reference will adjust automatically, if you add or remove data.

To see the details, and a short video, click here: Create an Excel Table from a List

Highlight Duplicate Records in an Excel List

If you want to look for duplicate records in an Excel list, you can use conditional formatting to highlight them.

To see the details, and a short video, click here: Highlight Duplicate Records in an Excel List

Show Multiple Grand Totals in an Excel Pivot Table

Did you know that you can show multiple subtotals or grand totals in an Excel pivot table? For example, you can show Sum, Average and Max at the bottom of your pivot table, or in the subtotals.

Click here, to read the details, and to see the short video: Show Multiple Grand Totals in an Excel Pivot Table

Video: Turn Off Paste Options in Excel

When you copy and paste in Excel, you might see option boxes, at the bottom right of the pasted data. You can click those buttons, to select an option for pasting the data, such as Paste Values.

If you don't like those boxes, and never use them, watch this video to see the steps to turn this feature off.

Note: If you're using Excel 2010 or Excel 2013, click the File tab, instead of the Office button.

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.

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

Ice Storm Photo

Here's a picture of the neighbour's vines, coated with ice, after this week's ice storm. Everything looked sparkly and lovely, but it sure was treacherous to move around out there!

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.