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…

Written by Debra Dalgleish from Contextures Blog When you create a pivot table in Excel, it doesn't matter if there are filters applied in the source data table. The pivot…

Excel Pivot tables make data analysis and visualization easy. With the help of these advanced pivot table skills, you can create powerful data analytics and reports.   New to Pivot Tables? If you…

Written by Debra Dalgleish from Contextures Blog Last week, someone asked me how to make an Excel hyperlink to next empty cell. See how to set that up, in a…

Written by Debra Dalgleish from Contextures Blog Select a region name in one Excel drop down list. Then, in the next drop down list, select from a list of employees…

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…