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: 29th April 2019

End: 24th June 2019

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: C003622 / Q025866

Location:

Maid Marian Way
Nottingham
NG1 6AB

Date / time:

Start: 1st May 2019

End: 26th June 2019

Time: 6:00 PM - 8:30 PM

Day: Wednesday

Fees / reductions:

Tuition fee: £65

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

Course code: C025618 / Q025805

Qualification

Nottingham College Certificate

Duration

8-9 weeks

Level Level 1
Entry requirements

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

Teaching & 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.

Tourism students go global in London

18/03/2019

Read more

Stapleford opens its doors to visitors

15/03/2019

Read more

Talented dancers take centre stage with the professionals

15/03/2019

Read more