Written by Debra Dalgleish from Contextures Blog In Excel for Office 365, there are threaded comments, where you can have discussions with your co-workers. Or, reply to your own threaded…

I learned about a new HR technique for talent mapping during a recent consulting project . It is called 9 box grid. In this page, let me explain what it is…

Written by Debra Dalgleish from Contextures Blog In all versions of Excel, you can use a simple formula, with the & operator, to combine values from different cells. If you…

Written by Debra Dalgleish from Contextures Blog Spill functions can fill neighbouring cells with their results, to create dynamic ranges. Thank you to Dermot Balson, who sent me his Excel…

Written by Debra Dalgleish from Contextures Blog Happy Spreadsheet Day 2020! We’re celebrating on a Saturday this year, so you have the whole day to relax, and play with spreadsheets.…

Written by Debra Dalgleish from Contextures Blog This coming Saturday, October 17th is Spreadsheet Day. I’m sure you’ve got a full day of celebrations planned, starting with waffles at breakfast,…

Line charts are essential for trend analysis, comparison over time, spotting distribution or volatility in your data. In this page, let me introduce 6 powerful line chart variations to help you…

Written by Debra Dalgleish from Contextures Blog Lately, I’ve noticed that some things in Excel look strange, when I have them on my second monitor. For example, an Excel UserForm…

Here is a super easy and fun way to create two-level data validation list within Excel. Something like this? In this article, learn how to easily create such two or…

Written by Debra Dalgleish from Contextures Blog There's an Excel Order Form tutorial on my Contextures site, with written steps and a video that show how to set it up…