Learn how to fill blank cells in Excel.
Microsoft Excel
Build ChatGPT into Excel
Many online resources demonstrate multiple codes or other ways to build ChatGPT into Excel and other applications.
Improve audit sampling efficiency with Excel’s Solver tool
Artificial intelligence capability can significantly reduce the time and effort auditors devote to sampling estimation tasks.
Quick Excel tips for accountants
This article offers a few quick Excel tips for varying levels of proficiency.
Convert dates using Arabic numerals to dates with Roman numerals
If you have several dates written with Arabic numerals, there are steps to convert them all to Roman numerals.
Update AutoRecover setting in Microsoft Excel
By default, AutoRecover is set to save every 10 minutes, but you can set it to save more often.
Using ChatGPT with Excel
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.
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.
Features
FROM THIS MONTH'S ISSUE
Real-life ways small firms use AI
Learn how four small firms use artificial intelligence to automate processes while maintaining strong oversight.
