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.

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

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

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

Posts from this author will be added to your daily email digest and your homepage feed. is a senior correspondent and author of Notepad, who has been covering all things Microsoft, PC, and tech for ...

How to copy an Excel sheet into a new workbook Your email has been sent Copying or moving data is a common task for users in Excel workbooks. Copying data from one worksheet to another within the same ...