Your Excel Tips - Subtotal Problems
Nov 3, 2015
Subtotal problems, formatting tips, holiday planner and much more, in this week's Excel news.
- Debra - firstname.lastname@example.org
If you use the Subtotal feature in Excel, and add two or more layers of subtotals, you might end up with duplicate grand totals. While working on a project recently, I figured out that errors in some columns were causing those duplicate totals.
You can download my sample file, and watch the video that shows how to set up the subtotals, and prevent duplicates.
Somehow, it suddenly turned into November, and if you like to plan ahead, you're already thinking about the holidays. To help you stay organized, I've updated my Holiday Planner Template, and you can download the new version.
Even if you're not planning for the holidays, you'll get some Excel ideas from the template, such as creating a Gantt chart from an hourly schedule, linking sub-budget sheets into a main sheet, and showing which store has the greatest number of low cost items.
Here are a couple of Excel articles I read recently, that you might find useful.
Build a Dashboard -- Ben Collins gives detailed instructions for a dynamic, interactive dashboard that he built in Excel. There are links to the source data, so you can follow along, and build your own dashboard. (Level - Intermediate)
Formatting Tips -- Another chapter from Curtis Frye's new book, "Microsoft Excel 2016 Step by Step" is available for free download. This chapter covers formatting, and you might find some new tips, such as how to change the default font for a workbook. (Level - Basic/Intermediate)
More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.
It was cool and very windy last week, and most of the leaves are now on the ground. (At least there's no snow yet!) However, I noticed these little guys poking through a fence, while we were out for a morning walk. I hope they hang on a bit longer, and winter stays away!
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser: http://www.contextures.com/newsletter/excelnews2015/20151103ctx.html
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.