Excel: Select Random Rows (No Duplicates)

Whether you work in or are preparing data for analysis, market research or auditing, or simply need to create unbiased samples for statistical studies, the need to select X number of rows at random from a Table is a common requirement for Excel users. In this video I...

Create a Checkbox-Style Filter

For as long as I can remember, Excel has included the ability to insert checkboxes into a worksheet. This was achieved by inserting a Checkbox Form Control from the Developer tab of The Ribbon. But that feature has shortcomings, primarily due to the fact that the...

Exclude Columns From a Pivot Chart

When you create a chart from a Pivot Table, all the columns from the Pivot Table are used in the chart. Even if you highlight specific columns, Excel ignores that and creates the chart by using all the columns. Consider the example below. I require a column chart that...

Excel: Create a Dinner Seating Plan

NOTE: This tutorial uses the FILTER function which is only available in Excel 365. If you’ve ever attended or organised a large dinner or wedding reception you’ll know that it’s usual at these types of events to have a seating plan displayed on the...

Excel: Filter a Pivot Table on a Date Range

A couple of weeks ago I was asked how to filter a pivot table based on a range of dates when the field containing the dates isn’t part of the pivot table. There’s more than one way to do this and in this video I’m going to show you 4 different methods and discuss the...

Excel: Lock a Checkbox on Protected Sheet

In this video, I’ll provide a solution to a common issue faced by Excel users: You have a worksheet that contains one or more checkboxes. You’ve enabled Sheet Protection yet the checkbox can still be checked and unchecked. Sheet Protection does not extend...