There was a court order to get Thomas Matejcek the help he needed. But days before his mother and her fiancé were murdered, ...

When the IBM PC was new, I served as the president of the San Francisco PC User Group for three years. That’s how I met PCMag’s editorial team, who brought me on board in 1986. In the years since that ...

Have you ever found yourself wrestling with an Excel formula, wondering why a seemingly simple task feels so complicated? For years, functions like VLOOKUP, CONCAT, and OFFSET were the go-to tools for ...

Suppose we have a workbook with employee data (employee names) of an organization, as shown in the above image. Column A contains the first names of the employees, column B contains middle names of ...

When you are using slicers with an Excel PivotTable it’s often useful to be able to get a comma-delimited list of the items selected in that slicer for use in a report title. It’s not easy to do ...

I don’t normally blog about Excel topics outside of Power Query and Power Pivot, but I think anyone who has ever done any serious work in Excel has found how difficult it is to concatenate more than ...