Q: It’s nice that the newer version of Excel has more than a million rows, but paging down all of those rows takes an eternity. We are now using Excel to analyze more than 300,000 rows of data, but navigating with the Page Down button takes forever. Is there a
Advertisement
TOPICS
Information management and technology assurance
A Prezi for You
Q: I attended a conference recently in which the instructor used an impressive animation effect to navigate the presentation from a single page, moving and zooming from one topic to another almost like navigating a road map with a magnifying glass. As he reached each topic, the screen zoomed in
CPA Horizons 2025: A Road Map for the Future
The AICPA has released the findings from a yearlong initiative to examine what’s on the horizon for CPAs and the accounting profession. CPA Horizons 2025 leveraged insights from more than 75,000 comments from CPAs in all segments of the accounting profession, regulators, thought leaders and futurists to highlight key trends
Technology 2012 Preview: Part 2
CPAs, whether in public practice or in industry, face a dizzying array of technological choices as 2012 approaches. To help everyone prepare for the year ahead, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to discuss the hottest tech topics in the accounting
High-Potential CPAs, the BIG Picture
Editor’s note: Also read “The Lowdown on High Potentials” in the December 2011 issue of the JofA. With the 2011 edition of its Top Talent Survey, the AICPA’s Private Companies Practice Section took a look for the first time at high-potential CPAs working in the business, industry and government (BIG)
ProSystem fx Tips
With tax season just around the corner, here are a few tips for using CCH’s ProSystem fx Tax (Foundation). ProSystem fx was the most-used software among the 10,026 respondents in the 2011 tax software survey conducted by the JofA and The Tax Adviser (see tinyurl.com/42o9h5s). 1. Tax cross-referencing. Pressing F1
Hardware Trends for 2012
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call
Business Wire Partners With EDGAR Online for XBRL Filings
Business Wire signed a deal to use EDGAR Online’s technology to create and produce extensible business reporting language (XBRL) filings to help its customers satisfy SEC reporting requirements, according to an EDGAR Online news release. A provider of news release distribution and regulatory disclosure services, Business Wire handles XBRL tagging,
Security Issues
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call
E&Y CEO Turley Retiring Effective June 2013
James S. Turley is retiring as chairman and CEO of Ernst & Young effective June 2013, the Big Four accounting firm confirmed Wednesday. In a communication to E&Y partners worldwide Nov. 10, Turley said that he would retire at age 58, according to a statement released by the firm. The succession
Software Trends for 2012
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call
Social Media
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call
Clifton Gunderson, LarsonAllen to Merge, Create Top 10 Firm
Top 20 accounting firms Clifton Gunderson and LarsonAllen said Tuesday that they plan to merge Jan. 2, 2012, creating one of the 10 largest CPA firms in the country. The new firm would take the name CliftonLarsonAllen (CLA) and boast more than $550 million in combined revenue. CLA would have
New Revenue Sources for CPA Firms
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+ Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call
Linking Can Be a Drag
Q: My job requires me to write a lot of link formulas in Excel, but I find the process confusing due to the numerous links and workbooks I deal with. Do you have suggestions for creating links in an organized approach? A: Excel allows you to create links automatically by
Family Business Transition Planning
Family relationships and values can make succession of family businesses even more challenging than for other enterprises. Here are some suggestions for family businesses that can make succession planning and execution less trying. (This article is adapted from a free white paper by the authors available at tinyurl.com/5uv6oy6.) By James
Welcome to the Chop Shop
Q: I am delivering a presentation next month and would like to play a small portion of a YouTube clip with it. What’s the best way to do this? A: Before you reuse a YouTube video in your presentation, you should first contact the author and obtain permission. Assuming
Technology 2012 Preview: Part 1
With 2012 just around the corner, the JofA gathered the three technology keynote speakers from the AICPA’s 2011 Practitioners Symposium/TECH+Conference to talk about tech trends heading into the new year. The nearly 90-minute conversation covered a wide range of technical issues critical to all CPAs. Participating in the call were:
Can You Keep a Secret (Folder)?
Q: I created a hidden folder on my desktop to prevent others from seeing it when using my computer or accessing my computer across the network. I did this by right-clicking on the folder and selecting Properties then, under the General tab, checking Hidden. While this did hide my folder,
Smart Question
Q: I just purchased a new smartphone, and I understand that there are more than 100,000 applications that I can download. Can you tell me some of the better smartphone applications that I should be using? A: It would take the entire JofA to describe all the useful smartphone
Features
SPONSORED REPORT
Preparing clients for new provisions next tax season
As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.
From The Tax Adviser
October 31, 2025
Recent developments in estate planning
October 31, 2025
Current developments in taxation of individuals: Part 2
September 30, 2025
Current developments in taxation of individuals: Part 1
August 30, 2025
