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 - firstname.lastname@example.org
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
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
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:
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.
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.
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.
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 ©2018
All rights reserved.