The standard budget layout isn't great for pivot tables. You can easily and quickly convert it into a normalised data structure using Power Query. See how in this short video. https://vimeo.com/601526539 [vimeo id="601526539"]

If you want to display a blank cell instead of a zero there are two ways to do it. See both in this short video. https://vimeo.com/601506805

Do you have a list or lists that you use all the time? Would you like to write the first entry and then drag it like January to get the rest of the list? Here’s how.

If you have data that has blanks in it you may be able to combine columns using Paste Special – Skip Blanks.

When you are working with text numbers in tables sometimes you need to convert real numbers into text numbers to do look ups. There are at least two ways to do this. Let's see how to convert real numbers into test numbers, real fast. https://vimeo.com/594604405

When you import numbers from other systems they sometimes come in as text and are left aligned.

There are a couple of ways to fix them and they can both be done in less than a minute.

The Merge cells format has lots of issues. It can crash macros and stop you copying and pasting.

In less than a minute you can use a macro to solve the problem.

Replacing colours manually can be a tedious task.

Did you know you can use Excel’s built-in Find & Replace to do the job for you?

Joining names; extracting codes or converting dates is usually done with formulas, but there is now a formula-free solution called Flash Fill.