Microsoft Excel

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.

Tips for printing all of the worksheets in an Excel workbook at one time.

With speed in mind, here are a few of my favorite Excel keyboard commands. How many do you already know?

I can’t figure out why the decimals and commas in my Excel-based cash flow statement (using the “Accounting Format”) don’t line up properly. What’s going on?