IT & Systems

IT & Systems

Course Name

Ellipse 9 Asset Data Manager

Course Description

This course is designed to take place over one day and will look at how to manage and implement the process for the efficient delivery of asset data changes. Through this process all asset changes are efficiently and effectively recorded through the maintenance of files, data and information held on corporate systems as defined in the applicable ADM standards.
Upon completion of this course, delegates should be able to comprehend an understanding into what makes an Equipment Reference, demonstrate; how to create / amend Equipment Asset Records including how to make the Assets Obsolete. In line with business process, delegates will also gain an understanding into what an MST is be able to demonstrate how to create, modify and make MSTs in-active.
Delegates will be assessed continuously by the Trainer on their ability to perform ADM orientated tasks.

Audience

The event is designed specifically for the following roles: -Systems Support Managers -Work Data Clerk Please note: - if your job discipline falls outside of these two roles, application for access will be assessed on an individual basis by the Business System Owner and their team.

Duration:

1 Day(s)

Class size:

8

Course Name

Ellipse 9 Asset Data Manager

Course Description

This course is designed to take place over one day and will look at how to manage and implement the process for the efficient delivery of asset data changes. Through this process all asset changes are efficiently and effectively recorded through the maintenance of files, data and information held on corporate systems as defined in the applicable ADM standards.
Upon completion of this course, delegates should be able to comprehend an understanding into what makes an Equipment Reference, demonstrate; how to create / amend Equipment Asset Records including how to make the Assets Obsolete. In line with business process, delegates will also gain an understanding into what an MST is be able to demonstrate how to create, modify and make MSTs in-active.
Delegates will be assessed continuously by the Trainer on their ability to perform ADM orientated tasks.

Audience

The event is designed specifically for the following roles: -Systems Support Managers -Work Data Clerk Please note: - if your job discipline falls outside of these two roles, application for access will be assessed on an individual basis by the Business System Owner and their team.

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 ADM

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Ellipse 9 Data Entry

Course Description

The aim of this course is to provide users with the ability to use Ellipse as a tool for the processing and amendment of works orders pertaining to the maintenance of railway assets and the recording of labour costing information.  Processes and Procedures: 
-Asset Information Services (AIS)Online  
-Ellipse Navigation 
-Work Management Process 
-Standard Jobs 
-Equipment Register 
-Work Arising Identification Form 
-Work Order – search/create/amend 
-Reprioritisation
-Labour Costing 
-MSTs 
-Business Objects 
-Works Planner
 
Upon completion of the course, delegates will be able to request an Ellipse Data Entry profile, allowing them to search for information, create, amend and close Work Orders and process labour costing information.  

Audience

Section Planners or Section Administrators who are Route based.

Duration:

3 Day(s)

Class size:

8

Course Name

Ellipse 9 Data Entry

Course Description

The aim of this course is to provide users with the ability to use Ellipse as a tool for the processing and amendment of works orders pertaining to the maintenance of railway assets and the recording of labour costing information.  Processes and Procedures: 
-Asset Information Services (AIS)Online  
-Ellipse Navigation 
-Work Management Process 
-Standard Jobs 
-Equipment Register 
-Work Arising Identification Form 
-Work Order – search/create/amend 
-Reprioritisation
-Labour Costing 
-MSTs 
-Business Objects 
-Works Planner
 
Upon completion of the course, delegates will be able to request an Ellipse Data Entry profile, allowing them to search for information, create, amend and close Work Orders and process labour costing information.  

Audience

Section Planners or Section Administrators who are Route based.

Duration:

3 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 DE

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Ellipse 9 Read Only

Course Description

This one-day course has been designed for Management or Engineering personnel who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).  Course Assessment/Profiles: 
•There is no formal assessment at the end of the course. Following the course delegates will be able to apply for the Global Profile of Read Only access. This is suitable for Engineering, Supervision or Management Overview. 
Processes and Procedures: 
•AIS Hub – Ellipse Support section 
•Ellipse Navigation 
•Work Management Process 
•Standard Jobs 
•Equipment Register 
•Work Arising Identification Form 
•Work Order – search and review 
•Works Manager – review scheduled work 
•Business Objects 
 

Audience

The course has been designed for people who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).

Duration:

1 Day(s)

Class size:

8

Course Name

Ellipse 9 Read Only

Course Description

This one-day course has been designed for Management or Engineering personnel who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).  Course Assessment/Profiles: 
•There is no formal assessment at the end of the course. Following the course delegates will be able to apply for the Global Profile of Read Only access. This is suitable for Engineering, Supervision or Management Overview. 
Processes and Procedures: 
•AIS Hub – Ellipse Support section 
•Ellipse Navigation 
•Work Management Process 
•Standard Jobs 
•Equipment Register 
•Work Arising Identification Form 
•Work Order – search and review 
•Works Manager – review scheduled work 
•Business Objects 
 

Audience

The course has been designed for people who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 RO

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

iOS Digital-Upskilling

Course Description

Tailored for colleagues in every role at Network Rail, our iOS Digital Up-Skilling course is designed to elevate your knowledge and everyday use of the hardware and software of our mobile devices, whether in an office or out on the track. This is a bespoke course, addressing your specific requirements, whether it is the use of Network Rail applications and software or just general use and familiarisation of an iPad or iPhone. Discuss your needs with your local RTSM and we will design the course bespoke for your cohort. As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours

Audience

This course is designed for anyone who manages Network Rail employees, with specific focus on new people managers. People Managers Supervisors Team Leaders And anyone who has a position involving line management to direct reports.

Duration:

1 Day(s)

Class size:

8

Course Name

iOS Digital-Upskilling

Course Description

Tailored for colleagues in every role at Network Rail, our iOS Digital Up-Skilling course is designed to elevate your knowledge and everyday use of the hardware and software of our mobile devices, whether in an office or out on the track. This is a bespoke course, addressing your specific requirements, whether it is the use of Network Rail applications and software or just general use and familiarisation of an iPad or iPhone. Discuss your needs with your local RTSM and we will design the course bespoke for your cohort. As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours

Audience

This course is designed for anyone who manages Network Rail employees, with specific focus on new people managers. People Managers Supervisors Team Leaders And anyone who has a position involving line management to direct reports.

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IOSDU

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

iProcurement for Requesters and Preparers eLearning

Course Description

This training will show users how to procure goods and services using the Network Rail iProcurement catalogue and how to raise requisitions. Upon successful completion of the course (achieving 70% in the knowledge assessment), the delegate will be eligible to apply for iProcurement and SWIM.

Audience

All Network Rail employees who are required to prepare and raise requisitions via the Oracle iProcurement system.

Duration:

60 mins Day(s)

Class size:

N/A

Course Name

iProcurement for Requesters and Preparers eLearning

Course Description

This training will show users how to procure goods and services using the Network Rail iProcurement catalogue and how to raise requisitions. Upon successful completion of the course (achieving 70% in the knowledge assessment), the delegate will be eligible to apply for iProcurement and SWIM.

Audience

All Network Rail employees who are required to prepare and raise requisitions via the Oracle iProcurement system.

Duration:

60 mins Day(s)

Class size:

