SEF PGT Induction and Pre-Sessional - September 2025 Starters

Meet your experienced Teaching Fellow from the School of Economics and Finance.

View the Learning Goals and Objectives for the Pre-Sessional Excel Course.

Now view the complete set of Excel Foundations video presentations which take you through formatting cells, organising data, viewing data, keyboard short cuts and  Excel applications.  

View and download this PDF guide which provides a list of Excel Shortcuts which you should find useful for this topic and the rest of the course.

To continue to explore this topic, view and navigate the following Excel Formulas and Functions video presentations which take you through  Mathematical Functions, Logical Functions, Cell References, Cell Auditing and an Excel Example Application applying the skills developed in this section.

To take this topic further, view the following video presentations which investigate the different types and characteristics of Excel Charts, how to create an effective Excel Chart, and an example application of Excel Charts.

To investigate the topic of Managing Data in more detail, now view the following video presentations which demonstrate  Conditional Formatting Rules, using the Vlookup Function, Pivot Tables and examples of the application of Pivot Tables in Excel.

Now you have been introduced to the topic of Data Analysis with Excel, watch these video presentations which demonstrate the application of Statistical Functions, the installation and use of Analysis Toolpak, how to perform and interpret a Regression Analysis, and an example applying the Data Analysis skills used in this section.

View and download the PDF with the Excel Project Financial Exercises

Download the Excel Workbook Example

The schedule of Lectures & Tutorials, and their Zoom links.

SEF PGt Professional Development Award overview 17.09.24

The slides from Dr David Norman's talk on the finance workshops exclusive to PGt students.

Watch this set of Careers Masterclass presentations narrated by Careers Consultant Serena Spoendlin. The presentations cover the topics of Careers Support Services, an Overview of the Finance Job Market, Investment Banking, Recruitment and Selection, and Tips for Job Hunting.  Each presentation is accompanied by a set of careers links and resources. Please click on the arrow in the top right corner to go to the next video. 

View the goals and objectives for the week.

Watch this set of Career Masterclass presentations by Careers Consultant Serena Spoendlin with a focus on Self Marketing yourself in Applications, CVs and Cover Letters, and approaches to Networking and gaining Work Experience. Please click on the arrow in the top right corner, to go to the next video. 

This video from professional services network PwC introduces approaches to creating a successful elevator pitch to self market your unique skills and experience.

Recommended Reading on Sampling and Central Tendency to take this topic further

Recommended  Reading on Probability Distributions to take this topic further

Recommended Reading to take the Topic of Estimation and Hypothesis Testing Further.

Recommended  Reading on Simple Functions to take this Topic further

Recommended Reading to take the Topic of Derivatives and Matrix Algebra Further.

Recommended Reading to take the Topic of Regression Analysis Further.

Here some videos presented by Dr. Yu Zheng. In these videos you will explore the topic of Sampling and Central Tendency in more depth and prepare for the problem sets.

Here some videos presented by Dr. Yu Zheng. In these videos you will explore the topic of Probability Distribution in more depth and prepare for the problem sets.

Here some videos presented by Dr. Yu Zheng. In these videos you will explore the topic of Estimation and Hypothesis Testing in more depth and prepare for the problem sets.

This set of narrated slideshow presentations will enable you to explore the topic of Simple Functions in more depth and prepare for the problem sets.

This set of narrated slideshow presentations will enable you to explore the topic of Derivatives and Matrix Algebra in more depth and prepare for the problem sets.

This set of narrated slideshow presentations will enable you to explore the topic of Regression Analysis in more depth and prepare for the problem sets.