Course Description

Formulas and functions enable you to perform calculations on a worksheet. Excel can perform simple calculations, such as summing a column of numbers, or very complex calculations such as calculating financial, statistical or engineering information.

By the end of this module, you will be able to

• Define formula and function

• List the mathematical operators used in Excel

• Explain how references to cells or ranges are used in formulas and functions

• Use the Sum and Average functions

• Use the AutoSum command

• Understand how to copy formulas and functions

• Explain relative and absolute cell references

• Understand how to move formulas and functions

• Describe methods for troubleshooting formulas and functions

Estimated completion time (hours): 1.7