Contextures Blog Excel Tips and Tutorials

Excel Roundup 0

Excel Roundup 20171214

Here is an end-of-the-year Excel Roundup, with articles that I’ve read recently. To get weekly links and articles, sign up for my weekly Excel newsletter. Merry Christmas, and happy holidays, and come back for...

Beyond the Rules for Excel Names 2

What Are the Rules for Excel Names?

As Juliet famously said to Romeo, “What’s in a name?” And she was talking about rows (misspelled as “rose”), so maybe Juliet was using a spreadsheet at the time. There are special rules for...

Excel Holiday Planner 2

Excel Holiday Planner Workbook

Long ago, I created a Christmas planner in Excel, and it has evolved over the years. Well, tomorrow is the first of December, so you’ve probably finished your planning for this year. But, if...

Do You Still Need Excel Subtotals? 3

Do You Still Need Excel Subtotals?

Excel has a SUBTOTAL function, which ignores hidden or filtered rows. There is a Subtotal feature too, that quickly groups your data, and adds one or more rows of subtotals. Do we still need...

Create a Tartan Pattern in Excel 3

Create a Tartan Pattern in Excel

Suddenly, it’s November, and it’s time to plan what you’ll wear on St. Andrew’s Day (November 30th). He is the patron saint of Scotland (and other countries), so of course you’ll need a kilt,...

Quick Trick to Add or Move Pivot Table Fields 0

Quick Trick to Add or Move Pivot Table Fields

We’re still recovering from Tuesday’s Spreadsheet Day celebrations, so we’ll keep it simple today. Here’s a quick trick to add or move pivot table fields, just by typing. Watch the really short video, and...

Happy Spreadsheet Day 2017 0

Happy Spreadsheet Day 2017

Happy Spreadsheet Day 2017! You’ve been waiting all year for this special day to arrive, I’m sure, so what will you do to celebrate today?

Multiple Copies of Pivot Table 1

Multiple Copies of Pivot Table Sheet

If you need to make a quick report, Excel has a built-in command that makes multiple copies of pivot table – one for each item in a Report Filter. See how that feature works,...