Search Contextures Sites

 

 

Contextures
Newsletter Index

 

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Aug 21, 2012

Print a numbered list of comments, add calculated items to a pivot table , and other tips, in this week's Excel news from Contextures.

Print a Numbered List of Excel Comments

On my Contextures website, there is code that lets you show a number at the top right of each comment cell. These little rectangles cover up the red triangle that marks the comment cells. This is a zoomed in view of the numbers.


There is also sample code creating a numbered list of comments on a separate sheet. I've recently updated that code, to address an issue with merged cells.


Click here to read the details, and download the sample file: Print a Numbered List of Excel Comments

Create an Excel Scenario Summary

Lasts week, you saw how to create an Excel Scenario.

This week, see how to turn those scenarios into a summary report -- choose either a summary report or summary pivot table.


Click here to read the article: Create a Scenario Summary

Create a Calculated Item in Excel Pivot Table

When you add fields to a pivot table, you can show or hide that field's pivot items. In addition to the existing items, you can create calculated items for a pivot field.

This article and video shows how to create a calculated item, and display it in the pivot table. You'll also hear the disadvantages to using calculated items.

Read the article here: Create a calculated item

Ribbon Editor Update

If you use Andy Pope's free Excel Ribbon Editor add-in -- RibbonX Visual Designer -- he has uploaded a new version.

The latest version of the designer (v2.22) will now allow access to the customUI14 section of Excel files when used in Excel 2010.


Using SUMIFS and SUMPRODUCT

In his Excel User blog, Charley Kyd explains the setup of SUMIFS and SUMPRODUCTS formulas. He includes examples of each function, and recommends which of the two to use.


Read Charley's article here: Using SUMIFS and SUMPRODUCT

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.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.