Search Contextures Sites
What new Excel features do you want?
Nov 10, 2015
Excel improvements, hide formula results, create test data, and much more, in this week's Excel news.
- Debra - firstname.lastname@example.org
Hide Results Based on Date
If a list has dated items, you can hide formula results based on those dates. This month, I'm participating in Movember, so I created an activity tracking file in Excel, with running totals.
The formulas check the date, and only the totals from today or earlier are shown. Here is the formula for the running count, and there is a similar one for the running sum.
You can read more about it, and download the sample file here.
Sample Data for Testing
When you are testing new formulas or techniques in Excel, you might not want to use one of your actual files. One of the most popular downloads on my website each month is my Sample Data file, which has a table with fake sales data. If you want a simple test file to use, you can download it here.
Another way to create data for a quick test is to use the RANDBETWEEN function, with minimum and maximum values. Then, press the right mouse button while you move the data cells a little to the right, and back into place. In the popup menu, click Copy Here as Values Only.
Here are a couple of Excel articles I read recently, that you might find useful.
Lock Slicers -- Mike Alexander shows how you can lock Slicers in place on a worksheet, so people can't move or resize them. (Level - Basic)
And if you use pivot tables, my Pivot Power Premium add-in will save you hours!
Excel Improvements -- Are there new features that you'd like to see in Excel? Go to the UserVoice site, where you can add your ideas, and vote for others. The Excel Team at Microsoft monitors the site, and tries to respond to any item with 20 or more votes. (Level - Basic)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.
Days of Wind and Roses
We had beautiful weather for most of last week -- it felt like September. Then, things took a turn for the worse, and it got windy and much cooler. I saw this brave little rose hanging onto a fence, while the wind howled, and dark clouds gathered. It's time to bundle up!
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: http://www.contextures.com/newsletter/excelnews2015/20151110ctx.html
See more recommended Excel products.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2015
All rights reserved.