Search Contextures Sites
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 firstname.lastname@example.org
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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!
Contextures Inc., Copyright ©2014
All rights reserved.