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.
Information management and technology assurance
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.
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.
Using 3D formulas in Excel
Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.
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
CPAs assess how their return preparation products performed.
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.
Data storytelling: A valuable and exciting skill to introduce to students
Help students prepare for careers using and communicating big data.
Tackling the IT challenges of dealing with cryptoassets
Digital assets, from bitcoin to tokens, are a new asset class that challenges technology used for enterprise resource planning and financial reporting. Here’s what you should consider if you decide to take on these challenges.
Extract and present information about dates in Excel
This article looks at a few ways to extract and present information about the day, month, and then year.
When autocorrect is a problem in Excel
There are two ways to solve an autocorrect problem such as the one in the question above — a temporary solution and a permanent solution.
Kevin H. Wang, CPA/CITP
Kevin H. Wang, CPA/CITP, is director of innovation at Warren Averett CPAs and Advisors. He works out of the firm’s Birmingham, Ala., office.
Addressing continued rise in Sarbanes-Oxley Act compliance costs
An annual survey reveals higher compliance costs in 2022 and suggests that automation may present a path to better efficiency.
Using SUMIFS to sum with multiple conditions
If you need to create a sum based on more than one criteria, you can use SUMIFS.
