Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Nov 26, 2013

Improve a pie chart + more Excel tips

In this week's Excel news, you'll see how to build a better pie chart, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

How to Make a Pie Chart in Excel

A pie chart is not the best way to present data in Excel, but sometimes you need to build one. When you do, make sure that it is not too crowded, and the information is easy to understand.

Click here to see the details, and watch the video: How to Make a Pie Chart in Excel

How to Show Missing Items in Pivot Table

In a pivot table report, if a customer has not bought a specific product, that item won't appear under the customer's name. However, you can make every product appear for every customer, by changing a pivot table setting.

For new products, that no customer has purchased, a temporary record can be added to the source data.

Click here to see the details, and watch the video: How to Show Missing Items in Pivot Table

Use MAX and IF With Multiple Criteria

Last week, we used the MAX and IF functions to find the latest date that a product’s price was changed. This week, we're adding the customer name to the criteria, then we'll find the latest price for the product and customer.

Click here to see the details, and download the sample file: Use MAX and IF With Multiple Criteria

More Excel Tips

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

  1. It doesn’t have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
  2. Instead of using macros, add a hyperlink to a shape, for workbook navigation. Mynda Treacy shows the steps.
  3. If you need to calculate the last day of any month, you can use Chandoo’s simple formula.
  4. Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

Video: Create Multiple Pivot Table Subtotals

Subtotals are automatically added in a pivot table, and you can add more, with a couple of simple steps. This short video shows the steps, and you can read more about subtotals on my website.

Stained Glass Leaves

It was cold and damp this week, so we did an indoor art project one day, after gathering a few leaves in the nearby park. The leaves, and a few broken crayon bits, were placed on wax paper, with another sheet on top. A warm iron stuck everything together, and we hung the "stained glass" in the window, where it looked very pretty.

___________________________

Recommended Excel Tools

In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, 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 some of the products mentioned in this newsletter, and earn a commission on the sales.

________________________

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.