1. LARGE()

Used this to find the top 5 of 200 values. Never know you could do this before!

2. SUM(Sheet1:Sheet10!A1)

I vaguely knew you could sum across worksheets before, but cool to rediscover this.