1428 Courses in Manchester

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Overview Appreciative Inquiry is a form of action research that collects people’s stories of best practices. We can use these best practices as a way to initiate organisational change. This course will guide attendees through the process of Appreciative Inquiry (AI) and give them the techniques to succeed in using the AI system. This course will benefit anyone that leads change and wants to create positive dialogue that leads to improvements within their organisation. Description David Cooperrider, Suresh Srivastva, and their colleagues at Case Western Reserve University developed AI in the 1980s. According to them, the aim of Appreciative Inquiry is to help the organisation in: Envisioning a collectively desired future Realising that vision in ways that successfully translate intention into reality and beliefs into practices The AI approach can be applied in almost all groups of people and once the process starts, the change is put in motion. The appreciative approach works in individual conversations among colleagues, managers and employees. AI consultants around the world are increasingly using an appreciative approach to bring about collaborative and strengths-based change. This course will provide attendees with the means to effectively develop the skills of managers for the benefit of their organisation. They will be taken through the full process of appreciative inquiry; developing a wide understanding of the tools and techniques required to effectively improve communication and affect change. What can Appreciative Inquiry achieve? Well, just imagine you were better able to: Solve problems within an organisation in a positive and forward-thinking way. Be more curious and excited about the challenges faced within the business. Ask unconditional, positive questions to strengthen the organisations capacity to increase potential. Approach change in an affirmative mindset. Use questions to create movement and change within the company. Simply apply core communication skills, for overall organisational success Topics covered: What is Appreciative Inquiry? – A review of the subject with an activity that helps embed understanding and a case study that explains the process in action. Benefits of Appreciative Inquiry to the Organisation – Establishing how AI can aid and improve the way an organisation works and how people communicate within it. Exploring how specific organisational issues can be viewed positively. Appreciative Inquiry Questions – Understanding how questions can be used to identify positive organisational improvements and refocus our approach to business issues. Appreciative Inquiry Interviews – A set process for performing AI interviews and framing consultations to get the best out of those involved. A chance to practice the given approach and hone personal skills. The 4D Model – An overview of the AI 4D Model (Discovery, Dream, Design, Destiny) and how it is applied. The 4D Model: Topic – Demonstrating how selecting the topic is the beginning of the 4D model process. Choosing the participants own topic to work on throughout the training. The 4D Model: Discovery – Showing how positive discussions are kick-started at this stage and taking a chance to look at, ‘the best there is and what has been’. The 4D Model: Dream – ‘Thinking big and beyond what they have in the past’. Creating an amazing and positive vision for the future. The 4D Model: Design – Laying the foundation with a design of the vision, principles, and set of propositions that describe the ideal end state. Defining the desired state by creating a hierarchy and blueprint for success. The 4D Model: Destiny – Defining clear actions that will help the organisation and individuals achieve what they have set out to. The output is the self-reinforcing nature of using positive and affirmative inquiry to improve the business. The 4D Model: Summary Task – Review of learning and knowledge check. The Change Process – Exploring Dr. Kotter’s 8-step change process and how it can support the AI approach. Rooms of Change – Understanding feelings and attitudes to change, using this interesting and memorable model. Using an activity to help participants consider their own ‘change position’ and what this might mean for them. Strategies for Managing Change – A simple set of skills to help overcome the challenges faced by people trying to implement change. Applying these strategies to the 4D Model and Appreciative Inquiry. Recall Quiz – A chance to review learning in an engaging way. Summary – Developing actions and key points to take away. Who should attend Managers who want to learn about and practice the Appreciative Inquiry approach to drive positive changes. Requirements for Attendees None.

This market-leading health and safety course enables companies to demonstrate compliance and embed health and safety into the company culture. Whilst anyone can attend, it is particularly beneficial for line managers, team leaders and supervisors. It is tried, tested and trusted.

Cognitive Behavioral Therapy (CBT) in couples counseling targets negative thought patterns and behaviors. This therapy provides practical solutions for improving communication and resolving conflicts, making it an effective approach for various relationship challenges. Key areas: negative thought patterns, behavior change, practical solutions, communication improvement, conflict resolution 3 x 1 hour sessions 

