Search Contextures Sites

 

Contextures
Newsletter Index

 

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures June 11, 2012

Compare sales in pivot tables, automatically fit merged row height, understand Excel sorting, and other tips, in this week's Excel news from Contextures.

 -  Debra ddalgleish@contextures.com
 

Compare Top and Bottom Sales in Pivot Table

If you're working on a sales plan, you might want to compare your company's best and worst product sales. Which products give the best return on your marketing efforts? How many bottom products to equal sales of top products?
 
An easy way to make these comparisons is to use Excel Pivot Tables. Click here to read the article: Compare Top and bottom Sales with Pivot Tables

Autofit the row height for Excel merged cells

Last week I was working on a client's Excel file, and we needed to use merged cells. Even though single cells with wrap text automatically adjust when more text is added, merged cells don't.
 
My client's Excel sheets need to be printed, and all the text in those merged cells has to show in the cell. With a bit of programming, I solved the problem.
 
See how to autofit the row height for Excel merged cells: Autofit the row height for Excel merged cells

Sorting and Comparing the Excel Way: Code Pages and Collating Sequences

Excel sorting seems like a simple task, but Excel MVP Charles Williams explains the intricacies of the task.

Click here to read the article: Sorting and Comparing the Excel Way

Program Excel with IronSpread Plug-in

IronSpread is an Excel 2010 plugin for Windows that lets you script your spreadsheets with Python. I'm not familiar with Python programming, but there is documentation on the IronSpread site, and a quick start guide.

A short video on the site also shows you how the plug-in works. Click here to visit the IronSpread website
 

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.

__

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.