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 create a Secondary Axis Chart in Excel
These types of charts let you display to different types of values eg: quantity and percentage. The percentage figures will appear on the secondary axis as a different chart type. Click 'Recommended Charts' to have one created for you.
Copilot
How to avoid the 'Oversharing Risk' in Copilot?
The latest Gartner® research report identifies a major risk: "Microsoft 365 Copilot could potentially expose over permissioned files to unauthorized or unintended users (Oversharing Risk)."
Copilot
How do I roll out Copilot?
Thinking about rolling out Copilot and wondering where to begin? It's a question we often get asked by organisations.