Two Better Ideas


Ali Allison, CPA, tax practice manager at Singer Lewak LLP in Los Angeles, had some useful ideas about the Tech Q&A item “Generate Duplicate Changes in Multiple Excel Worksheets,” which appeared in the December 2008 issue, page 104. The article is about keeping several similarly laid out spreadsheets along with an annual summary sheet. She suggests adding a “3D” reference for an overview. To do that, she adds, the summary worksheet should have a formula like =SUM(Jan:Dec!B5) to total all the cells in B5 from sheet Jan to sheet Dec. To get the 3D reference, type =SUM in the summary worksheet and then click on the first sheet (for example, Jan), and hold down the Shift key as you click on the last sheet (that is, Dec) and finally click in the cell to be totaled (that is, B5). And presto: an instant 3D reference.


And in the same column, regarding the item “A Quick Way to Erase Selected Data From a Workbook,” she points out that our suggestion to use GoTo, Special to identify and remove Constants is not enough. She explains that some accountants use Excel as a calculator and will enter, for example, =25+25+10. Since Excel will read that as a formula, it won’t select it as a constant and remove it. She suggests viewing the formulas with Ctrl-` (the key to the left of the 1 key) to see what’s left after the constants have been erased to see what else needs to be deleted.



Year-end tax planning and what’s new for 2016

Practitioners need to consider several tax planning opportunities to review with their clients before the end of the year. This report offers strategies for individuals and businesses, as well as recent federal tax law changes affecting this year’s tax returns.


News quiz: Retirement planning, tax practice, and fraud risk

Recent reports focused on a survey that gauges the worries about retirement among CPA financial planners’ clients, a suit that affects tax practitioners, and a guide that offers advice on fraud risk. See how much you know with this short quiz.


Bolster your data defenses

As you weather the dog days of summer, it’s a good time to make sure your cybersecurity structure can stand up to the heat of external and internal threats. Here are six steps to help shore up your systems.