Try these two ways of analyzing and reporting QuickBooks Online data using Microsoft’s Power BI Desktop Version.
Information management and technology assurance
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.
Efficient ways to open Microsoft Excel
There are a couple of ways to have Excel open most conveniently for you.
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.
Cybersecurity risk: Constant vigilance required
These tips can help diminish the likelihood and
impact of a cyberattack.
Smart Lookup in Microsoft Excel
You can quickly look up text from your Excel spreadsheets from several online sources.
Increase time increments by minutes in Excel
You can incrementally increase times for your agenda by a certain number of minutes.
Advice from an expert on cyber insurance coverage
Cybersecurity specialist Mike Foster shares common questions that insurance companies might ask when your company is applying for cyber insurance coverage and advice on how to address them.
The payoffs of RPA for one accounting firm
How can organizations and firms evaluate whether robotic process automation (RPA) is right for a project? First, they must know what RPA is and isn’t, and the pain points they are trying to address. An expert shares knowledge on the topic in this podcast episode with transcript.
The heavier lifting that technology can accomplish for CPAs
Podcast guest and technology expert David Cieslak shares why automation should be embraced by finance professionals and explains how he became known as “Inspector Gadget.”
Tackling NFTs in the accounting classroom
An emerging technology has interesting accounting implications.
Change the case of text in Excel
You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.
2022 tax software survey: Shares of respondents and product and company information
Bonus: The percentages for all products, including a breakdown of their usage among firms ranked by ranges of numbers of preparers, in the 2022 tax software survey.
Using 3D formulas in Excel
Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.
2022 tax software survey
CPAs assess how their return preparation products performed.
Features
FROM THIS MONTH'S ISSUE
Building a better CPA firm: Stepping up service offerings
A key step in business model modernization is determining how to implement services that satisfy clients and employees.