Microsoft Excel tips and tricks for accountants

TOPICS

February 1, 2016

Microsoft Excel: Failure to launch

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

February 1, 2016

Microsoft Excel: A formula for going green

How to color-code formulas in Excel.

January 1, 2016

Microsoft Excel: Rowing logically

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

April 1, 2014

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.

June 1, 2013

Excel at hyphen removal

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

May 1, 2005

Calculate length of service in years and months

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

November 1, 2004

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

July 1, 2004

Split an Excel cell and enter two pieces of information

How to use Excel’s Format command to add two pieces of information to one cell.

FROM THIS MONTH'S ISSUE

AI risks CPAs should know

Are you ready for the AI revolution in accounting? This JofA Technology Q&A article explores the top risks CPAs face—from hallucinations to deepfakes—and ways to mitigate them.