Skills - Spreadsheet Methods

Aim:
To provide practical experience in the use of spreadsheet software in typical business and other activities

Course Content:

•  Enter numeric and character data to a spreadsheet
• Enter formulae to generate results
• Format column entries
• Creating & using templates
• Use basic functions SUM, AVG
• Use absolute cell references
• Use the single condition IF function with relational operators
• Create graphs
• Use formulae containing both absolute and relative cell references
• Use multiple IF functions with logical operators
• Use the LOOKUP function
  

Night: tbc. Duration: 1 day Fee: tbc