Marjon Community News Hub

Pick and Mix Spreadsheet Sessions - cherry-pick your way and improve your skills

Picture of Kathryn Parker
Pick and Mix Spreadsheet Sessions - cherry-pick your way and improve your skills
by Kathryn Parker - Thursday, 19 January 2017, 10:14 AM

Spreadsheets – Formulas, Operators and Cell Referencing
With: Mersedes Farjad/Tracey Eaton/Helen Day-Cocking
Week Commencing: Monday 23 January 2017
Venue: IT Training & Support Training Room (access via 24 hour computer room)

This taught session will be repeated three times during the same week.  Learners need to book for only one session.

Topics covered in this session:


  • Creating formulas
  • Good Practice: The easy way to create formulas
  • Copying formulas


  • Order of operations
  • Using operators in formulas
  • Formula error messages

Relative & absolute cell referencing:

  • Relative cell referencing within formulas
  • Absolute cell referencing within formulas

Mixed cell referencing

Click here to book your session.  If you are unable to book for a session please contact IT Training & Support and we will try to resolve the issue.

For more information about the Spreadsheet module and what is covered each week, please refer to the attached schedule.

Click here to access the Task Sheet and associated files.  This is a guideline of what is covered in the session. If you are able to complete this sheet without any help, then you do not need to attend this taught session. Simply email the completed Task Sheet to the team for marking and feedback.

If you are unsure about some of the topics, why not book in for one of our drop-in sessions and we can go over them with you.

If you are unsure about most of the topics then we would strongly recommend you attend the taught session.

If you have any problems accessing/saving the files please contact the team and we will email the files to you.

If you would like more information regarding the ECDL qualification please contact us