I started writing a series of blogs on the use of Excel spreadsheets for circuit design on the now-defunct Microcontroller Central. Those blogs, though separate from this blog and future ones that I ...

Excel gurus love to tell you, "Always format your data as a table." While that's usually solid advice, it's not always the best move. In some scenarios, a simple range outperforms a table entirely.

Pivot tables are an advanced method of arranging organized data and using formulae in Microsoft Excel. We could use standalone formulae over rows and columns but upon adding or deleting rows these ...

Ditch manual sorting for live formulas that rank top performers, fastest times, and equal scores as data changes.

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...