In this guide, you will learn how to use Excel’s advanced formulas such as INDEX-MATCH, OFFSET, and INDIRECT to enhance your data analysis capabilities. First, let’s explore the INDEX-MATCH ...

Fix Excel formulas that won’t spill! Learn how to troubleshoot #VALUE errors caused by Analysis ToolPak functions and improve your workflow.

Microsoft Excel was first released in 1987 and — despite popular competitors such as Google Sheets — is still used by millions of businesses throughout the world. Described as the “world’s most ...

Learn the difference between formulas and functions and how the two can be combined to unlock the data-crunching potential of Microsoft Excel. The MSU Libraries offer three different Excel workshops: ...

This workshop will show participants how the most commonly used Microsoft Excel formulas work. Click the "Link" below to register for this free workshop.

You can create a release to package software, along with release notes and links to binary files, for other people to use. Learn more about releases in our docs.