Excel and Spreadsheets Intermediate Level

Ref: C3128896

This course is designed to expand your Excel skills. To not just create column, bar and pie charts but to edit their background and designs and link them to Word documents. Practice using more complex formulae like: IF, THEN, OR, AND, ELSE, cell referencing and extracting data from sorts and filters.

Course aim

To build on skills from the introduction course or for those already using Excel for basic charts, formulae, sorts and filters. This course involves more complex formulae, charts, sorts and filters and how to extract data into other documents.

Do I need any particular skills or experience?

  • This course is for beginners and improvers

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

  • Create, update, format, link and print out charts.
  • Use more complex formulae like: IF, THEN, ELSE, OR, AND, SUMIF, COUNTIF.
  • Use cell referencing.
  • Sort and filter in more depth and the extract data.

How will I be taught?

What kind of feedback can I expect?

What else do I need to know?

An internet connection, digital device with sound and video so that you can use our video learning platform, Zoom and a personal email address to join the WEA’s digital learning platform.

Pre-course work, reading and information sources

What can I do next?

View full course information sheet

Excel and Spreadsheets Intermediate Level

Is this course right for me? Request more information

If you don't have a pin, please call 0300 303 3464 to enquire about enrolling on this course.

Conditions

As a registered charity, and to meet our funders’ requirements, we need to check a few things with you before you enrol. Please check the details below to ensure you meet the basic eligibility critiera:

  • 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 2021
  • You declare that the address you provide is correct and that you will provide evidence of this and your eligibility to live and work in the UK
  • 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