MS Excel - introduction - IT01

Who is this course for?

This course will cover the basics of getting started with Microsoft Excel. It is aimed at beginners who have never used the software before or have the basic skills of entering data only. The course will give a general grounding in design, the use of functions and formulas within a spread sheet and to use charts/graphs. 

Aims

To introduce and get started in properly using Microsoft Excel in the correct use of Functions and Formulas and navigating around the worksheets.

Objectives

At the end of the course participants will be able to

  • create spreadheets by entering and editing (text) labels/titles and (figures) values/data
  • navigating around the spreadsheet
  • manipulating the worksheet
  • formatting the worksheet
  • use of autosum
  • enter and edit basic formulas.
  • use of mathematical operators (+ * / -)
  • introduction to bodmas
  • using the functions of sum, average, min, max, today, now, count and counta
  • charts/graphs (pie, bar, line) - single data and comparison

Trainer

The programme is taught by Maureen Ann Slatter - IT Trainer.

Contact: skillslearninganddevelopment@lancashire.gov.uk

Cost

The cost of this course is £100.00 per delegate.

Delivery Dates & Venue

Venue
The Exchange
County Hall
Conference Training Facility
Preston. PR1 8XJ

  • Course 17180008: 12 December 2017 - 9:30am – 4:30pm
  • Course 17180009: 22 January 2018 - 9:30am – 4:30pm
  • Course 17180010: 6 March 2018 - 9:30am – 4:30pm

Apply