Accounting technology news and resources

TOPICS

December 1, 2017

How to boost Excel efficiency with Power Query

This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.

November 27, 2017

Basic Excel time-saving tips

This column offers tips on features, shortcuts, and tools that can save time, improve the integrity of workbooks, and simplify data analysis.

November 17, 2017

Blockchain: An opportunity for accountants? Or a threat?

Will blockchain technology have a similar harmful effect on CPAs, or will it merely become a useful tool for accountants?

November 3, 2017

Cybersecurity tips from the ‘Shark Tank’

Shark Tank star and cybersecurity expert Robert Herjavec said CPAs have an important role to play as trusted advisers on cybersecurity.

November 1, 2017

How to find the best prices

Dozens of free price-checking apps are available to help you instantly price-check items by scanning an item’s bar code.

November 1, 2017

‘We have to be bold’

Eric Hansen, CPA, CGMA, incoming chair of the AICPA board of directors, envisions a prosperous future for the profession in a rapidly changing environment.

November 1, 2017

Expect the unexpected: Risk assessment using Monte Carlo simulations

Modern computing power, combined with software including Microsoft Excel, can produce advanced statistical models to analyze the risks of business opportunities.

November 1, 2017

Microsoft Excel: How to make Social Security numbers private

How to print a report with truncated Social Security numbers.

November 1, 2017

Accounting and ERP systems: A look inside drillable financial statements

Drillable data is not only easy to navigate, it also provides a stellar audit trail sure to make any auditor smile.

November 1, 2017

Microsoft Excel: Fixing a proofing formula that fails every time

The problem, it turns out, is related to Excel’s famous built-in 15-digit number limitation.

November 1, 2017

Microsoft Word: Enable Word’s AutoRecovery tool

How to turn on Microsoft Word’s AutoRecovery tool.

October 22, 2017

Accountants’ role in managing AI disruption

An AICPA fall Council session addressed how accountants can prepare for the change and lead their communities’ response to the new technology.

October 1, 2017

Expanding your app-titude

Duet display enables an additional monitor … Turo brings Airbnb model to car rentals

October 1, 2017

Microsoft Excel: 3 quick tips

Handy Excel tips from “Technology Q&A” author J. Carlton Collins, CPA.

October 1, 2017

Cybersecurity: A new engagement opportunity

CPAs who possess the appropriate expertise can perform new consulting and attest services for clients under a recently released AICPA framework. Developing expertise in this area is the key.

October 1, 2017

Amazon Echo vs. Google Home: Which is better?

So which device is better: the Echo or Home?
Through continued improvements, they keep leapfrogging each other in functionality in specific areas.

October 1, 2017

Microsoft Office: Outlook 2016 search tips

How to use Outlook’s Advanced Find tool.

September 12, 2017

10 things to know about Apple’s new iPhone X

Apple unveiled its new iPhone X with a nearly $1,000 price tag. Is the new iPhone a grand improvement? Here’s a look at 10 features you should know about.

September 1, 2017

Microsoft Excel: How to link text boxes to data cells

Yes, it is possible to link the contents of a text box in Excel to data in a cell.

September 1, 2017

Expanding your app-titude: When I Work makes shift scheduling less of a chore

A monthly look at apps and websites that can make the CPA’s job and life better.

FROM THIS MONTH'S ISSUE

Making the right choice when no one is watching

The true test of one’s character is the decision made when no one is looking over your shoulder. Learn how CPAs can uphold ethical standards and take actions that help limit liability risk.