Format pivot table numbers + more Excel tips
Excel Weekly News from Contextures September 23, 2014
In this week's Excel news, you'll see how to format pivot table numbers based on the source data formatting, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.
- Debra - firstname.lastname@example.org
- Combo Box Problem in Excel 2013
- Copy Pivot Table Source Number Formatting
- More Excel Tips
- Excel Announcements
- Video: Compare Cells with EXACT Function
- Weekly Photo: Fall Pumpkins
- Excel Tools
Worksheet Combo Box Problem in Excel 2013
Some of my sample files use a combo box that appears when you click on a cell that has a drop down list. There is code that changes the combo box, so it shows the correct list for each cell. There is a problem with this, in Excel 2013, if you use a list that is directly based on a formatted Excel table.
Click here to see the details: Worksheet Combo Box Problem in Excel 2013
Copy Pivot Table Source Number Formatting
When you add number fields to a pivot table, they usually appear in the General format. I've created a macro that will format all the number fields, based on the formatting that you have used in the source data.
Click here to see the details, and download the sample file: Copy Pivot Table Source Number Formatting
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Chandoo shows how to use the TEXT function in a SUMPRODUCT formula, to get a total for July sales.
- Excel has several functions to round numbers, and Ken Puls shows how to do the same things in Power Query.
- If you have to cook for a crowd, use the Excel Jambalaya Calculator by Jay Crush to sort out the recipe quantities.
- If your chart titles are overlapping the chart labels, watch Jon Acampora's video to see how to fix the problem.
- Bill Meade uses crib sheets to help remember all the Excel tricks that he's learned.
- Jeff Weir digs into the Formula Auditing tools, and has suggestions for some improvements.
- See how to create a simple User Defined Function in Excel, by watching Sara Silverstein's short video.
- 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:
- New Book: Financial Modeling for Business Owners and Entrepreneurs, by Tom Y. Sawyer. "You'll learn to create operational and financial models in Excel that describe the workings of your company in quantitative terms."
2-Day Course (Dutch): Excel VBA for Financials, 2-day course (in Dutch), led by Excel experts, Jan Karel Pieterse and Tony de Jonker. This course is specifically aimed at the Finance professional. It has no frills, and no technical mumbo-jumbo – just the VBA you need to achieve more success in your daily job.
Date: November 19 and December 3, 2014. Location: Utrecht (Netherlands)
Video: Compare Cells with EXACT Function
You can use the EXACT function to compare text and values in two cells, to see if they are exactly the same. Use it on the worksheet, or in a data validataion formula.
It's officially fall now, here in Canada, and I took this photo last week, at a historical park. I love the old brick house, and the bright fall colors in the flowers and pumpkins. I hope you're enjoying good weather too!
Recommended Excel Tools
In addition to all the free Excel tips and tutorials, there are other Excel tools that you can invest in. To learn more about the products listed below, click on the links to take a look at their features, and decide if they're right for you.
- Contextures Excel UserForm Course
- Contextures Excel Tools Add-in
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- FastExcel V3
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.