Excel for Beginners

Airedale Enterprise
21 November 2019

Aimed at those people who are new to using Microsoft Excel

  • 10:00 am - 3:00 pm
  • £95+VAT

The course

Our “Excel for Beginners” training workshop is aimed at those people who are new to using Microsoft Excel, or have very limited knowledge and would like to start again! This course is a practical training session giving you the opportunity to have a go at creating a spreadsheet from scratch.

Who should attend

The course is aimed at people who are already employed, or are looking for work, who will need to use Microsoft Excel. Anyone who is going to be using Excel at home is also welcome. Those attending must have some basic IT skills.

What to expect

What will you learn?

The workshop will aim to provide you with an understanding of basic spreadsheet concepts and will provide practical experience of dealing with data and simple formulae in newly created or existing spreadsheets.

  • Understanding the Excel window
  • Creating and saving new Excel workbooks
  • Opening, editing and updating existing workbooks
  • Using Spell-check
  • Recognising error messages and using undo/redo commands
  • Basic formatting of cells, text, numbers, dates, percentages
  • Adjusting width of columns and height of rows
  • Duplicating or moving data, rows or columns
  • Sorting and filtering data
  • Using simple formulae and functions
  • Borders and shading (cells/rows/columns)
  • Timesavers (freezing rows/columns; autofill; incremental entries)
  • Basic printing options
  • Fit to specified pages
  • Modify margins
  • Formatting spreadsheet
  • Display numbers as percentages
  • Format currency symbols
  • Format date styles
  • Work with multiple spreadsheets
  • Add additional cell content
  • Produce charts to analyse data
  • Pivot tables
  • Edit/modify charts

The outcome

  • After the session you will be able to:
  • Create and edit simple spreadsheets
  • Input text and numeric data into cells and format appropriately
  • Create the mathematical formulae Add, Subtract , Multiply & Divide
  • Use edit, undo, redo, cut, copy and paste tools
  • Sort and filter data
  • Use borders and/or shading to improve readability of the printed version
  • Adjust page settings and check spreadsheet layout prior to printing

Equipment

Laptops will be provided however if you wish to bring your own then please ensure that you have a full copy of Excel 2007 or 2010. All work will be saved to a memory stick so that you can use at a later date.

Trainer Ali Afgan

Ali has a background in Computing/ IT and is a qualified Software Engineer (BEng). He has been a professional IT trainer/ lecturer since 2012 and has a wealth of experience. He is passionate about sharing his knowledge and aiding individuals to develop further.

Additional Info

Funding of 40% (European Social Fund) may be available towards the cost of the course through *The Skills Service please call 01535 607775 to check eligibility criteria.