Advanced Excel for Data Managers

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 Advanced Excel for Data Managers 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 from 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 – Advanced Course

Our advanced course is for Data Managers who can already perform basic calculations and want to take their Excel skills to the next level.

You will learn:
• Formulae and Functions
• Named Ranges
• Pivot Tables and Charts
• Linking multiple worksheets
• Conditional Formatting
• Paste Special
• Using Tables
• Macros

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

Who should attend

This training course is beneficial for Data Managers or roles equivalent.

Our Excel – Advanced Course is aimed at;

• Data Managers
• Regular Excel Users
• Confident Excel Users
• Excel users who can already perform basic calculations
• Excel users who want to take their Excel skills to the next level
• Excel users who are confident with basic calculations, formulae, formatting, filtering and chart

Are you a Data Manager or someone who deals with data who does not fit these criteria? Perhaps you would be better suited for the Excel – Beginners Course.

Agenda for Advanced Excel for Data Managers Course 9am – 3:30pm

 

Introduction to Advanced Excel

Formulae, Functions and Named Ranges
Reviewing Basic Functions and Formulae
Naming cells and Name Manager
Relative and Absolute References
Nested Functions
Dynamic Ranges using Offset
Indirect. Text, Date and Time Functions
Lookups and Index Match
Sumproduct Function for Multiple Conditions

Linking Data
Linking Between Worksheets and Workbooks
Hyperlinks and Updating Links

Data Validation
Validation Types and Lists
Custom Validation

Tables
Creating and Naming a Table
Inserting and deleting records
Sort, Filter and Slicer functionality
Table Styles, Formulae and Total Row
Converting Table to a Range
Removing Duplicates

Pivot Table and Charts
Understanding and Creating Pivot Table
Pivot Table Fields
Totals and Subtotals
Pivot Table Format and Layout
Grouping
Pivot Table Calculations
Report Filters and Slicers
Creating Pivot Charts

Conditional Formatting
Highlighting Cells Based on Values
Data Bars, Colour Scales and Icon Sets
Custom Rules Using Formulae
Rules Manager
Sparklines

Special Pasting
Pasting Values, Formulae, Formats and Validations
Transposing ranges
Arithmetic with Paste Special
Skipping Blanks

Automation with Macros
Recording and Running a Macro
Shortcut Keys
Assigning Macros to Buttons

Schedule

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

 

VenueSeptember 2018 October 2018 
Birmingham17th9th
Exeter8th
London18th11th
Manchester27th18th
Newcastle28th19th

Course Fee at Training Locations

Consultancy & TrainingPer Delegate FeeFree Telephone
Consultancy Support
Full Day£249** / £349*12 Months

* When you book for one delegate.
All prices are excluded from VAT.

** When you book for two or more colleagues, price is reduced by £100 for a full day course for each delegate. Colleagues may be from other schools. The cost for a full day’s training is £249 per delegate if you book two or more colleagues instead of £349 per delegate. All prices are excluding VAT.

Consultancy & Training Course Fee at Your School

For any in-house enquiries, please contact us on 0844 504 5812

Cluster of Schools

Many schools request a whole day training, combining ASP Interactive training in the morning with FFT training or one of our other Training Courses in the afternoon.

Combining ASP Training with the NEW ASP Governor Training Course is also an excellent combination supporting schools Nationally to ensure school Governing Bodies understand their school ASP Summary Report, fulfil their Leadership and Management responsibilities and support School Evaluation and Improvement.

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

About Us

Since 2006, we have specialised in ASP (formerly RAISEonline) and Fischer Family Trust Consultancy and Training for all schools and local authorities, analysing your school’s performance and progress data together with your staff.

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.

Booking Form

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

If you continue to have issues, please contact us on 0207 183 8357, option 5.