How to insert & use Functions in Excel Functions help you perform a variety of mathematical operations, lookup values, calculate date and time, and a lot more.

There are two other methods to use the Row function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

How to Automatically Insert the Date Onto a Spreadsheet. Microsoft Office Excel offers many tools and processes for automating actions in spreadsheets.