Contextures

Contextures News 20151103

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.

Subtotal Problems

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.

Holiday Planner

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.

Excel Articles

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.

Fall Color

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!

weekly photo

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd@ contextures.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

 

Last updated: November 27, 2019 2:36 PM