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…

Power Query (Get & Transform data in Excel) is a true game changer. It can simplify and automate various data activities. The key benefits of Power Query are, Connect to…

Written by Debra Dalgleish from Contextures Blog Instead of adding and removing pivot table values one at a time, click a Slicer, to quickly add and remove them, in groups.…

Written by Debra Dalgleish from Contextures Blog Old items might still appear in pivot table drop down lists, even after you remove the items from the source data. Here’s how…

Gantt charts are useful for visualizing a project’s timeline and activity flow. In this article, learn how to create an interactive project gantt chart with drill-down capability using Excel. Here…

Written by Debra Dalgleish from Contextures Blog Today's video shows how to set up a matching items list – select a region name, and the list shows all employees who…

Stream graph or stream plot is a variation of area chart that looks like a stream. Here is a quick demo of a stream chart. Learn how to create such a graph…