Introduction to Excel spreadsheets

Microsoft Excel Starter

This covers the widely used basic functions of Microsoft Excel at introduction level. Prior knowledge of Excel is not essential but is beneficial. The course is informal but structured and you will be encouraged to ask questions as the course develops. The training will be delivered using the latest version of Microsoft Excel 2016 on our computers. The lessons are structured using sample data that relates to your course handbook. Free training downloads are provided to all delegates on completion of the course. There will be a 15 minute break in the morning and afternoon, with 45 minutes for lunch. Lunch on our scheduled courses is provided by IPSO FACTO. Refreshments are available throughout the course.

Is this course for you?

This course is aimed at those who are new to Microsoft Excel or those who are finding it challenging to use Excel at work and have had no formal training. It is also for those who want to consolidate their understanding of Excel at this level, prior to progressing onto level 2.

Not sure: Complete our online Excel Questionnaire

We’ll get back to you on completion: click here

Training options

Virtual classroom: £700+VAT for up to 10 delegates
On-site: £750+VAT for up to 8 delegates on the course
On-site: £600+VAT for up to 4 delegates on the course

Live Virtual Classroom schedule

Session 1: 09:00 to 10:00 [break 10:00 to 10:15]
Session 2: 10:15 to 11:15 [break 11:15 to 11:30]
Session 3: 11:30 to 12:30 [lunch 12:30 to 13:30]
Session 4: 13:30 to 14:30 [break 14:30 to 14:45]
Session 5: 14:45 to 15:45 [summarise and close 15:45 to 16:00]

Courses Includes

• Computer and the latest software for each delegate
• Microsoft Training Manual
• Post course training downloads
• Certificate on completion
• Post course support relating to course content

Microsoft Excel & Windows Shortcut and Training Files

The files below will be used during training to help improve your performance.

• Microsoft Excel shortcuts infographic
• Microsoft Windows shortcuts
• Training List 1

Course Aims

• To create and edit simple Microsoft Excel worksheets and workbooks.
• To improve your confidence when using Microsoft Excel at this level.

Course Objectives

By the end of this course you will be able to:

• Create and edit simple formulas
• Format spreadsheet data
• Sort a list of data and quickly answer a range of questions
• Filter a list of data and quickly answer and present data responding to a range of questions
• Create simple but effective business charts
• Print spreadsheet data and charts
• Learn a range of useful short cuts

Introduction to Excel (Get to know Excel)

Learn a few important facts about Excel – Techniques for selecting cells and data – Enter spreadsheet data – use shortcuts – Prepare the quick access toolbar – Saving to local – 365 SharePoint – OneDrive.

Simple formulas (Create useful formulas)

Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.

Formatting techniques (Simplify your data)

Learn how to use a range of formatting techniques to create structure in your spreadsheet.

Lists of business data (Input, edit and question your data)

Interrogating and manipulating lists of business data are important skills. Learn how to input data using shortcuts, manipulate data, and quickly answer a range of questions relating to the data.

Business Charts (Create high impact charts)

Learn how to use important selection techniques – chart options – create and edit charts

Printing (Print different types of data)

Understand how to: Print lists – Print charts – use Page Break Preview

Excel shortcuts (Time savers)

There are many useful time saving shortcuts included in the course

Feedback from recent course delegates.