Spreadsheets for Voluntary and Community Groups

Ref: C2338560

This course is aimed primarily at secretaries and treasurers in the community sector who need to use spreadsheets to keep accounts and financial records and who have to produce regular reports. The course will cover simple accounting, book keeping and spreadsheet construction and analysis. The course will also teach how spreadsheets can be used to store information which can then be filtered and sorted. This will be a practical course based on the real needs of students and will draw on a wide range of experiences to share with students.

Course aim

This course is aimed at volunteers and staff in the community sector with with responsibility for accounts and financial reports

Do I need any particular skills or experience?

  • This course is for improvers
  • Experience of using MS Office, creating naming/storing new files and and printing.

By the end of the course I should be able to:

  • Understand the correct MS Office programme to use to carry out specific tasks eg, Word, Excel, Access etc
  • Construct and populate a simple spreadsheet which could be used for profit and loss, business accounts and reports to Boards and Trustees
  • Carry out simple calculations by the insertion of formulas into spreadsheets
  • Construct and populate a spreadsheet as a database to store complex information
  • Sort, filter data in a spreadsheet and carry out conditional formatting and data validation

How will I be taught?

  • The WEA tutor will use a range of different teaching and learning methods and encourage you and the group to be actively involved in your learning
  • You may be asked to undertake additional work in your own time to support your learning

What kind of feedback can I expect?

  • A range of informal activities will be used by the tutor to see what you are learning which may include quizzes, question and answer, small projects and discussion
  • You will have opportunities to discuss your progress with your tutor
  • You will be encouraged to share your work with the group and discuss your learning
  • You will be encouraged to consider other students work and give your opinions and suggestions
  • A file of work will be kept which will help to record your progress

What else do I need to know?

  • PCs are provided but students are encouraged to bring their own laptops. A notebook and pen are essential.

Pre-course work, reading and information sources

  • Students are encouraged to look at Excel before the course if possible but this is not essential and no prior knowledge will be assumed

What can I do next?

Download full course outline

Spreadsheets for Voluntary and Community Groups Course Outline

Enrolment Conditions

You can enrol online if you meet all of the following requirements:

  • are paying the standard fee or are on any of the qualifying benefits
  • are paying with a credit/debit card or are not paying a fee because of a qualifying benefit
  • have a valid email address
  • have been resident in the UK, EU or EEA for the last 3 years
  • are aged 19 years or older on 1st September 2017
  • have read and accept the standard terms and conditions
Visa Credit payments supported by RBS WorldPay Visa Debit payments supported by RBS WorldPay Visa Electron payments supported by RBS WorldPay Mastercard payments supported by RBS WorldPay Maestro payments supported by RBS WorldPay JCB payments supported by RBS WorldPay Solo payments supported by RBS WorldPay
RBS WorldPay Payments Processing