Accounting technology news and resources

TOPICS

January 1, 2022

Card-carrying ways to automate expense reports

Just about everything we do daily has been automated in some way. And that includes expense reports.

January 1, 2022

4 cool features for optimizing Outlook

Here are four features that can help you make the most efficient use of Outlook.

December 20, 2021

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.

December 7, 2021

Work with other departments to bring more tech to your curricula

Follow these tips for successful interdepartmental collaborations.

December 7, 2021

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.

December 7, 2021

A road map for learning data analytics

Models can help faculty teach — and students grasp — this important subject.

December 1, 2021

Helping clients build a cyberattack recovery plan

CPAs can play critical roles in helping companies plan
their recovery from online attacks.

December 1, 2021

How to hide zero values

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

December 1, 2021

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.

December 1, 2021

Using the Excel personal assistant

Excel Personal Assistant can help you locate all the features Excel has to offer.

November 23, 2021

6 lessons from audit experts who adopted AI early

Machine learning is within reach for many audit firms.

November 18, 2021

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.

November 9, 2021

Performing a simple linear regression in Excel

When teaching cost behavior in a managerial or cost accounting course, we explain that there are various methods a company can use to estimate its fixed and variable costs, including regression analysis. The next time you cover this topic, consider teaching students how to perform a simple linear regression analysis in Excel.

November 1, 2021

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.

November 1, 2021

Journal-entry testing using Excel

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

November 1, 2021

5 advanced PowerPoint tips for awesome presentations

This month’s column lays out five tips designed to help even experienced users of Microsoft PowerPoint push their presentations to the next level.

October 22, 2021

AI in manufacturing: Optimizing costs and enabling the workforce

Manufacturing leaders can use artificial intelligence to improve efficiency and drive growth. But taking full advantage of the technology requires upskilling the workforce.

October 18, 2021

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.

October 12, 2021

The Excel Advanced Filter function gives you flexibility

Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook.

October 1, 2021

Cleaning and joining data using Excel’s Power Query

This month’s column shows how to clean and join data using Excel’s Power Query.

FROM THIS MONTH'S ISSUE

Start in high school to strengthen the accounting profession

A practitioner-led outreach program, born of a university, accounting professionals, and local community collaboration, shows how to successfully engage high school students with the modern accounting profession.