Contextures

Contextures News 20151110

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.

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.

=IF([@Date]>TODAY(),"", COUNT($C$4:$C4))

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.

Excel Articles

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!

weekly photo

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Last updated: November 27, 2019 2:26 PM