Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Fix Numbers + more Excel tips

Excel Weekly News from Contextures November 11, 2014

In this week's Excel news, you'll see tips for fixing numbers that don't add up, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

Fix Numbers That Don't Add

If you copy data from a website, and paste it into Excel, the numbers might not add or sort correctly. The data might have hidden characters, such as non-breaking spaces. Here are a few quick ways to fix those numbers.

Click here to see the details: Fix Numbers That Don't Add

Scary Pivot Table Training Giveaway

Thank you to everyone who entered the giveaway for a chance to win an Xtreme Pivot Table Course ($199 value), thanks to John Michaloudis, from My Excel Online Training. The deadline was Sunday, Nov. 9th, and John is selecting 3 random winners for the training.

The winners will be announced on my Pivot Table Blog tomorrow, and will have 24 hours to respond, and claim their prize.

Click here tomorrow, to go to the blog, and see who won the contest: Pivot Table Blog

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • I'm sure you've heard that Microsoft Office apps, including Excel, are now free for the iPad. Jared Newman takes a look at what you get.
  • Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Pivot Table on Protected Sheet

Protect a worksheet and allow users to change some cells, and allow changes to the pivot table. There are some restrictions on the pivot table functions though, when the sheet is protected.

Fall Fruit

All the leaves have fallen off this little tree in our local park, but it is filled with bright red fruit. It might be a crabapple, but if you know for sure, please let me know.

Featured Excel Product

Chandoo is releasing his new Excel Dashboard Templates kit on Thursday, November 13th. I've had a peek at these ready-to-use templates, and they look great.

The dashboards just use formulas, so you don't have to worry about enabling macros, to see the results.

You'll have a dashboard up and running in just a few minutes -- replace the sample data with your own actuals and targets, click to customize the layout, and it's done!

Peltier Tech Chart Utility

See more recommended Excel products.


Note: I am an affiliate for some of 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.