Search Contextures Sites
Custom Search

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures May 21, 2013

Delete shapes, use Slicers + more Excel tips

This is the first day back to work after a long weekend here in Canada, to celebrate Victoria Day. I didn't get pictures of any of the fireworks, but there's a brightly coloured bird in my photo this week, at the end of the newsletter.

In this week's Excel news, you'll see how to create a simple calculated field in a pivot table, quickly delete objects on a worksheet, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Quickly Clear Objects from Worksheet

If you copy data from a website, and paste it into Excel, you might get some pictures and small shapes, along with the text. It can be hard to find those objects on a large worksheet, and get rid of them.

In this article, you'll see how to find the objects, and quickly delete them.

Click here to see the details and to watch the short video: Quickly Clear Objects from Worksheet

Create a Simple Calculated Field in a Pivot Table

In addition to the fields from a pivot table's source data, you can create other fields, by using formulas. In this tutorial, you'll see how to create a simple calculated field, which shows each salesperson's bonus payment.

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

Use Slicers to Filter a Table in Excel 2010

Slicers were introduced in Excel 2010, and they're a great way to filter a pivot table. Slicers were improved in Excel 2013, where you can also use them to filter an Excel table.

That feature isn't available in Excel 2010, but fortunately AlexJ has developed a workaround, and shared his solution with us.

Click here to see the details, and download the sample file: Use Slicers to Filter a Table in Excel 2010

More Excel Tips

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

Video: Turn Off the GetPivotData Feature

If you try to link to a cell in a pivot table, you might see a GETPIVOTDATA formula, instead of a normal cell reference. You can turn this feature off, by using a command on the Excel Ribbon.

Watch this short video to see the steps.

For more information on GETPIVOTDATA, please visit my Contextures website: GetPivotData Formula

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.

Bright Red Cardinal

On one of our forest walks last week, I spotted this bright red cardinal, perched in a tree. Usually it's hard to find them, but this guy was out in plain view. I guess he was enjoying the sunny day too.

__

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.