N/A

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

PD/IT/IPROC EL

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Elearning
How to Book

Course Name

ITIL Foundation v4

Course Description

This course provides a broad-based view of the ITIL4 framework’s approach to Service Management. It covers a broad range of material at a high-level, as would reasonably be expected from a ‘Foundation’ course, with specific depth in key areas of service management and its practice. Organisations that are actively engaging with new areas of practice such as Lean and DevOps will gain from understanding how ITIL4 can help them embrace these areas with IT Service Management.

Audience

This course is for anyone that needs to know more about the latest version of the world’s most used Service Management framework. Delegates that are involved with an organisation that practices IT Service Management (ITSM) or hope to be should start here. Delegates that already hold an ITIL v3 Foundation certificate but haven’t taken their studies further should also start here as this course expands on their existing knowledge and takes it in new directions.

Duration:

3 Day(s)

Class size:

12

Course Name

ITIL Foundation v4

Course Description

This course provides a broad-based view of the ITIL4 framework’s approach to Service Management. It covers a broad range of material at a high-level, as would reasonably be expected from a ‘Foundation’ course, with specific depth in key areas of service management and its practice. Organisations that are actively engaging with new areas of practice such as Lean and DevOps will gain from understanding how ITIL4 can help them embrace these areas with IT Service Management.

Audience

This course is for anyone that needs to know more about the latest version of the world’s most used Service Management framework. Delegates that are involved with an organisation that practices IT Service Management (ITSM) or hope to be should start here. Delegates that already hold an ITIL v3 Foundation certificate but haven’t taken their studies further should also start here as this course expands on their existing knowledge and takes it in new directions.

Duration:

3 Day(s)

Class size:

12

Competence Name Awarded:

Competence Awarded:

Course Code:

ITIL4

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

Microsoft Excel 2016 VBA Advanced

Course Description

Using Intrinsic Functions, Variables and Expressions
  • Defining Expressions and Statements
  • How to Declare Variables
  • Determining Data Types
  • Programming with Variable Scope
  • Harnessing Intrinsic Functions
  • Defining Constants and Using Intrinsic Constants Creating User Defined Functions
  • Creating a Function Procedure
  • Calling a UDF
  • Using a function within an Excel Workbook Message Boxes and Input Boxes
  • Adding Message Boxes
  • Using Input Boxes
  • How to Declare and Use Object Variables Handling Errors
  • Defining VBA's Error Trapping Options
  • Capturing Errors with the On Error Statement
  • Determining the Err Object
  • Coding an Error-Handling Routine
  • Using Inline Error Handling Creating Forms and Controls
  • Defining User Forms
  • Utilising the Toolbox
  • Using UserForm Properties, Events And Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Using the Label Control
  • Using the Text Box Control
  • Using the Command Button Control
  • Using the Combo Box Control
  • Using the Frame Control
  • Using Option Button Controls
  • Using Control Appearance
  • Setting the Tab Order
  • Filling a Control
  • Adding Code to Controls
  • How to Launch a Form in Code Working with Procedures
  • Procedure Arguments
  • Passing Arguments
  • Optional Arguments
  • Default Values
  • Passing arguments by value and reference Working with Ranges
  • What is a Range?
  • Range Property of the Application
  • Cells Property
  • The Special Cells Method
  • Naming Ranges Events
  • Workbook Events
  • Worksheet Events Working with Arrays
  • What is an Array
  • Array Sizes
  • One Dimensional Arrays
  • Arrays with Multiple Dimensions
  • A word about index numbers
  • Ubound and Lbound Charts
  • Creating charts from worksheet data
  • Key Properties and methods of the chart object
  • Manipulating Chart Data from cells Active X Data Objects
  • Key Objects
  • The Connection Object
  • The Record Set Object
  • A word about the connection string Appendix: Using the PivotTable Object
  • Understanding PivotTables
  • Creating A PivotTable
  • 2010 Pivot Wizard Procedure
  • Coding the manipulation, Pivoting the Table
  • Using PivotFields Excel VBA – Quick Reference Guide Programming Techniques
  • Best Practice for Excel Programming
  • Using Worksheet Functions
  • A Word about VB functions Ascii Codes
  • Inserting non- printable characters into literal strings
  • Controlling data entry into text boxes and other form controls.
  • A complete list of all standard ASCII codes is given below If time:-
  • Coding the File System object
  • Coding Word or PowerPoint from Excel
  • Coding to control Excel Application Events

Audience

•Delegates should have attended MS Excel VBA Introduction course. •Experience of recording and writing simple macros •Please note this course is not suitable for Excel 2010 users who have no VBA knowledge

Duration:

2 Days Day(s)

Class size:

1-12

Course Name

Microsoft Excel 2016 VBA Advanced

Course Description

Using Intrinsic Functions, Variables and Expressions
  • Defining Expressions and Statements
  • How to Declare Variables
  • Determining Data Types
  • Programming with Variable Scope
  • Harnessing Intrinsic Functions
  • Defining Constants and Using Intrinsic Constants Creating User Defined Functions
  • Creating a Function Procedure
  • Calling a UDF
  • Using a function within an Excel Workbook Message Boxes and Input Boxes
  • Adding Message Boxes
  • Using Input Boxes
  • How to Declare and Use Object Variables Handling Errors
  • Defining VBA's Error Trapping Options
  • Capturing Errors with the On Error Statement
  • Determining the Err Object
  • Coding an Error-Handling Routine
  • Using Inline Error Handling Creating Forms and Controls
  • Defining User Forms
  • Utilising the Toolbox
  • Using UserForm Properties, Events And Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Using the Label Control
  • Using the Text Box Control
  • Using the Command Button Control
  • Using the Combo Box Control
  • Using the Frame Control
  • Using Option Button Controls
  • Using Control Appearance
  • Setting the Tab Order
  • Filling a Control
  • Adding Code to Controls
  • How to Launch a Form in Code Working with Procedures
  • Procedure Arguments
  • Passing Arguments
  • Optional Arguments
  • Default Values
  • Passing arguments by value and reference Working with Ranges
  • What is a Range?
  • Range Property of the Application
  • Cells Property
  • The Special Cells Method
  • Naming Ranges Events
  • Workbook Events
  • Worksheet Events Working with Arrays
  • What is an Array
  • Array Sizes
  • One Dimensional Arrays
  • Arrays with Multiple Dimensions
  • A word about index numbers
  • Ubound and Lbound Charts
  • Creating charts from worksheet data
  • Key Properties and methods of the chart object
  • Manipulating Chart Data from cells Active X Data Objects
  • Key Objects
  • The Connection Object
  • The Record Set Object
  • A word about the connection string Appendix: Using the PivotTable Object
  • Understanding PivotTables
  • Creating A PivotTable
  • 2010 Pivot Wizard Procedure
  • Coding the manipulation, Pivoting the Table
  • Using PivotFields Excel VBA – Quick Reference Guide Programming Techniques
  • Best Practice for Excel Programming
  • Using Worksheet Functions
  • A Word about VB functions Ascii Codes
  • Inserting non- printable characters into literal strings
  • Controlling data entry into text boxes and other form controls.
  • A complete list of all standard ASCII codes is given below If time:-
  • Coding the File System object
  • Coding Word or PowerPoint from Excel
  • Coding to control Excel Application Events

