Microsoft Excel

How to use Excel’s new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

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.