Search Contextures Sites
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 firstname.lastname@example.org
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
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.