4 ridiculously useful Excel tools Microsoft barely tells you exist

Camera Tool
Not on the ribbon, but three clicks from your toolbar
Flash Fill
Ctrl+E does what a formula would take five minutes to write
Analysis ToolPak
It just isn’t turned on by default
Watch Window
One floating panel tracks cells across sheets and workbooks
Excel has been hiding more than you’d think
Buried in menus, not because they’re weak