540 Trainer courses in Yeadon delivered Live Online

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

For us, working out is about one thing: EMPOWERMENT. Exercise improves every aspect of our life. Join us for HIIT followed by cool down Yoga.

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering classroom, one to one, tailored and bespoke courses. Tailored In company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Please visit our site (ms-officetraining co uk) to get a feel of the excellent feedback our courses have had and look at other courses you might be interested in. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

PMI® Authorized PMP® Exam Preparation is a four-day course which will help delegates to build on their knowledge in every area of project and program management skill development. This certification positions learners to successfully complete the Project Management Professional (PMP)® examination.

POWERPOINT 🔸 A series of 1 hour sessions 🔸 Learn different aspects of PowerPoint and boost those presentations of yours! 🔸 Learn how to create stunning presentations that wow your audience 🔸 Do the sessions that are of most use to you! Or do them all, it's entirely up to you - and if you do, we have a 'Do all 6 and only pay for 5' offer for you! - we don't know how to run this offer via Eventbrite though, so contact us or book all of them via our website instead: https://pochattraining.co.uk/powerpoint/ 💦Session 1)  Text Formatting The skills learned in this session are useful for all Microsoft Office Products and most other Word Processing Apps 💦Session 2) Image Formatting & Effects  💦Session 3) Using and Formatting SmartArt 💦Session 4) Creating Slide Masters 💦Session 5) Animating Text and Images 💦Session 6) Page Design, Layout and Transitions Run by a friendly, patient trainer, these sessions will be held in small groups These are practical sessions, where you will practice what we're covering as we go along Ask as many questions as you like Many people are using PowerPoint but have never really learned how to use most of its features Learn how to do all those nifty tricks that you see other presenters using Spice up your presentations! Are you great with using text but don't really know a lot about image formatting, or general page design? Now is your chance to pick and choose and learn what you need

This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.

Learn to communicate better in groups

Wouldn't sales be a 'walk in the park' without challenging customers? Why is it that some customers are so difficult to please, so quick to call 'foul' at the slightest blip and so mean with their gratitude after we've bent over backwards to accommodate them? Whether we are looking at prospective or existing customers, there is a toolkit for dealing with the most challenging of them. This course will help participants: Use broad open questions to give the customer a platform for their opinions or issues Improve listening skills to really understand what's behind the customer's challenging style Probe specific phrases to show listening and earn deeper disclosure Use silence to let challenging customers 'blow off steam' Understand the negative impact of certain phrases on a challenging customer Summarise effectively and reassure the customer of our understanding of their needs Recognise the 'behaviour cycle' and avoid emotional escalation Understand 'transactional analysis' and how to bring people from 'child' to 'adult' state Create loyalty in customers who are slow to give trust 1 What makes a customer 'challenging'? Why customers challenge us - understanding their drivers 'Wearing their shoes' - seeing things from their perspective Understanding our own personality style How to flex with a style that is different from our own Ways to quickly recognise a customer's style The benefits of flexing with a challenging customer's style 2 Practical exercise - forum theatre Participants take it in turns to deal with the trainer (who plays the role of the challenging customer) Observers stop the action when they hear or see something they deem wrong The participant in the seat gets a chance to use a suggested alternative line The participant who makes the suggestion has the chance to occupy the seat and deliver it themselves Frequent feedback from the trainer as to how the participant's words are making him feel Opportunities to rewind the action if an ill-advised line is suggested and delivered Flipchart for capturing what worked, what didn't work and why Mehrabian principle - the importance of body language and tone over words used 3 Questioning and listening skills How to use open questions to get the customer talking What questions to avoid and why The use of pauses and silence to reduce tension and build trust What listening is and what it isn't Question funnelling - how to earn deeper disclosure through probing The power of summary 4 Transactional analysis explained What is transactional analysis (TA)? Exploring the TA states and why people behave in that way under pressure How to bring challenging customers to 'adult' state to reduce tension How 'parent' or 'child' behaviours can be inadvertently triggered Understanding the 'behavioural cycle' and how to break it Mini-role play 'vignettes' to demonstrate real time impact of ill-chosen words 5 How to build trust with challenging customers Techniques for placating current challenging customers Methods that the participants have already used effectively - understanding why those methods worked and how other participants can model them Participants' experiences of trust having been lost - understanding why those experiences had that negative outcome How to 'go the extra mile' with challenging customers 6 Bringing a 'real' challenging customer to life Participants give the trainer a brief profile of a specific challenging customer of theirs 5-10 minute roleplay in which the trainer brings that individual to life Observing participants - without interrupting - make notes on what is and isn't working Trainer stops the action half-way through to give feedback on how he is feeling Participant goes back into the roleplay having recalibrated their approach based on feedback Observers give feedback on what did and didn't work Trainer comes out of character to explain the impact of the participant's words and behaviours 7 Wrap-up Key learnings from each participant Individual action planning - steps that can and will be implemented in the workplace

HACCP Level 2 Training Courses for Food and Drink Manufacturers and Caterers. Special Offer

Our Refugee Family Reunion course is designed to empower individuals and professionals with the knowledge and skills needed to navigate the complex process of reuniting refugee families. View our Refugee Family Reunion training course dates below, available remotely via Microsoft Teams. Our Refugee Family Reunion course is designed to empower individuals and professionals with the knowledge and skills needed to navigate the complex process of reuniting refugee families. From understanding the application forms and procedures to meeting the necessary requirements and avoiding common pitfalls, this comprehensive course covers it all. We will guide you through the intricacies of the refugee family reunion process, ensuring you have the expertise to assist those in need. By the end of this course, you’ll be well-equipped to assist refugees in the challenging process of reuniting with their families. Gain the knowledge and insights necessary to offer accurate and compassionate guidance, ensuring that families can find solace and hope in their journey towards reunion.   Course joining links, materials and instructions are sent out 24hours before the course starts. Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our fully qualified and OISC regulated trainer will guide you through the process and ensure you are competent in Refugee Family Reunion. This an opportunity not to be missed by Immigration Advisors, Charities, Lawyers, Solicitors and Legal Professionals. Course Content: Introduction-Refugee Family Reunion How to apply – VAF 4A FORM Requirements: Appendix family reunion (protection), Appendix Relationship with Partner, Appendix CNP Family Members Refugee family reunion applications outside the Immigration Rules Challenges – Preparing a good quality application with good evidence, Additional evidence required in applications outside the rules Remedy Who can help Conclusion