IT Courses

Overview: This Microsoft Access course is for delegates who have sound skills in the use of MS Access and are now ready to expand their knowledge into some of the more specialised and advanced features of the software. This course will provide delegates with the skills needed to create complex queries, create macros to automate tasks, enhance forms and reports and use the Access programming language Visual Basic for Applications (VBA), enabling delegates to really take control of their databases.

Overview: This Access course enables delegates to progress from the one level databases associated with holding data in Microsoft Excel, to multiple table relational databases, covering all the basics including the advantages and disadvantages. This course is a perfect starting point for a future in data manipulation.

Overview: This Acrobat Professional course will enable delegates to share electronic versions of documents with others in a format that allows them to view, print, and even review the content, even if they don't have the original software that was used to create the file. In this course, delegates will use Adobe Acrobat to convert documents to PDF files, and will customise PDF files for both their needs and the needs of the reader.

Overview: This course is designed to take participants through the development process of building software demonstrations and interactive simulations. The course is task-based, with participants learning by recording and updating projects. Along with covering the key features of Captivate, the course focuses on best practices to record Captivate projects.

Overview: Adobe Illustrator is a drawing and design package. This course will give you the experience you need to produce professional Graphics and illustrations, and will increase your levels of productivity and creativity within illustrator. Once you have completed this course you can move on to the Adobe Illustrator Advanced course.

Overview: This course will take you through the advanced techniques of Illustrator, helping you to become more efficient and effective when using Adobe Illustrator.

Overview: Adobe InDesign is an industry-leading program that takes desktop publishing and design to a new level. The goal of this course is for you to be able to create simple but professional documents that are ready to use for the web and for print.

Overview: This course, aimed at those who have attended the Introduction to InDesign, will introduce the advanced tools and techniques through hands on exercises and theory.

Overview: Lightroom Classic is a great solution for image organisation and management, rapid editing and adjustment, and sharing and presentation. While Photoshop allows you to make incredibly complex edits to individual images, Lightroom offers a far simpler solution for photographers to manage their image catalogue, make bulk edits and adjustments, and rapidly output the final product.

Our one day introduction course gets you up and running on this powerful application in no time at all. We teach you how to use the interface to manage your image catalogue, edit metadata, detect faces, make adjustments to exposure or colour temperature, crop, and make localised corrections.

Overview: This course has been designed with beginners in mind. It is an introduction into the features of Adobe Photoshop, guiding the delegates around the imaging tools required to enhance and manipulate graphics, in order for them to be placed into publications.

Overview: Adobe Photoshop is the industry standard image manipulation tool. This course, aimed at those who have attended the introduction to Photoshop course or have used it regularly. Delegates will gain an understanding of Photoshop to use it with confidence for both print and web applications.

Overview: Premiere Pro Getting Started is a 2 day hands on training course which covers the basics of using Adobe Premiere Pro. The course starts at the very beginning discussing concepts like storyboarding, resolution and frame rate.

You will learn how to import footage, take clips and create your own sequences. Within these sequences you will then make adjustments with a variety of editing tools such as slip and slide or ripple and roll.

As the course progresses you will learn how to apply transitions and adjust them, create titles and edit them, and apply things like captions to your video.

In addition to the video editing process you will also learn to work with audio, apply effects, work with ducking and lots more.

If you want to get up and running quickly and professionally with Premiere Pro this live course is the answer.

Overview: ArcGIS Advanced builds on the material covered on the Introduction-level courses, and explores some of the more advanced capabilities of ArcGIS Desktop.
ArcGIS Advanced Day 1 leans more towards topics concerning data analysis and presentation. The course explains the benefits of the Geodatabase format, explores the more advanced functions relating to everyday operations such as Labelling, Symbology Editing and Layouts, and introduces the software's Reporting function.
ArcGIS Advanced Day 2 leans more towards topics concerning data editing and data processing. The course explains the more advanced data capture functions & keyboard shortcuts, and shows how to use the Field Calculator for smart attribute editing. It will also demonstrate the use of the ArcToolbox menus for geoprocessing, and introduce the concept of Modelbuilder for the automation of repetitive workflows.
The course is suitable for ArcGIS users with previous experience (at least 6 months would be recommended), or those who have recently attended an Introduction-level course.

Overview: This two-day ArcGIS training course is aimed at those who are new to the ArcGIS Desktop software (or to GIS), or those at a novice level. Through a combination of tutor led teaching and hands-on exercises it aims to give users confidence to use the power of GIS and ArcGIS to display, manipulate and analyse information geographically, with the result that they are able to make more informed decisions.

Day 1 covers basic data manipulation and presentation - it will show you how to use and create Map Documents and Layers in ArcMap, and how to make best use of the Catalog. You will also learn different ways of interacting with features on the map, how to define and save symbols for features, and how to present data in a layout.

Day 2 covers basic data analysis, editing and importing - it will show you how to write a query to select specific features; how to bring in data from an external source such as Excel; how to set up an attribute join to visualise such data on the map; how to create shapefiles and geodatabases; how to edit existing map features and create new ones using the edit toolbar.

Overview: Through a combination of tutor led teaching and hands-on exercises the course aims to give users confidence to use the power of the latest version of ArcGIS Pro to present, manipulate and analyse information geographically, in order to be able to make more informed decisions, share information effectively ... and produce great looking maps!

