Introduction to Excel Spreadsheets

Ref: C2341199

The course will be in two parts. This first half of the course will cover the use of Excel for accounting and the use of spreadsheets to keep accounts, financial records, produce balance sheets and profit and loss accounts. The second part of the course will cover the use of Excel as a database programme including searching, sorting, data validation and macros. 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 students who have a good working knowledge of Windows and MS Office and want to learn how to use Excel for accounting, budgets etc and have an overview of excel as a database

Do I need any particular skills or experience?

  • This course is for improvers
  • The course is for students who may be treasurers of community groups, a small business or other voluntary activity and need to produce accounts or budgets, or those who need to do store information and sort it for business/charity purposes

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

  • Use the correct MS Office programme to use 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 etc
  • Carry out simple calculations by the insertion of formulas into spreadsheets and link sheets etc
  • Construct and populate a spreadsheet as a database to store simple 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
  • There will be a number of tasks appropriate to your course such as written work, creating art or craft, video, photography or small projects. Some of these may be marked to help you progress

What else do I need to know?

  • laptops are provided but students are encouraged to bring their own laptops to create and save spreadsheets that are relevant to themselves. A notebook and pen are essential.

Pre-course work, reading and information sources

  • Whilst no previous knowledge of Excel is required students are expected to have a good understanding of Windows, file management and opening and closing MS Office Programmes. The course will focus on the Excel programme.

What can I do next?

  • Progress to another WEA course
  • Progress to a course with another provider
  • This course could lead to a range of job opportunities. Follow link to National Careers Service for more details https://nationalcareersservice.direct.gov.uk/
  • Become involved with the WEA in a range of voluntary work and other activities including campaigning as a WEA member
  • Become involved as a volunteer for a WEA partner or another organisation

Download full course information sheet

Introduction to Excel Spreadsheets

Enrolment Conditions

As a registered charity, and to meet our funders’ requirements, we need to check a few things with you before you book. Please could we ask that you check the list below to ensure you meet our basic criteria:

  • You are paying the standard fee (with a credit or debit card) or you are on any of the qualifying benefits
  • You have a valid email address so that you can receive confirmation of your booking
  • You have been resident in the UK, EU or EEA for the last 3 years
  • You are aged 19 years or older on 1st September 2018
  • You have read and accept our standard terms and conditions

Not sure or have further questions? Contact courseenquiries@wea.org.uk

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