Microsoft Excel

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.

Microsoft Excel 2016 has two new mapping capabilities.

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.

Excel’s NETWORKDAYS function (available in Excel 2010 and later editions) returns the number of working days in a specified period of time.

A few options exist for controlling some of Excel’s AutoFormat behavior.