Data analytics is a new means to the same end: providing high-quality and timely information to decision-makers.
Information management and technology assurance
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.
Work with other departments to bring more tech to your curricula
Follow these tips for successful interdepartmental collaborations.
Calculating the issue price of a bond using the NPV function in Excel
When teaching financial accounting, faculty often discuss bonds payable and how to calculate the issue price of a bond. Consider teaching students to calculate the issue price by using the net present value function in Excel.
A road map for learning data analytics
Models can help faculty teach — and students grasp — this important subject.
Helping clients build a cyberattack recovery plan
CPAs can play critical roles in helping companies plan
their recovery from online attacks.
How to hide zero values
In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.
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.
