Dennis O'Reilly began writing about workplace technology as an editor for Ziff-Davis' Computer Select, back when CDs were new-fangled, and IBM's PC XT was wowing the crowds at Comdex. He spent more ...

Q. When I open Excel, I always have to choose Blank workbook. Is there any way to have Excel do this automatically and skip the step of getting the Start screen? Q. I have a folder of Excel files that ...

Have you ever sent an Excel file to a colleague, only to realize they couldn’t open it because of compatibility issues? Or perhaps you’ve spent hours perfecting a spreadsheet, only to see its ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...

Excel has several advanced sorting options, but most of us never venture beyond the ordinary alphabetic and numeric sorts. If you need more than a simple sort, check out Excel’s advanced sorting ...

What if you could turn the tedious task of combining transaction files into a quick and easy process? With Power Query in Excel 365, you can do just that. This powerful tool allows you to merge files ...