Search Contextures Sites
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 firstname.lastname@example.org
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:
- In his blog, Chris Webb explains how to accumulate data in an Excel table using Data Explorer and PowerPivot.
- At the Get Digital Help blog, Oscar demonstrates how to use a map in an Excel chart. Then, select a city from a drop down list, and it is pinpointed on the map.
- For a peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- A retiree in Japan has spent the past 10 years creating stunning artwork in Excel. It's amazing to see what he has done.
- On his Option Explicit VBA blog, Jordan Goldmeier shared his sample workbook for creating Excel Fortune Cookies.
- Chandoo shows how to transpose data from a horizontal arrangement to vertical, by using formulas.
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.
- 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.
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.
Contextures Inc., Copyright ©2017
All rights reserved.