Accounting technology news and resources

TOPICS

March 1, 2022

Combining formulas and text in the same cell in Excel

You can include both a formula and text in the same cell in Excel.

February 17, 2022

Tax pros are subject of ‘spearphishing’ attacks

Bogus emails may impersonate the IRS or tax software providers. Here’s what to watch out for.

February 11, 2022

How not-for-profits are adapting to a technological revolution

To get the most out of their technology spending not-for-profit leaders need to develop a strategy, consider cybersecurity, and recruit tech experts for the board.

February 8, 2022

Teach students to address accounting questions using data analytics

Data analytics is a new means to the same end: providing high-quality and timely information to decision-makers.

February 8, 2022

How to easily transpose data in Excel

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

February 4, 2022

Federal security agencies warn of potential Russian-sponsored cyberattacks

A joint cybersecurity advisory from the Cybersecurity and Infrastructure Security Agency, the FBI, and the NSA urges businesses and other organizations, to step up their cybersecurity mitigation and detection efforts.

February 3, 2022

A blockchain glossary, the CPA firm of the future, and Excel malware

Blockchain — what does it mean to you? A glossary of terms offers clarity. Also, hear or read more about accounting firms’ tech-integrated future.

February 3, 2022

Avoid these 8 PowerPoint mistakes

PowerPoint blunders can make your presentations painful to sit through. Try these tips to make your talks clearer, more concise and more memorable.

February 1, 2022

Cyberattacks via Excel add-ins jump nearly 600%

Report finds huge surge in malware infections via .XLL files.

February 1, 2022

Automate routine data entry with Excel Flash Fill

If Excel can sense a pattern in what you are doing,
it will try to complete the task for you.

February 1, 2022

Embracing technology in the audit

Firms and practitioners are using digital tools to provide more value to clients.

February 1, 2022

Transposing data in Excel

You can easily convert horizontal data to
vertical and vertical data to horizontal by using the
Transpose feature in Excel.

February 1, 2022

How to spill formulas in Excel

With spilling, you can create a formula in one cell, and that formula will then spill over into other adjacent cells when a set of values is calculated.

January 31, 2022

Companies urged to bolster defenses against ‘triple threat’

Businesses are experiencing more, and more costly, incidents of fraud, compliance breaches and cyberattacks but are not doing enough to protect themselves, KPMG says in its 2022 Fraud Outlook report, A Triple Threat Across the Americas. The report recommends five steps companies can take to mitigate the risk of losses to this “triple threat” of dangers.

January 11, 2022

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.