Audience

•Delegates should have attended MS Excel VBA Introduction course. •Experience of recording and writing simple macros •Please note this course is not suitable for Excel 2010 users who have no VBA knowledge

Duration:

2 Days Day(s)

Class size:

1-12

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

EX10VBAA

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

NA

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Microsoft Excel VBA 2016 - Office Introduction

Course Description

At the end of this course you will be able to:
•Record and edit a Macro recorded within Excel/Word
•Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
•Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
•Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
•Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
•Create an error handling routine in case things go wrong with VBA code
Subject Areas
Lesson 1: Getting started
•Introducing Visual Basic for Applications
•Recording a Macro
•Running a Macro
•Absolute or Relative Cell Referencing
•Saving and Opening Files with Macros
•Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons
•Editing a Macro in the Visual Basic Editor
•Understanding the Development Environment
•Tips for General Typing in VBA
•Using Visual Basic Help
Lesson 2: Working with Procedures
•Program Design
•Understanding Modules
•Creating a Module
•Understanding Procedures
•Programming Macro Concepts
•Creating a Subroutine
•Creating a Function
•Understanding Arguments
•Exiting Procedures
•Calling Procedures
Lesson 3: Understanding Objects, Properties, Methods, and Events
•Understanding Objects Properties, Methods, and Events
•Navigating the Object Hierarchy
•Understanding Collections
•Using the Object Browser
•Using the With Statement
•Working with Properties
•Working with Methods
•Creating an Event Procedure
Lesson 4: Using Expressions, Variables and Intrinsic Functions
•Naming Rules
•Understanding Expressions and Statements
•Declaring Variables
•Understanding Data Types
•Determining the Value of Variables
•Working with Variable Scope
•Using Built-in VBA Functions
•Understanding Constants
•Using Built-in VBA Constants
•Using Message Boxes
•Controlling the Answer to a Message Box
•Using Input Boxes
•Declaring and Using Object Variables
Lesson 5: Controlling Program Execution
•Understanding Control-of-Flow Structures
•Using the If...End If Decision Structures
•Using the Select Case ... End Select Structure
•Using the Do ... Loop Structure
•Using the For ... Next Structure
•Using the For Each ... Next Structure
•Guidelines for Use of Control-of-Flow Structures
Lesson 6: Working with Forms and Controls
•Understanding UserForms
•Using the Toolbox
•Working with a Form's Properties, Methods, and Events
•Working with Form and Control Properties, Methods and Event
•Working with Form Controls
•Setting the Tab Order
•Populating a Control
•Adding Code to Controls
Lesson 7: Debugging and Handling Errors
•Understanding Errors
•Using Debugging Tools
•Setting Breakpoints and Using Break Mode
•Stepping Through Code
•Trapping Errors with the On Error Statement
•Understanding the Err Object
•Working with Inline Error Handling
•Writing an Error-Handling Routine
Please can you ensure that you take your laptop for this trainptops are not provided as standard.

Audience

•Navigate, edit and manage Excel workbooks. •Format worksheets and workbooks. •Understand the difference between absolute and relative references. •Understand the basics of Excel formulas and functions, e.g. Sum, text functions. •Understand the concepts of a Macro and its capabilities.

Duration:

2 Days Day(s)

Class size:

4-8

Course Name

Microsoft Excel VBA 2016 - Office Introduction

Course Description

At the end of this course you will be able to:
•Record and edit a Macro recorded within Excel/Word
•Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
•Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
•Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
•Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
•Create an error handling routine in case things go wrong with VBA code
Subject Areas
Lesson 1: Getting started
•Introducing Visual Basic for Applications
•Recording a Macro
•Running a Macro
•Absolute or Relative Cell Referencing
•Saving and Opening Files with Macros
•Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons
•Editing a Macro in the Visual Basic Editor
•Understanding the Development Environment
•Tips for General Typing in VBA
•Using Visual Basic Help
Lesson 2: Working with Procedures
•Program Design
•Understanding Modules
•Creating a Module
•Understanding Procedures
•Programming Macro Concepts
•Creating a Subroutine
•Creating a Function
•Understanding Arguments
•Exiting Procedures
•Calling Procedures
Lesson 3: Understanding Objects, Properties, Methods, and Events
•Understanding Objects Properties, Methods, and Events
•Navigating the Object Hierarchy
•Understanding Collections
•Using the Object Browser
•Using the With Statement
•Working with Properties
•Working with Methods
•Creating an Event Procedure
Lesson 4: Using Expressions, Variables and Intrinsic Functions
•Naming Rules
•Understanding Expressions and Statements
•Declaring Variables
•Understanding Data Types
•Determining the Value of Variables
•Working with Variable Scope
•Using Built-in VBA Functions
•Understanding Constants
•Using Built-in VBA Constants
•Using Message Boxes
•Controlling the Answer to a Message Box
•Using Input Boxes
•Declaring and Using Object Variables
Lesson 5: Controlling Program Execution
•Understanding Control-of-Flow Structures
•Using the If...End If Decision Structures
•Using the Select Case ... End Select Structure
•Using the Do ... Loop Structure
•Using the For ... Next Structure
•Using the For Each ... Next Structure
•Guidelines for Use of Control-of-Flow Structures
Lesson 6: Working with Forms and Controls
•Understanding UserForms
•Using the Toolbox
•Working with a Form's Properties, Methods, and Events
•Working with Form and Control Properties, Methods and Event
•Working with Form Controls
•Setting the Tab Order
•Populating a Control
•Adding Code to Controls
Lesson 7: Debugging and Handling Errors
•Understanding Errors
•Using Debugging Tools
•Setting Breakpoints and Using Break Mode
•Stepping Through Code
•Trapping Errors with the On Error Statement
•Understanding the Err Object
•Working with Inline Error Handling
•Writing an Error-Handling Routine
Please can you ensure that you take your laptop for this trainptops are not provided as standard.

Audience

•Navigate, edit and manage Excel workbooks. •Format worksheets and workbooks. •Understand the difference between absolute and relative references. •Understand the basics of Excel formulas and functions, e.g. Sum, text functions. •Understand the concepts of a Macro and its capabilities.

Duration:

2 Days Day(s)

Class size:

4-8

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

QAVBA10INT

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Microsoft Power Bi Fundamentals

Course Description

This introduction to Power BI Desktop provides a condensed yet balanced look at the data analysis process. It starts by showing you how to import and connect to data from different sources, including Excel and CSV files. It then focuses on the process of shaping and cleaning data, plus appending tables in the Query Editor.
You will also learn how to create interactive end user dashboards using a range of visualisations.
The course ends with a brief look at the Power BI online service where reports are published so we can easily share them with others.
Some knowledge of Microsoft Excel is preferable.

Take Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
This Fundamentals course does not look at DAX (please look at the 2 day Introduction for DAX)

Audience

• Managers (who will not be creating reports but want a good idea of what their team do, what some of the terms mean, etc.) • People with very basic Excel knowledge • People who will be doing very simple reports and not on a regular basis

Duration:

