Advertisement
TOPICS

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.

How to hide zero values

In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.

Using stocks and other data types in Excel

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

Career advice and RPA tips from CPA leaders

One CPA leader shares more on being a lifelong learner and the advice she gives to up-and-coming accountants; another leader explains some of the opportunities that firms have to automate certain processes and begin to offer more advisory services.

Ask the expert: Road to digital transformation

Guy Pearson is a Chartered Accountant, Chairman of Interactive Accounting, a progressive accounting firm he founded in 2009, and an angel investor in a portfolio of companies.

Journal-entry testing using Excel

In this example walk-through, learn how to use Microsoft’s spreadsheet application to perform several tasks, including sampling.

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.