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.
Information management and technology assurance
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.
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.
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.
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.
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.
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.
Aliases and shared mailboxes
Having second email addresses and shared emails can be useful tools to manage the flow of emails.
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.
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.
Automatically create subtotals in Excel
There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.
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.
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.
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.
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.
Using Advanced Filter in Excel
Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.
How to compare documents
Learn how to find changes to a Word document when Track Changes wasn’t turned on.
Q&A: The 2 most prevalent cyberthreats for CPA firms
The co-author of the JofA’s Professional Liability Spotlight column discusses common strategies used by cybercriminals and how they can be mitigated.
What CPAs need to know about NFTs
NFTs are unique, immutable, and auditable records of the ownership of both physical and digital assets.
Using COUNTIF and COUNTIFS in Excel
COUNTIF is used to count items based on one criterion, while COUNTIFS is used to count items based on multiple criteria.
