If you’ve ever dragged a formula down hundreds (or thousands) of rows, you’ll know how fiddly...

If your imported text looks odd, Excel has clean-up formulas that fix it in seconds:

• =TRIM(A1)...

Need a quick sum, average, or count from your data  without any hassle? 

• Just highlight your...

Highlight your data and press Ctrl + T to turn it into a dynamic Excel Table. You’ll instantly get...

If you ever spend time retyping patterns of information like splitting full names into first and...

Ever been in a large Word document and needed to look at two parts of it at the same time? Or a...

If you need to highlight all the blank cells in an Excel list, you can use this simple shortcut:

• ...

If you have multiple Excel files you need to combine in to one list, Power Query may have the...

If whilst working on your document or spreadsheet and you need to email it to a colleague as an...

Have you ever been working on a Word document or a large Excel file or for that matter a big...