Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

Excel Weekly News from Contextures Apr 01, 2014

Pivot table formulas + more Excel tips

In this week's Excel news, you'll see two types of pivot table formulas, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Image Changes Size After Preview

Recently, I had a problem with worksheet images changing size, after I used the Print Preview window. One logo started as a small square in the corner, and expanded to fill most of the worksheet!

I hope you never run into this oddity, but you can click here to see what I did to fix the problem: Excel Images Change Size After Preview

Calculated Field vs Calculated Item

After you create a pivot table, you can enhance the results by writing your own formulas, to create calculated fields and calculated items. What's the difference between those formulas? When should you use a calculated field and when should you create a calculated item?

Click here to see how to set this up: Calculated Field vs Calculated Item

Worst Error Message Ever?

I've seen some confusing error messages in Excel, but this one was definitely the least helpful one that I've ever encountered. It's hard to see, in the screen shot below, but there weren't any words, just the yellow triangle. Have you ever seen anything like this?

Click here to see the details: Least Informative Excel Message Ever

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • Chandoo challenged us to solve an Excel problem, and find the products with the maximum change in monthly sales. There were 170 comments, with a wide variety of solutions.
  • 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: Edit a Recorded Macro

It's easy to record a macro while you do something in Excel, such as formatting a pivot table. To make the code more flexible, make a few changes, to remove the specific references.. In this video you'll see the steps for recording a pivot table formatting macro, and then editing the recorded macro.

Flock of Birds

Last week, while we were driving home, a huge flock of birds swarmed from the field beside the highway. Fortunately, I was holding the camera, and managed to snap a couple of pictures. I was glad that the sun roof and windows were closed!

__________________________

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.