2155 Other courses in Chester delivered Live Online

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Is your learner ready to transition to a Speech Generating Device? Do you need help selecting a device and/or preparing your learner for the transition? This training will help get your questions answered! With the current influx of communication devices and apps to the market how do we ensure that basic functional communication skills are maintained and taught right from the beginning? Speech Generating Devices (SGDs) were first introduced for people with motor difficulties like cerebral palsy and now these devices are being introduced to our learners with autism and other related communication difficulties. for these populations, language and cognition are often compromised and basic social and communication skills have not always been mastered prior to the introduction of a device. Because of this, the way we teach the use of SGDs needs to be specifically tailored to fit the needs of each individual paying attention to devices capabilities vs. user capabilities. This full-day workshop will describe procedures for analysing a learner's current PECS skills to determine candidacy for transitioning to a Speech Generating Device (SGD), choosing a device, and teaching functional use of the device, and why we must teach the basic principles of communication to our learner first to ensure positive outcomes are achieved. *Participants should bring a Speech Generating Device (SGD) to the training for use during a variety of activities. WATCH VIDEO TOPICS COVERED INCLUDE Review of the PECS Protocol The unique challenges of learners with complex communication needs Procedures for analysing current PECS skills Determining candidacy for transitioning from PECS to a Speech Generating Device The 5 criteria for appropriate device selection Preparing the learner for the transition Using elements of the PECS protocol to teach functional SGD use Problem solving SGD use Tuition Includes: Detailed Handout with space for note taking, Delegate Practise Bag and Certificate of Attendance. CEUs: 5.5 BACB CEUs; Satisfactory completion of this course requires participants to be present for the duration of the course and to participate in all student responding activities (e.g. questions, role play, quizzes, and surveys). Pyramid Educational Consultants is an approved BACB ACE Provider for Learning (Type 2) Continuing Education Credits. The BACB does not warrant, endorse, sponsor, approve, or partner with the event, organisation, or instructor.

The event "Getting you more sales, leads and enquiries from your website in 2024" is a one-hour online session aimed at helping participants maximize their website's performance. The session will cover topics such as improving Google search rankings, increasing click-through rates, and ultimately boosting sales, orders, and leads. The event promises a practical, actionable, and jargon-free approach to website optimization, with a focus on SEO and sales conversions. Participants will receive a personalized review and recommendations for their website. The event is presented by Damian Donnelly, Ad_Man Digital Marketing, and is limited to 10 reviews per month. Testimonials from previous clients are provided to support the effectiveness of the session.

We are delighted to share that we are now running our GP Admin Development Programmes Live Online! If your team have had enough of pre-recorded courses then this is perfect!  We are delivering the content online - Live!  Teams can get involved, interact with each other, and have great discussions. We deliver a suite of programmes to support the development pathway of GP admin staff.  Just £79+vat pp for a half day workshop with resources. The first in the series is: Positive & Proactive Communication for Effective Call Handling This workshop will provide an opportunity to look at how we positively communicate with others - taking into account patients expectations, stereotypes, our role, and how to have the best interactions! We add value by discussing the importance of their roles, exploring how change impacts us and patients, and how we can choose to respond. We couple this with a deeper exploration of communication techniques that leads to a greater understanding of how we can communicate using positive intention & language. It's suitable for all staff (new and more experienced). We also encourage the line manager to participate so that they can follow up on the content using our manager support pack - enabling staff to sustain and embed the learning. The programme will cover the following: The Heart Of The Surgery Changes & Choices Patient Experience Effective Communication Managing Other’s Emotions & Challenging Patients Importance of Signposting Keeping Motivated Creating New Habits We will be running multiple dates so that you can enrol small groups of staff any one time, leaving you enough people to man the helm!If you have any questions then please do get in touch,lucy@thedevelopmentpeople.co.uk

This is a one to one course running over five weeks, providing two hours a week of tuition on a flexible basis. The course is aimed at those keen to discover more about the practical aspect of interior design. Whether you are about to embark on a project of your own, are keen to learn more about your individual style, or are just looking to gain more confidence, this course will give you the knowledge and tools to confidently create stylish interiors.

This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate. 98% Employment rate after completion of the course. Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are.  This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate.   98% Employment rate after completion of the course. How will you learn? Apart of our traditional class-based tuition, we also offer Virtual Learning courses. On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification. We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!! You will have: According to the timetable- 1 lessons per week for 9 consecutive weeks. Exams and final exam based on which the certificate will be issued. On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.  What is Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally.  Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation. Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.  Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.  Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course Individual support on the journey from the course to a job placement With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. We will enhance your CV Guidance through the job application process (free of charge) Gain an insight into the airline selection process and final one-to-one interview The vast global experience of our instructors This course has been developed in accordance with EASA PART-CC Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. Course Entry Requirements: English Language at B2 (CEFR) level or above. There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career.  Dates (choose one for your course): 15 May 2024 – 10 July 2024, Wednesday classes 18 September 2024 – 6 November 2024, Wednesday classes 14 November 2024 – 9 January 2025, Thursday classes Course duration – 9 weeks Classes – once a week Lesson Time – 10am to 5pm – London time Course fee – £529 (we offer flexible payment plan and accept weekly instalments) Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

Attend our world class Kanban University accredited Certified Kanban System Design training course and learn to implement Kanban in your company

This training covers two essential aspects: Understanding the highway Code and road safety measures to handle accidents, incidents, and breakdowns. Driver Health and Wellbeing: Understand the impact of physical and mental health on driving performance. Identify early warning signs of fatigue, stress, and other health issues. Learn effective strategies for managing work-life balance and reducing stress. Promote a healthy lifestyle to enhance overall well-being and driving safety. Drivers’ Hours and Working Time Regulations: Master the Rules of the Road Ensure compliance with complex driving and rest regulations. Understand the impact of hours worked on driver safety and well-being. Learn how to effectively manage driving and rest periods, breaks, and exemptions to avoid penalties and protect your business. Join us to enhance your knowledge of the Highway Code and road safety preparedness. Register today to ensure your drivers are well-versed in the rules of the road and equipped to handle unexpected challenges on their journeys. Please review our Terms and Conditions for more information.