3677 Courses delivered Live Online

Attending this programme will give you the knowledge and skills to transform your communication skills immediately, having learnt: The pros and cons of different communication channels and when best to use them The power of communicating through words, sound and body language Why people behave and communicate differently and how to recognise and adapt to their style What someone's natural behavioural style means when it comes to making decisions How to increase sales through better and more personalised communication How to engage better with audiences of all sizes when presenting

Whether you’re starting out in private practice, or have been in business for a while, this inspiring course will SAVE you time and money and help you build the practice and lifestyle you want … Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Extremely helpful course. The real life, practical examples and advice were invaluable...EMMA WARDROPPER Live Online Training – Join Jennifer Broadley for this inspiring, practical training – you will have plenty of opportunity to ask questions. Simply book your place and we will email you details of how to join the Zoom training the day before the event. BONUS RECORDING – the training is recorded in case anyone experiences technical difficulties on the day, so you also get a recording for a limited time afterwards to maximise your learning. Why take this course Although word of mouth is one of the best ways to get business, being a good counsellor or therapist isn’t always enough to fill your practice with clients – and that’s where the easy-to-learn, simple but effective business and marketing skills you will learn on this online course come in. Jennifer Broadley has been a qualified and practising psychotherapist for 10 years and has been in business for herself for well over 20 years. She brings her extensive knowledge of the personal and professional ups and downs to life in this practical and motivating day. You will also gain a wealth of time-saving devices and tips that others who have successfully built their thriving practices have used, all of which will allow you to focus more time on your clients. Jennifer built her business, Healthy Chat, from no clients to full practice within 2 years. She has tried-and-tested marketing strategies and will share with you the ones that have worked for her and the ones that haven’t. She is fully transparent with her client numbers, systems and finances so that you will leave the course clear about whether a full-time or part-time therapy practice is for you – and how to go about getting the work/life balance you want. I’ve learned so much! A must for everyone setting up a therapy businessHEALTH VISITOR What will you learn The essential actions to take when starting your practice from scratch – what’s worth spending money on and what’s not Confidence to take on your first client(s) or increase your client intake until you have a full practice Clear systems for starting or growing your counselling / therapy practice Tools to ensure clients easily find you, trust that you can help, and then book sessions with you Clarity about how long to work with a client – average timings and outliers (for stress, trauma, panic attacks, relationships, etc); when to keep a client and when to let a client go Key information that will help you decide how much to charge and when/whether to be flexible Important things to remember if you work with clients online Time-saving methods for client management: intake, treatment, ending well and future follow up How to manage yourself as a business owner – when to work hard, when to take time out How to make your therapy practice fit in with the lifestyle you want to live – and what to do to avoid becoming overwhelmed When (or whether) to let go of your full or part-time work and shift to letting your counselling practice support you financially How to get your 9 emotional needs met while working for yourself How to define your ideal client(s) and where to find them Practicalities: taking payments, tracking your numbers, meeting your targets, turnover v’s net income, paying VAT (or not), paying tax, chasing non-payments Creating a healthy, open attitude and language around money and finances How to set up your therapy practice to be financially successful and more… Brilliant, this online course has shown me what I need to focus on to build a successful private practice – and where to put my energy, money and time!COUNSELLOR Course Programme The ‘Obsessive Compulsive Disorder – understanding OCD and how best to treat it’ online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am A context for the demand for HG therapy and counselling 11.00am Comfort break and discussion 11.30am Private Practice Design 1.00pm Lunch break 1.45pm Marketing your practice 2.45pm Comfort break and discussion 3.00pm Effective Therapy Sessions & Client Follow up 4.00pm Day ends Who is this course suitable for? Anyone who wants to set up a private therapy or counselling practice If you’re already in private practice and want to increase your client numbers, work less and earn more, you’ll also benefit from attending Anyone who is presently in full or part time salaried work and is considering moving to self employment or entrepreneurialism This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

We all know people are quick to judge – in fact neuroscience research suggests that it takes less than a second for first impressions to be made. Crucial skills need developing to establish credibility and make the impact you want, based on who you are and what is important to you. Despite our best efforts, sometimes a work relationship or situation becomes challenging – what then? You need to be assertive to get things back on track. There is an art to doing this well and feeling proud of yourself for making your voice heard in the right way.

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office 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 Certificates Certificates Certificate of completion Digital certificate - Included

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 public, one to one, tailored and bespoke courses. Tailored training courses: In, 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. 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 Certificates Certificates Certificate of completion Digital certificate - Included

