- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Excel Advanced Course, 1-Day. Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases. Course Details: Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Advanced Certification Hours: 1 Day, 10am-5pm Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications. Excel Advanced Course Description General Editing Standard Formatting Rules Input Validate rules Using Formulas in Conditional Formatting Group and Outline Filter and Sorting Excel Tables and Advanced Filter Working with Excel tables Copy specific datasets from sheets, workbooks or external data Consilidate Goal seek, consolidate and scenarios Using Form Templates Creating Templates Advanced Excel Lookup Functions VLookup Function Hlookup Function Using the Index Function, Using the Match Function, Index and Match Together Using the Indirect Function Excel Advanced Functions Using Error Functions, Logical Functions, Array Functions, Rounding Functions Advanced Excel Pivot Table Tools Importing Pivot Table Data, Calculated Fields in Pivot Tables, Showing Pivot Data as a Percentage, Creating Custom Pivot Tables Styles Pivot Charts Excel Macros Creating, amending and deleting macros Running macros Macro menus, toolbars and shortcuts Alternative Excel Courses Inlcuded with the Excel Advanced Course PCWorkshops Excel Advanced Certificate on completion Excel Advanced Notes Excel Code Examples Practical Excel Advanced exercises Personalised attention in a 1-1 session About us Our experienced trainers are award winners. FAQ's Client Comments
Value-based selling (In-House)
By The In House Training Company
This workshop will help you create, develop and close business opportunities using a consultative approach and a value-based (not price-led) proposition. Value-based selling means working the way your customer wants to buy, not how you want to sell. It also means: In a transactional sale the customer knows the answer without help from a salesperson (or cannot see why they should choose you), or is prepared to stay with what they have. Customer decision criteria are price and convenience and customers resent time spent with (new) salespeople, mainly because the salesperson adds little or nothing to what the customer already has and just wastes time. In a consultative or value-based sale, by contrast, the customer doesn't know the answer already. The salesperson must take the role of an advisor, not just a 'product promoter'. Customers demand expertise, advice and customisation during the sales process. Often customers insist on multiple meetings with salespeople and others to develop advantages that you can bring and reduce the perceived risk of changing. In this way the salesperson often adds more value than the product or service alone. This very practical workshop will help you use proven strategies and tactics to build, manage and successfully close sustainable business opportunities using a consultative approach and a value-based (not price-led) proposition. This includes: Increased impact of your new sales conversations, presentations and proposals - leading to faster decisions and increased conversion Greater confidence, consistency and professionalism throughout the business development process Enhanced sales questioning skills and techniques, leading to better, faster and more accurate development of customer needs, problems, value and expectations Improve your people, communication, influence and persuasion skills when approaching, consulting or presenting your services and solutions How to build value at all points in the customer's buying process through your knowledge, skills and structured approach Proven ways to gain additional business and referrals from existing customers and contacts, through direct approach and lead generation Being better able differentiate your firm, your solutions, track-record and expertise clearly and accurately with tailored value statements for each stage and for each opportunity Overcome and avoid price-based objections, buying criteria and negotiation 1 Introduction and key principles of value-based selling Introduction and review of pre-course questionnaires - KPIs, personal learning objectives and key principles The main principles of value-based selling and how they benefit you and the customer How value-based selling differs from 'transactional' or 'price-based' selling The stages of the customer's buying cycle - how to identify and work through strategies for each stage The concept of structured and set-piece selling and proposing Presentation by participants: Personal sales improvement goals 2 Value-based selling strategies and skills What is value? How can one move away from a price-led agenda? How to survive and resist price pressure - six techniques A review of key competencies and skills needed for a value-based approach Strategies, case studies and examples with discussion and review Defining your initial value proposition and comparative advantage How best to established the right level of trust, rapport and credibility Planning and practice session: Strategy - mapping a value-based sales process. 3 Connecting skills Research before the meeting and the first few minutes - ways to gain instant rapport and setting the foundation for a successful outcome in a first sales call How to structure an effective first time sales call or meeting - the subtle differences that are important to master How best to differentiate your solutions and build credibility and enthusiasm early or at the start of the buying process Overcoming initial buying resistance and relaxing the prospect; gaining rapport, opening the meeting: PBC (purpose-benefit-check) and gaining agreement to proceed Planning and practice session: Connecting - first meeting with a new contact 4 Consulting - building, developing and influencing client needs Understanding the power of high-impact and third-level questions to influence people based around specific needs and solutions The importance of body language and other personal communication dynamics when asking questions; empathic listening, run-on questions, drawing out skills, summarising, etc Creating a 'disturb' approach to creating needs and opportunities and positioning your solutions Using proven advanced sales questioning techniques with greater skill: Outcome, SPIN and qualification questions 'Decision-making criteria' - tools to help you develop the relevant criteria with the customer and in doing so progress your sales opportunities more effectively Planning and practice session: Questioning skills 5 Convincing - presentation and persuading skills practice Substance and style - selecting the right tone and content to engage and enthuse your prospect Compelling benefits and reducing perceived risk - key messages to deliver Helping the customer choose your proposition - by being convincing, compelling and credible when you present Professional and effective presentation skills - with personal coaching and practice sessions The keys of influence and persuasion and the keys to convincing a new customer to choose you for the first time Planning and practice session: Role-play in presenting your solution 6 Commitment Knowing when and how to close for commitment to the next stage in your sales process, plus ways to ask for commitment professionally and effectively How to isolate, prioritise and answer objections and concerns more openly and accurately, using a consultative not a confrontational approach Deal more effectively and profitably with price objections and reduce buyer's remorse (which can lead to an 'I want to think about it' reaction and cause delay and inertia) Key negotiation skills around the closing process - getting to 'yes' Planning and practice session: Role-play in closing and negotiation skills 7 Assessed role-play - Final practice session Live role-plays There is an option for external participants to be brought in to the live training workshop to take-part in the final assessed role-play or assist with other sessions run during the course. Performance assessment - 'Dragon's Pitch' The final afternoon of the course is an assessed role-play using a prepared scenario and external 'CEO'. The assessment criteria will be agreed prior to the workshop. 8 Workshop summary and close Personal action plan and learning summary
Effective Pain Management
By Human Givens College
Help with chronic pain – learn the powerful psychological and behavioural techniques that alleviate persistent pain and accelerate healing with pain specialist Dr Grahame Brown Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Fantastic to have the opportunity to train with this specialist. Thoroughly enjoyed this online course – the best I have attended...CLINCIAL HYPNOTHERAPIST Live online training – Join Dr Grahame Brown on Wednesday 24th April 2024 for this practical live online training event via Zoom, you will have plenty of opportunities to ask questions. Simply book your place and we will email you the Zoom link the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date? Register your interest and we’ll let you know when there’s another. Why you should attend Pain is endemic in our society and whatever the cause – back pain, migraine, arthritic pain, dental pain, irritable bowel (IBS), labour/menstrual pain, cancer pain, psychogenic pain, psychosomatic pain – it can be incapacitating. Chronic pain is any pain which lasts for more than three months and it is estimated that between 25–40% of our population suffer from persistent or chronic pain. The sociological and economic costs of this are enormous but it is in the personal human suffering involved – mental as well as physical – that the real costs should be measured. Many are desperate for effective help to relieve their pain and the associated effects, such as insomnia and depression. This online workshop – with leading pain and musculoskeletal medicine consultant Dr Grahame Brown – gives you important new information about how we experience pain – derived from the latest neuroscience – and a powerful range of psychological techniques for managing pain naturally, preventing it from escalating and speeding up healing. You will discover how people can be helped out of the vicious cycle of chronic pain and how, by working holistically through the bio-psycho-social model, suffering can be dramatically reduced. You don’t need to have any prior medical knowledge to learn from and enjoy the day – you will leave with a much clearer understanding of what is going on in the mind/body system, what you can do to reduce suffering when pain persists and ways to prevent chronic ongoing pain from developing. It is a key event if you work with people suffering from pain at any stage (from recent onset, recurrent to persistent) or if you would like to find out how to successfully manage pain without medication. You will learn a wide variety of pain management techniques, which can easily be integrated into your work, to help relieve pain and promote recovery – often in just one session. Dr Grahame Brown has a real gift for helping people heal themselves – I know: I’m one of them!CHRISTOPHER BUCKLEY, PROFESSOR OF RHEUMATOLOGY, UNIVERSITY OF BIRMINGHAM What will you learn An increased understanding of how we perceive pain (from the latest neuroscientific research) and what is happening in the mind/body system A road map for helping people out of the vicious cycle of chronic pain, or to stop it developing in the first place The confidence and skills to help patients suffering from persistent pain of whatever cause – no need to feel ‘heart-sink’ with some patients anymore An understanding of what is going on when pain persists – and what you can do about it How to reduce the risk of chronic pain developing – prevention is better than cure – and identify the factors that make it likely A range of psychological chronic pain management techniques to use with your patients or yourself The importance of the bio-psycho-social model in reducing pain and accelerating healing How to produce significant pain relief by changing the way people think about their pain – in minutes An understanding of the value of pain displacement and how to use the brain’s ‘reality simulator’ What the latest neuroscience tell us about the experience of pain How to use guided imagery, relaxation and distraction to promote chronic pain relief How to deal with constant pain and promote healing How healthcare professionals can make their consultations more therapeutic How to avoid labelling patients’ pain as ‘purely psychological’ The many myths about pain – and why some well-intentioned pain management techniques don’t work and more… No prior medical knowledge is needed for you to benefit from the day. Course Programme The ‘Effective Pain Management’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding pain 11.00am Comfort break and discussion 11.30am Assessing a person with persistent pain 1.00pm Lunch break 1.45pm Psychological & Behavioural treatment interventions 2.45pm Comfort break and discussion 3.00pm Practical demonstration of interventions 4.00pm Day ends Who is this course suitable for? This course is designed to enhance the skills and knowledge of health care professionals of any discipline who work on a regular or occasional basis with people in pain to improve outcomes, including: • doctors • surgeons • nurses • dentists • neurologists • osteopaths • chiropractors • palliative care workers • psychiatrists • midwives • physiotherapists • occupational therapists • psychologists • health visitors • support/care workers • psychotherapists • counsellors – it is perfect CPD If you personally experience persistent pain then you will gain much from the workshop but please be aware the programme is not designed to be a treatment day and the tutor will be unable to give opinions to individuals with pain problems unless (with consent) their problem can be discussed for the benefit of all participants Anyone who would like to understand more about their own experience of pain, or that of someone they care for, and what can be done to manage ongoing pain and alleviate suffering This course has been independently assessed 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.
Adobe InDesign Fundamentals Training
By London Design Training Courses
Why Choose Adobe InDesign Fundamentals Training Course? Course info. Learn Adobe InDesign fundamentals from certified tutors. Master layout creation, typography, layouts and design principles. Choose in-person or live online sessions. Certificate of Completion and lifetime email support provided. Duration: 5 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own hours of your choice, available from Monday to Saturday between 9 am and 7 pm. Adobe Certified Instructors and Expert for InDesign, and a professional graphic designer. In this advanced course, we will delve into InDesign's powerful features, productivity techniques, and workflow speed tricks. 5-hour Adobe InDesign Fundamentals training course, designed to empower you with essential skills for layout and design projects. Suitable for beginners and those with some experience, this course ensures you can confidently create professional-quality documents and publications. Part 1: Introduction to Adobe InDesign (1 hour) Explore the workspace and tools Set up new documents with proper page size and margins Format text and images effectively Customize the interface for efficient workflow Part 2: Text Formatting and Styles (1 hour) Apply character and paragraph styles for consistent formatting Control text flow with text frames Organize lists using bullets and numbering Master special characters for typographic control Part 3: Working with Images (1 hour) Import and position images in the document Adjust image size and alignment within frames Create professional layouts with text wrapping around images Enhance visuals with image frames and effects Part 4: Layout Design (1 hour) Create precise grids and guides for alignment Arrange objects for a balanced layout Streamline design work with layers Maintain consistency with master pages and templates Part 5: Printing and Exporting (1 hour) Understand color modes and printing principles Export to PDF and other formats for various outputs Ensure print readiness through preflighting Efficiently archive and manage InDesign files Through hands-on exercises and practical examples, you'll solidify your understanding of each module. This course equips you to design visually captivating layouts, create documents for diverse purposes, and manage InDesign projects effectively. Adobe InDesign is a powerful desktop publishing tool, and our fundamentals course sets the stage for you to explore and expand your skills in a wide range of design projects. Don't miss this opportunity to unlock your creative potential with InDesign!
2-day Acting Foundation
By Acting Workshops
A special 5-day acting course including voice work, movement, improvisation and scene work led by the amazing Stuart Laing – it is designed for beginner-to-intermediate actors who might be considering making the leap into training professionally.
Express Yourself Confidence Workshop - overcome shyness and inhibitions
(6)By The Sunflower Effect Confidence Courses
Proven to be effective and to improve the prospects of quiet, shy, self-conscious and introverted people. Would you love to Express Yourself and let the real you out? Want to play more in life – and have a whole lot more fun? Want to overcome your fear of performing in front of groups In this unique one-day self-confidence workshop you will be discovering the keys to an authentic confidence and how to exude the kind of magic and passion for life that enables you to look and feel good. The workshop provides a context to express yourself in a safe environment with other people who feel in the same boat as you, and are 100% committed in supporting you in making breakthroughs in the area of self-expression, confidence and overcoming your fears of performing/speaking in front of others. This helps to counteract the effects of having your confidence undermined in the past.
Best MS (Microsoft) Project Beginners Courses in London, England! This one-day Microsoft Project Beginners Course is designed to cover the concepts of creating, scheduling, baselining and tracking projects using Microsoft Project. We cover all versions of Microsoft Project, instructor-led, classroom-based, practical, and hands-on. We offer the classes on a one-to-one basis, but group sessions are scheduled on request.
