Search Contextures Sites
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 - firstname.lastname@example.org
- Fix Numbers That Don't Add
- Scary Pivot Table Course Giveaway
- More Excel Tips
- Excel Announcements
- Video: Pivot Table on Protected Sheet
- Weekly Photo: Fall Fruit
- Featured Excel Product
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
- Neale Blackwood shares his 4 guidelines for formula creation. Do you agree with all of them?
- Did you celebrate International Keyboard Shortcut day last week? Dick Kusleika shared several of his favourites, including shortcuts to open, close and save workbooks.
- On Chandoo's blog, Sohail Anwar explains how you can use multiple conditions in a VLOOKUP.
- Even if you're not a lawyer, you can keep track of your time, with this technique from Ben J. Kusmin.
- Sumit Bansal compares the benefits of VLOOKUP versus using INDEX/MATCH.
- 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.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
- Chris Webb is running a one-day Power Query course in London on Nov. 13, 2014.
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.
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.
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!
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.
Contextures Inc., Copyright ©2014
All rights reserved.