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…

Written by Debra Dalgleish from Contextures Blog Do you remember the number grids from your schools days, where you filled in the multiplication answers? What's 4 times 8? Or 9…

Pivot tables are powerful. Use these 6 tricks to save time when working with them. 1 - Double click to see details Ever wondered what numbers add up to the…

Hello folks. 50% of 2020 is behind us. Let me share a few updates with you all. First check out this awesome double rainbow outside our house on 30th June.…

Written by Debra Dalgleish from Contextures Blog There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product before. In…