Search keywords: Excel Hints

Basic Formulae
Multiply =a1*a2
Divide =a1/a2
Autosum =SUM(a1:a5)
Average =average(a1:a5)
Max =max(a1:a5)
Min =mix(a1:a5)

Advanced Formulae
=SUBTOTAL(3,A6:A105) Useful for automatically counting the number of records showing after using a filter.