Microsoft Excel

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.

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.

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.

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 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.