What you will learn
Classroom based learning delivered by highly experienced Microsoft Certified Trainers. Very interactive session with plenty of hands on, applying new learnt skills throughout the day with exercises.
The following will be covered during the course:
- Excel Charting Concepts
- Creating Basic Charts Quickly
- Fine-Tuning Charts with Design Tab Choices
- Layout Tab Options
- Using Axes and Gridlines
- Format Options
- Adjusting Specific Chart Types
- Changing a Chart’s Data Source
- Printing and Sharing Charts
One of the most practical and relevant training sessions I have attended as a headteacher.
Excel Charts Agenda
Overview of how dashboards are so useful
Various Functions
- IF, AND, OR
- SUMIF / AVERAGEIF / COUNTIF / COUNTIFS
- SUMIFS / AVERAGEIFS
- IFERROR
- VLOOKUP
- MATCH
- Names Ranges
Conditional Formatting
- Icon sets
- Data Bars
- Colour Scales
- High and Low
Graphical Images
- Inserting Shapes
- Using the Snipping Tool
- Images from the Internet
Creating Graphs
Representing data using various graph options:
- Donut, Waterfall
- Pie, Line, Column
- Sparklines
Pivot Tables
- Storing data as Tables
- Creating Pivot Tables
- Using Slicers
- Slicer Options and formats
- Using Timelines
- Timeline Options and formats
Using the Camera
Macros – To Automate and Navigate
- Creating, Editing and Running Macros
- Running Macros to buttons
General Excel Options
- Hiding Sheets
- Hiding Formula Bar
- Sheet displays
- Password Protecting
- Column, Row Headings – Hiding
- Scroll Bars – Hiding
Bringing it all together
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
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