54547 Courses

Learn how to work with and connect multiple data sets to effectively analyse and report on data. Course overview Duration: 1 day (6.5 hours) Within Excel you have some powerful features to enable you to connect and analyse multiple data sources. Power Query enables you to import and manipulate your data, Power Pivot enables you to connect multiple data sources and create pivot tables and pivot charts from them. This course is an introduction to Power Query and Power Pivot in Excel to get you started on creating a powerful reporting capability. Knowledge of working with Excel workbooks and relational databases would be an advantage. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Add extra columns of data Append data Merge data from other tables Create data models Build data relationships Build Pivot Tables Build Pivot Charts Use Slicers and Timeline Filters Content Importing data Data sources Importing data Transforming data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Appending queries Appending data from other tables Adding text Columns from example Custom columns Conditional columns Merge queries Setting up and using merge queries Merging in columns of data Creating a data model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Analysing information using pivot tables Creating and modifying a Pivot Table Recalculating the Pivot Table Filtering the Pivot Table Searching the Pivot Table Drilling down to underlying data Customising field names Changing field formatting Pivot charts, slices and timelines Creating Pivot Charts Adding and using Slicers

REFERENCE CODE 610/0075/3 COURSE LEVEL NVQ Level 2 THIS COURSE IS AVAILABLE IN Course Overview This qualification is aimed at individuals wishing to prove they have the level and range of knowledge and skills required to install Interior Systems in the Construction working environment. It is not expected that all workers will complete the same tasks, there are 3 mandatory units common to all pathways. The Pathways will allow employees with specific skills and from companies of all sizes equal opportunity to complete. All work must be completed following Industry recognised Safe Working Practices and in accordance with relevant legislation. 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 a range of tasks and situations. There is also a Level 2 Certificate and a Level 3 Diploma in Interior Systems available.

Make your own personalised beautiful silver jewellery using specialised clay that turns into solid silver once your pieces have been made and fired.

Manual Handling Training delivered directly in your workplace anywhere across North Wales. Manual handling accidents account for more than a third of all accidents reported each year. Manual handling training is for everyone who carries out manual handling tasks in the course of their work. While fatal manual handling accidents are rare, accidents resulting in a major injury are more common, accounting for more than 10% of the total number of reported manual accidents. This course can be delivered directly in your workplace anywhere across North Wales for up to 6-12 delegates for a group booking of only £595.00 +Vat. For more information on our Manual Handling training courses in North Wales or if you want to discuss a course specific to your business needs please email us.  Or alternatively, call Janine or Mark on 01978 884 775 to discuss your training needs. Manual Handling Training in North Wales

Learn some very simple and effective ideas to become more effective at sales

Elevate your skills in designing, delivering and evaluating engaging and interactive training that will leave a lasting impact on your team or organisation Course overview Duration: 2 days (13 hours) This Train the Trainer workshop will enable you to gain valuable insights and practice helping you to feel more comfortable and confident delivering training sessions. We will look at some training best practice tools and techniques to ensure you can deliver the learning outcomes required. The workshop covers the training cycle but focuses heavily on interactive and practical training techniques to bring learning to life for participants. There will be opportunities to practice delivery of real work-based training and receive feedback on delivery style. Objectives  By the end of the course you will be able to: Explain Kolb’s model of how adults learn Describe the 4 key learning styles and how to engage people with different learning styles Apply the training cycle to plan, design, deliver and evaluate your training Write SMART training objectives Use and select a variety of methods to make your training interactive, engaging and effective Describe ways to deal with difficult participants or situations that may arise Apply your training skills to deliver structured training sessions with more competence and confidence Content The Training Cycle Assessing needs Planning and preparing Implementing training Reviewing Assessing Assessing Needs Understanding the task Assessing the learner’s current ability Identifying the gap Planning and Preparing Having clear outcomes in mind What people learn: o Knowledge o Skill o Understanding How people learn: preferences and learning styles and methods suitable for each Planning a programme Planning a session – a systematic approach Assessing risk Writing and using SOPs in training Key Skills for Effective Training Explanation and Demonstration Questioning and Listening Observation and Feedback Facilitation and Debriefing skills Coaching Using questioning, listening and feedback to help learners solve problems and develop confidence Evaluation and Assessment How to measure reactions and participant satisfaction Use of tests and assessments to measure learning Organisational measures of learning transfer Leverage You will have the opportunity to deliver two training sessions on this programme and gain valuable feedback to support you in your ongoing training delivery. Participants are required to prepare a 15 minute training session. This can be something you have delivered before or something you’ve created for the course. Please prepare and include any visual aids you would usually use when speaking and bring them with you, f possible, please also bring your smart phone (with camera, and memory capacity for a short video clip to be added), and headphones.

