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

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

Screen-capturing programs such as the Windows Snipping tool are fine for capturing graphics you see on your screen's visible area. However, if you need to print a document with a height that exceeds ...

Back in April 2014, I wrote about the first release of Microsoft’s Excel for iPad, and I found it to have a well-designed UI and most of the features of the desktop version. It was missing some things ...

Can Excel send Alerts? Yes, but with some limitations. Excel cannot email an alert to you automatically unless you write a macro in the Visual Basic (VBA) editor to perform this function. And, the ...

This Excel spreadsheet uses conditional formatting to highlight the resistor pairs in a design that can create a particular ratio. The target ratio is entered in cell C3, and the tolerance is entered ...

Excel and Access are two software applications which belong to the Microsoft Office suite. You can create a data file in a spreadsheet format using Access and then later open the file and work on it ...

Q. I receive regular spreadsheets with all of our company’s accounts, departments, employees, and balances, and I have to subtotal the amounts by accounts, departments, etc. I have been manually doing ...