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…

Ever have data in a calendar format and just wished you can get it in to tabular format? Something like this: You can use Excel formulas or Power Query to…

Written by Debra Dalgleish from Contextures Blog One of the newest Excel functions is TEXTJOIN -- use it to combine several text items, quickly and easily. It's a big improvement…