1 Day Day(s)

Class size:

8

Course Name

Microsoft Power Bi Fundamentals

Course Description

This introduction to Power BI Desktop provides a condensed yet balanced look at the data analysis process. It starts by showing you how to import and connect to data from different sources, including Excel and CSV files. It then focuses on the process of shaping and cleaning data, plus appending tables in the Query Editor.
You will also learn how to create interactive end user dashboards using a range of visualisations.
The course ends with a brief look at the Power BI online service where reports are published so we can easily share them with others.
Some knowledge of Microsoft Excel is preferable.

Take Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
This Fundamentals course does not look at DAX (please look at the 2 day Introduction for DAX)

Audience

• Managers (who will not be creating reports but want a good idea of what their team do, what some of the terms mean, etc.) • People with very basic Excel knowledge • People who will be doing very simple reports and not on a regular basis

Duration:

1 Day Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PBI F

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

Microsoft Power BI Intermediate

Course Description

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This 'intermediate' course has been tailored to include specific functionality required within Network Rail.

Implementing Row Based security
. Using the Power BI service
. Creating workspaces / Apps / content packs
. The difference between a workspace and app and when to use
. Managing permissions
. Scheduling auto refresh
. Conditional Formatting (text & numbers)
. Drill downs (single visual / cross page)
. Creating dynamic themes / titles
. Using JSON files & Dax / slicers to create dynamic titles)
. Using bookmarks
. Import & Direct query and when to use
. Time intelligence (4 week calendar)
. Comparing historical periodical data using Sales data focussing on trends & forecasts
. Creating effective tooltips
. Data modelling
. Setting up a Schema
. Getting around common problems (e.g. creating a dataset of single values)
. DAX aggregates
. DAX logics
. Measures & new columns
. Emphasise on when to use a measure / calculated column
. Creating variables within measures & using Return / return if
. Working with untidy data
. Key influencers / decomposition tree analytics tools

Note: this course is not targeted at end-users of the software with limited experience.

Audience

It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Fundamentals, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables. Please Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.

Duration:

2 Day(s)

Class size:

8

Course Name

Microsoft Power BI Intermediate

Course Description

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This 'intermediate' course has been tailored to include specific functionality required within Network Rail.

Implementing Row Based security
. Using the Power BI service
. Creating workspaces / Apps / content packs
. The difference between a workspace and app and when to use
. Managing permissions
. Scheduling auto refresh
. Conditional Formatting (text & numbers)
. Drill downs (single visual / cross page)
. Creating dynamic themes / titles
. Using JSON files & Dax / slicers to create dynamic titles)
. Using bookmarks
. Import & Direct query and when to use
. Time intelligence (4 week calendar)
. Comparing historical periodical data using Sales data focussing on trends & forecasts
. Creating effective tooltips
. Data modelling
. Setting up a Schema
. Getting around common problems (e.g. creating a dataset of single values)
. DAX aggregates
. DAX logics
. Measures & new columns
. Emphasise on when to use a measure / calculated column
. Creating variables within measures & using Return / return if
. Working with untidy data
. Key influencers / decomposition tree analytics tools

Note: this course is not targeted at end-users of the software with limited experience.

Audience

It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Fundamentals, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables. Please Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.

Duration:

2 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IT/APPS/PBI I

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Microsoft Power BI Introduction

Course Description

This two-day course goes beyond just the basics and includes a comprehensive look at using Power BI Desktop, as well as Microsoft’s Power BI Pro online service.
With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. With the use of DAX calculations and a comprehensive range of visualizations, you can then produce detailed reports.
The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.
This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.
1. Getting Started
The Power BI Process
Launch Power BI Desktop
The Four Views of Power BI
Create Report Visuals
2. Getting Data
Connect to Data Sources
Connect to an Excel File
Connect to a CSV File
Connect to a Database
Connect to a Web Source
Connect to a Folder of Files
Create a Data Table
3. Transform and Append Data
Clean Data in the Query Editor
Remove Rows by Filter
Replace Values, Query Data Types
Data Type Detection, Add a Custom Column
Append Data to a Query, Add an Index Column
Resolve Error Issues
Perform Basic Math Operations • The Power Query Editor
Fill Data Up and Down
Split Column by Delimiter
Add Conditional and Custom Columns
A Simple Column Merge
4. Pivot and Unpivot Data
Pivot Data in Power Query
Pivot and Append Data
Pivot but Don’t Summarise
Unpivot Data
Append Mismatched Headers
5. Manage Table Relationships Merge Queries
Table Join Kinds
The Merge Process
6. Group Data in Power Query
Group Rows in a Table
7. Build a Data Model
Relate Tables in a Data Model
Cardinality
Data modelling schema
Filter Flow
Table joins
Hide in Report View
8. Dax Calculated Columns
Create Calculated Columns 
Calculated columns best practice
Dax Syntax
Common function categories  
9. Introduction to DAX Measures
DAX Rules
Turn off Field Summarisation
The COUNTROWS Function
The DISINCTCOUNT Function
The CALCULATE Function
The SUMX Function
When to Use SUMX vs. SUM
10. Introduction to Time Intelligence
Standard Calendar vs. Custom Calendar
Calendar: A Special Lookup Table
Mark a Calendar as a Date Table
Time Intelligence Functions
The TOTALYTD Function
11. Create Report Visualizations
Create and Format Visuals
Create a Map Visual, Create a Chart Visual
Format Map and Chart Visuals
Create Table, Matrix and Card Visuals
KPI, Gauge, Waterfall visuals
Format Table visuals
Control a Visual’s Number Format
Use Slicers to Filter Data
Sync Slicers Across Pages
Visuals from the Marketplace
Export Report Data to Excel
12. Hierarchy, Groups and Conditional Formats
Create a Hierarchy to “Drill” Data
Compare Data in Groups
Add Conditional Formatting
13. Publish and Share Your Report Online
Publish to the Online Power BI Service
Get Reports from Power BI Service
Get Quick Insights
What is Q&A?
Share your Report
14. Apply your learning
Post Training Exercise
When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
To enable you to get the most from this learning experience you must have read the DAX information sent to you prior.

Audience

A good understanding of Excel is required, specifically Pivot Tables, IF Statements, NESTED IF, VLOOKUPs, SUMIF, SUMIFS. Also, an understanding of Relational Database Technologies may be beneficial. The main pre-requisite is to have a good understanding of your business's need to collect, cleanse, analyse and deliver insights and visualisations of your business data.

Duration:

2 Days Day(s)

Class size:

8

Course Name

Microsoft Power BI Introduction

Course Description