Overview: This course is designed for: Structural Fabricators and detailers who want to get to grips with the essentials of Advance Steel.

Overview: This course is designed to give a good fundamental understanding of 3D modelling, It covers Solid Modelling, 3D Faces, Model/Paper Space, bi-directional, Boolean, Adaptive.

Overview: This course is designed for the new AutoCAD® user who requires comprehensive training in AutoCAD. It incorporates the features, commands, and techniques for creating, editing, and printing drawings with AutoCAD LT. Hands-on exercises throughout the course explore how to create 2D production drawings.

Overview: This course is designed for the experienced AutoCAD user who requires additional training. It incorporates the features, commands, and techniques for becoming more productive when creating, annotating, and printing drawings with AutoCAD.

This courseware is designed for the new AutoCAD® user who requires comprehensive training in AutoCAD. It incorporates the features, commands, and techniques for creating, editing, and printing drawings with AutoCAD LT. Hands-on exercises throughout the courseware explore how to create 2D production drawings.

Overview: This courseware is designed for the new AutoCAD® Civil 3D user who requires comprehensive training in AutoCAD Civil 3D. It incorporates the features, commands, and techniques for creating, editing, and managing 3D Civil Models with hands-on exercises throughout the course.

Overview: Delegates are introduced to the fundamental principles of 3D parametric part design. Learn how to create intelligent parametric parts by capturing design intent and how this helps to streamline the process of modifying and documenting designs.

Learn the fundamental principles and recommended workflows for creating 3D assemblies and learn the proper techniques and recommended workflows for creating, placing, and constraining custom and standard components in an assembly.

Delegates learn the proper techniques and recommended workflows for creating base, projected, section, detail, and isometric views of 3D parts and assemblies. Students will also learn how to define and follow drafting standards while dimensioning and annotating drawing views.

Overview: This courseware builds on the fundamental principles gained from Inventor Essentials part 1.

Delegates learn the basics of 3D sketching, and build upon 2D sketching knowledge. They will also learn new tools for creating more complicated shapes, cover parameters in more depth and assign appearances and materials to parts.

This courseware covers the fundamental principles and recommended workflows for “top down” design techniques as well as documenting assemblies. Delegates learn the proper techniques and recommended workflows for documenting assemblies using standard and exploded drawing views, how to customise assembly views, and how to create overlay views that represent multiple mechanism orientations.

Overview: Using the functionality of the Autodesk Navisworks Review, Simulate, and Manage, this course teaches delegates how to combine 3D geometry from cross disciplines into one scene to enable e-ective model reviews, and run object-interference checks on 3D models.

Overview: This course covers a wide range of advanced topics in Revit® Architecture, continuing to build on the concepts introduced in the Revit Architecture Essentials course. Students learn about site design, advanced rendering techniques, phasing and design options, creating families of custom components, and collaborating on a design.

Overview: This course covers the basics of Revit® Architecture, from schematic design through construction documentation. Students are introduced to the concepts of Building Information Modelling and the tools for parametric building design and documentation.

Overview: This course covers the basics of Family Creation within Revit software, from profile and simple families through to nested fully parametric objects. Delegates are introduced to the process of creation and editing families and the tools utilised for parametric adaptions.

Overview: During this course delegates will learn about building information modelling and the tools for parametric MEP systems design and documentation using Autodesk Revit® MEP. Begin the three-day guide by learning the fundamental features of Autodesk Revit MEP, then progressing through schematic design, system analysis and construction documentation, and finishing with design visualisation.

Overview: This course covers the basics of Revit Structure, from schematic design through construction documentation. Students are introduced to the concepts of Building Information Modelling and the tools for parametric building design and documentation.

Overview: This course covers the basics of Template Creation within Revit software. Delegates are introduced to the process of creation and editing families and the tools utilised for parametric adaptions.

Overview: This four-day course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this course you will learn day-to-day management tasks including how to manage applications client health hardware and software inventory operating system deployment and software updates by using Configuration Manager. You also will learn how to manage compliance and create management queries and reports.

Overview: We offer Camtasia on a private course basis. This course is not available as a public scheduled event.

Camtasia is a popular screen recording and video editing software application that allows users to create professional videos and tutorials. Videos can be imported or captured from the screen, then text and other media can be added. All of which can be enhanced with a range of effects and animations.

A Camtasia project can then be published in various formats, including SCORM compliant e-learning which can be uploaded to a Learning Management System.

This course is designed to cover every aspect of Camtasia, taking the delegate from the very basics of video creation through to adding text, images, audio and other media. To editing and finally publishing in the many output formats available.
Along the way, topics such as quizzes and screen captures are covered. Everything needed to create professional videos and tutorials.

Overview: Canva is easy graphic design for people who aren’t graphic designers!

It’s used mainly to make social media posts look professional, as you can publish your designs straight to Facebook, Twitter etc …although it’s recently expanded into presentations.

There are two versions of Canva – paid (pro) and free. This Canva training course can be attended by people who have either account (there are only a few differences and I will include workarounds for the features that aren’t included in the free version).

Overview: SPECIAL NOTICE

