Microsoft Excel & Access Intermediate Spreadsheets & Databases

Ref: C2343176

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 and Access as database programmes 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 and Access to intermediate level for accounting, budgets, project management and databases.

Do I need any particular skills or experience?

  • This course is for improvers
  • The course is ideal 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 including sorting and filtering data in a spreadsheet and carrying out conditional formatting and data validation
  • Construct a simple Access database capable of storing, sorting and reporting on data such as contacts, inventories and customer relationships

How will I be taught?

  • The WEA’s digital learning platform, Canvas will be used to provide resources or to support lessons, enable assessment, provide learner feedback and for other activities for individuals away from the course. If you want to understand more about our digital learning platform please visit:
  • 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?

  • You will be able to keep a record of your progress and achievement using photos, audio, text or documents uploaded into the WEA’s digital learning platform, WEA Canvas.
  • Your tutor will provide written, text and audio feedback recorded in WEA Canvas, WEA’s digital learning platform.
  • You will be able to keep a digital portfolio of your work on WEA’s digital learning platform, Canvas.
  • 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 or Access 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 and Access programmes.

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
  • 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

Microsoft Excel & Access Intermediate Spreadsheets & Databases

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 2019
  • You have read and accept our standard terms and conditions

Not sure or have further questions? Contact

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