Your grumpiest customers can become your biggest advocates if you solve their problems quickly, effectively and permanently. We supply the top tips for dealing with tricky customers so your teams can create positive outcomes from every interaction with some simple techniques that make a difference to relationships straight away. Bespoke courses include: Customer needs and expectations Communication styles and how to influence them Assertiveness The 4 psychological fears Dealing with difficult customer behaviour The power of your behaviour Five steps to customer problem solving

Join John McGlone for an hour long session where we will provide insight into the Data Protection industries predominant Certification programme. In this session, we will run over some of the course content, show example exam questions and answer any burning questions you may have. All Webinar attendees will receive a full Practice Exam to give even further insight into what to expect on exam day. Certification Logo What's Included? 1 hour with John McGlone Free Practice Exam Questions and Answer session Who Should Attend?   Anyone with an interest in IAPP training

Understanding cultural differences in the global sales environment is critical to your salespeople’s success. Developing their intercultural communication skills and knowledge of the sales and negotiation techniques of different cultures and nationalities, will help them to ensure relationships are as effective and rewarding as possible. Bespoke courses include: The impact of language and cultural differences on the sales environment Communication techniques in international sales Effective sales questions A global mindset Culture and its impact on sales Delivering on different cultural expectations Perceptions of time across cultures and the impact on sales cycles and timelines

Discover the amazing features this tool has to offer in combining, collating and editing documents and the forms, markups and redaction techniques available. Duration 1 day (6.5 hours) Overview This Adobe Acrobat course looks at the powerful features of the tool quite often overlooked.  The course requires the use of either the Standard or Professional versions of Acrobat as the free Acrobat Reader only has limited functionality. Learn how to combine documents into a single file, edit and mark up PDFs, compare documents, redact data from documents and create fillable forms. Objectives  By the end of the course you will be able to: Create PDFs from other tools Set security Collate and combine files into a single PDF Edit PDF files Complete and sign documents Create fillable forms Mark up PDF documents Compare files Redact data Content Creating PDFs Building PDF documents from Word, Excel and PowerPoint Setting PDF options for print, image quality and security Working in Acrobat Home, Tools and Document Views Using the Navigation Panel and Pane Floating toolbar and Contextual menus Collating and Combining Files Combining multiple files into a single PDF Adding extra files Deleting pages and reorganising pages Editing Files Editing text and graphics Adding text and images Adding headers and footers, watermarks and backgrounds Adding Links Adding manual links Automatic links Completing and signing documents Using fill and sign to complete forms Adding signatures Creating Fillable and Signable Forms Prepare a form Autodetect fillable fields Add manual fillable fields Adding drop downs, check boxes, etc. Naming fields Setting field properties Previewing the form Marking Up Documents Marking up changes Using sticky notes Using the highlighter pen Adding stamps Attaching documents and audio Replying to comments Comparing Files Selecting settings Comparison report Reviewing differences Using the changes pane Redacting Data (Acrobat Professional only) Setting redaction options Redacting chosen text Searching and redacting words, phrases or patterns Redacting whole pages Applying redaction