Advertisement
TOPICS

Microsoft Excel

Excel: This forecast was bound to happen

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.

Excel: The power of mapping

CPAs often have to produce recurring reports, such as quarterly balance sheets, from datasets, such as trial balances. The process can be tedious and prone to error, but an Excel technique called mapping can show the way to better results. Learn more in this Technology Workshop.

Excel at hyphen removal

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

Transfer an Excel formula from one worksheet to another

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

FROM THIS MONTH'S ISSUE

How to set up an effective internship program

Learn how firms can recruit stronger interns and build robust on-ramps for talent by following five recommendations.

From The Tax Adviser

July 31, 2026

Current developments in S corporations

July 31, 2026

Transfer pricing treatment of acquired intangibles

June 30, 2026

Condo casualty losses: Deductions for common-interest property

May 31, 2026

Trust distributions: Timing, tax, and practical considerations