Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Mar 26, 2013

Have you upgraded to Excel 2013 yet, or are you still using one of the older versions? Are there features that you wish they'd add to the next version of Excel? One of the links below takes you to a video, where you can see an exciting new feature that they're working on at Microsoft.

Also in this week's Excel news, you'll see how to limit dates to a specific range, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Limit Date Range with Excel Data Validation

With Excel's data validation feature, you can limit what is entered on the worksheet. In this example, you can limit dates to a specific range, based on the current date.

To see the details, and to download the sample file, click here: Limit Date Range with Excel Data Validation

Excel Average Based on Multiple Criteria

In Excel, you can use criteria when you're calculating a sum or a count, by using the SUMIFS and COUNTIFS formulas.

Did you know that there is an AVERAGEIFS function too, so you can calculate an average based on criteria?

To see the details, and to download the sample file, click here: Excel Average Based on Multiple Criteria

Stop Pivot Table Column Widths From Changing

By default, a pivot table's column widths will adjust automatically, when you update the pivot table.

If you have adjusted your pivot table column widths, and you want them to stay that way, you can change a setting in the pivot table options.

Click here, to read the details: Stop Pivot Table Column Widths From Changing

Ask Excel a Question?

Instead of typing a complex formula in Excel, wouldn't it be great if you could just type a question, and Excel could calculate the answer for you?

According to Stephen Chapman, owner of the MSFTKitchen blog, Microsoft is working on an Excel feature -- Analyze -- that answers your written questions. It even creates a chart based on a typed question!

You can see a demo of Analyze in a video on Stephen Chapman's MSFTKitchen blog -- Project Analyze Demo.

There's no hint as to when the Analyze feature might be available, but it certainly looks exciting!

Video: Quickly Copy and Rename an Excel Sheet

When you need to copy a worksheet, and rename the copy, there are a couple of tricks you can use, to do the job quickly.

For written instructions, and other worksheet tips, please go to this page on my Contextures website: Excel Worksheet Tips

Here is a short video that shows how it works.

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please 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 the products mentioned in this newsletter, and earn a commission on the sales.

 

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.