The CISSP course is not delivered as a boot camp or exam prep course. Our course is a ‘theory based’ guide through the eight ISC2 domains to support your learning of the ISC2 Book of Knowledge. This course should be taken many months in advance of your CISSP exam booking. It will not substitute the considerable amount of self-study that all CISSP delegates need to undertake. This course attracts mixed ability delegates and is always tailored to meet the needs of all participants.

Aimed at security professionals, this course surveys the entire information security landscape and the technologies involved. The course addresses the eight knowledge domains that comprise the common body of knowledge (CBK) for information systems security professionals and will help delegates prepare for CISSP certification.

The course offers a theory based approach to the security process, with opportunities to discuss the immediate application of concepts and techniques described in the CBK to the real world. It can be considered as providing a good introduction to security management, architecture and engineering.

The course comprises of eight sessions that map directly to the (CBK), each one is theory based with instructor led discussions; there are no hands on labs.

Overview: Whether you are new to Agile principles and have an idea of what Scrum is or have already spent time involved with teams talking about or implementing Scrum ensuring success with Scrum can be a daunting prospect.

You have understood that the benefits of ‘going agile’ include improving quality productivity and time to market but how does this happen in practice? And how can you ensure that you can deliver these process improvements? If you have not undertaken Scrum Training with a formally Certified ScrumMaster (CSM) Trainer then you may be missing key knowledge and skills that will enable you to make the most of the opportunities afforded by effective implementation of Scrum principles and practices.

The 2 day highly interactive CSM course investigates the Scrum framework in detail from theory and foundations to practical application and pitfalls covering all the team roles activities and artifacts so that you can be an effective Scrum Master or member of a Scrum team.

Overview: Whether you are new to Agile principles and have an idea of what Scrum is or have already spent time involved with teams talking about or implementing Scrum taking on the Product Owner role can be a daunting prospect. The role of the Scrum Product Owner is crucial to the overall Scrum Team acting as the liaison between the development team and the wider customer community.

An effective Scrum Product Owner will work collaboratively with stakeholders to define the overall product vision and is responsible for communicating that vision to the team and motivating the team to deliver a high quality product. The Product Owner is responsible for creating and maintaining the Product Backlog and is a key contributor to the Sprint Planning and Review Meetings. The Scrum Product Owner can help maximise delivery capabilities enhance the planning and scheduling process improve project estimation and drive overall product success.

If you’ve not undertaken Scrum Training with a formally Certified Scrum Trainer then you may be missing key knowledge and skills that will enable you to make the most of the opportunities afforded by effective implementation of Scrum principles and practices.

This 2 day interactive course investigates the Scrum framework in detail from theory and foundations to practical application and pitfalls covering all the team roles activities and artifacts but focuses specifically on the role played by the Product Owner. You will learn about activities such as managing stakeholders vision definition ROI management Product Backlog definition and refinement creating effective stories defining acceptance criteria for stories and defining “done” with the rest of the Scrum Team.

Overview: ChatGPT is a revolutionary technology that’s reshaping the world of work. Everybody is talking about it, but most people are not using it effectively.

ChatGPT gained 100,000,000 users in less than 60 days but 99% of people don't know how to use it to its full potential.

This course will help you harness the full potential of ChatGPT. It’s designed to take you from beginner to expert.

Overview: This course can benefit you in two ways. If you intend to pass the CompTIA A+ Core 1 (Exam 220-1101) certification examination, this course can be a significant part of your preparation.

However, certification is not the only key to professional success in the field of IT support. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your skill set so that you can confidently perform your duties in any entry-level PC support role.

Overview: This course can benefit you in two ways. If you intend to pass the CompTIA A+ Core 2 (Exam 220-1102) certification examination, this course can be a significant part of your preparation.

However, certification is not the only key to professional success in the field of IT support. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your skill set so that you can confidently perform your duties in any entry-level PC support role.

Overview: This course is aimed at those new to using a computer. Delegates will learn basic computer concepts and skills related to the Windows environment. In addition, delegates will also learn the basics of Microsoft Word and Outlook.

Overview: During this Crystal Reports course, delegates will learn the basics of report creation, from linking the report to the requisite data source, to distributing the report to others. Delegates will also learn about sorting, grouping, linking, basic formula creation and working with Crystal Report experts.

Overview: Delegates will learn how to create advanced formulas in Crystal Reports, format Crystal reports based on calculation results (conditional formatting), use multiple sections, insert sub reports and access data from sources other than PC databases.

Overview: The aim of this course is to educate users in the basics of using Office 365 and its services and cover basic administration processes.

Aimed at the user wishing to acquaint themselves with the basic features and administration of Office 365. The course stresses the role of OneDrive, SharePoint and Teams in document management.

Familiarity with the basics of Windows is highly recommended to get the most out of this course.

Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.

We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.

It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.

For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.

Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.

Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.

The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.

Overview: This course is split into 3 main areas:

1. Get and Transform (Power Query)
2. Power Pivot - Data Models and DAX calculations
3. Dashboard Creation with Pivot Tables, Charts and Slicers

It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.
This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.

Overview: This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.

Overview: Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.

This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.

Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.

Overview: This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.

