Excel for Schools – Beginners

What you will learn

Microsoft Excel is the world’s most popular spreadsheet application included in all Microsoft Office Suites. When used effectively it is a powerful tool, allowing you to analyse data and so much more.

We are pleased to announce that our BRAND NEW Excel course is now available, designed to support you in using Excel to increase efficiency and produce invaluable insights for your schools.

Our Excel for Schools – Beginners training course has been designed to support Data Managers and further staff in a school environment from beginners to more advanced users.

These one-day courses will empower you with the knowledge and skills to manipulate, analyse and summarise data.

Throughout the course, you will be gaining outstanding guidance and support by our senior consultants who will show you how you can use this tool.

This course will enable you to effectively navigate, interpret and evaluate the data provided to gain the highest possible knowledge from the data.

Excel – Beginner Course

Our beginner course is aimed at users who are new to Excel or wish to brush up on their basic skills and will provide learners with a core understanding of how to use the software.

You will learn:
• Data Entry
• Text and number formats
• Basic Mathematical Functions
• Autofill
• Sorting and Filtering Data
• Charts
• Formatting and Printing Spreadsheets

Fiona Lawson-Ross
One of the most practical and relevant training sessions I have attended as a headteacher.
Fiona Lawson-Ross

Who should attend

Our Excel – Beginners Course is aimed at;

• New Excel users
• Irregular Excel users
• Excel users who need to brush up on their basic skills
• Excel users who are not confident in basic calculations, formulae, formatting, filtering and chart
• Excel users who are not confident with using Excel within the Data Manager or Data Entry role

Are you a Data Manager who does not fit these criteria? Perhaps you would be better suited for the Excel – Advanced Course.

This training course is beneficial for any staff member that deals with data entry and management including;

• Data Managers
• Data Entry Support Staff
• Administration
• Head Teachers
• Deputy Head Teachers
• Senior Management Teams
• Subject Leaders
• SENCO’s
• Gifted and Talented Leaders
• Class teachers

Agenda for Excel – Beginners Course 9am – 3:30pm

 

Introduction to Excel

Excel Structure
Creating, Saving and Formatting Workbooks
Adding, Deleting and Copying Worksheets
Sharing a Workbook
Protecting Worksheets and Workbooks

Data Entry and Navigation
Selecting Cells using Keyboard and Mouse
Inserting Cells, Rows and Columns

Formatting
Text and Number Formats
Font Styles and Borders
Autofit, Alignment and Fill
Wrap Text and Cell Merging
Format Painter and Clear Formats
Basic Table Formatting
Conditional Formatting
Freeze Panes and split cell

Editing Cells
Editing Multiple Cells and Formula Bar
Copy, Cut, Paste and Paste Values
Find and Replace
Autofill and Flash Fill
Sort and Filter

Formulae and Functions
Basic Functions and Cell References
Autosum
Copying and Pasting Formulae
Absolute References

Charts
Creating a Chart and Chart Types
Chart Format and Design

Layout and Printing
Printing First Row
Headers and Footers
Page Layout

Schedule

The maximum number of delegates for each training session is 10 or 12 depending on the location.

Venue September 2018  November 2018 
Birmingham 13th 13th
London 14th 12th
Manchester 20th 18th
Newcastle 21st 19th

Course Fee at Training Locations

In-house Course Fee

Full Day £995*
Half Day £675*

*All prices are excluded from VAT.

For any in-house enquiries, please contact us on 020 7183 8357.

Cluster of Schools

More than one school can gather to request an in-house training. Maximum number of delegates is 12 for a quality training session. We can organise sessions in the morning and afternoon if your request more than 12 delegates to attend.

Alternatively, contact us by telephone/email to speak to one of our consultants to discuss your school’s needs, options and request a Personalised Training package.

About Us

Since 2006, we have specialised in ASP (formerly RAISEonline Training) for all schools and local authorities to analyse your school’s performance and progress data with your colleagues.

Our mission is to provide quality and multifaceted consultancy in education and training in Early Years settings, Primary Schools, Secondary Schools, Special Schools, Church Schools and Independent Schools.

ASP training and consultancy sessions can be personalised to support the professional development needs of your school team and offer consultancy support to Head Teachers, Deputy Head Teachers, Senior Management Teams, Subject Leaders, SENCO’s, Gifted and Talented Leaders, Class teachers, Newly Qualified Teachers, Learning Support Assistants and Governors.

We are here to support you with using tools such as ASP, Ofsted IDSR’s, Excel, FFT and MIS Systems as well as provide guidance for Governing Bodies, creating your school’s data story, EYFS, SEN, Gifted and Talented, Leadership and Management, School Improvement and Ofsted Preparation.

You can select your audience – Training can be 1:1 for Headteachers and Deputies, for particular focus groups or whole staff teams.

Consultancy & Training

ASP & IDSR Primary
ASP & IDSR Secondary
ASP & IDSR Post 16

Microsoft Excel
Introduction
Intermediate
Advanced
Expert
Pivot Tables
Dashboards
Excel Charts
Excel VBA Introduction

Power BI
Introduction 1 Day
Introduction 2 Days
Intermediate 2 Days
Advanced 2 Days

Microsoft Word
Introduction
Intermediate
Advanced

Microsoft PowerPoint
Microsoft Teams
Microsoft Sharepoint – End User

Data Story Course
Fischer Family Trust

Booking Form

If you would like to book a course or find out more about our bespoke training, please fill the contact form below and we will get back to you as soon as possible. Please contact us on 0207 183 8357, option 5.

Please note, the below booking form will not be available until you accept the use of cookies and refresh