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

Please contact the College on 0115 914 6414 or 0115 9100 100 for details on how to enrol on this course.

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):

12 September 2017 - 21 November 2017
12:30-15:00
Tuesday

Course code:

C011816/Q011817

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:

Maid Marian Way, Nottingham NG1 6AB

Date(s):

14 September 2017 - 23 November 2017
18:30-20:30
Thursday

Course code:

C011813/Q011814

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

8-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
How To Apply Media Panel

Practical information 

Do you need any help or support while at College or need to know how to get here?

How To Apply Media Panel2

How to apply 

Find out how easy it is to apply for a full-time course at Central and learn more about the application…

Course Guide 2

Course fees 

Need help with tuition fees, travel or equipment costs? We may be able to help you!

24/08

Blog post - GCSE results – what next?

Read more

16/08

Apprentices get ahead

Read more

11/08

Bidding a fond farewell to our Chinese visitors

Read more