This two-day course goes beyond just the basics and includes a comprehensive look at using Power BI Desktop, as well as Microsoft’s Power BI Pro online service.
With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. With the use of DAX calculations and a comprehensive range of visualizations, you can then produce detailed reports.
The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.
This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.
1. Getting Started
The Power BI Process
Launch Power BI Desktop
The Four Views of Power BI
Create Report Visuals
2. Getting Data
Connect to Data Sources
Connect to an Excel File
Connect to a CSV File
Connect to a Database
Connect to a Web Source
Connect to a Folder of Files
Create a Data Table
3. Transform and Append Data
Clean Data in the Query Editor
Remove Rows by Filter
Replace Values, Query Data Types
Data Type Detection, Add a Custom Column
Append Data to a Query, Add an Index Column
Resolve Error Issues
Perform Basic Math Operations • The Power Query Editor
Fill Data Up and Down
Split Column by Delimiter
Add Conditional and Custom Columns
A Simple Column Merge
4. Pivot and Unpivot Data
Pivot Data in Power Query
Pivot and Append Data
Pivot but Don’t Summarise
Unpivot Data
Append Mismatched Headers
5. Manage Table Relationships Merge Queries
Table Join Kinds
The Merge Process
6. Group Data in Power Query
Group Rows in a Table
7. Build a Data Model
Relate Tables in a Data Model
Cardinality
Data modelling schema
Filter Flow
Table joins
Hide in Report View
8. Dax Calculated Columns
Create Calculated Columns 
Calculated columns best practice
Dax Syntax
Common function categories  
9. Introduction to DAX Measures
DAX Rules
Turn off Field Summarisation
The COUNTROWS Function
The DISINCTCOUNT Function
The CALCULATE Function
The SUMX Function
When to Use SUMX vs. SUM
10. Introduction to Time Intelligence
Standard Calendar vs. Custom Calendar
Calendar: A Special Lookup Table
Mark a Calendar as a Date Table
Time Intelligence Functions
The TOTALYTD Function
11. Create Report Visualizations
Create and Format Visuals
Create a Map Visual, Create a Chart Visual
Format Map and Chart Visuals
Create Table, Matrix and Card Visuals
KPI, Gauge, Waterfall visuals
Format Table visuals
Control a Visual’s Number Format
Use Slicers to Filter Data
Sync Slicers Across Pages
Visuals from the Marketplace
Export Report Data to Excel
12. Hierarchy, Groups and Conditional Formats
Create a Hierarchy to “Drill” Data
Compare Data in Groups
Add Conditional Formatting
13. Publish and Share Your Report Online
Publish to the Online Power BI Service
Get Reports from Power BI Service
Get Quick Insights
What is Q&A?
Share your Report
14. Apply your learning
Post Training Exercise
When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
To enable you to get the most from this learning experience you must have read the DAX information sent to you prior.

Audience

A good understanding of Excel is required, specifically Pivot Tables, IF Statements, NESTED IF, VLOOKUPs, SUMIF, SUMIFS. Also, an understanding of Relational Database Technologies may be beneficial. The main pre-requisite is to have a good understanding of your business's need to collect, cleanse, analyse and deliver insights and visualisations of your business data.

Duration:

2 Days Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IT Apps / Power BI Intro

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

ORACLE - Projects for Project Team Members

Course Description

The Oracle Projects for Team Members curriculum is designed to take the end user through the Oracle Projects application in the Oracle E-Business Suite and to promote a wider understanding of how it interfaces with other Oracle applications such as iProcurement, Purchasing, Accounts Payable, General Ledger, HRMS, and OTL.
It is aimed at anyone in Network Rail who will need to use Oracle Projects as part of their role. Though the course touches on the planning tools P3e and OPIS, it does not cover either in detail. The course will give the user an overview of Oracle Projects from a systems perspective and does not go into detail in relation to local business process.
The Oracle Projects for Team Members course replaces the following historical courses:
•Oracle Projects for Project Managers (OP03)
•Oracle Projects for Commercial Assistants (OP02)
•Oracle Projects for Information Management (OPIM)
•Oracle Projects for Property.
 

Audience

Intended Audience : •Project Managers / Scheme Project Managers •Commercial Assistants or other members of a Commercial Team •Though not aimed at Planners, the course may be beneficial to Planners wishing to learn more about Oracle in relation to Projects •Anyone who wishes to learn more about Oracle Projects

Duration:

2 Day(s)

Class size:

2-8

Course Name

ORACLE - Projects for Project Team Members

Course Description

The Oracle Projects for Team Members curriculum is designed to take the end user through the Oracle Projects application in the Oracle E-Business Suite and to promote a wider understanding of how it interfaces with other Oracle applications such as iProcurement, Purchasing, Accounts Payable, General Ledger, HRMS, and OTL.
It is aimed at anyone in Network Rail who will need to use Oracle Projects as part of their role. Though the course touches on the planning tools P3e and OPIS, it does not cover either in detail. The course will give the user an overview of Oracle Projects from a systems perspective and does not go into detail in relation to local business process.
The Oracle Projects for Team Members course replaces the following historical courses:
•Oracle Projects for Project Managers (OP03)
•Oracle Projects for Commercial Assistants (OP02)
•Oracle Projects for Information Management (OPIM)
•Oracle Projects for Property.
 

Audience

Intended Audience : •Project Managers / Scheme Project Managers •Commercial Assistants or other members of a Commercial Team •Though not aimed at Planners, the course may be beneficial to Planners wishing to learn more about Oracle in relation to Projects •Anyone who wishes to learn more about Oracle Projects

Duration:

2 Day(s)

Class size:

2-8

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

PD/IT/ORACLE PPTM

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Possession Planning System Read and Write

Course Description

This course is aimed to take both internal and external users through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System and how to create Worksites TSR's and Possessions.
 

Audience

This course is intended for internal and external users of Possession Planning System.

Duration:

1 Day Day(s)

Class size:

8

Course Name

Possession Planning System Read and Write

Course Description

This course is aimed to take both internal and external users through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System and how to create Worksites TSR's and Possessions.
 

Audience

This course is intended for internal and external users of Possession Planning System.

Duration:

1 Day Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/PPS RW

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

Possession Planning System Read Only

Course Description

This course is aimed to take the user through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System.

Audience

This course is aimed at users within Capacity Planning and other roles that need to search for Possessions, workstites,TSR's and create reports.

Duration:

0.5 Days Day(s)

Class size:

8

Course Name

Possession Planning System Read Only

Course Description

This course is aimed to take the user through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System.

Audience

This course is aimed at users within Capacity Planning and other roles that need to search for Possessions, workstites,TSR's and create reports.

Duration:

0.5 Days Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/PPSRO

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes
How to Book

Course Name

Railway Cost Information Service CAF User Training - eLearning

Course Description

This course will provide users with the competencies required for CAF User level access to the Railway Cost Information Service.

Audience

All those who will have CAF User level access to the Railway Cost Information Service.

Duration:

60 minutes Day(s)

Class size:

999999

Course Name

Railway Cost Information Service CAF User Training - eLearning

Course Description

This course will provide users with the competencies required for CAF User level access to the Railway Cost Information Service.

Audience

All those who will have CAF User level access to the Railway Cost Information Service.

Duration:

60 minutes Day(s)

Class size:

999999

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

RCIS EL

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Elearning
Enrol Now

Course Name

Windows Digital Up-Skilling

Course Description

Tailored for colleagues in every role at Network rail our Windows Digital Up-Skilling course is designed to elevate your digital competency while integrating LEAN practices. From unlocking the features of your laptop or PC to efficient navigation and customisation of the Windows OS, this course addresses the specific needs of railway industry workers. Learn essential file management through OneDrive, enhance productivity in Microsoft Outlook and Teams, and efficient document creation in Word, Excel and impactful presentations in PowerPoint—all while adopting LEAN principles for streamlined processes. Whether you're a novice or a seasoned professional, this course ensures that your digital skills align seamlessly with the demands of the railway industry.

