Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Apr 30, 2013

Find and prevent Excel errors + more tips

Excel errors have been in the news lately, and it's made me think about catching my own errors. Our Toronto Blue Jays have been making plenty of mistakes lately too, and you can see a smarter kind of blue jay in my photo this week, at the end of the newsletter.

In this week's Excel news, you'll see how to find and prevent errors, add slicers to old Excel files, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Close All Files in Excel 2013

Excel 2013 files are in separate windows, and it can take a while to close them all, if you have several files open.

Use these tips to close all the files quickly in Excel 2013: Close All Files in Excel 2013

Catching Your Excel Errors

How do you prevent and find Excel errors? Excel was in the news recently, with big news stories about errors in an economic research paper.

We all make mistakes, but what's the best way to prevent them, and find the ones that get through? Setting up spreadsheet checks and controls is a good start, and there are tools to help you too. I've found a free tool that you can use.

Click here to read the details Catching Your Excel Errors

Problems Adding Slicers in Excel 2010

Slicers were introduced in Excel 2010, and they make it easy to filter one or more pivot tables with a single click. You can use slicers with older Excel files too, if you update them first.

Click here for the details, and see how to fix problems with adding slicers to old pivot tables: Problems Adding Slicers in Excel 2010

Video: Show a Popup Message When Cell is Selected

In some worksheets, a short message might help people who are entering data. The message can explain what to enter in the cell, and it only pops up when the cell is selected.

This video shows you a quick way to add a message to a cell. The tip uses the data validation feature, but you don't need to add any data validation rules -- just show the message.

For more on data validation messages, please visit my Contextures website. Show Data Validation Messages

Excel Dashboard Course - Discount Ending

As I mentioned last week, Mynda Treacy from My Online training Hub is opening her Excel Dashboard course, for a limited time.

Tomorrow is the deadline for the registration discount -- if you sign up by 8 pm Pacific time on May 1st, you can get the course for 20% off. Use the Discount code: DASH

The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there’s even an option to download the videos. The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues.

Click here to find out find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.

Remember, if you sign up by May 1st, you can get the dashboard course for 20% off. Use the Discount code: DASH

Are your skills up to date

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.

Blue Jay at the Conservation Area

Blue Jays are beautiful birds, but very noisy, so it's easier to find them, than some of the quieter birds. I saw this fellow at the local conservation area last week, chirping loudly from the top of a tree.

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.