Highlighting or even deleting duplicate records in Excel is simple but listing them isn't as easy. Fortunately, you can use Power Query to easily display a list of duplicate values or records.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

Excel Off The Grid uncover how VBA can supercharge your Power Query experience by automating key processes, from managing refresh settings to creating reusable custom functions.