As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

Irene Okpanachi is a Features writer, covering mobile and PC guides that help you understand your devices. She has five years' experience in the Tech, E-commerce, and Food niches. Particularly, the ...

Removing Excel's gridlines reduces visual clutter, enhances charts and tables, and helps you design more app-like dashboards.

Excel spreadsheets are one of the most useful tools to create documents with calculations and data and organize the accounting or VAT tax, among other tasks. Luckily, while working on Excel you can ...

Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

The open source community has created many open source Java projects, which range from charting software to game frameworks to word processors. In this post, I introduce an open source library project ...

Often it is useful for XML data to be presented as a spreadsheet. A typical spreadsheet (for example, a Microsoft Excel spreadsheet) consists of cells represented in a grid of rows and columns, ...