Accounting technology news and resources

TOPICS

December 8, 2020

Use VLOOKUP to help manage your gradebook

VLOOKUP is a formula that allows you to “look up” certain data and retrieve it into another table, by row. This function can be especially useful when you have a well-structured table with information organized by rows (such as a gradebook)!

December 8, 2020

9 tips for teaching data analytics

Four professors offer insight and advice on this challenging subject.

December 2, 2020

New report highlights digital transformation during COVID-19 and beyond

Get some insights on how CPAs and finance professionals are using technology solutions to change their businesses in the era of COVID-19. A new report will guide a long-term, strategic approach to drive digital success, manage risk and streamline costs.

December 1, 2020

Tech tools

3 ways to professionalize your Zoom presence … Fun farm

December 1, 2020

Data preparation for CPAs: Extract, transform, and load

ETL tools can help accountants streamline the process of preparing data for analysis and aid in better decision-making.

December 1, 2020

4 more OneNote tips

What else can you do with OneNote? Here are four more tips.

November 30, 2020

4 technology gift ideas for CPAs

This article discusses some gadgets and gizmos that might make a CPA’s life a little bit better — or at least more fun.

November 23, 2020

3 tips for building remote-work policies that last

This article discusses ways firm owners and leaders can start to develop a strategy for a work-from-anywhere reality that lasts.

November 10, 2020

Use the Quick Access Toolbar to increase your efficiency in Excel

Try this tip and have your most-used functions right at your fingertips.

November 1, 2020

Excel 365 has X-cellent upgrade over VLOOKUP

Kelly L. Williams, CPA, Ph.D., explains how to use XLOOKUP, a new function for Excel 365 users that essentially replaces VLOOKUP and HLOOKUP.

November 1, 2020

Tech tips for remote work

Maximize comfort and productivity with an optimized internet connection and a decluttered digital desktop.

November 1, 2020

Check your exposure on the dark web

A look at applications, gadgets, and other technology that can improve a CPA’s job and life.

November 1, 2020

4 ways to unleash the power of OneNote

The key to success with OneNote is having a good understanding of its architecture and enabling some of the less obvious features that supercharge the tool.

October 27, 2020

Cybersecurity provides opportunities for auditors to serve

Practitioners can provide services to clients related to cybersecurity beyond their financial statement auditing role, according to a newly published report from the Center for Audit Quality.

October 13, 2020

3 things the COVID-19 pandemic has taught CPAs about technology

This article discusses ways to harness technology lessons from this pressure-packed year.

October 8, 2020

Fair value, stablecoins addressed in new AICPA guidance

Nonauthoritative set of 13 Q&As also touches on how investment companies and broker-dealers should account for digital assets.

October 1, 2020

Tax consequences of data breaches and identity theft

Losses are not likely deductible by individuals through 2025, but the receipt of free identity protection services may be nontaxable.

October 1, 2020

Dock can help cure home office blues

A look at applications, gadgets, and other technology that can improve a CPA’s job and life.

October 1, 2020

Using LEFT, MID, RIGHT to dissect Excel cells

It is very easy to dissect the contents of a cell in Excel using the functions LEFT, MID, and RIGHT. All three functions are easy to learn.

October 1, 2020

Answering 7 questions about remote work

Months after COVID-19 forced most accountants to work remotely, we answer questions on how to optimize working conditions at home.

FROM THIS MONTH'S ISSUE

How a CPA beat burnout after strokes, depression

Randy Crabtree, CPA, suffered two strokes in four days and struggled with his mental health for years before he learned to recognize, address, and prevent chronic stress. Learn from his insights on how CPAs can avoid professional burnout.