Read the latest information and advice on the Coronavirus (COVID-19) — Latest information

Close

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 get in touch.

Microsoft Units: Spreadsheets (Level 1) - Part-time

Business Sales

Course outline

This course will consolidate existing knowledge of Microsoft Excel at Level 1 using Microsoft Office 2016.

  • Understand the ribbon in excel.
  • Enter data, numbers and symbols in the relevant cells.
  • Understand the different mouse shapes.
  • Edit and format text and adjust text alignment.
  • Calculate using formulae including SUM, AVERAGE, COUNT, COUNTA, MIN and MAX.
  • Display formulae and print.
  • Use of Autosum, Autofill and Absolute cell referencing.
  • Layout and print worksheets.
  • Save/open file into specified drives and folders.
  • Use Page Setup – fit data to one page, use of margins and headers/footers.
  • Create and modify charts (Column, Bar, Pie and Line). Use of basic IF and COUNTIF functions.

How to apply for this course

Apply now and if you need to pay any course fees, or provide evidence if you wish to claim a fee reduction, we will contact you to let you know how to do this.

For help on completing the online application form, please see our useful apply online guide here.

Choose an option below and press apply now.

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 / time Fees / reductions
Maid Marian Way
Nottingham
NG1 6AB

Start: 8th September 2020

End: 10th November 2020

Time: 9:30 AM - 12:30 PM

Day: Tuesday

Tuition fee: £108

Tuition fees may be waived if you are in receipt of certain benefits. Please see our Financial Help page to see if you can claim a fee reduction.

Course code: C003639 / Q003871

Maid Marian Way
Nottingham
NG1 6AB

Start: 17th November 2020

End: 12th January 2021

Time: 9:30 AM - 12:30 PM

Day: Wednesday

Tuition fee: £108

Tuition fees may be waived if you are in receipt of certain benefits. Please see our Financial Help page to see if you can claim a fee reduction.

Course code: C028084 / Q024609

Qualification

College Certificate

Level Level 1
Entry requirements

You must be comfortable using a computer and have some basic experience of Microsoft Excel 2016.

Assessment

Tutors will give regular verbal and written feedback. You will be required to complete an Individual Learning Plan (ILP) and encouraged to set your own personal targets as part of this course.

Progression

There may be opportunities to progress onto other courses both in the community and at Nottingham College sites.

The course tutor can discuss appropriate opportunities if you wish to further your learning in this subject area.

Additional information

Tutor: Fiona Dracott

Related courses

Lewis joins international artists for special London exhibition

25/09/2020

Read more

Thomas’s VE Day photo wins top competition

18/09/2020

Read more

Keeping our students safe on work placement

17/09/2020

Read more