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: 9th January 2020

End: 12th March 2020

Time: 12:30 PM - 3:00 PM

Day: Thursday

Fees / reductions:

Tuition fee: £90

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

Course code: C030874 / Q030875

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.

Additional information

Tutor: Fiona Dracott

You can read more about community courses in our Guidance for Community Courses booklet.

Related courses

Light Night in pictures

11/02/2020

Read more

4 quick benefits of hiring an apprentice

07/02/2020

Read more

5 apprenticeships you didn't know existed

06/02/2020

Read more