Introducing the Art Therapy and Expressive Therapies Package: Unleash Your Creativity, Heal, and Flourish Are you seeking a unique and powerful way to express your emotions, process experiences, and find healing? Miss Date Doctor’s Art Therapy and Expressive Therapies Package offers you a creative and transformative journey to explore your inner world, tap into your creativity, and promote emotional well-being. Art therapy and expressive therapies provide a non-verbal and imaginative outlet for processing emotions and experiences. Through various creative mediums, you’ll discover new insights, release emotional tension, and cultivate a deeper connection with yourself. Here’s how the Art Therapy and Expressive Therapies Package can benefit you: Creative Expression: Engage in various expressive art forms, such as drawing, painting, sculpting, and collage-making. These creative expressions allow you to communicate thoughts and feelings that might be challenging to put into words. Emotional Release: Through art, you can release emotions that may have been suppressed or difficult to express verbally. The creative process can be cathartic, enabling you to process complex feelings and experiences. Self-Exploration: Art therapy encourages self-reflection and introspection. As you create art, you’ll gain insights into your thoughts, emotions, and subconscious mind, fostering greater self-awareness. Empowerment and Agency: Art therapy emphasizes the process rather than the end result, empowering you to embrace imperfection and experiment without judgment. This approach can extend to other aspects of life, promoting a sense of agency and resilience. Stress Reduction: Engaging in creative activities can reduce stress and promote relaxation. The meditative aspects of art therapy can provide a welcome escape from daily pressures and anxieties. Healing Trauma: For individuals who have experienced trauma, art therapy can be a gentle and effective way to explore and heal from emotional wounds. The creative process can foster a sense of safety and control in processing traumatic memories. Enhancing Communication: For those who find it challenging to express themselves verbally, art therapy offers an alternative means of communication. It can improve verbal expression and interpersonal skills. Building Confidence: Creating art allows you to tap into your inherent creativity, fostering a sense of accomplishment and boosting self-confidence. As you witness the fruits of your artistic expression, you’ll gain greater confidence in your abilities. Participating in art therapy and expressive therapies at Miss Date Doctor is a journey of self-discovery and growth. Our skilled therapists will guide you in exploring various artistic mediums and techniques, tailoring the experience to suit your unique needs and preferences. Experience the transformative power of creativity, heal from emotional wounds, and flourish in the Art Therapy and Expressive Therapies Package. Embrace art as a powerful tool for self-expression and personal growth. Unleash your creativity and find healing in the beautiful world of art therapy. 3 X 1 hour sessions https://relationshipsmdd.com/product/art-therapy-and-expressive-therapies-package/

Overview This one day course will provide guidance on how to become more assertive and build self-confidence, which in-turn will help your attendees to achieve greater work effectiveness and productivity, whilst putting them in control of their daily activities and making them more able to overcome stressful work and life situations. Description Being assertive is being able to express yourself with confidence without having to resort to passive, aggressive or manipulative behaviour. By developing assertiveness and becoming aware of our own strengths and weaknesses, we can modify our behaviour for greater effectiveness in social and business interactions. Topics covered: What is Assertiveness? – A series of activities relating to what assertiveness means and, perhaps more importantly, what it means to the participants. My Assertiveness Goals – A chance for the participants to review what they want to get out of the session and where they would like to end up with regard to their approach to assertiveness. How Assertiveness Works – A look at human reactions and the reasoning behind them culminating in an activity that looks at the participants own observations in relation to assertive behaviour. My Assertive Rights – A review of the rights we have as individuals followed by a commitment to the rights by the participants. Taking a Positive Approach – Looking at key methodology, including: – Giving and Receiving Compliments A review of typical responses to compliments and their negative consequences, followed by an opportunity to develop new, positive responses. – Improving Self-Esteem An in-depth review of each individual’s positive aspects. – New Challenges A set of challenges to take participants out of their comfort-zone and into the realm of possibilities. – Effective Communication A look at what makes effective communication, with some modelling of behaviours. Approaching Assertiveness – A look at the four cornerstones of being assertive with an opportunity to practice these behaviours. The Words You Use – Understanding the key areas of effective communication. Covering the areas of; Disclosing Your Feelings, Being Clear, Being Persistent, Empathising and Working Towards a Wise Outcome. Preparing to Be Assertive – A chance to understand and practice a set process of ‘scripting’ in order to develop an effective and natural approach to assertive interactions. Assertive Review – An activity that solidifies the reasoning behind wanting to become assertive, whilst demonstrating that it is not an unachievable outcome. Who should attend Anyone that needs to develop their assertiveness skills and improve communication with others Requirements for Attendees None.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 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. 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. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

