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.

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