This month’s column explains how the new AI tool known as ChatGPT can help with challenging Excel tasks such as creating PivotTables and writing macros.
Microsoft Excel
Calculating double-declining balance depreciation for tax purposes in Excel
Variable-declining balance uses the double-declining factor but also initiates the automatic switch to straight-line depreciation once that is greater than double-declining.
Automatically create subtotals in Excel
There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.
Automatically color-code cells in Microsoft Excel
You can automatically have cells turn certain
colors based on the text within those cells. This
is easily done using one of the many types of
conditional formatting.
Using Power BI for advanced QuickBooks data analytics
Try these two ways of analyzing and reporting QuickBooks Online data using Microsoft’s Power BI Desktop Version.
Using Advanced Filter in Excel
Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.
Using COUNTIF and COUNTIFS in Excel
COUNTIF is used to count items based on one criterion, while COUNTIFS is used to count items based on multiple criteria.
Efficient ways to open Microsoft Excel
There are a couple of ways to have Excel open most conveniently for you.
Smart Lookup in Microsoft Excel
You can quickly look up text from your Excel spreadsheets from several online sources.
Increase time increments by minutes in Excel
You can incrementally increase times for your agenda by a certain number of minutes.
Change the case of text in Excel
You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.
Using 3D formulas in Excel
Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.
Extract and present information about dates in Excel
This article looks at a few ways to extract and present information about the day, month, and then year.
When autocorrect is a problem in Excel
There are two ways to solve an autocorrect problem such as the one in the question above — a temporary solution and a permanent solution.
Using SUMIFS to sum with multiple conditions
If you need to create a sum based on more than one criteria, you can use SUMIFS.
Features
FROM THIS MONTH'S ISSUE
AI risks CPAs should know
Are you ready for the AI revolution in accounting? This JofA Technology Q&A article explores the top risks CPAs face—from hallucinations to deepfakes—and ways to mitigate them.
