Find out how to add a border to only part of a document, make Excel find cells for you, and create a calculated field that concatenates two or more text fields.

Excel's functionality includes chart options you can insert to add a title directly onto a line graph, so that you don't have to insert extra text boxes or type into the cells around the graph.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

And that’s it. It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations. Next, you’ll add calculations to your table.