Advertisement
TOPICS

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.

Creating the right visuals for your data

Two leading figures in the field of data visualization explain how CPAs can best use visual depictions of numbers and how history’s “heroes of visual thinking” transformed numbers into images that carry ideas and meaning.

Add Favorites to the Ribbon

You can add all your favorite or frequently used Excel features in one tab on your Ribbon.

FROM THIS MONTH'S ISSUE

AI risks CPAs should know

Are you ready for the AI revolution in accounting? This JofA Technology Q&A article explores the top risks CPAs face—from hallucinations to deepfakes—and ways to mitigate them.