Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...

Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

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