Course Objectives At the end of this course you will be able to: Work with advanced lookup and reference functions Create macros to automate common tasks Use advanced techniques to analyse data Create PivotTables and PivotCharts Work with data validation tools Import and export data ' Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The course was very interesting and engaging and will definitely be put to use. The trainer was very helpful and charismatic. Marving Lopez - AM Best Europe Pedro was excellent. Very knowledgeable, clear and great rapport with class. Darren Barkey - Direct Wines Great content and learnt a lot. Really enjoyable :) Kristie-Lee Ryan - Stirling Ackroyd 1 year email support service Take a closer look at the consistent excellent feedback from our growing 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 public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: 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. Advanced Functions COUNT, COUNTA, COUNTIF, COUNTBLANK, SUMIF, SUBTOTAL IF, OR, AND, IFERROR VLOOKUP to lookup Exact Values and Approximate values MATCH, INDIRECT, ROW/COLUMN, INDEX, OFFSET Analysing Data PMT function to calculate a monthly payment of a loan What If Analysis using Goal Seek Use scenarios to consider many different variables Using Solver Add-in to optimize variables PivotTables Create a PivotTable to analyse worksheet data Add or remove fields in a PivotTable Change the data source for a PivotTable Working with external data sources Using different Statistical Functions Calculate a Running Total, % of Grant Total, Difference From… Using the Slicer and Timeline to filter the PivotTable Using Filters in a PivotTable Group by Date, Auto Group by ranges of values, Custom Group Create a PivotChart The GETPIVOTDATA function Formula auditing Precedents and dependents Error checking Watch a formula and its result by using the Watch Window Evaluate a nested formula one step at a time Data Validation Number Validation Data List Validation Message Prompts and Alerts Conditional Data Validation Data Validation Errors Consolidation Consolidate data by position Consolidate data by category Use a formula to consolidate data Outline (group) data in a worksheet Create an outline of rows Create an outline of columns Copy outlined data Hide or remove an outline Connect external data to your workbook Using the Power Query Editor to import data From Text and CSV, From Access, From Web, From another Workbook Using the Power Query Editor to; Transform your data by Selecting which fields to import, by Splitting Columns, Changing Data Type and more. Deleting Applied Steps Refreshing your data Working with Form Controls; Buttons, Option Buttons and Scroll Bars Introduction to Macros Change Macro Security settings How to Record a macro Some Macro Examples Delete a macro Edit the macro to view the VBA code Copy part of a macro to create another macro Assign a macro to a button Who is this course for? Who is this course for? This course is intended to end users who want to develop their skills so they can use advanced techniques to analyse extensive and complex datasets in Excel and to automate simple tasks with the use of Macros. Requirements Requirements Preferably, delegates should have attended the Excel Intermediate 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 Certificates Certificates Certificate of completion Digital certificate - Included

https://www.valuex2.com/agile-hr-certification/ https://www.linkedin.com/company/80563537/

https://www.valuex2.com/agile-hr-certification/ https://www.linkedin.com/company/80563537/

Duration 1.875 Days 11.25 CPD hours This course is intended for The job roles best suited to the material in this course are: team leaders, project managers, managers of scrum teams, teams transitioning to scrum, professionals intending to pursue the scrum master certification. Overview How to use the Scrum Framework to deliver products and services faster and with higher quality. How to leverage lean principles to identify waste in a system, process, or organization. Techniques and metics Scrum Masters use to improve. team happiness and performance. The patterns and practices of high-performing teams. How the Scrum Master role scales in an Agile implementation. This course is an adaptive, repeatable process that equips individuals and organizations in how to thrive in a world where change is the only constant. From Fortune 100 companies (Google, Amazon, Apple, etc) to nonprofits. Scrum has a proven record of reducing burnout, doubling throughput in half the time, and increase employee happiness. Core Scrum The Scrum Framework The Origins of Scrum (Optional) The Scrum Team Developers Scrum Master Leadership/Management Scrum Events The Sprint Product Backlog Re1nement Estimation Sprint Planning Sprint Review Sprint Retrospective Daily Scrum Scrum Artifacts Lean Principles Describe a Kaizen mindset and explain how small, iterative changes can lead to revolutionary leaps. Describe the three pillars of Scrum ? Transparency, Inspection, and Adaptation,? which implement the work of Ogunnaike and Ray. Explain the importance of reducing and eliminating waste in the system. Perform a root-cause analysis (e.g., using the ?5 Whys? technique). Assess the Process EZciency of their Scrum Team and recall that the de1nition of Lean is a Process EZciency of 25% or higher. Explain how the work of Takeuchi and Nonaka on Lean and the Toyota Production System paved the way for Scrum. Describe the origins of the name ?Scrum? from Takeuchi and Nonaka?s ?New New Product Development Game. Recognize that a Lean mindset suggests that you address a defect immediately after it is identi1ed as opposed to a mindset where defects are stored to be 1xed later. Agile Manifesto Recognize the four values of the Agile Manifesto and their signi1cance in the context of complex adaptive systems. Identify the 12 principles of the Agile Manifesto and describe their function in guiding practices that support teams in implementing and executing with agility. Explain that Scrum is one of the driving forces that gave rise to the Agile movement and predates the Agile Manifesto. Explain why the majority of ?Agile? teams are late, over-budget, and with unhappy customers (i.e., not agile) and explain what needs to be done to 1x that. Patterns of High Performing Teams Yesterday?s Weather Happiness Metric Teams that Finish Early Accelerate Faster Stable Teams Swarming Interrupt Buffer Good Housekeeping (formerly Daily Clean Code) Scrum Emergency Procedure Scrum@Scale Descaling Scaling the Scrum Master Registered Scrum Master Credential Access and complete the Registered Scrum Master by Scrum Inc. exam. Download their Registered Scrum Master Credential (upon successful completion of the exam). Be Recognized in the International Registry of Agile ProfesstionalsTM State the renewal process. Additional course details: Nexus Humans Agile Scrum training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Agile Scrum course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

A popular 6-week Mindfulness Meditation and Dynamic Breathing course that provides participants with tools to support them in an increasingly challenging world.