How to use Filter and Advanced Autofilter in Excel - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

Due to the size of spreadsheets it would sometimes be useful to quickly highlight all cells exhibiting the same criteria. This features allows you to highlight cells that contain comments, constants or formula, blanks, Objects (pictures, buttons, etc), cells in rows or columns that are different from their neighbors, precedents and dependents, last cell in a sheet, and cells with conditional formatting or data validation.

This video tutorial shows how to change the color fill of a cell in Excel.

Liven up boring pie charts, by adding pictures to them.

Calculate the interest RATE charged on a constant annuity cash flow.

This video tutorial shows how to change the font of the chart legend in Excel.