In this Microsoft Excel tutorial I explain how to combine data stored across multiple worksheets in one sheet or table. I use Power Query to achieve this. Click here to download the featured file. Video Table of Contents 00:00 – Introduction 00:14 – Combine sheets (tables) in the same workbook 00:21 – House data in… Read More »Combine Data from Multiple Sheets into One Sheet In Excel | Consolidate Tables into a Single Sheet

In this Microsoft Excel video tutorial I demonstrate how to highlight and count duplicate rows in your data. This can include or exclude the first occurrence. Click here to download the featured file. Video Table of Contents 00:00 – Introduction 00:03 – Concatenate the values in each row 01:02 – Count the number of occurrences… Read More »Highlight and Count Duplicate Rows In Excel | Highlight Duplicate Rows in Excel Except First

In this video tutorial I explain how to quickly and easily group rows and create automatic subtotals. I also demonstrate how to create nested subtotals based on grouping in multiple columns. Click here to download the featured file. Video Table of Contents 00:00 – Introduction 00:04 – Group and create subtotals for one column 01:11… Read More »How to Create Automatic Subtotals in Excel | Nested (Multiple) Subtotals | Group Rows & Subtotal