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 Clear filters with a shortcut
Use Tables - Ctrl + T
Then add Slicers to make filtering easier, finally use the sequential shortcut Alt then A, then C to clear filters. Remember Alt All Clear!
Teams
How to Colour Code Folders in Microsoft Teams
If you're a colour coding sort of person, you'll love the new ability to colour code your folders in Microsoft Teams. Just right click, go to Colour and select from the options available.
365 Productivity
How to Format Slicers in Excel
Slicers are a winning feature in Excel - Slice and Dice data in a simple and user-friendly interface