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 firstname.lastname@example.org
- Image Changes Size After Preview
- Calculated Field vs Calculated Item
- Worst Error Message Ever?
- More Excel Tips
- Video: Edit a Recorded Macro
- Weekly Photo: Flock of Birds
- Excel Tools
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:
- Jon Peltier shows how to make a specific chart label a different colour, using formulas, instead of programming.
- Mynda Treacy explains how to plot missing dates in a pivot chart
- 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.
- If you're a little rusty in statistics, Mike Alexander gives a clear explanation of standard deviation, and the options for calculating it in Excel
- 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.
- Contextures Excel Tools Add-in
- 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 some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.