Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

Learn how absolute percentage growth helps you evaluate the standalone performance of your investments without benchmarks.

Certain graphics on this page may be affected by ad-blocking software. If portions of the page appear blank and an ad blocker is enabled, please disable the ad blocker and refresh the page to ensure ...