Written by Debra Dalgleish from Contextures Blog There are two types of AutoFilters in Excel – worksheet AutoFilters, and List (Table) AutoFilters. If you're using Excel AutoFilter macros, be sure…

Written by Debra Dalgleish from Contextures Blog If you change any of the information in a pivot table's source data, the pivot table won't immediately show your latest changes. You…

Written by Debra Dalgleish from Contextures Blog Excel macros ran really slowly in a workbook that someone sent to me. They said it was an Excel custom function (UDF) causing…

Happy New Year to all our readers. Let’s kick start the year with an awesome & free 2020 calendar template, daily planner and monthly calendar. Please click here to download…

Written by Debra Dalgleish from Contextures Blog Happy New Year's Eve! If you're setting goals for 2020, get these three free Excel templates to help you "Excel" at your New…

Hello readers, On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday…

Hello readers, I have an exciting announcement for you. I will be presenting at two events at London in April 2020. Please consider this my personal invitation and join me…

Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as…

Written by Debra Dalgleish from Contextures Blog Recently, someone asked me how to count duplicate number sets. There were hundreds of rows, with 6 numbers in each row. Did any…

Hello friends, It’s here. Power BI Play Date – my latest online training program is now ready for your consideration. Please take a few minutes to read this to know…