Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information
is entered into a cell.
Information management and technology assurance
7 tips for using Zoom better
This article offers Zoom tips that cover everything
from basic reminders to advanced advice.
Combining formulas and text in the same cell in Excel
You can include both a formula and text in the same cell in Excel.
Tax pros are subject of ‘spearphishing’ attacks
Bogus emails may impersonate the IRS or tax software providers. Here’s what to watch out for.
How not-for-profits are adapting to a technological revolution
To get the most out of their technology spending not-for-profit leaders need to develop a strategy, consider cybersecurity, and recruit tech experts for the board.
Teach students to address accounting questions using data analytics
Data analytics is a new means to the same end: providing high-quality and timely information to decision-makers.
How to easily transpose data in Excel
The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.
Federal security agencies warn of potential Russian-sponsored cyberattacks
A joint cybersecurity advisory from the Cybersecurity and Infrastructure Security Agency, the FBI, and the NSA urges businesses and other organizations, to step up their cybersecurity mitigation and detection efforts.
A blockchain glossary, the CPA firm of the future, and Excel malware
Blockchain — what does it mean to you? A glossary of terms offers clarity. Also, hear or read more about accounting firms’ tech-integrated future.
Avoid these 8 PowerPoint mistakes
PowerPoint blunders can make your presentations painful to sit through. Try these tips to make your talks clearer, more concise and more memorable.
Cyberattacks via Excel add-ins jump nearly 600%
Report finds huge surge in malware infections via .XLL files.
Automate routine data entry with Excel Flash Fill
If Excel can sense a pattern in what you are doing,
it will try to complete the task for you.
Embracing technology in the audit
Firms and practitioners are using digital tools to provide more value to clients.
Transposing data in Excel
You can easily convert horizontal data to
vertical and vertical data to horizontal by using the
Transpose feature in Excel.
How to spill formulas in Excel
With spilling, you can create a formula in one cell, and that formula will then spill over into other adjacent cells when a set of values is calculated.
Companies urged to bolster defenses against ‘triple threat’
Businesses are experiencing more, and more costly, incidents of fraud, compliance breaches and cyberattacks but are not doing enough to protect themselves, KPMG says in its 2022 Fraud Outlook report, A Triple Threat Across the Americas. The report recommends five steps companies can take to mitigate the risk of losses to this “triple threat” of dangers.
Using range names in Excel
Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.
Card-carrying ways to automate expense reports
Just about everything we do daily has been automated in some way. And that includes expense reports.
4 cool features for optimizing Outlook
Here are four features that can help you make the most efficient use of Outlook.
5 key steps for digital transformation during a crisis
Major changes can be difficult to implement at any time but especially during a pandemic. Here are some lessons learned from a successful system implementation.
Features
SPONSORED REPORT
Preparing clients for new provisions next tax season
As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.
