Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

Microsoft isn't trying to confuse you—Excel's three ranking functions balance flexibility, compatibility, and tie handling.