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
- Fix Currency Separators
- Extra Items in Pivot Table Grouped Dates
- More Excel Tips
- Excel Announcements
- Video: Show Picture in Comment
- Weekly Photo: Christmas Countdown
- Featured Excel Product
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
- At Macworld, Lou Hattersley compares the iPad versions of Microsoft Excel and Apple Numbers. Which app do you think she recommends?
- Mu Lin offers 3 guidelines for designing data dashboards. The article focuses on news reports, but the tips can be applied to business dashboards too..
- Cells with drop down lists only show an arrow when selected, so Jon Acompora created a workaround, to always show an arrow.
- It's hockey season here in Canada, but Tanner Bell is thinking about baseball, and uses pivot tables to calculate projected standings for the fantasy baseball draft.
- In part 2 of his series on data analysis, Sumit Bansal explains how to set up a 2-variable data table.
- 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!
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.
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.
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.