Microsoft Excel

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.

How to color-code formulas in Excel.

How to convert these two or three lines of data records into single rows.

J. Carlton Collins outlines two ways to remove hyphens from Social Security numbers in Excel.

How to use Microsoft Excel to calculate employees’ length of service.

Q. I know how to link data from a cell in one worksheet to another worksheet, but how can I transfer a formula? A. To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter