Excel recently released @mentions to tag specific people within the comments.
Information management and technology assurance
Collaboration with an Excel workbook
A share feature in Excel allows you to share your workbook and specify sections, tables, ranges, charts, or worksheets that need to be addressed or viewed by someone else.
A taxonomy for classifying digital assets
A nonauthoritative guide aids accountants with discussions about digital assets, general ledger account management, establishing internal controls, and complying with anticipated regulatory changes around reconciliations and disclosures.
CPA.com announces launch of generative AI initiative
The AICPA’s business and technology subsidiary announced plans to deliver a series of initiatives to build awareness and understanding of generative AI for the accounting profession.
Can ChatGPT answer your clients’ questions?
We put ChatGPT to the test with hypothetical tax questions. See if you think it’s ready to compete with a CPA.
Take refuge in a password manager
Password managers have features an Internet browser lacks that can make your life easier, such as a customized password generator and built-in authenticator for six-digit codes.
Bots emerge as cyber threat for accounting firms
Hackers are now using bots to identify and attack cybersecurity vulnerabilities on a mass scale. What can accountants do to bolster their defenses? Find out from technology and cybersecurity expert Roman Kepczyk in the latest episode of the Journal of Accountancy podcast.
Tech roundtable: Getting your data in order
Technology leaders in accounting discuss digital assets, what CPAs need to know about Web 3.0, and more in this podcast episode with transcript.
Tech roundtable: Tapping into automation and tools of the future
Technology leaders in accounting discuss when and when not to use ChatGPT and robotic process automation in this podcast episode with transcript.
How to handle AI chatbots in the classroom
AI chatbots such as ChatGPT are very popular among students. Here’s how some professors are handling them.
Get started with robotic process automation: Build your first bot
Follow this step-by-step guide to create a bot to automate simple business tasks.
Organize notes digitally
OneNote allows you to create digital notebooks to document and organize ideas, things to do, office procedures, and project notes.
Apply the same formatting to an entire Excel workbook
Applying the same formatting to each sheet
in an Excel workbook is ideal when each of your
sheets is set up the same, but it can be helpful in
other circumstances as well.
AutoFormat tables in Excel
An AutoFormat option in Excel will format your
table and allow you to choose from several options.
Digital documentation: Avoiding a business deduction disallowance
Common taxpayer lapses of substantiation can be remedied with a little awareness and versatile digital recordkeeping apps.
The promise and peril of ChatGPT
Early adopters are finding uses for ChatGPT in accounting, but the chatbot raises concerns about security and accuracy.
Increase capacity with automation
Firms should consider costs and risks to prioritize
automating repetitive tasks, panelists in our
technology roundtable suggest.
Fill blank cells in Excel
Learn how to fill blank cells in Excel.
Build ChatGPT into Excel
Many online resources demonstrate multiple codes or other ways to build ChatGPT into Excel and other applications.
Make the documentation process more efficient with Scribe
Scribe is a combination of screen recorder and documentation writer and can help build a step-by-step guide with actions and zoomed screenshots of what you typed or clicked on.
Features
FROM THIS MONTH'S ISSUE
Building a better CPA firm: Stepping up service offerings
A key step in business model modernization is determining how to implement services that satisfy clients and employees.