If you get errors in your results in Excel, edit your formula so it starts with the 'IfError' formula. You can 'nest' an If Error formula and another formula to remove the error messages and it will look so much better

Jump in and out of Power Query to clean your data - even for pesky small jobs - so much quicker!

Sometimes you need to manage a large worksheet by hiding data - use the Outlining / Group options to add show/hide buttons to collapse your data when not in use.