Business Applications Training Courses

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.

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.

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.

The Advanced After Effects Course is a great next step if you have already attended the beginners After Effects course and want to learn the more advanced features for producing motion graphics and visual effects. You will go through topics such as masking, keyframes, shapes, path animation, working with effects, 3D, tracking plus lots more.

This 2 day Instructor led Advanced After Effects Class runs at our York Centres and can also be held as a closed course at your preferred location for a team of people.

This 2 day live course covers all of the basic skills needed to start using Adobe After Effects properly.

During the course you will learn to work with layers in After Effects, understand keyframing, control animations, work transparency, and better understand rendering and output.

By the end of the class you will be able to competently edit your video content using After Effects and applying best practice techniques taught by an Adobe Certified Instructor.

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.

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.

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

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.

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.

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.

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.

The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.

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.

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.

During this course delegates will learn how to use Storyline to create effective and interactive eLearning projects either for desktop or mobile devices.

The course covers software simulation, handling videos and creating question surveys.

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.

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.

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*reg* 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

This practical, hands-on course is designed for Excel users who want to prepare their data effectively for use in Power BI Desktop. Delegates will learn how to structure, clean, and optimise Excel data so it can be imported, modelled, and visualised seamlessly in Power BI. By the end of the day, participants will understand the key differences between Excel and Power BI data handling, and will be confident in applying best practices that reduce errors, improve efficiency, and create a solid foundation for insightful reporting.

Learn to devise and create clickable and profitable Google Ads.

Focus your campaigns to give you superb ROI from your advertising budget.

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.

HTML & CSS are the fundamental building blocks of the web. This course is designed to provide delegates with the fundamental knowledge and skills necessary to build simple web pages. It further serves to provide a platform for further learning both in HTML and CSS, and JavaScript.

Delegates will learn how to build simple web pages that incorporate text elements, hyperlinks, images, tables and (simple) forms. Delegates will also learn about CSS and how to apply basic styling to HTML elements.

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

Course Notes:

There is an overlap between the content of this 1 day Introduction to HTML & CSS course and the content on the suggested follow-on 3 day Modern, Responsive Websites with HTML & CSS course.

You may wish to review the content of the Modern, Responsive Websites with HTML & CSS course and if more suitable to your training needs attend this course rather than the 1 day Introduction to HTML & CSS course.

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.

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

The one-day SQL course is designed for users with a good knowledge of MapInfo, but who have difficulty getting to grips with query building and the management and use of queries.

It’s for those using any version of MapInfo Pro and is run as a hands-on session. Training notes are provided for back-up and revision purposes.

The course’s aim is to give the user the ability to use SQL within MapInfo and allow them to textually and spatially analyse data.

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.

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

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

Are you ready to unlock the potential of the Power Platform? Our beginner-friendly course will empower you to build applications using Microsoft’s powerful suite of tools. Whether you’re a non-technical enthusiast or a budding developer this course is tailored for you.

Since this is a beginner's course we will cover two of the four Power Platform tools within the course curriculum Power Apps and Power Automate. You will also learn to integrate with common Office 365 products such as Outlook and One Drive.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

This Search Engine Optimisation course is ideal for anyone new to SEO and 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. Achieving good rankings with search engines is often vital to reach existing and potential customers.

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

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.

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

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.

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.

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.