Overview: This course is for small business owners, members of marketing departments, those seeking a career change wishing to become Google AdWords professionals, and web designers seeking to offer AdWords as an additional service.

Overview: Knowing how people and customers interact with your websites and mobile applications can provide potent insights into how well the messages, pages, and other content on your website is received. By monitoring, tracking, and analysing visitors to your website and their activities on your website, you can draw conclusions about the effectiveness of your site content, promotions, and advertising campaigns and technical details such as site architecture and navigation.

Google Analytics is free to use and easy to set up. It allows your organization to track user actions on your web properties and use Google Analytics' rich reporting and analysis tools to analyse data, measure discrete interactions on your site, and qualify the success of your web initiatives. With Google Analytics, you can define success metrics for your website and measure that performance through data analysis. Google Analytics also lets you monitor your site in real-time, and provide alerts when events occur that are out of the norm.

Overview: Google Keep allows you to quickly capture ideas, create lists, and take notes. And more importantly, you can view, manipulate, and use your data instantly and share it with anyone.

Overview: This course is aimed at those new to Google Slides, or who have limited knowledge of the package. During this course delegates will explore the Slides environment and create presentations.

Delegates will format text on slides, add graphical objects to a presentation, modify objects on slides, add tables to a presentation, add charts to a presentation and prepare to deliver a presentation.

Overview: This one day course uses the free Google Web Designer tool and is ideal for designers who are looking to create web ads and animated online content without the need to learn to write code. Using an intuitive, design focused interface we teach you how to create banners, animate your content, work with 3d tools, adjust content, and lots more.

If you are new to Google Web Designer it can be a bit intimidating and our one day course will have you up and running in no time at all.

Overview: The course is an introduction to Google Workspace. It will help users format, manage and present data effectively and improve workflow and team collaboration.

Overview: Do you want to build content for your website, create HTML email campaigns, or maybe even use HTML and CSS from within other programs like InDesign (yes that is possible)?

If so our 1 day beginners course is for you, aimed at those who are completely new to HTML5 and CSS3, our experienced instructors can accommodate both those who want to learn to write the code manually, and those who prefer to avoid this by using Dreamweaver to generate everything.

During the course you will learn how to create basic HTML5 pages, using CSS3 to add more complex design elements as you go, resulting in professional looking content that you will want to share with others. This course includes 1 day of live online learning, backed up by post course support and access to online resources for practicing your new skills.

Overview: Java is everywhere and is as popular as ever. This hands-on course, delivered using Java 11, endeavours to provide the fundamental skills you need to become a Java Developer. We'll have you build a series of realistic apps focusing on object-oriented principles from the start.

Note that this is not a beginners course. You are expected to be familiar with programming concepts and have a little coding experience. If not you should consider our Learn to Code with Java course instead.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Overview: The Java Programming 2 course is closely aligned with the Oracle Java SE 8 Programmer II exam.

This course focuses on the core language features and Application Programming Interfaces (APIs) you will use to design effective object-oriented and functional programming applications with the Java Standard Edition 8 Platform.

This course will teach you how to design and develop robust Java code that is easy to test and maintain and can be integrated into multiple applications.

The most important new topics introduced in Java SE 8 are covered, such as Functional Programming and Stream API, that allow you to use the most up to date techniques in your code.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Overview: We offer Mapinfo training on a private course basis only. This course is not available as a public scheduled event.

The course is aimed at those who have good knowledge and experience in the use of MapInfo data and the software and are ready to further their knowledge through some advanced MapInfo training. The aim is to give the delegates confidence to use some of the more advanced options and to learn some of the background settings and structure of the MapInfo system.

Overview: We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.

The course is aimed at those who have gained some experience in the use of MapInfo data and the software and are ready to further their knowledge. The aim is to give the MapInfo trainees confidence to use their own data within the MapInfo environment, learn how to map external data sources, perform basic analysis and produce themed maps from their data.

Overview: This one-day course is designed to help business users understand the basics of Microsoft Copilot for Microsoft 365, a productivity tool that uses artificial intelligence to provide real-time intelligent assistance within Microsoft 365 productivity apps including Word, Excel, PowerPoint, Teams and Outlook. It is designed to transform productivity, creativity, collaboration for users, teams and organisations.

The course is beginner-friendly and requires no previous AI expertise.

Overview: The Technical overview of Microsoft 365 Copilot for the IT Professional Course, delves into the capabilities of Microsoft 365's AI-powered feature designed to enhance productivity and efficiency within organizations. This course will explore the following key areas:

Microsoft 365 Copilot Features: Uncover the ways in which Microsoft 365 Copilot can streamline tasks across applications such as Word, Excel, PowerPoint, Outlook, Teams (and many more applications!). Understand Microsoft 365 Copilot functionality including content generation, summarization, text refinement and tone suggestions via natural language prompts.

Microsoft Business Chat, an innovative cross-app experience unlocking capabilities to improve information discovery and context across multiple apps including calendar, emails, chats, documents, meetings and contacts. Microsoft Business chat is available to users from Microsoft 365.com, Bing (when signed in with a work account), or within Microsoft Teams.

Microsoft 365 Copilot Architecture: Gain insights into the inner workings of Microsoft 365 Copilot as it harnesses vast language models (LLMs) and organization's data via the Microsoft Graph. Discover the power of Microsoft Semantic Index, a cutting-edge technology facilitating swift and accurate retrieval of contextually relevant information.