As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours.

Audience

All roles within Network Rail

Duration:

1 Day(s)

Class size:

8

Course Name

Windows Digital Up-Skilling

Course Description

Tailored for colleagues in every role at Network rail our Windows Digital Up-Skilling course is designed to elevate your digital competency while integrating LEAN practices. From unlocking the features of your laptop or PC to efficient navigation and customisation of the Windows OS, this course addresses the specific needs of railway industry workers. Learn essential file management through OneDrive, enhance productivity in Microsoft Outlook and Teams, and efficient document creation in Word, Excel and impactful presentations in PowerPoint—all while adopting LEAN principles for streamlined processes. Whether you're a novice or a seasoned professional, this course ensures that your digital skills align seamlessly with the demands of the railway industry.

As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours.

Audience

All roles within Network Rail

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

WDU

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face
How to Book

Course Name

Ellipse 9 Asset Data Manager

Course Description

This course is designed to take place over one day and will look at how to manage and implement the process for the efficient delivery of asset data changes. Through this process all asset changes are efficiently and effectively recorded through the maintenance of files, data and information held on corporate systems as defined in the applicable ADM standards.
Upon completion of this course, delegates should be able to comprehend an understanding into what makes an Equipment Reference, demonstrate; how to create / amend Equipment Asset Records including how to make the Assets Obsolete. In line with business process, delegates will also gain an understanding into what an MST is be able to demonstrate how to create, modify and make MSTs in-active.
Delegates will be assessed continuously by the Trainer on their ability to perform ADM orientated tasks.

Audience

The event is designed specifically for the following roles: -Systems Support Managers -Work Data Clerk Please note: - if your job discipline falls outside of these two roles, application for access will be assessed on an individual basis by the Business System Owner and their team.

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 ADM

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Ellipse 9 Data Entry

Course Description

The aim of this course is to provide users with the ability to use Ellipse as a tool for the processing and amendment of works orders pertaining to the maintenance of railway assets and the recording of labour costing information.  Processes and Procedures: 
-Asset Information Services (AIS)Online  
-Ellipse Navigation 
-Work Management Process 
-Standard Jobs 
-Equipment Register 
-Work Arising Identification Form 
-Work Order – search/create/amend 
-Reprioritisation
-Labour Costing 
-MSTs 
-Business Objects 
-Works Planner
 
Upon completion of the course, delegates will be able to request an Ellipse Data Entry profile, allowing them to search for information, create, amend and close Work Orders and process labour costing information.  

Audience

Section Planners or Section Administrators who are Route based.

Duration:

3 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 DE

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Ellipse 9 Read Only

Course Description

This one-day course has been designed for Management or Engineering personnel who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).  Course Assessment/Profiles: 
•There is no formal assessment at the end of the course. Following the course delegates will be able to apply for the Global Profile of Read Only access. This is suitable for Engineering, Supervision or Management Overview. 
Processes and Procedures: 
•AIS Hub – Ellipse Support section 
•Ellipse Navigation 
•Work Management Process 
•Standard Jobs 
•Equipment Register 
•Work Arising Identification Form 
•Work Order – search and review 
•Works Manager – review scheduled work 
•Business Objects 
 

Audience

The course has been designed for people who require an overview of Ellipse and need to be able to search for maintenance-related information within the system. It is not designed to provide in-depth knowledge of the system and should not be regarded as a substitute for formal training for a more in depth role (such as Section Planner).

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/ELLIPSE 9 RO

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

iOS Digital-Upskilling

Course Description

Tailored for colleagues in every role at Network Rail, our iOS Digital Up-Skilling course is designed to elevate your knowledge and everyday use of the hardware and software of our mobile devices, whether in an office or out on the track. This is a bespoke course, addressing your specific requirements, whether it is the use of Network Rail applications and software or just general use and familiarisation of an iPad or iPhone. Discuss your needs with your local RTSM and we will design the course bespoke for your cohort. As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours

Audience

This course is designed for anyone who manages Network Rail employees, with specific focus on new people managers. People Managers Supervisors Team Leaders And anyone who has a position involving line management to direct reports.

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IOSDU

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book

Course Name

iProcurement for Requesters and Preparers eLearning

Course Description

This training will show users how to procure goods and services using the Network Rail iProcurement catalogue and how to raise requisitions. Upon successful completion of the course (achieving 70% in the knowledge assessment), the delegate will be eligible to apply for iProcurement and SWIM.

Audience

All Network Rail employees who are required to prepare and raise requisitions via the Oracle iProcurement system.

Duration:

60 mins Day(s)

Class size:

N/A

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

PD/IT/IPROC EL

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Elearning

How to Book

Course Name

ITIL Foundation v4

Course Description

This course provides a broad-based view of the ITIL4 framework’s approach to Service Management. It covers a broad range of material at a high-level, as would reasonably be expected from a ‘Foundation’ course, with specific depth in key areas of service management and its practice. Organisations that are actively engaging with new areas of practice such as Lean and DevOps will gain from understanding how ITIL4 can help them embrace these areas with IT Service Management.

Audience

This course is for anyone that needs to know more about the latest version of the world’s most used Service Management framework. Delegates that are involved with an organisation that practices IT Service Management (ITSM) or hope to be should start here. Delegates that already hold an ITIL v3 Foundation certificate but haven’t taken their studies further should also start here as this course expands on their existing knowledge and takes it in new directions.

Duration:

3 Day(s)

Class size:

12

Competence Name Awarded:

Competence Awarded:

Course Code:

ITIL4

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book

Course Name

Microsoft Excel 2016 VBA Advanced

Course Description

