Part time Spreadsheets Level 2 IT323

Spreadsheets - Level 2 IT323
QualificationOCR Spreadsheet Software Level 2
Qualification Level
Level : 2
What do these levels mean?

Duration :12 weeks - 3 hours per session

Times :See below.

Dates

• 06 January - Wednesday 2.00pm - 5.00pm

Run by : IT, Business and Professional Studies Department.
Tutor : John Reynolds

Awarding Body
Oxford, Cambridge & RSA Examination Board (OCR)

Is it right for me?
On this intermediate course you will learn how to make better use of Excel, either at work or for home use. Building on a good understanding of the basic features, we quickly move onto some more advanced aspects. This course provides 6 credits towards the Level 2 ITQ qualification.

What qualifications will I need?
Successful completion of the level 1 'Spreadsheets & Databases' course.

What will I be learning about?

• Create Spreadsheets using the functions SUM, COUNT, AVERAGE, MAX & MIN.
• Use the Function Wizard & the AutoSum Key.
• Work with Percentages ' calculate VAT from Gross.
• Excel as a Database ' Sort & Filter from an Excel Table.
• Analytical functions such as SUMIF, COUNTIF & VLOOKUP.
• Create Macros to automate operations ' create Macro Buttons.
• Work with Relative, Mixed & Absolute cell references.
• Create spreadsheets in a professional way.

Students will be expected to complete a test paper.

What else does the course include?
null

What is next?
Further IT courses

How much will it cost?
Total - £135

Money Matters