Excel+Formula

Using formulas in an excel spreadsheet is a great way to quickly gather the information you want on your table and put it together in whatever way you want; you can use numerous amounts of different formulas. You don't always have to use the insert function button, it can be typed up in the table. You begin the formula by using an equal sign and typing in the 4-6 letter code for the formula.

Formula Autocomplete, automatically suggests function names, arguments and named ranges, and automatically completing them if desired, based on the characters entered. Formulae can refer to a table as well.

The use of formulas can help you be very efficient and effective with your spreadsheet and displaying information to its viewer.