Learning Outcomes

In this free course, you will learn how to:

• Discuss Excel and error messages in Excel
• Analyse how to use ‘trim’ and ‘truncate’ functions
• List examples and uses of spreadsheet applications
• Identify ‘mode’ and ‘mod’ functions
• Explain worksheet and cell name (cell reference)
• Describe factorial and absolute value functions
• Identify ‘active cell’, ‘name box’ and ‘formula’ bar
• List the comparison operators in Excel
• Discuss spreadsheet simple formulas
• Describe how to use ‘concatenate’ and ‘log’ functions
• Summarise the uses of ‘standard deviation’ and ‘power’ functions
• Explain the ‘And’, ‘Or’ and ‘IF’ functions