Excel Weekly News from Contextures August 26, 2014
Fix Pivot Headings + more Excel tips
During the summer, I am sending you the newsletter twice each month, instead of weekly. You will get the next newsletter on September 9th. In this week's Excel news, you'll see how to remove "Sum of in pivot table headings, and other tips. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
Earlier this month, I updated my Data Validation Multi-Select Premium kit, so it's much easier to customize the code, and add it to your file. If you've purchased a copy of the kit, you should have received an email with a link to download the new version.
I've also created a page with answers to frequently asked questions about the product, and please let me know if you have any other questions.
To enter random numbers on an Excel worksheet, you can use the RANDBETWEEN function. Set a bottom and top number, and a random number from that range is returned.
In this example, CHOOSE and RANDBETWEEN work together in a formula, to return text -- a random region name (East, West or Central) in one column, and a random gender (Male or Female), in another column.
Click here to see the details, and watch the video: Create Random Text in Excel
For pivot table Value fields, "Sum of" or "Count of" is automatically added to the field name. You can shorten these default names, or change them to something more descriptive. Watch the short video, to see the steps, or follow the written instructions.
Click here to read the details, and watch the video: Remove Sum Of in Pivot Table Headings
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
In this video, see how to use the LEFT, RIGHT and MID functions, to pull the year, month and day from a string of numbers.
It's hard to believe that summer is almost over, and school starts next week. My garden is doing well, and there were lots of tomatoes ready to pick, so I put my little helpers to work. Those tomatoes taste extra delicious when someone else picks them!
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.