Excel - Percentages
It's simple when you know how! And to incorporate shortcuts into your Excel formulas, means you just get things done even more quickly.
Ctrl + = for Autosum
F4 to lock a cell in to make it an absolute cell reference
Ctrl + Shift + 5 to make a number format into a percent
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
How to set your 'Out of Office' in Outlook
Before you head away for a long weekend - be sure to set your 'Out of Office' up in Outlook. Anytime someone emails you, they will get an automatic reply. You can even set one for Internal emails and another for External replies.
365 Productivity
Word Tip - Select Text with Similar Formatting
A quick fix for a formatting change.
Don't bother with the format painter - next time go to the Home Ribbon > Editing > Select > Select Text with Similar Formatting.
Then make your changes - Presto!, All similar text will also be updated throughout the document.
365 Productivity
How to save your Signature for use in Microsoft Word.
Never lose your signature or have to create it again! Use an electronic pen to draw your signature. Click Win + Shift to screen capture your signature. Paste into a new page by clicking on Ctrl + V. Go to Insert and save image as a QuickPart. Create new a new Building Block. Insert Quickpart! Now your signature will always be there for you to use!