INTERMEDIATE EXCEL FOR STUDENTS
EXCEL TRAINING COURSE FOR A LEVEL AND DEGREE STUDENTS
Intermediate Excel for Analysis
Every year since 2019, we have run an Intermediate Excel for Analysis course in connection with the University of Leeds. The course is taught over 2 sessions and covers a range of functions and features that are aimed to help students improve their data analysis skills in Excel.
After the face-to-face teaching, there is a marked exercise which mimics a typical analysis scenario to test your understanding of the key features and functions covered. This is an excellent opportunity to practise using Excel as you might do in your first job. The exercise is graded and for students that receive a Pass or a Distinction, you will receive a certificate to show off your new level of Excel skills.
Find out more from Steve, one of our Excel Trainers:
%
NPS SCORE
%
PASS RATE
%
RECEIVED DISTINCTIONS
Statistics based on our 2021 training course with the University of Leeds students.
Course content
Best practice
We share some of our tips and tricks from a combined 50 years’ experience in using Excel.
Logical functions
IF
Count functions
COUNT, COUNTIF, COUNTBLANK
Maths functions
SUM, SUMIF, SUBTOTAL, CORREL, RANK
Text functions
LEFT, RIGHT, MID, LEN, CONCAT, TEXTJOIN
Other features
Filters, Flash Fill, Pivot Tables, Named Ranges, VLOOKUP, HLOOKUP, XLOOKUP, INDEC, MATCH, XMATCH, INDEX MATCH, INDEX MATCH MATCH
Benefits of taking the course
Learn new features & functions
Reduce the level of mistakes & errors
Become more efficient in Excel for study & work
Boost your CV with certified Excel learning
What past students say
Hear from two University of Leeds BA Geography graduates, Conor and Lydia, that have previously taken our Intermediate Excel for Analysis course. They share what they enjoyed about the training and how it has helped them in the job application process.
Our Range of MS Excel Training Courses
Excel is the most ubiquitous spreadsheet tool in the world with 81% of businesses using it. Excel skills are typically learnt ‘on the job’ with little or no formal training. Our tried and tested courses empower participants with a toolkit of resources, theory and practical examples showing how to best utilise this fantastic tool and drive time efficiencies in their workflow.
We currently run 4 public Excel training courses, to match a range of abilities:
Basic Excel
Intermediate Excel for Analysis
Advanced Excel for Analysis
Advanced Excel for Visualisation
Extend your Excel knowledge
Check out our brochure for more info on our other courses, such as Advanced Excel, to take your skills further! (student discounts available)
Add Excel to your curriculum
We welcome the opportunity to work with other courses and institutions. Please contact us to discuss your Excel training requirements.
Meet our Trainers
Steven Halsall
Founding Director
Steve is the co-founder of Red Tiger Talent, Coaching and Consulting. He has worked in analytics for over 25 years with various senior roles in consulting and client side. He is also an experienced entrepreneur – having successfully started 5 businesses to date, two of which went on to be acquired.
Paul Halsall
Founding Director
Paul has over 20 years of experience working for a variety of organisations. His career started with 15 years’ experience in a range of analytical roles in retail, leisure and telecommunications sectors utilising skills such as SQL, GIS, and MS Excel and culminated in him leading a global analytics team of 8 people.
Visit our blog where we share our thoughts on a range of topics such as recruitment, career development, coaching, mental health and more.