Microsoft 365 Copilot Prerequisites and Licensing: Navigate the technical prerequisites and feature enablement necessary for an organization to leverage Microsoft 365 Copilot's potential. Explore pricing and licensing options for both Microsoft 365 Copilot and Business Chat.

How Microsoft 365 Copilot ensures enterprise-grade data security and privacy through integration with Microsoft 365 security and compliance features including Data Loss Prevention, Sensitivity Labels, Defender for Cloud Apps File Policies, Data Access Governance Reports

Microsoft 365 Data Collaboration, Classification and Reporting features to identify and protect sensitive data including Collaboration Insights, Sensitive Information Types, Microsoft Syntex and Microsoft Priva.

IT Professional's Readiness and Deployment Tasks for Microsoft 365 Microsoft 365 Copilot: Understand required the skills and tasks to ready your organization for Microsoft 365 Microsoft 365 Copilot's integration. This includes configuring permissions, managing administrative controls, change management, promoting adoption, and overseeing usage monitoring.

Upon completing this course, you will possess a holistic comprehension of Microsoft 365 Copilot and its potential transformative impact on an organization and requirements as an IT Professional to deploy, secure, manage, promote and support a Microsoft 365 Copilot Deployment.

Overview: This Microsoft Forms Essentials course covers how Forms, SharePoint and Power Automate integrate into data collection and storage solutions in Office 365.

Overview: This course covers how Forms, SharePoint and Power Automate integrate into data collection and storage solutions in Office 365.

Overview: As desktops has evolved, so have methods for deploying and updating them. In this course, you'll learn how to plan and implement an operating system deployment strategy. This course will help you understand the various methods available, the scenarios they're suited for, as well as how to deploy Windows using modern methods. This course will also cover planning and implementing an update strategy for Windows.

During this course, you’ll be introduced to key components of modern management and co-management strategies. You’ll examine what it takes to incorporate Microsoft Intune into your organization and how to use it to manage modern desktops and devices. You’ll also learn about methods for deployment and management of apps and browser-based applications.

In this course, the student will be introduced to the key concepts of security in modern management. This course covers authentication, identities, and access, as well as about how to protect these categories. The student will be introduced to Azure Active Directory and learn how to use Microsoft Intune to protect devices and data with compliance policies. Finally, this course will cover key capabilities of Azure Information Protection and Windows Defender Advanced Threat Protection and how to implement these capabilities.

Overview: Power Apps is a suite of apps, services, connectors, and a data platform that provides you with an opportunity to build custom apps for your business needs.

This 1-day course explores the basic building blocks and allows you to create your own Apps and understand how to develop your skills to the next level.

Overview: This course is available on a private course basis only.
We run the Microsoft Power BI Desktop course as a public scheduled event and also as a private course.

This 4-day course is intended for anyone who is new to designing and implementing self-service Business Intelligence (BI) solutions using Microsoft Power BI Desktop and the Power BI Service. It is ideal for anyone who needs a total immersion in the subject matter as the course structure is very comprehensive. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience. Due to the very comprehensive nature of this course, the content delivered may vary depending on new and updated features, delegate requirements, and course objectives.

This course is also commensurate with the “PL-300 Microsoft Power BI Data Analyst” course and serves as ideal preparation for the Microsoft PL-300 exam. In addition to providing the knowledge required for this exam, this course takes a broader and more practical approach to Power BI, demonstrating useful techniques that will prove extremely helpful in the workplace.

The first part of the course introduces the capabilities and components of Power BI Desktop before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create queries for implementation in data models, students will learn how to shape and transform loaded data, mashup data from various sources by merging and appending data, and manage, structure, and parameterise queries. Delving behind the scenes, students will also be introduced to the M language, highlighting ways in which existing code can be tweaked and how user defined code and functions can be implemented.

Part two of the course introduces students to tabular data modelling concepts, preparing the data in readiness for use in reports and dashboards. The importance of implementing relationships is also covered. In order to enhance the data model, students will be introduced to the DAX expression language to enable them to implement calculated columns, measures, and tables. Consideration is also given to implementing time intelligence in the design of data models.

In part three, you will learn how to create and design reports and implement visualisations. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). The implementation of maps in reports is also given coverage. To create interactivity in reports, students will also learn how to implement various types of filters and slicers.

Finally, in part four, we turn our attention to the Power BI Web Service. Attendees will learn how to publish reports to the Power BI Service and how to organize and secure content. The creation and use of dashboards will be considered, and the sharing of content will also be given coverage. We will look at user accessibility issues and consider how users, including mobile users, can interact with report content. Managing and refreshing datasets in the Power BI Service is also included.

Additionally, with the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.

Overview: Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

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 course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.

Overview: Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

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 course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.

Overview: This two day course is designed for individuals who will use Microsoft Project as a tool to assist them in managing projects. The topics in this course cover the critical skills necessary to create and modify a project plan file that contains tasks, resources, and resource assignments.

Overview: Microsoft Sway is a presentation program that allows you to create interactive reports, stories, presentations and more

Sway can include text, pictures and media, pulling content from a variety of locations, including your own device, network or internet source.

