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.
Technology
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.
Using Benford’s Law to reveal journal entry irregularities
Benford’s Law can help uncover indicators of fraud — and anomalies that arise from legitimate business practices.
Increase time increments by minutes in Excel
You can incrementally increase times for your agenda by a certain number of minutes.
Efficient ways to open Microsoft Excel
There are a couple of ways to have Excel open most conveniently for you.
Smart Lookup in Microsoft Excel
You can quickly look up text from your Excel spreadsheets from several online sources.
Cybersecurity risk: Constant vigilance required
These tips can help diminish the likelihood and impact of a cyberattack.
