Microsoft Excel

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?

Excel 2016 provides a new tool called Forecast Sheet that automatically calculates and plots your upper and lower forecast boundaries based on your desired level of confidence.

Use a little trickery to create a bull’s-eye chart in Excel.

How to “flatten” data in Excel.

How to use Microsoft Excel’s Color Scale format.

Tips for using Excel’s Subtotal and PivotTable tools.

How to unhide unused columns and rows.

How to get Excel to open a new blank workbook upon launching the program.