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.

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.

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.

Assertiveness is the quality of being self-assured and confident without being aggressive. Assertive individuals are able to get their point across without upsetting others, or becoming upset themselves. This course focuses on understanding the difference between aggressive, passive and assertive behaviours to improve personal communication effectiveness.

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

A one day programme focused on written business communication.

To write effectively requires knowledge of the process for constructing written business communications. When applied to various types of written communication such as a report, presentation, memo, letter, e-mail, this knowledge helps produce clear, concise, unambiguous communications.

The programme provides delegates with a chance to obtain the knowledge, test its application, and thus become more confident when faced with a written communication task at work.

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).

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.

Conflicts can be resolved peacefully and effectively. Peacefully discussing differences of opinion is a healthy way to bring important issues to light and strengthen your relationships with co-workers, managers and suppliers, as well as friends and significant others. This course helps delegates learn how to effectively handle conflict in a way that minimises stress and relieves tension.

Good customer care depends on the attitudes and skills of each individual employee. Without it few businesses succeed. People at all levels need to understand how communication works from the customer's perspective and to get an understanding of the best way to approach individual customers.

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 course is aimed at staff within organisations who possess very little formal knowledge of personnel management but have a level of responsibility for it. The course is intended to raise awareness and understanding of the main areas of involvement.

The workshops are designed to be highly interactive using a combination of discussion, exercises and quizzes, examples of best practice and recent case law to help participants apply the techniques to their every-day work and problems.

It greatly enhances the relevance and understanding of the course if reference can be made to existing policies, procedures and problems experienced within the workplace.

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.

This interactive course enhances interview skills by providing an opportunity to learn the different phases of interviewing: preparation and planning, conducting an interview, and following up. This includes a high level of delegate participation.

This course is designed for supervisors and first line managers who are new to their roles.

This course aims to introduce supervisors and first line managers to their new roles, developing particular awareness and skills in the areas of leadership style, motivation and delegation.

The aim of this course is to identify stress in self and others and what we can do to manage this that promotes a positive health and wellbeing culture at work.

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

During this course delegates will learn how to create, manage, and track personal and team plans, integrate tasks with goals, and visually monitor progress using the enhanced features available in Microsoft Planner Premium. You will also learn how to integrate Planner with other Microsoft 365 apps, such as Outlook, Teams, and To-Do, to enhance your productivity and workflow.

This 4-day course is intended for anyone new to designing and implementing self-service business intelligence solutions with Microsoft Power BI Desktop and the Power BI Service. The course structure is very comprehensive and provides a total immersion in the subject matter. 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 is continually evolving, this course is regularly reviewed and updated to keep the 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, and client requirements.

The course structure takes a broad and practical approach to Power BI, defining best practices and demonstrating useful techniques that will prove extremely useful in the workplace. The content delivered will also help delegates prepare for the “PL-300 Microsoft Power BI Data Analyst” exam.

The first part of the course introduces the capabilities and components of Power BI before delving into the realms of discovering and loading data from a variety of sources. Primarily focussed on using Power Query to create robust queries, students will learn about issues surrounding data quality, how to cleanse data, how to transform and then restructure data, and how to mashup data from various sources by merging and appending data. We will also examine how to manage, structure, and parameterise queries. Although a lot can be achieved working with the user interface in Power Query, we will also delve behind the scenes and introduce 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 also learn about the DAX expression language to enable them to implement calculated columns, measures, and calculated 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 visuals. 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 initially look at how we can further enhance the user experience by implementing features such as drill through reports, bookmarks, and showing and hiding content. Then, in order to share reports created in Power BI Desktop, 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 different ways of sharing 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.

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.

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.

Minutes are a vital method of recording information and capturing thoughts and ideas. It is important that this becomes an easy process. This Minute Taking course illustrates the various stages of minute taking and covers invaluable techniques.

When was the last time you thought about how you influence others, how you change minds, shape opinions, move others to act?

This course will give you greater insight in order to develop your skills and confidence in using your influence - irrespective of your formal role or grade. Improving your skills in influencing, communication and negotiation will help you understand what makes you and other people tick, how to work more effectively and how to develop a convincing personal style to reach mutually satisfactory outcomes in different situations.

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 one day, highly interactive, fun, yet practical event has been designed for delegates to learn more about themselves and the different styles of others, increasing personal effectiveness to support the achievement of business and personal goals.

The focus is on individuals becoming more self-aware and identifying how others impact on ourselves and how we impact on other people. Our ability to understand ourselves and others, increases our ability to become for personally effective and influential.

Personal effectiveness and communication skills are key to delivering in our job role, interacting with people, team working and developing teams and individuals. Further development in these skills will have an impact on many areas of day-to-day work e.g. meetings, problem solving; time-management; decision-making and all aspects of communication.

Delegates will have an opportunity to focus on their own personal effectiveness and style and through this, further develop their interpersonal skills.

Each delegate will receive a personal profile, which provides them with information on their personality type, as an aid to understand more about self and others. This will then be used to identify strategies for enhancing personal effectiveness and influence. The Profile will be used as a working document throughout the programme as a basis for self-analysis and group discussions. Delegates may then go on to use it as a personal development tool.

https://www.clarity4d.com/about

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.

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.

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.

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.

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.

Discover everything you need to know about creating a social media marketing strategy.

Learn how to engage with your target audience and attract new customers.

This three-day instructor-led course provides students who wish to develop and maintain SQL Server databases Additionally, it will be of use to individuals who administer applications that deliver content from SQL Server databases.

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.

Managing others can be one of the toughest challenges we face at work, covering a huge range of responsibilities and tasks. This course gives a complete overview of what a manager needs to know, covering both technical and relationship skills. Delegates will leave with a thorough understanding of what good management looks like, and how to use it to get the best from others.

All of us, no matter how successful in our fields, will face adversity at some point in our careers. When the pressure is on, the difference between thriving or not is resilience.

This practical course will give you the tools and knowledge to live and work with less stress by developing your skills in dealing with frustration, anxiety and pressure in positive ways.

Effective use of the telephone is an essential skill within every department of every organisation. The telephone is an integral part of an organisation's success. Many people are unaware of the image they portray whilst speaking on the phone. This course teaches delegates how to make and take calls, and how to deal with tough situations on the phone such as complaints.

Time can only be used once. This course teaches delegates how to manage time effectively. It helps delegates keep priorities in focus and avoid time wasting. The course is interactive and includes a high level of delegate participation.

People benefit from training that's well organised and implemented, and the key to successful training is the trainer. Only a trainer who is properly skilled can maximise the learning opportunity. This course is highly interactive and requires attendees to give brief presentations and lessons to the other delegates.

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