Sways are stored on Microsoft's servers and tied to a Microsoft account, although more content is available when accessing through an Office 365.

Overview: This course is for users wishing to acquaint themselves with the basic features of Microsoft Teams in Office 365. The course stresses the role of Teams, Channels, Files, Meetings and Chat.

Overview: This Microsoft Office 365 course is aimed at the Office 365 user wishing to manage their Office 365 Tenancy and the major Applications within it as well as automating business processes in Office 365.

Overview: This course is aimed at those wishing to setup Office 365 and keep it running.

Overview: This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course stresses the role of Outlook as an "All in One" messaging, SharePoint for Team collaboration and Lync 2010 for unified communications.

Overview: This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365. The course covers the role of using the Office Online Applications to create, edit, comment and share documents.

This course can be tailored to meet your organisations requirements.

Each topic area is 90 minutes. Choose 4 x 90 minute modules for a 1 day course, or
2 x 90 minute modules for a half day course

Overview: This course is aimed at the user wishing to acquaint themselves with the basic features of Office 365 and OneDrive for Business. The course stresses the role of OneDrive for Business as a document storage location and how it is used by Office and Outlook.

Overview: The Oracle PL/SQL course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Overview: The Oracle PL/SQL Stored Program Units course provides practical experience in developing and writing triggers, functions, procedures and packages. It also introduces some of the Oracle-supplied packages.

Overview: The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced.

Overview: The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features.

Overview: The Oracle SQL Fundamentals course is designed to give delegates practical experience in writing Oracle SQL statements and scripts. A wide range of SQL functions and data manipulation statements are introduced.

Overview: This course is aimed at those who are already using Microsoft Outlook but want to work more efficiently. Do you find email a helpful tool or a frustrating chore? This course is intended to help you develop an effective email strategy.

You’ll develop techniques for keeping your email clean so that incoming mail isn’t missed. And find important emails in the future.

Overview: Many of us use Outlook every day but that doesn't mean you're getting the most out of it. As the versions progress new features are introduced and there are also some hidden features too that you wouldn't stumble across unless you went looking for them. This course will help you work better, faster and more efficiently ensuring you get the most out of Microsoft Outlook.

Overview: This 1-day course is designed for anyone new to creating and implementing flows in Microsoft Power Automate. The content will introduce delegates to the key concepts of Power Automate, with the goal of empowering them to design and implement their own solutions in the workplace.

At course completion, attendees will possess sufficient knowledge to work with Power Automate to automate and manage common everyday business processes. Delegates will understand when and why Power Automate should be implemented and be able to create practical and useful flows to suit individual requirements. In essence, all the skills necessary to help them design and develop their own office automation solutions.

The course includes automating processes in Microsoft SharePoint, Outlook, Excel Online, OneDrive, and Microsoft Teams.

Please note, this course is about automated cloud flows. In other words, automation in the cloud, not desktop automation.

The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power Automate is continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring the best return on investment from the learning experience. As such, the content delivered may vary slightly from the advertised course outline depending on new and updated features.

Overview: This course is aimed at those new to PowerPoint, or who have limited knowledge of the package. During this course delegates will explore the PowerPoint environment and create presentations.

Delegates will format text on slides, add graphical objects to a presentation, modify objects on slides, add tables to a presentation, add charts to a presentation and prepare to deliver a presentation.

Overview: This interactive workshop enables delegates to develop and refine their presentation and public speaking techniques.

This course involves a high level of delegate participation.

At the end of the course, delegates will be able to plan, outline, and create a presentation. Delegates will also be able to recognise and apply effective presentation techniques.

Overview: Many are leaving PowerPoint behind and using the new Prezi Next software for business presentations. Prezi helps you create exciting, professional and colourful presentations, using both a blank canvas and fully customisable presentation templates. You can insert and customise text, colour schemes, images and videos as well as create your own videos.

Upon completion of this course, delegates will be able to create their own Prezi presentation either from Prezi templates or from scratch, become confident in the creation of non-linear presentations and learn how to design & build an amazing presentation that everyone will remember.

Overview: This two day project management course covers the theory of managing a project. Anyone who needs to plan projects as a core or significant part of their job will benefit from attending.

An essential ingredient of a successful project is the effective utilisation of the project resources over time. This two day course provides a structured approach to project planning, highlighting the concepts and techniques in a progressive series of steps to enable the delegates to produce realistic and achievable plans.

Overview: Microsoft Publisher is an easy to use desktop publishing application that helps you create, customise, and publish materials such as newsletters, brochures, flyers and catalogues.

In this Publisher course, delegates will create a publication from scratch as well as using some of the hundreds of business and personal designs available in Publisher. This course will enable delegates to create, design, and edit publications.

Overview: Python is an object oriented rapid development language deployed in many scenarios in the modern world.

This Python Programming 1 course is designed to give delegates the knowledge to develop and maintain Python scripts using the current version (V3) of Python.

There are many similarities between Python V2 and Python V3. The skills gained on this course will allow the delegate to develop their own skills further using Python V2 or V3 to support the development and maintenance of scripts.

