10 types of Excel charts for data visualization
This column tours of some of the most useful charts, starting with the basic ones and moving to the more advanced.
Microsoft Excel
Using ChatGPT-4o with Excel
Learn how to use the new ChatGPT-4o (Omni) to interact with Microsoft Excel.
Identify and delete duplicates in Excel
This article looks at a few ways to identify duplicates in Excel.
How to create a watermark in Excel
This column shows a couple of ways to create a watermark in Excel.
How to find errors in Excel formulas
This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.
Change text to sentence case in Excel
In this month’s column, find out how to change text strings to sentence case in Excel.
Move quickly with Excel’s Navigation Pane
The Navigation Pane in Excel is a useful tool that allows users to easily move around and manage large workbooks.
Resources for advancing your Microsoft skills
This column discusses the resources available to help sharpen your Microsoft skills.
Exploring Excel’s dynamic FILTER function
The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be shown.
Record tasks in Excel with Automate
The Automate tab allows you to create and run Office Scripts, which allow users to automate tasks in 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.
Import data from a picture into Excel
Excel allows you to extract data from a picture.
Incorporate text in one cell using Fill/Justify in Microsoft Excel
You can combine text that is separated into multiple cells 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.
