Troubleshoot Reports + more Excel tips
Excel Weekly News from Contextures October 21, 2014
In this week's Excel news, you'll see how to troubleshoot with a report diagnostic display, 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
Mynda Treacy's Excel
Dashboard course is open for registration, until this Thursday,
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.
If you have several pivot table reports in a workbook, you can create a Diagnostics sheet, to make sure all the filters are set correctly, before you print the workbook. AlexJ shares his technique for setting up the monitoring sheet, to save you time and headaches.
Click here to see the details: Excel Report Diagnostic Display
If you change the source data for a pivot table, the new information doesn't automatically appear in the pivot table -- it has to be refreshed. You can manually refresh it, or change a setting, so some updates are automatic, or use programming to update automatically.
Click here to see the details: Automatically Refresh a Pivot Table
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:
If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. This video shows you the steps to create the pivot table and set up page fields. The result is not as flexible as a regular pivot table, but it does create a summary of all your data.
I found this old gadget recently, while cleaning out a drawer. I used it occasionally, long ago, and would need to find instructions before using it again. There is a Canadian quarter beside it (that's a caribou), to give you an idea of the size. It's two pieces of plastic, with a hinge. The wooden handled gadget goes with it. You can see the bottom layer in the close-up view.
Do you know what it is? Have you ever used one? I'll give you the answer next week.
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.
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.