Excel New Features
November 10, 2015
Request new Excel features, hide formula results, create test data, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
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.
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.
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!
That's it for this week! If you have any comments or questions, send me an email.
Last updated: November 27, 2019 2:26 PM