The Automate tab allows you to create and run Office Scripts, which allow users to
automate tasks in Excel.
Microsoft Excel
Hear all about it: What’s in the December JofA
The JofA’s editor-in-chief highlights the news, features and advice that CPAs will find useful in the December issue of the magazine. Listen to the podcast or read the transcript.
Change the orientation of text in Excel
You can choose from several text orientations in Excel.
Using Data Validation to circle specific data in Excel
You can automate the task of inserting red circles around items using Data Validation tools.
Incorporate text in one cell using Fill/Justify in Microsoft Excel
You can combine text that is separated into multiple cells in Excel.
Import data from a picture into Excel
Excel allows you to extract data from a picture.
Join text in Excel
This article offers four methods to join usernames to the @ symbol and domain.
Writing advanced Excel macros with GPT-4
For a fee, the AI tool offers more computing power to help automate repetitive tasks such as cleaning data.
Use Forms to collect client feedback
Surveys are great for collecting information from your clients, and using software to collect responses makes generating reports and metrics a breeze.
Bring attention to a comment in Excel with @mentions
Excel recently released @mentions to tag specific people within the comments.
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.
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.
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.
Features
FROM THIS MONTH'S ISSUE
4 ways solo practitioners can stand out
Five years ago, a grieving Angel Zhen started his own CPA firm with no clients and no revenue. Today, he has 300 clients, $600,000 in revenue and 12 weeks of annual vacation. In this JofA article, he shares how he set up his firm and how you could do the same.
