Professional Development

Microsoft Excel Formulas

What is a formula in Excel? It is a way for you to make calculations on data that is already written in the spreadsheet. What's best about formulas is that they are linked to the data in such a way that if the data changes, it will show you an updated result, reflecting the change. Learn how the fill handle helps you repeatedly copy the same formula across the worksheet. One of the objectives in learning formulas is understanding the concepts of absolute referencing and relative referencing. This session teaches participants how to use values from cells from other worksheets inside a single formula, and integrate data from multiple worksheets.