Search Contextures Sites
Hide Subtotals + more Excel tips
Excel Weekly News from Contextures February 17, 2015
In this week's Excel news, you'll see how to quickly hide pivot table subtotals, 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
- Hide Pivot Table Subtotals
- More Excel Tips
- Excel Announcements
- Video: Connect Slicers to Multiple Pivot Tables
- Weekly Photo: Way Back When
- Featured Excel Product
If you add more than one field to a pivot table's Row Labels area, you'll probably see subtotals on some of those fields. If you don't need them, you can quickly hide the subtotals, by using a command on the Excel Ribbon. Or, if you need to hide subtotals in several pivot tables, you can use a macro to do the job for you.
See the details in my blog post, and watch the short video: Hide Pivot Table Subtotals
Here are a few of the Excel articles that I read recently, that you might find useful:
- Here's another reason to start using Power Query. Gašper Kamenšek shows how to get all the data from a folder.
- Jan Karel Pieterse has updated his comprehensive article on working with circular references in Excel.
- In case you missed any of the new features in Office 365, you can check this list of what was added in January 2015.
- If you don't mind clicking though the items one at a time, ComputerWorld UK has 10 free apps to boost your Excel and Word 2013 productivity.
- The Investintech blog shares 9 simple tips for working with Excel data. Of all those tips, I probably use #4 most often. How about you?
- Jordan Goldmeier is presenting at this year's PASS Business Analytics conference, and has released an hour-long preview webinar for his session – Creating Outstanding Spreadsheet Models.
- In a short video, Bill Jelen (Mr. Excel) and Mike Girvin (ExcelIsFun) show two different ways to insert an apostrophe at the start of each number in long column of numbers. Starting at the 1:00 mark, Bill shows how an apostrophe, and other characters, affected cell entries in old versions of Lotus 1-2-3.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
- Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration is now open, for this year's event.
Slicers are a great way to filter a pivot table, and in this video you can see how to filter more than one pivot table, with a single slicer. This is a great way to show results on a dashboard, using GETPIVOTDATA to pull numbers from filtered pivot tables.
Click here to watch the short video that show how it works: Connect Slicers to Multiple Pivot Tables
It was my mother's birthday last week, so I looked for an old picture of us together, to share with her. It looks like we're on a picnic outing in this photo, but in fancier clothes than we would wear for today's picnics. And yes, my cheeks are a little thinner now!
Chandoo has just opened a new online course -- 50 Ways to Analyze Your Excel Data. Registration closes on Friday, Feb. 20th, and classes begin on Monday, Feb. 23rd.
Don't sign up for this if you are a beginner though -- the course is designed for intermediate to advanced Excel users only.
There are 50 online video lessons, grouped into the following categories:
- General Analysis Techniques (25)
- Marketing & Operations Analysis Techniques (11)
- Financial Analysis Techniques (8)
- Case Studies (6)
When the course opens on Feb. 23rd., 35 of the lessons will be available, and you can go through them in an order -- you don't have to follow a specific lesson plan. By March 8th, the remaining 15 lessons will also be available, and by the end of March, additional bonus material will be published.
Remember, the registration for 50 Ways to Analyze Your Excel Data closes on Friday, Feb. 20th, so sign up now, if you are interested.
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 ©2015
All rights reserved.