Microsoft Excel

Microsoft has made several improvements to Excel 2016’s PivotTables.

How to use Excel’s CONVERT function to convert a multitude of units of measurements.

Use this formula to count the number of words in a Microsoft Excel cell.

How to print a report with truncated Social Security numbers.

The problem, it turns out, is related to Excel’s famous built-in 15-digit number limitation.

Handy Excel tips from “Technology Q&A” author J. Carlton Collins, CPA.

Yes, it is possible to link the contents of a text box in Excel to data in a cell.

It is possible to modify Excel’s default blank workbook; you can even modify the default new worksheets that you insert into your existing workbooks.

How to use Excel’s Evaluate tool to understand complicated formulas.

A handy trick makes it possible to reference vertical data horizontally.

By following a common set of spreadsheet design rules, companies can produce more consistent workbooks that may be easier to review, edit, and use by others in their organizations.

When it comes to choosing the best font for displaying both text and numbers, the font you choose matters.