Breaking News & Updates
Xero’s financial report reveals BIG loss but share price pop. - eepurl.com/isNmKQ
Excel Q&A: Show formulas in a spreadsheet
A student took a look at our newly created Staff Payment, PAYG, Super spreadsheet file and they wanted to know which formulas are used in the spreadsheet. This is a great question because there are many ways that a spreadsheet like this can be created and we’ll explore these methods in the forthcoming month.
The secret to reveal formulas is the Tilde key at the top left of your keyboard. Simply press Ctrl + ` and all the formulas in the spreadsheet will be revealed. You can then work intelligently on your spreadsheet and make changes fully aware of where numbers are simply entered or where complicated formulas exist.
Note: Our Excel Q&A service (just like our MYOB Q&A support) is designed to provide extra training content over and above the examples that are in our online Microsoft Excel Training Course.
-- Did you like what you read? Want to receive these posts via email when they are published? Subscribe below.
