How To Create Cell Borders - Excel tutorial

Category: Excel tutorials > Formatting - Difficulty:

Calculate the Net Present Value of a series of cash flows.

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 use the formatting painter in Excel.

The are some basic aspects of spreadsheets which should be considered. When developing your spreadsheets some upfront thought can be vital. This video clip will show you how to create effective spreadsheets and reduce the risk of errors.

Learn how to sort data in Excel, including how to develop customized sort orders to meet your exact needs.