Excel - Easy Text Functions
Having a good knowledge of basic function in Excel is the key to working quickly to get stuff done.
Simple text formatting shouldn't mean retyping a list - have these little formulas up your sleeve and you'll get the job done in no time!
=Upper (A1)
= Lower (A1)
= (Proper A1)
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
How to show all formulas in Excel
Next to your number 1 key on the keyboard is the magic "tilde" button.
Use ctrl + ` to show formulas and ctrl + ` to hide formulas.
365 Productivity
Excel - Percentages
Across all industries and all roles, at some time or another you're going to need to work out the percentage of something.
Take the number, divide by the total and multiply by one hundred over one... just got quicker.
365 Productivity
How to Manage Duplicate Data in Excel
Managing duplicates in Excel can often be a daunting task, but with a few simple steps, you can easily identify, filter, and remove them to ensure your data is as accurate and clean as possible.