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 enrol onto this course

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

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

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 23rd September 2019

End: 18th November 2019

Time: 9:30 AM - 12:00 PM

Day: Monday

Fees / reductions:

Tuition fee: £56.88

Community Learning funded. See our Financial Help page for fee reduction information.

Course code: C025524 / Q024494

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 24th September 2019

End: 19th November 2019

Time: 6:00 PM - 8:30 PM

Day: Tuesday

Fees / reductions:

Tuition fee: £56.88

Community Learning funded. See our Financial Help page for fee reduction information.

Course code: C003622 / Q003854

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 13th January 2020

End: 2nd March 2020

Time: 12:30 PM - 3:00 PM

Day: Monday

Fees / reductions:

Tuition fee: £56.88

Community Learning funded. See our Financial Help page for fee reduction information.

Course code: C028084 / Q024609

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 14th January 2020

End: 3rd March 2020

Time: 6:00 PM - 8:30 PM

Day: Tuesday

Fees / reductions:

Tuition fee: £56.88

Tuition fees may be waived if you are in receipt of certain benefits.

Course code: C025618 / Q025805

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 10th March 2020

End: 5th May 2020

Time: 6:00 PM - 8:30 PM

Day: Tuesday

Fees / reductions:

Tuition fee: £56.88

Tuition fees may be waived if you are in receipt of certain benefits.

Course code: C025618 / Q026043

Qualification

Nottingham College Certificate

Level Level 1
Entry requirements

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

Assessment

You will complete tasks throughout the course, there is no formal exam.

Progression

Progression routes can be discussed with the tutor at the end of the course. Options include attending a follow up course studying Microsoft Word or Microsoft Access at Level 1.

Related courses

Email this course information

Use the form below to email this course information directly to your inbox for future reference.

(required)

The information submitted through this form will be handled in accordance with our Privacy Policy.

Matthew’s up for Rising Star accolade

18/09/2019

Read more

Circus fun at Freshers' Fair!

13/09/2019

Read more

Chinese visitors learn motor industry skills

11/09/2019

Read more