Excel Tutorials
A collection of written and video based Excel tutorials (Power BI coming soon)Excel: Select Random Rows (No Duplicates)
Select random rows from a table with a neat trick to ensure no duplicates
Create a Checkbox-Style Filter
Use the new Insert > Checkbox feature to create a filter for a Dashboard
Exclude Columns From a Pivot Chart
Choose which columns from a Pivot Table to include in a chart
Excel: Create a Dinner Seating Plan
Quickly create a seating plan for a dinner using a combination of Excel and PowerPoint
Excel: Filter a Pivot Table on a Date Range
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
Excel: Lock a Checkbox on Protected Sheet
Sheet Protection on its own doesn’t prevent users changing a checkbox. Lean about the additional steps needed.
Excel: Automatically Generate Sequential ID’s – In Reverse
Automatically generate sequential ID numbers when a row is added at the top of a Table
Excel: Automatically Generate Sequential ID’s
Automatically generate sequential ID numbers such as TET-0001, TET-0002 etc when a new row is added
Excel: Import Content from XML
Use Power Query to load and clean data from an XML file into Excel