Goal Seek

The Goal Seek feature can save you a lot of trial and error when you want a calculated cell to equal a specific value.

The keyboard shortcut to open the Goal Seek dialog is Alt T G.

Related Posts

Shortcut to lock or unlock a cell

The keyboard shortcut to unlock or lock a cell or a range (its a toggle, so it switches between the two) is Alt H O L pressed in sequence, not held down.

Related Posts

 

Windows Clipboard

Did you know you can accumulate copied entries in the Windows clipboard?

The default setting is to only have the last thing you copied, but a setting change can give you access to multiple items to paste.

You can also pin items to the clipboard to keep them there.

To change the setting.

Click the Windows button and choose the Settings icon

The select System.

Then select Clipboard (bottom left) and change the Clipboard History to On – done.

 

If you copy multiple items you can press the Windows key and V to access what’s on the clipboard.

Then you can click the top right elipse icon to Pin the item to the clipboard.

Related Posts

Nothing in life is to be feared, it is only to be understood. Now is the time to understand more, so that we may fear less.

Marie Curie (1867 – 1934)

Restart a Pivot Table in one go

If you want to clear all the fields from a Pivot Table you can use the clear all option.

On the PivotTable Analyze or Analyze tab click the Clear drop down and select Clear All.

 

This removes all the fields and allows you to start again from scratch.

Financial Modelling with Scenarios

A great webinar recording from Danielle Stein Fairhurst from Plum Solutions and Thomas Paul from BDO.

A flexible technique to handle lots of different variables in a model using data tables.