Accounting technology news and resources

TOPICS

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

Using range names in Excel

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.

January 1, 2022

Card-carrying ways to automate expense reports

Just about everything we do daily has been automated in some way. And that includes expense reports.

January 1, 2022

4 cool features for optimizing Outlook

Here are four features that can help you make the most efficient use of Outlook.

December 20, 2021

5 key steps for digital transformation during a crisis

Major changes can be difficult to implement at any time but especially during a pandemic. Here are some lessons learned from a successful system implementation.

December 7, 2021

Work with other departments to bring more tech to your curricula

Follow these tips for successful interdepartmental collaborations.

December 7, 2021

Calculating the issue price of a bond using the NPV function in Excel

When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function in Excel.

December 7, 2021

A road map for learning data analytics

Models can help faculty teach — and students grasp — this important subject.

December 1, 2021

Helping clients build a cyberattack recovery plan

CPAs can play critical roles in helping companies plan
their recovery from online attacks.

December 1, 2021

How to hide zero values

In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.

December 1, 2021

Using stocks and other data types in Excel

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

December 1, 2021

Using the Excel personal assistant

Excel Personal Assistant can help you locate all the features Excel has to offer.

FROM THIS MONTH'S ISSUE

4 ways solo practitioners can stand out

Five years ago, a grieving Angel Zhen started his own CPA firm with no clients and no revenue. Today, he has 300 clients, $600,000 in revenue and 12 weeks of annual vacation. In this JofA article, he shares how he set up his firm and how you could do the same.