The Python Programming 1 course comprises sessions dealing with syntax, variables and data types, operators and expressions, conditions and loops, functions, objects, collections, modules and packages, strings, pattern matching, dates, exception handling, files, and databases.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Overview: The Python Programming 2 course comprises sessions dealing with advanced object orientation, iterators and generators, comprehensions, decorators, multithreading, functional programming, web services, and unit testing.

The delegate will learn how to exploit advanced features of the Python language to build complex and efficient applications.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

The delegate will learn and acquire skills as follows:

Encapsulating classes
Exploiting polymorphism using inheritance and mixins
Associating objects via composition and aggregation
Working with static members
Using iterators as an alternative to for
Constructing custom iterators
Constructing functions that yield generators
Manipulating lists, sets, and dictionaries using comprehension
Exploiting aspect oriented programming using decorators
Writing multithreaded code
Sharing data between threads
Processing collections using lambdas
Building RESTful clients
Building RESTful APIs
Testing units of code

Overview: This course is aimed at those already familiar with PowerPoint. During this course delegates will go beyond using the standard layouts and designs offered by PowerPoint, to creating their own designs.

Delegates will integrate current design trends into their presentations to create modern but professional slides and learn some of the tricks and short-cut methods for doing so. You will create a presentation containing a variety of slide layouts which can used as a template for future presentations.

Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

The Sage workshops follow on from the Level 1 and 2 courses, looking in detail at some specific Sage program areas.

Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

This course introduces the Sage Accounting program, and is ideal for those with a small amount of book keeping / financial knowledge, but who are new to Sage. It covers the basics of how Sage works, along with all of the day to day transactions which you are likely to come across when using Sage Accounts programs day to day.

Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

This course follows on from the Introduction to Sage Accounts course, to look at some of the more intricate or less common tasks you might need to undertake.

Overview: We offer Sage training on a private course basis. Private Sage training is tailored to meet your own needs and can be delivered using a backup of your own Sage system, this ensures that the training is relevant to your own organisation.

Training can be delivered using our tutor-led virtual classroom option or we can come to your site. Please contact us for a quote.

This course is aimed at those who need to process Payroll on a Sage 50 system. It will give you all of the information necessary to set up Sage 50 Payroll to suit your business, and to process day to day transactions including:

making payments, deducting PAYE and NI, processing attachments, student loans and statutory payments. It will also cover calculating how much you need to pay to HMRC each month, and submitting information to HMRC as and when required. This 2 Day course also covers calculating and recording holidays and pensions in detail, as well as further options including timesheet entry, nominal link to Sage Accounts, loans, statement of employment & personnel information.

Overview: This Search Engine Optimisation course is ideal for anyone who is responsible for increasing the number of high-quality visitors to a website and wants to understand how to ensure their website ranks highly with search engines like Google and Yahoo. This course will benefit beginners and improvers. Achieving good rankings with search engines is often vital to reach existing and potential customers - over 80% of internet users say that search engines are the main way they find things on the internet.

Overview: The goal of this course is to take you from Zero to Hero and provide you with the knowledge required both as an end user and as a site administrator or owner of Microsoft SharePoint sites to understand, use, create, configure and manage SharePoint Sites in Office 365/Microsoft 365.

Note – If you are a ‘back end’ SharePoint Administrator looking for training on the SharePoint Admin Center, you should attend
Mastering SharePoint Online Design, Architecture and Best Practice Administration

This course is a combination of the following two courses:
Mastering SharePoint Fundamentals
Mastering SharePoint Online Site Administration

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

Day 1
The first day is designed for users who are new or have basic skills with SharePoint and want to understand SharePoint and be able to use SharePoint.

You will discover and understand:

What SharePoint is and how it fits into Microsoft Teams and Microsoft 365
Key benefits of SharePoint
What is a SharePoint Site and what are is the difference between a Team Site and Communication Site
SharePoint Document Libraries and Microsoft Lists
SharePoint Document features including versioning, metadata and co-authoring
SharePoint Pages, News, Events, Spaces
Extended SharePoint functionality via apps
SharePoint permissions and sharing with people inside and outside the organisation
Microsoft Search to discover information within SharePoint and across Microsoft 365

Day 2-5
The next 4 days of this course take you from being a user of a SharePoint Site to being a Site Owner/Site Administrator

You will understand and learn how to create, configure and manage:

What are SharePoint Site Administrators’ roles and responsibilities
SharePoint Evergreen model and how to keep up to date with changes
SharePoint Site Use cases and templates
SharePoint Administrators vs Site Administrators vs Site Owners
Top-Level Site vs Subsite Administration
Creating Sites and Site Designs
Creating, configuring and managing Site Pages
Understanding Lists vs Libraries
Creating, configuring and managing Site Lists
Creating, configuring and managing Site Libraries
Creating, configuring and managing metadata: Site Columns, Content Types, Managed Metadata
Document Sets
Document ID aka Durable links
Creating, configuring and managing Site News
Creating, configuring and managing Site Events
Creating, configuring and managing Site Spaces
Creating, configuring and managing Site Navigation: Site Navigation, Home Sites and Global App Bar
Targeting Content and Navigation using Audiences
Understanding Creating, configuring and managing Hub Sites
Understanding and configuring Site Permissions
Understanding and configuring External Sharing
Creating, configuring and managing Site Libraries
Extending SharePoint Site Functionality using Apps and Features
Understanding and configuring Site Settings

