This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.
Information management and technology assurance
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.
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?
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.
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.
‘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.
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.
Microsoft Excel: How to make Social Security numbers private
How to print a report with truncated Social Security numbers.
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.
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.
Microsoft Word: Enable Word’s AutoRecovery tool
How to turn on Microsoft Word’s AutoRecovery tool.
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.
Expanding your app-titude
Duet display enables an additional monitor … Turo brings Airbnb model to car rentals
Microsoft Excel: 3 quick tips
Handy Excel tips from “Technology Q&A” author J. Carlton Collins, CPA.
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.
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.
Microsoft Office: Outlook 2016 search tips
How to use Outlook’s Advanced Find tool.
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.
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.
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.
Features
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.