Using Intrinsic Functions, Variables and Expressions
  • Defining Expressions and Statements
  • How to Declare Variables
  • Determining Data Types
  • Programming with Variable Scope
  • Harnessing Intrinsic Functions
  • Defining Constants and Using Intrinsic Constants Creating User Defined Functions
  • Creating a Function Procedure
  • Calling a UDF
  • Using a function within an Excel Workbook Message Boxes and Input Boxes
  • Adding Message Boxes
  • Using Input Boxes
  • How to Declare and Use Object Variables Handling Errors
  • Defining VBA's Error Trapping Options
  • Capturing Errors with the On Error Statement
  • Determining the Err Object
  • Coding an Error-Handling Routine
  • Using Inline Error Handling Creating Forms and Controls
  • Defining User Forms
  • Utilising the Toolbox
  • Using UserForm Properties, Events And Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Using the Label Control
  • Using the Text Box Control
  • Using the Command Button Control
  • Using the Combo Box Control
  • Using the Frame Control
  • Using Option Button Controls
  • Using Control Appearance
  • Setting the Tab Order
  • Filling a Control
  • Adding Code to Controls
  • How to Launch a Form in Code Working with Procedures
  • Procedure Arguments
  • Passing Arguments
  • Optional Arguments
  • Default Values
  • Passing arguments by value and reference Working with Ranges
  • What is a Range?
  • Range Property of the Application
  • Cells Property
  • The Special Cells Method
  • Naming Ranges Events
  • Workbook Events
  • Worksheet Events Working with Arrays
  • What is an Array
  • Array Sizes
  • One Dimensional Arrays
  • Arrays with Multiple Dimensions
  • A word about index numbers
  • Ubound and Lbound Charts
  • Creating charts from worksheet data
  • Key Properties and methods of the chart object
  • Manipulating Chart Data from cells Active X Data Objects
  • Key Objects
  • The Connection Object
  • The Record Set Object
  • A word about the connection string Appendix: Using the PivotTable Object
  • Understanding PivotTables
  • Creating A PivotTable
  • 2010 Pivot Wizard Procedure
  • Coding the manipulation, Pivoting the Table
  • Using PivotFields Excel VBA – Quick Reference Guide Programming Techniques
  • Best Practice for Excel Programming
  • Using Worksheet Functions
  • A Word about VB functions Ascii Codes
  • Inserting non- printable characters into literal strings
  • Controlling data entry into text boxes and other form controls.
  • A complete list of all standard ASCII codes is given below If time:-
  • Coding the File System object
  • Coding Word or PowerPoint from Excel
  • Coding to control Excel Application Events

Audience

•Delegates should have attended MS Excel VBA Introduction course. •Experience of recording and writing simple macros •Please note this course is not suitable for Excel 2010 users who have no VBA knowledge

Duration:

2 Days Day(s)

Class size:

1-12

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

EX10VBAA

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

NA

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Microsoft Excel VBA 2016 - Office Introduction

Course Description

At the end of this course you will be able to:
•Record and edit a Macro recorded within Excel/Word
•Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
•Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
•Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
•Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
•Create an error handling routine in case things go wrong with VBA code
Subject Areas
Lesson 1: Getting started
•Introducing Visual Basic for Applications
•Recording a Macro
•Running a Macro
•Absolute or Relative Cell Referencing
•Saving and Opening Files with Macros
•Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, and Buttons
•Editing a Macro in the Visual Basic Editor
•Understanding the Development Environment
•Tips for General Typing in VBA
•Using Visual Basic Help
Lesson 2: Working with Procedures
•Program Design
•Understanding Modules
•Creating a Module
•Understanding Procedures
•Programming Macro Concepts
•Creating a Subroutine
•Creating a Function
•Understanding Arguments
•Exiting Procedures
•Calling Procedures
Lesson 3: Understanding Objects, Properties, Methods, and Events
•Understanding Objects Properties, Methods, and Events
•Navigating the Object Hierarchy
•Understanding Collections
•Using the Object Browser
•Using the With Statement
•Working with Properties
•Working with Methods
•Creating an Event Procedure
Lesson 4: Using Expressions, Variables and Intrinsic Functions
•Naming Rules
•Understanding Expressions and Statements
•Declaring Variables
•Understanding Data Types
•Determining the Value of Variables
•Working with Variable Scope
•Using Built-in VBA Functions
•Understanding Constants
•Using Built-in VBA Constants
•Using Message Boxes
•Controlling the Answer to a Message Box
•Using Input Boxes
•Declaring and Using Object Variables
Lesson 5: Controlling Program Execution
•Understanding Control-of-Flow Structures
•Using the If...End If Decision Structures
•Using the Select Case ... End Select Structure
•Using the Do ... Loop Structure
•Using the For ... Next Structure
•Using the For Each ... Next Structure
•Guidelines for Use of Control-of-Flow Structures
Lesson 6: Working with Forms and Controls
•Understanding UserForms
•Using the Toolbox
•Working with a Form's Properties, Methods, and Events
•Working with Form and Control Properties, Methods and Event
•Working with Form Controls
•Setting the Tab Order
•Populating a Control
•Adding Code to Controls
Lesson 7: Debugging and Handling Errors
•Understanding Errors
•Using Debugging Tools
•Setting Breakpoints and Using Break Mode
•Stepping Through Code
•Trapping Errors with the On Error Statement
•Understanding the Err Object
•Working with Inline Error Handling
•Writing an Error-Handling Routine
Please can you ensure that you take your laptop for this trainptops are not provided as standard.

Audience

•Navigate, edit and manage Excel workbooks. •Format worksheets and workbooks. •Understand the difference between absolute and relative references. •Understand the basics of Excel formulas and functions, e.g. Sum, text functions. •Understand the concepts of a Macro and its capabilities.

Duration:

2 Days Day(s)

Class size:

4-8

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

QAVBA10INT

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Microsoft Power Bi Fundamentals

Course Description

This introduction to Power BI Desktop provides a condensed yet balanced look at the data analysis process. It starts by showing you how to import and connect to data from different sources, including Excel and CSV files. It then focuses on the process of shaping and cleaning data, plus appending tables in the Query Editor.
You will also learn how to create interactive end user dashboards using a range of visualisations.
The course ends with a brief look at the Power BI online service where reports are published so we can easily share them with others.
Some knowledge of Microsoft Excel is preferable.

Take Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
This Fundamentals course does not look at DAX (please look at the 2 day Introduction for DAX)

Audience

• Managers (who will not be creating reports but want a good idea of what their team do, what some of the terms mean, etc.) • People with very basic Excel knowledge • People who will be doing very simple reports and not on a regular basis

Duration:

1 Day Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PBI F

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book

Course Name

Microsoft Power BI Intermediate

Course Description

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published. This 'intermediate' course has been tailored to include specific functionality required within Network Rail.

Implementing Row Based security
. Using the Power BI service
. Creating workspaces / Apps / content packs
. The difference between a workspace and app and when to use
. Managing permissions
. Scheduling auto refresh
. Conditional Formatting (text & numbers)
. Drill downs (single visual / cross page)
. Creating dynamic themes / titles
. Using JSON files & Dax / slicers to create dynamic titles)
. Using bookmarks
. Import & Direct query and when to use
. Time intelligence (4 week calendar)
. Comparing historical periodical data using Sales data focussing on trends & forecasts
. Creating effective tooltips
. Data modelling
. Setting up a Schema
. Getting around common problems (e.g. creating a dataset of single values)
. DAX aggregates
. DAX logics
. Measures & new columns
. Emphasise on when to use a measure / calculated column
. Creating variables within measures & using Return / return if
. Working with untidy data
. Key influencers / decomposition tree analytics tools

Note: this course is not targeted at end-users of the software with limited experience.

Audience

It is recommended that you have completed either the Excel Intermediate or Excel Advanced level workshops as well as Power Bi Fundamentals, or have equivalent experience. It is expected that you have a good understanding of Excel functions such as IF and VLOOKUP functions, as well as Defined Names, Importing Data and a basic understanding of PivotTables. Please Note: When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.

Duration:

2 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IT/APPS/PBI I

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Microsoft Power BI Introduction

Course Description

