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
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
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
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.
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!
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.
Contextures Inc., Copyright ©2017
All rights reserved.