Pivot Table Shopping List + more Excel tips
Excel Weekly News from Contextures October 07, 2014
In this week's Excel news, you'll see how to create a shopping list with a pivot table, 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
- Add Your Own Icon to a Custom Ribbon Tab
- Excel Meal Planner With Pivot Table
- More Excel Tips
- Excel Announcements
- Video: Fix Numbers That Don't Add
- Weekly Photo: Macs For Sale
- Excel Tools
Mynda Treacy’s Excel Dashboard course is open for registration, until Oct. 23rd. Save 20% if you sign up by Oct. 16th.
I highly recommend this online course, which has excellent content, and great student support from Mynda. Her new Power Pivot course is available too, and you can get both courses in a bundle. I'm going through her Power Pivot course right now, and it's a great way to get started with this powerful Excel feature.
BONUS: If you sign up for the course through this link, you can have a copy of any one of my Contextures Products.
When you sign up, type DebraD in the Code box, and email me your receipt number.
Add Your Own Icon to a Custom Ribbon Tab
If you create a custom tab for the Excel Ribbon, you can use the built-in icons, or draw one of your own. Even if your artistic skills are limited (like mine!), you can make a simple shape in Paint, of use the drawing tools in Excel to design it. It's fun, once you get started.
Click here to see the details, and watch the video: Add Your Own Icon to a Custom Ribbon Tab
Excel Meal Planner With Pivot Table
We usually think of Excel as a business tool, but it can help around the house too. Unfortunately, it can't do the cooking, but there is a weekly meal planner on my Contextures website, that you can download. Enter the meal and product information, then pick your meals for the upcoming week, and click a button to create a weekly shopping list, in a pivot table.
Click here to see the details, and download the sample file: Excel Meal Planner With Pivot Table
More Excel Tips
Here are a few of the Excel articles that I read recently, that you might find useful:
- Alan Murray shows how to create a battery chart. It's based on a 3-D stacked cylinder, but he shows it without rotation.
- For a bit of fun, try creating formulas in the interactive Pizza Party Panic. You have to type in the cell references, but it's an interesting experiment..
- Ken Puls explains how to pull named ranges into Power Query, from the workbook.
- Brad Edgar uses options buttons and the CHOOSE function to control the display on a dashboard.
- 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: Practical Numerical Methods for Chemical Engineers: Using Excel with VBA by Richard A. Davis “over 100 VBA macros for extending Excel's power for engineering & scientific analysis. Engineers & scientists will find the enhanced coverage of computational tools applicable to a variety of problems in their own disciplines.”
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: Fix Numbers That Don't Add Correctly
Sometimes a column of numbers doesn't add up correctly on a worksheet. Instead of showing a total, the sum is zero. This usually occurs if you've imported the numbers from somewhere else, and Excel doesn't recognize the data as real numbers..
See the steps for fixing the numbers in this short video tutorial. The video shows an older version of Excel, but the trick still works nicely, in the newer versions. Just use the Copy and Paste Special commands on the Ribbon's Home tab.
Macs For Sale
When I started using Excel, long ago, my computer was a Macintosh. Eventually, I switched to Windows, but every fall I still enjoy buying some tart, crispy McIntosh apples. They were first developed in Eastern Ontario, where I grew up.
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 ©2016
All rights reserved.