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
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:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
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 ©2017
All rights reserved.