How to do an X-Lookup Formula in Excel
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!
365 Productivity
How to Transpose Data in Excel
A handy little tip from the Paste options in Excel
Copy then Paste and select the Transpose option.
It doesn't work if you Cut - only Copy and not next door - select a cell underneath or on a new sheet.
365 Productivity
Mastering Outline Numbering in Microsoft Word
Using Tab and Shift and Tab you can quickly change levels for your outline numbering. Tab moves forward and Shift and Tab moves you back a level.