Excel Tutorials

Select random rows from a table with a neat trick to ensure no duplicates

Use the new Insert > Checkbox feature to create a filter for a Dashboard

Choose which columns from a Pivot Table to include in a chart

Quickly create a seating plan for a dinner using a combination of Excel and PowerPoint

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

Sheet Protection on its own doesn’t prevent users changing a checkbox. Lean about the additional steps needed.

Automatically generate sequential ID numbers when a row is added at the top of a Table

Automatically generate sequential ID numbers such as TET-0001, TET-0002 etc when a new row is added

Use Power Query to load and clean data from an XML file into Excel