Excel Dynamic Array Functions are a true game changer. These newly introduced DA functions can filter, sort, remove duplicates and do much more. The output of these functions can go…

Written by Debra Dalgleish from Contextures Blog There's an Excel weekly meal planner on my website, to help you organize your meals, and create a shopping list. Now that we're…

Are you ready for a fun Excel challenge? Read on then… You are a nautical transport manifest analyst at New Donk city harbor. But you also have a secret identity.…

Written by Debra Dalgleish from Contextures Blog A simple data change can cause a strange pivot table refresh error, if you added the data to the Data Model. The problem…

Ever wanted to turn a number to words like 123,456 to One hundred twenty-three thousand four hundred fifty-six? You can use this elegant Excel formula to get convert number to…

How are you? I want to say hello and check in with you in these strange and scary times. How are we… Jo, kids, Excel (our dog) and I are…

We  can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy.…

Written by Debra Dalgleish from Contextures Blog It's been a long time since the last Excel roundup, so here's a new one! Check out these Excel links and articles, and…

Do you want to create a simple, elegant and useful tracker using Excel? You can make trackers with features like tables, data validation rules and conditional formatting. In this page,…

Written by Debra Dalgleish from Contextures Blog Some events occur on the Nth weekday of a specific month each year. Maybe your book club meets on the 4th Tuesday every…