It looks like you have JavaScript turned off

Pretty much everything should work. But you may find some components look slightly off as a result. You can find out what JavaScript is here. If you don't have JavaScript turned off, or if something doesn't work that you think should do, please email websiteteam@centralnottingham.ac.uk.

Microsoft Units - Spreadsheets (Level 1)

Accounting Spreadsheet

Course outline

This course consolidates existing knowledge of Microsoft Excel.

  • Enter, Edit and organise data
  • Use Page Setup – fit data to one page, use of margins and headers/footers
  • Formulas to include: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTBLANK, COUNTIF, SUMIF, ROUND, TODAY, VLOOKUP
  • Absolute and Relative formulas with the use of the $ sign
  • Creating charts (Column, Pie and Line)

Next steps

It is no longer possible to enrol on this course, however, we may be running the course again in the future!

Want to find out more first?

Get in touch by hitting the button below and filling out our enquiry form.

Download a guide Get in touch
Qualification

Level 1 Certificate

Duration

9 weeks

Level Level 1
Entry requirements

You must be comfortable using a computer and have some experience of Microsoft Office.

Teaching & assessment

You will complete tasks throughout the course and build a portfolio, there is no formal exam.

Progression

Progression routes can be discussed with the tutor at the end of the course.

Additional information

The use of a personal memory stick would be helpful.

Related courses
Programme Of Study Media Panel

Course fees 

You may be able to study for free! Check whether you are eligible here.

Application

Practical information 

Do you need any help or support while at College?

19/05

Inspiring creative careers

Read more

12/05

Awards success for talented Nottingham students

Read more

11/05

Celebrating Caring Nurses

Read more