Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Fix Currency + more Excel tips

Excel Weekly News from Contextures December 02, 2014

In this week's Excel news, you'll see how to fix currency values, 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 Currency Separators

If you receive a file that has currency in a format with different separators, you can use a built-in Excel tool to quickly fix the problem. For example, change from German format -- 987.654,32 -- to USA format -- 987,654.32.

Click here to see the details: Fix Currency Separators

Extra Items in Pivot Table Grouped Dates

When you group dates in a pivot table, Excel automatically adds two items in the list -- they start with a less than or greater than symbol, and show the first and last dates in your pivot table data You can see an example in the screen shot below.

Click here to get the details, and watch the video: Extra Items in Pivot Table Grouped Dates

More Excel Tips

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

  • To start the countdown to Christmas, Mynda Treacy created an Advent Calendar in Excel. You can download the file, if you'd like a bit of fun while you count the days until Christmas
  • 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. And vote for your favourite!

Excel Announcements

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

  • New Book: Business Analytics with Management Science Models and Methods, by Arben Asllani. "Master decision modeling and analytics through realistic examples, intuitive explanations, and tested Excel templates...emphasizes the application of practical management science techniques in business analytics."

Video: Show Picture in a Comment

Did you know that you can put a picture in a worksheet's popup comment, instead of text? You could add product pictures, or other graphics.

This short video shows you the steps, in Excel 2010. The steps are the same in Excel 2013, but the border will look different.

Christmas Countdown

One of our Christmas traditions is an advent calendar -- open a numbered door every day in December, and find a delicious chocolate. The only hard part is finding the correct door for the day -- I don't have to answer an Excel question to get the treat!

The candy company is named in honour of Laura Secord, who was a Canadian heroine during the War of 1812.

Featured Excel Product

If you're getting ready to prepare reports for your company's year end, the amazing Excel Chart Utility from Jon Peltier can help you save time and frustration. There are versions for both Windows and Macintosh, and you'll be able to create complex charts with just a few clicks, instead of struggling for hours.

The custom chart types in this utility include Box Plot, Waterfall, Marimekko, Cluster Stack, and several others. Choose between the Standard and Advanced versions -- you can compare the features in this list.


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.