It’s always useful to see all the data in finance spreadsheets like a cash flow forecast or a profit and loss account, but sometimes you just want to see the important numbers. Any type of spreadsheet which contains formulas can be manipulated using a feature called ‘Outlining’ and in this short video I show you how to do this with one click – then cut back on the clutter and see only the totals you want.The great thing about this is you can switch the outlines on and off whenever you like, using the same shortcut key, after you’ve hidden some rows and columns.This simple Excel trick is something we teach as part of our Excel Level 2 Ninjas course – there are many secrets in this feature rich program that are right under your nose! What are you waiting for? Watch the video and let me know what you think!
Tags: blog, efficiency implementation, Excel, learning & development solutions, shortcuts, spreadsheets, training, training & development