Written by Debra Dalgleish from Contextures Blog If you're using my Excel Pivot Power Free add-in, there's a new version for you to download. There's one new feature, one feature…

Written by Debra Dalgleish from Contextures Blog Copying and pasting can save you lots of time in Excel. Imagine if you had to manually re-enter all that data instead!. Occasionally…

Written by Debra Dalgleish from Contextures Blog Do you keep notes about the Excel formulas and macros that you create? What's your documentation system, if you have one? Is it…

Ever wanted to make a random sentence or text? You can use Excel formulas to make totally random sentences. This is a great way to generate test data or dummy…

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…