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

You can enrol on this course by telephone, in person or by post. Click below to find out how!

Find out how to enrol

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
Location Date(s) Course code Fees / reductions

Location:

Vernon House
Vernon House, 18 Friar Lane, Nottingham NG1 6DQ

Date(s):

21 February 2017 - 02 May 2017
12:30-15:00
TUE

Course code:

CC9609AP1Y

Fees / reductions:

Full fee: £90

This course is funding by PCDL so if you are in receipt of certain means-tested benefits and are currently looking for work you may not have to pay any fees. Please visit our Course Fees page more information.

Location:

Central College Nottingham, Maid Marian Way, Nottingham NG1 6AB

Date(s):

23 February 2017 - 27 April 2017
18:00-20:30
THU

Course code:

CC9610AP1Y

Fees / reductions:

Full fee: £80

This course is funding by PCDL so if you are in receipt of certain means-tested benefits and are currently looking for work you may not have to pay any fees. Please visit our Course Fees page more information.

Location:

Vernon House
Vernon House, 18 Friar Lane, Nottingham NG1 6DQ

Date(s):

09 May 2017 - 04 July 2017
12:30-15:00
TUE

Course code:

CC9609AP2Y

Fees / reductions:

Full fee: £90

This course is funding by PCDL so if you are in receipt of certain means-tested benefits and are currently looking for work you may not have to pay any fees. Please visit our Course Fees page more information.

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?

28/11

Computing students teach 'silver surfers'

Read more

22/11

International visit a big success

Read more

21/11

Fundraising drive by our brave lecturer

Read more