This one-day or Two Session workshop will focus on a key but often ignored communication skill: Focused Listening.

A payment plan is available, please contact us for more details. WSET Level 3 in Wines Award is an advanced level qualification for professionals working in the wine industry and for wine enthusiasts. If you are looking to delve deeper into the world of wines, this qualification provides a detailed understanding of grape growing and wine making. Upon completion you will be able to assess wines accurately, and use your understanding to confidently explain wine style and quality.  What the course covers Wine Tasting: Taste, describe and analyse wines using the WSET Systematic Approach to Tasting Food and Wine Matching: A guide to the key considerations when matching food and wine successfully Labelling: Learn how to decode and understand labels Wine Production: Learn about the production factors influencing the style, quality and price of wine from vineyard to bottling Light Wines: Learn about the styles of wines produced in the key wine regions and districts of the world: France, Italy, Spain, Portugal, Austria, Germany, Greece, South Africa, Australia, New Zealand, North and South America, England and Wales Sparkling Wines: Learn about the methods of production and the main styles of sparkling wines from the key wine producing countries: France, Spain, Italy, Germany, New World - Australia, California, New Zealand, South Africa Fortified Wines: Learn about the methods of production/main styles of fortified wines from the key wine countries: Spain, Portugal, France, Australia Examination: The examination is in two parts and takes place in the afternoon session of the final day of the course. The WSET Exam fee is included in the course cost. Theory paper: a combined theory paper consisting of a 50 question multiple-choice section and a four question short answer written section. 2 hours. Tasting: a blind tasting of two wines. A mark of 55% required in all sections to pass. 1 hour. The qualification has full accreditation from the UK Government’s Qualifications & Curriculum Authority as a Level 3 Vocational Qualification. To view the full course specification, including examples of exam questions, please click HERE. Recommended Private Study: 56 hours additional private study is recommended for this course. It is strongly recommended the majority of the private study is done in preparation for each session. Private study is essential to ensure that you are ready and prepared for the exam. Entry requirements: Although not essential, we do recommend you have completed the WSET Level 2 Award in Wines before enrolling on the course. The syllabus assumes that candidates already possess a good basic understanding of simple wine making techniques, key grape varieties and viticultural patterns. The fee of £825 includes All WSET course materials including; 'Accounting For Style And Quality' course manual (comprehensive 250 page textbook), Study Guide and Full SAT Tasting Card All wine tasting samples (60 to 70 wines) The use of professional ISO tasting glasses 6 days of professional WSET tuition by a WSET Certified tutor Teaching of the WSET Level 3 Systematic Approach to Tasting Wine (SAT) ® which will enable you to analyse wines objectively and consistently in preparation for the tasting exam Two fully marked mock tasting exams and weekly written exam technique sessions to ensure you are fully prepared for the exam Comprehensive student support by WSET certified educator outside of class time should you have any questions before, during and after the course Registration with WSET and all examination fees Internationally-recognised certificate and pin badge upon successful completion VAT at 20% (VAT receipt can be provided on request) Special Educational Needs Please make us aware if you have a condition that may mean you qualify for additional help during the exam such as dyslexia. Funding Funding for this course is available:  DEVELOP is the educational programme of The Drinks Trust, the drinks and hospitality industry charity. DEVELOP offers fully funded training and skills courses, delivered by industry-leading providers for people already working, or with an ambition to work, in the drinks and hospitality industry. Manchester Wine SChool has partnered with The Drinks Trust to bring courses free of charge to eligible students. All of the WSET courses are available for funding with DEVELOP. To learn more please visit the Drinks Trust website HERE Criteria of eligibility for DEVELOP funding: must be 18 or over, eligible to work in the UK, have a National Insurance Number, and be earning less than £26k/pa

Gain comprehensive knowledge and practical skills in seizure first aid and rectal paraldehyde administration with our course. Ideal for caregivers, healthcare professionals, educators, and individuals.