8654 Courses

If you're looking for a short, sharp high-impact intervention that will help motivate and inspire your sales team then a 'bite-sized' session could be just what you're looking for. We have a range of sessions that can be delivered on an 'off-the-shelf' basis, or they can be tailored to your specific requirements or, of course, we can develop something specifically for you on an entirely bespoke basis. And the length of the session is entirely up to you - 45-minutes, an hour, a half-day - whatever you prefer. Sessions can be run for small groups as part of your regular team meetings or they can be delivered for larger audiences, conference-style - the choice is yours. The session outlines below are just to give you an idea of the possibilities. If one of them whets your appetite please just give us a call on 01582 463463 to talk through what we can do for you - we're here to help!

REFERENCE CODE 600/6511/4 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at those who are involved in plastering activities in the workplace. It is not expected that candidates working in this industry all do the same activities so the qualification has been developed to allow opportunities for those carrying out work in any one of the following broad categories: solid basic plastering, solid full plastering, basic fibrous plastering and full fibrous plastering. Those taking the qualification must also prove knowledge and competence in working at heights, calculating quantities and wastage and the use of powered and hand tools and equipment. All work completed must be done in accordance with building regulations and industry recognised safe working practices, including the disposal of waste. The qualification is structured to ensure that there is a high degree of flexibility within the units available and will allow employees from companies of all sizes and specialisms equal opportunity to complete. To provide this opportunity in addition to the core skills above, candidates will also be able to select optional units recognising skills including, working with direct bond dry linings, laying sand and cement screeds, installing mechanically fixed plasterboard and carrying out repair work. The standards cover the most important aspects of the job. This qualification is at Level 2, although some units may be at different levels and should be taken by those who are fully trained to deal with routine assignments. Candidates should require minimum supervision in undertaking the job

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables

There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service. It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way. It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level. The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away. 1 Getting Started The Power BI ecosystem Opening Power BI Desktop Power BI's four views Introduction to Dashboards 2 Importing Files Importing data sources Importing an Excel file Importing a CSV file Importing a database Connect to an SQL Server Database Import vs. Direct Query Importing from the web Importing a folder of files Managing file connections 3 Shape Data in the Query Editor The process of shaping data Managing data types Keeping and removing rows Add a custom column Appending tables together Hiding queries in reports Fixing error issues Basic maths operations 4 The Data Model Table relationships Relationship properties 5 Merge Queries Table join kinds Merging tables 6 Inserting Dashboard Visuals Things to keep in mind Inserting maps Formatting Maps Inserting charts Formatting Charts Inserting a tree map Inserting a table, matrix, and card Controlling number formats About report themes Highlighting key points Filter reports with slicers Sync slicers across dashboards Custom web visuals 7 Publish and share Reports Publishing to Power BI service Editing online reports Pinning visuals to a dashboard What is Q&A? Sharing dashboards Exporting reports to PowerPoint Exporting reports as PDF files 8 The Power Query Editor Fill data up and down Split column by delimiter Add a conditional column More custom columns Merging columns 9 The M Functions Inserting text functions Insert an IF function Create a query group 10 Pivoting Tables Pivot a table Pivot and append tables Pivot but don't aggregate Unpivot tables Append mismatched headers 11 Data Modelling Expanded Understanding relationships Mark a date table 12 DAX New Columns New columns and measures New column calculations Insert a SWITCH function 13 Introduction to DAX Measures Common measure functions Insert a SUM function Insert a COUNTROWS function Insert a DISTINCTCOUNT function Insert a DIVIDE function DAX rules 14 The CALCULATE Measure The syntax of CALCULATE Insert a CALCULATE function Control field summarisation Things of note 15 The SUMX measure X iterator functions Anatomy of SUMX Insert a SUMX function When to use X functions 16 Time Intelligence Measures Importance of a calendar table Insert a TOTALYTD function Change financial year end date Comparing historical data Insert a DATEADD function 17 Hierarchies and Groups Mine data using hierarchies Compare data in groups

Learn how to use OneNote to create, organize and populate electronic notebooks. Course overview Duration: 4 hours OneNote is a digital notebook and can be a great way to easily take notes. Whether for meetings, on training courses or to help with to do lists. It works very much like it’s paper copy equivalent but, of course, with lots of enhanced features. Its integration with Outlook and the other office applications means you can easily take notes and link them to documents meeting details and then email them out. You can even add audio and video notes as reminders. Objectives  By the end of the course you will be able to: Create and manage notebooks Add contents Tag and prioritise content Create notes from other applications Create To Do Lists and integrate into Outlook Content Using OneNote Creating notebooks Creating sections and pages Formatting pages Using page templates Creating page templates Reordering sections and pages Deleting sections and pages Creating OneNote content Adding text Bullet lists Adding tables Adding images Adding drawings Adding links Adding audio and video notes Tagging Tagging Creating custom tags Creating to-do lists Searching and filtering for tags Notes Creating quick notes Filtering them in OneNote notebooks Linked notes Outlook integration Linking to tasks in Outlook Flagging notes for follow up Inserting Outlook meeting content Taking minutes Emailing OneNote pages Send emails to OneNote

Being a Mentor in the Early Years

This very practical session is designed to enable participants to improve the impact, clarity and accuracy of their reports. It focuses equally on the two key areas - structure and writing technique. This course will help participants: Scope reports based on objective and intended readership Write a structured report Use the Fog Index to ensure readability Write grammatically correct and well-punctuated text Review and edit their work. 1 Introduction Objectives and overview Introductions and personal aims 2 What makes a good report? Practical activity and feedback 3 Before you start The planning process and scoping a report Organising information Key report headings What goes where? Writing practice and review 4 Writing tips and techniques Clear English and use of language Grammar and sentence structure Refresher in punctuation Writing in the third person The Fog Index - and how to measure readability 5 Pulling it all together Reviewing and proofing 6 Review Summary of key learning points Action planning

A high-impact programme designed to be fun and to get people fully involved. The first-class, jargon-free content is based on what people need to know in practice, not off-putting legal language. This introductory course covers: Introducing Working Safely: Accidents can happen to anyone. The realities of the human suffering behind the statistics. The importance of personal responsibility. Defining hazard and risk: Focusing on the six broad hazard groups, participants are asked to think about the hazards and risks they come across in their own work. 'Risk assessment' demystified. Identifying common hazards: All the main issues - aggression and violence, asbestos, bullying, chemicals and harmful substances, computer workstations, confined spaces, drugs and alcohol, electricity, fire, getting in and out, height, housekeeping, lighting, manual handling, noise, personal hygiene, plant and machinery, slips and trips, stress, temperature, vehicles and transport, and welfare facilities. Improving safety performance: Bridging the gap between management and workforce, encouraging participants to play their part. Also covered: contract work, inspections, safe systems and permits, protective equipment, signage, emergency procedures, reporting and health checks.

This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course

English courses for all levels are available through Mac International