Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.
Advertisement
TOPICS
Information management and technology assurance
How we successfully implemented AI in audit
A partner at Garbelman Winslow CPAs describes the Maryland firm’s experience using machine learning to improve its audit process.
Microsoft Excel: More Dynamic Arrays functions
In addition to the new SORT function, you may also find the new FILTER and UNIQUE array functions useful.
What’s ‘critical’ for CPAs to learn in an AI-powered world
The experts in our eighth annual accounting
technology roundtable focus on the development of machine-learning algorithms, along with the new skills and ways of thinking necessary to keep pace with AI.
Ask the expert: Technology in lease accounting
Donald J. Coduto is a KPMG Advisory leader for the firm’s implementation initiatives related to the new lease accounting standards and is assisting several large multinational organizations with their adoption of the new lease accounting standards.
Accounting firm data breaches: One state’s records
An examination of Maryland’s records of accounting firm data breaches reveals what is known about these illicit activities and how to protect your firm.
Firms lose cloud access after Cetrom systems breach
A new breach affecting services used by CPA firms was confirmed when cloud services provider Cetrom said it suffered a malware attack that was discovered May 24.
Better computer and mobile device hygiene
Have you ever had a stranger ask to borrow your mobile phone? Do you connect to public Wi-Fi networks? Cybersecurity expert Mike Foster has advice for handling those situations.
How organizations can better fend off cyberattacks
Cybersecurity is a multifaceted, ever-changing concern of organizations. Cyber expert Mike Foster offers advice for keeping their networks secure.
4 key steps for auditors in assessing technology risks
The business risks associated with new technology seem almost endless. But a new resource can help auditors, management and audit committees discharge their responsibilities associated with those risks.
Talking ’bout bots, AI, and the value of time
Rather than seeing technology as “taking over” the work they do, CPAs should take the opportunity to brainstorm with clients and staff about how to add value to businesses.
4 ways to save time in Excel
This article offers tricks to make you more efficient and effective with the spreadsheet application.
Wolters Kluwer takes services offline after malware attack
Following a malware attack, cloud tax and accounting services provider Wolters Kluwer took a number of its platforms and applications offline this week.
Award helps fund research on blockchain’s effect on auditing
The researchers will receive $15,000 in funding and access to 120 auditors to further their blockchain research.
Outlook now auto-detects POP3 accounts
The POP3 mail account settings are still there, but they have been relocated to a nonintuitive menu location.
Google Chrome’s numerous processes
As far as the Chrome app goes, the use of separate processes is intended to help make the product more stable. However, the search tools and internet provider you use are different matters.
A dozen Excel time-savers
I’ve compiled a list of a dozen Excel tricks that will help any CPA become more efficient and effective.
Discovering a better answer
Meet Bill Reeb, CPA/CITP, CGMA, the AICPA’s 2019–2020 chair.
Software offers ‘Fresh’ approach to small business invoicing
FreshBooks is a basic bookkeeping software package that specializes in providing invoices for very small businesses and freelancers. Launched in 2004, FreshBooks today offers cloud-based bookkeeping tools to manage invoices, payments, and expenses, and also to provide minimal time management.
Help students embrace emerging technologies
Educators and practitioners play an important role in helping students succeed in the evolving profession.
Features
FROM THIS MONTH'S ISSUE
How to set up an effective internship program
Learn how firms can recruit stronger interns and build robust on-ramps for talent by following five recommendations.
From The Tax Adviser
July 31, 2026
Current developments in S corporations
July 31, 2026
