Microsoft Excel

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.

An AutoFormat option in Excel will format your
table and allow you to choose from several options.

Learn how to fill blank cells in Excel.

This article offers a few quick Excel tips for varying levels of proficiency.

If you have several dates written with Arabic numerals, there are steps to convert them all to Roman numerals.

By default, AutoRecover is set to save every 10 minutes, but you can set it to save more often.

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.

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.

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.

Learn how to filter data using wild cards and other complex criteria using Advanced Filter in Excel.

COUNTIF is used to count items based on one criterion, while COUNTIFS is used to count items based on multiple criteria.