Excel Subtotal Problems
November 03, 2015
Subtotal problems, formatting tips, holiday planner, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
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!
That's it for this week! If you have any comments or questions, send me an email.
Last updated: November 27, 2019 2:36 PM