Excel

Functions

Action Shortcut Before After
Replace a string by another
=SUBSTITUTE(A1; "world"; "everybody")
Hello world! Hello everybody!

Tips

Comparing two versions of a sheet

There's a hidden tool there to do it :

C:\Program Files (x86)\Microsoft Office\Office15\DCF\SPREADSHEETCOMPARE.EXE

Keyboard shortcuts

Action Shortcut
Insert current date CTRL + SHIFT + ,
Insert current time CTRL + SHIFT + .
Flash-Fill CTRL + E
Print/export