Microsoft’s new weekly topic around is one of my favorite topics: Excel
Weekly Topic: Excel – Inside Microsoft Dynamics GP
Excel & OfficeTips & Hidden Features
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.