Overview: This one day course is designed to familiarise the SharePoint user with the basics of creating, permissioning, populating and managing a SharePoint Team Site

Overview: With a quarter of the planet estimated to be using Social Media today, Social Media has become a valid component of a comprehensive marketing communications programme.

How can you use this opportunity effectively to promote your business?

What do you need to do to use Social Media strategically?

During this course we show you how Social Media can support your overall marketing plan. We will mix theory with practical, hands-on experience and discussion about your specific business objectives.

This course is ideal for any marketing people or business owners who are new to Social Media or who are already active on Social Media but would like to learn how to use them more effectively.

We will concentrate on the "Big 4" of Twitter, LinkedIn, Facebook and YouTube.

Overview: This course will provide you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter and sort data from multiple tables and how to use views and stored procedures.

Overview: This 5 day course is intended for students new to querying and programming with Microsoft SQL Server products who need a total immersion in the subject on a SQL Server 2016 or 2017 platform. This is a very comprehensive and intensive course with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.

Additionally, with the course structure being fully modularised, customised versions of this course can also be devised and delivered to suit individual requirements. In fact, specific content from this course could also be combined with material from other related courses to produce a bespoke training package – just ask for details.

Overview: This 3 day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2016 or 2017 system infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server administration concepts, tools and utilities. The installation of SQL Server, covered in the first module of the course, is optional and can be omitted to free up time for other topics if desired.

The course focuses on managing a single on-premise SQL Server Database instance and does not delve into more advanced enterprise features such as high availability and replication. Neither do we consider cloud-based solutions in this course. That said, for delegates looking to get a strong grounding in SQL Server architecture and administration, perhaps before advancing on to more advanced features, this is an ideal course upon which to build.

Attendees will gain insight into the infrastructure and architecture of SQL Server, enabling individuals to fully understand the product with which they are dealing. Configuration of server instances and databases is given full treatment, as are database transaction logs, and the creation and maintenance of indexes. Concise treatment is given to managing SQL Server security, including both at the server and database level. The focus then shifts to examining how best to move and protect data, such as when importing or exporting it between heterogeneous data sources, backing it up to external media, and restoring data from a backup. Many tasks involved in the day to day administration of a SQL Server instance can be performed automatically, making an administrators life potentially simpler, and such is the subject matter in the module dealing with SQL Server Automation. The final part of the course looks at monitoring and troubleshooting SQL Server performance and related issues.

Overview: This course is aimed at those who would like to develop their skills and knowledge of VBA programming in Access application development.

Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.

Overview: This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value

Overview: Visio provides a dedicated, familiar, Microsoft drawing environment, complete with a broad range of templates, shapes, and sophisticated tools designed to make creating a wide variety of business and technical diagrams easy, giving business and technical users the power to visualise and communicate ideas, information, and systems.

Delegates will learn basic concepts for creating flowcharts, cross-functional flowcharts, and organisation charts. This includes learning the basics for using and creating shapes, printing drawings, creating custom stencils, and many time-saving shortcuts and techniques designed to increase user productivity.

Overview: This five-day course features intensive hands-on training that focuses on installing, configuring, and managing VMware vSphere 8, which includes VMware ESXi™ 8 and VMware vCenter® 8. This course prepares you to administer a vSphere infrastructure for an organization of any size.

This course is the foundation for most VMware technologies in the software-defined data center.

Overview: The Web Development 1 with HTML, CSS and JavaScript course comprises sessions dealing with HTML, CSS and JavaScript - the three core languages of web development. HTML tags give a web page its structure, Cascading Style Sheets provide the style, and JavaScript code is used to make the page dynamic and interactive. All three are essential for a modern, responsive web site.

The delegate will learn how to construct and style a simple web site, and add dynamic and interactive behaviour to their web pages.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Overview: This five-day instructor-led course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2022. Additionally, this course teaches how to deploy other Active Directory server roles such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).

Please note, this course is also applicable for learners using Windows Server 2016 and Windows Server 2019

Overview: This five-day course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2022, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2022. This course is also applicable to learners using Windows Server 2016 or Windows Server 2019.

Overview: This five-day course will provide you with the knowledge and skills required to configure the networking features in Windows Server 2022, to automate and consolidate networking processes and resources, easily connect private clouds with public cloud services, and connect users to IT resources and services across physical boundaries. You will learn how to configure some of the key networking features, such as IP addressing, IP Address Management (IPAM), Domain Name System (DNS), and Dynamic Host Configuration Protocol (DHCP), Remote Access technologies, such as Virtual Private Networks (VPNs). You will learn how to integrate your branch office networks and network infrastructure with Hyper-V and use advanced Hyper-V networking features. You will be introduced to software defined networking.

Overview: This Word course covers the advanced features of Microsoft Word for delegates who need to work with forms, large or complex documents, and sharing documents among multiple team members.

Overview: This course is for delegates who want to learn to be more productive with Microsoft Word. Delegates will learn how to use the essential day to day functions of Word including how to create and edit documents and use character and paragraph formatting. Delegates will also be shown ways to ensure word documents are consistent and engaging using headers and footers, SmartArt and many other design features.