If you have added a column for manual entries to a PowerQuery table you may have discovered that when you refresh the query that the manual data gets messed up. In order to keep the manual data you will need to take a snapshot of the manual data in another query and then merge that query with the new data. Here's how to do that.
Preserving Manual data added to a PowerQuery Table18 May 2023 | Topic:Top-10
6 Steps to optimize setup of a Pivot Table6 October 2022 | Topic:Top-10
Excel Piivot Tables are one of the most powerful and useful tools in Excel. In this short video I want to explain 6 steps that you should do each time you create a Pivot Table to optimize it's performance, the ease of creating reports and save you time.
All About Using CountIFS and SumIFS7 December 2020 | Topic:Top-10
In the bonus #11 episode of the Excel Top-10 series, learn the best way to count or sum data from a table based on custom criteria.
Created and narrated by our CEO, Frank Byl.