Skip to main content

Excel – Getting Started

If the Enrolment Status is 'available for enrolment', select below by ticking the left hand box and then click the Enrol button.

Select Enrolment Status Course Code Date Duration Time Location Costs
Available for enrolment UXPPFZ01 Thu 8 Jun 2023 4 Weeks 09:30 - 11:30 Auction Mart £ *
* You may be eligible for fee remission on this course, if you are, you will need to send us your evidence after enrolling.

This course is designed to introduce you to the basic functions and formulae of the Microsoft Excel program.

This course is designed for anyone who is new to using Microsoft Excel and wants to build a foundation of skills using the software

Introduction to Excel worksheets working with:

  • Ribbons
  • The Office button
  • Quick access toolbar
  • Workbook views (page layout, normal view, full screen)
  • Working with worksheets (rename, insert, colour, move)

Inputting data and numbers using:

  • Autofill
  • Copying and moving data
  • Sorting data
  • Searching for data and replacing data

Formatting using:

  • Font style (font, size, colour, bold, italic, underline)
  • Alignment (left, right, centre, merge and centre, wrap and rotate text)
  • Number (currency formatting, decimal places, date format)
  • Borders (line style, colour, width and shading cells,
  • Comment boxes

Using formulae to calculate:

  • Total
  • Average
  • Highest and lowest

Printing:

  • Changing margins
  • Fitting worksheet to one page

Changing the orientation:

  • Placing work in the centre of the page
  • Using preview
  • Inserting headers and footers

Creating charts and graphs:

  • Column, bar and pie charts
  • Formatting charts (changing colours, size and background)

Further Study

  • Excel – Improvers
  • Excel – Advanced

Part-time courses are term time only. See our term dates for further information.

Did you know that some of our courses are free if you earn less than £18,525 (£21,255 if you live in West Yorkshire, difference in qualifying earning amounts is due to local authority funding regulations). Call 01756 693 309 for further information.

Scroll Up