Accounting technology news and resources

TOPICS

March 8, 2023

How to increase your students’ digital acumen

Prepare students to make a bigger impact through technology.

March 1, 2023

Improve audit sampling efficiency with Excel’s Solver tool

Artificial intelligence capability can significantly reduce the time and effort auditors devote to sampling estimation tasks.

March 1, 2023

Quick Excel tips for accountants

This article offers a few quick Excel tips for varying levels of proficiency.

March 1, 2023

Outlook flags and rules

This article discusses two simple tools available in Outlook desktop and Outlook online.

February 3, 2023

Digital assets in danger: How to guard against hackers

An expert on cybersecurity details the current threat landscape related to digital assets and shares advice on protecting digital assets in this podcast episode with transcript.

February 1, 2023

Convert dates using Arabic numerals to dates with Roman numerals

If you have several dates written with Arabic numerals, there are steps to convert them all to Roman numerals.

February 1, 2023

From numbers to narrative: How CPAs can tell stories with data

Become a better adviser to colleagues and clients by strengthening your data storytelling skills.

February 1, 2023

Update AutoRecover setting in Microsoft Excel

By default, AutoRecover is set to save every 10 minutes, but you can set it to save more often.

January 30, 2023

Using ChatGPT with Excel

This month’s column explains how the new AI tool known as ChatGPT can help with challenging Excel tasks such as creating PivotTables and writing macros.

January 11, 2023

How COVID-19 changed the way we teach

The COVID-19 pandemic forced colleges and universities to embrace the digital age. Accounting faculty members reflect on adapting to the changes, both positive and negative.

January 1, 2023

Calculating double-declining balance depreciation for tax purposes in Excel

Variable-declining balance uses the double-declining factor but also initiates the automatic switch to straight-line depreciation once that is greater than double-declining.

January 1, 2023

Aliases and shared mailboxes

Having second email addresses and shared emails can be useful tools to manage the flow of emails.

December 20, 2022

5 ways firms can use technology to transform audits

Technology has been transforming audits for years, and that trend will only accelerate with the Statement on Auditing Standards (SAS) No. 142, Audit Evidence, which took effect on Dec. 15, 2022.

December 8, 2022

The CPA’s guide to technology (and tech gifts)

Inspector Gadget, aka David Cieslak, is the guest on this podcast episode, which focuses on cybersecurity and CPA-centric holiday gifts.

December 1, 2022

Use Mail Merge to send bulk emails

Mail Merge can be an option for sending bulk emails to a small, specific group or for those who need a simpler tool than bulk email software.

December 1, 2022

Automatically create subtotals in Excel

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

December 1, 2022

Automatically color-code cells in Microsoft Excel

You can automatically have cells turn certain
colors based on the text within those cells. This
is easily done using one of the many types of
conditional formatting.

December 1, 2022

Using Power BI for advanced QuickBooks data analytics

Try these two ways of analyzing and reporting QuickBooks Online data using Microsoft’s Power BI Desktop Version.

November 30, 2022

Audit committee disclosures increase, right along with workload

A Center for Audit Quality report reveals an increase in public company audit committee disclosures, particularly related to cybersecurity, while an accompanying report aims to help audit committees manage their growing list of responsibilities.

November 1, 2022