This two-day course goes beyond just the basics and includes a comprehensive look at using Power BI Desktop, as well as Microsoft’s Power BI Pro online service.
With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. With the use of DAX calculations and a comprehensive range of visualizations, you can then produce detailed reports.
The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.
This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.
1. Getting Started
The Power BI Process
Launch Power BI Desktop
The Four Views of Power BI
Create Report Visuals
2. Getting Data
Connect to Data Sources
Connect to an Excel File
Connect to a CSV File
Connect to a Database
Connect to a Web Source
Connect to a Folder of Files
Create a Data Table
3. Transform and Append Data
Clean Data in the Query Editor
Remove Rows by Filter
Replace Values, Query Data Types
Data Type Detection, Add a Custom Column
Append Data to a Query, Add an Index Column
Resolve Error Issues
Perform Basic Math Operations • The Power Query Editor
Fill Data Up and Down
Split Column by Delimiter
Add Conditional and Custom Columns
A Simple Column Merge
4. Pivot and Unpivot Data
Pivot Data in Power Query
Pivot and Append Data
Pivot but Don’t Summarise
Unpivot Data
Append Mismatched Headers
5. Manage Table Relationships Merge Queries
Table Join Kinds
The Merge Process
6. Group Data in Power Query
Group Rows in a Table
7. Build a Data Model
Relate Tables in a Data Model
Cardinality
Data modelling schema
Filter Flow
Table joins
Hide in Report View
8. Dax Calculated Columns
Create Calculated Columns 
Calculated columns best practice
Dax Syntax
Common function categories  
9. Introduction to DAX Measures
DAX Rules
Turn off Field Summarisation
The COUNTROWS Function
The DISINCTCOUNT Function
The CALCULATE Function
The SUMX Function
When to Use SUMX vs. SUM
10. Introduction to Time Intelligence
Standard Calendar vs. Custom Calendar
Calendar: A Special Lookup Table
Mark a Calendar as a Date Table
Time Intelligence Functions
The TOTALYTD Function
11. Create Report Visualizations
Create and Format Visuals
Create a Map Visual, Create a Chart Visual
Format Map and Chart Visuals
Create Table, Matrix and Card Visuals
KPI, Gauge, Waterfall visuals
Format Table visuals
Control a Visual’s Number Format
Use Slicers to Filter Data
Sync Slicers Across Pages
Visuals from the Marketplace
Export Report Data to Excel
12. Hierarchy, Groups and Conditional Formats
Create a Hierarchy to “Drill” Data
Compare Data in Groups
Add Conditional Formatting
13. Publish and Share Your Report Online
Publish to the Online Power BI Service
Get Reports from Power BI Service
Get Quick Insights
What is Q&A?
Share your Report
14. Apply your learning
Post Training Exercise
When requesting this course you MUST have Power BI downloaded and installed on your computer. If you do not have Power BI installed you will not be able to partake in the course.
To enable you to get the most from this learning experience you must have read the DAX information sent to you prior.

Audience

A good understanding of Excel is required, specifically Pivot Tables, IF Statements, NESTED IF, VLOOKUPs, SUMIF, SUMIFS. Also, an understanding of Relational Database Technologies may be beneficial. The main pre-requisite is to have a good understanding of your business's need to collect, cleanse, analyse and deliver insights and visualisations of your business data.

Duration:

2 Days Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

IT Apps / Power BI Intro

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book

Course Name

ORACLE - Projects for Project Team Members

Course Description

The Oracle Projects for Team Members curriculum is designed to take the end user through the Oracle Projects application in the Oracle E-Business Suite and to promote a wider understanding of how it interfaces with other Oracle applications such as iProcurement, Purchasing, Accounts Payable, General Ledger, HRMS, and OTL.
It is aimed at anyone in Network Rail who will need to use Oracle Projects as part of their role. Though the course touches on the planning tools P3e and OPIS, it does not cover either in detail. The course will give the user an overview of Oracle Projects from a systems perspective and does not go into detail in relation to local business process.
The Oracle Projects for Team Members course replaces the following historical courses:
•Oracle Projects for Project Managers (OP03)
•Oracle Projects for Commercial Assistants (OP02)
•Oracle Projects for Information Management (OPIM)
•Oracle Projects for Property.
 

Audience

Intended Audience : •Project Managers / Scheme Project Managers •Commercial Assistants or other members of a Commercial Team •Though not aimed at Planners, the course may be beneficial to Planners wishing to learn more about Oracle in relation to Projects •Anyone who wishes to learn more about Oracle Projects

Duration:

2 Day(s)

Class size:

2-8

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

PD/IT/ORACLE PPTM

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Possession Planning System Read and Write

Course Description

This course is aimed to take both internal and external users through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System and how to create Worksites TSR's and Possessions.
 

Audience

This course is intended for internal and external users of Possession Planning System.

Duration:

1 Day Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/PPS RW

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book

Course Name

Possession Planning System Read Only

Course Description

This course is aimed to take the user through how to search for possessions, worksites and Temporary Speed Restrictions (TSR's) as well as create reports within Possession Planning System.

Audience

This course is aimed at users within Capacity Planning and other roles that need to search for Possessions, workstites,TSR's and create reports.

Duration:

0.5 Days Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

PD/IT/PPSRO

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face This course requires Virtual Classes

How to Book

Course Name

Railway Cost Information Service CAF User Training - eLearning

Course Description

This course will provide users with the competencies required for CAF User level access to the Railway Cost Information Service.

Audience

All those who will have CAF User level access to the Railway Cost Information Service.

Duration:

60 minutes Day(s)

Class size:

999999

Competence Name Awarded:

N/A

Competence Awarded:

N/A

Course Code:

RCIS EL

Prerequisite Name:

N/A

Prerequisite Short Code:

N/A

Skills Assessment Scheme Regime:

N/A

Course Type:

This course requires Elearning

Enrol Now

Course Name

Windows Digital Up-Skilling

Course Description

Tailored for colleagues in every role at Network rail our Windows Digital Up-Skilling course is designed to elevate your digital competency while integrating LEAN practices. From unlocking the features of your laptop or PC to efficient navigation and customisation of the Windows OS, this course addresses the specific needs of railway industry workers. Learn essential file management through OneDrive, enhance productivity in Microsoft Outlook and Teams, and efficient document creation in Word, Excel and impactful presentations in PowerPoint—all while adopting LEAN principles for streamlined processes. Whether you're a novice or a seasoned professional, this course ensures that your digital skills align seamlessly with the demands of the railway industry.

As the IT Training Team within Network Rail, we pride ourselves on our ability to provide bespoke solutions tailored to meet your individual IT needs. Whether you require one-to one or closed cohort training, face to face or virtual, we understand the importance of addressing your specific requirements. Our dedicated team of experts possesses in-depth knowledge of Network Rail's IT systems and can deliver training sessions that align precisely with your job roles and responsibilities. We are committed to ensuring that you receive the highest quality training experience, empowering you to enhance your IT skills and proficiency. With our personalised approach, we guarantee that you will receive the support and guidance necessary to excel in your IT endeavours.

Audience

All roles within Network Rail

Duration:

1 Day(s)

Class size:

8

Competence Name Awarded:

Competence Awarded:

Course Code:

WDU

Prerequisite Name:

Prerequisite Short Code:

Skills Assessment Scheme Regime:

Course Type:

This course requires Face to Face

How to Book