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 ...

Inserting a pivot table in a sheet in Excel 2013. Image: Screenshot by Susan Harkins/TechRepublic When is the last time you opened Microsoft Excel to do some data science? If it's been a while, you're ...

Have you ever opened an Excel file and felt a pang of unease? Rows upon rows of data, cryptic formulas sprawled across cells, and a tangle of manual formatting that seems one misstep away from chaos.

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...