The point of this single web page is to be a one-stop shop. The links below point to the various ways that I use or have used Excel to teach Economics, including my summer Excel teaching workshop. My ...

I've been helping readers find the best deals for over five years. If you’ve never worked with spreadsheets before, just opening Microsoft Excel can feel intimidating. The program has so many ...

Old-school Excel functions like SUMPRODUCT, INDEX/MATCH, and IFERROR remain essential for stable, readable, and maintainable ...

Renaming Excel worksheets supports navigation, organization, and cross-sheet references. Descriptive sheet names aid accessibility by helping those using screen readers to navigate the workbook.

Ah, Excel. This little piece of software is the unicorn of spreadsheets, and that’s why so many people want to learn it. You’ll be hard-pressed to find an office that doesn’t use Excel for one purpose ...

Microsoft Excel spreadsheets hold more than a million rows of data and automate number crunching, but they can do so much more. Excel’s simple interface lends itself to uses well beyond those that its ...