2446 Courses

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Microsoft Excel® in Depth 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

One-Day Course 10am - 4pm Updated Jan 2023 (Working Together to Safeguard Children (Jan 2021 Updated) & Keeping Children Safe in Education (2022)) This Course can also be run within your organisation for your staff group at a reduced rate, contact us for a quote or if you have any other questions about this course talk to an adviser now online: Online Live Customer Adviser What is the course about? This course will help you and your staff become familiar with the role and responsibilities of the designated safeguarding lead in your organisation. It will develop both your competence and confidence in carrying out the role of Designated Safeguarding Lead (DSL). Formally known as Level 3

Reclaiming Regulation is a series of individual, in-= person workshops for women who are seeking to explore nervous system regulation, somatic awareness, and embodied wellbeing. These 90 minute workshops offer accessible, practical tools to support emotional balance, reduce overwhelm, manage nervous system regulation and develop a deeper connection with the body. Each session is a stand alone experience that blends nervous system theory with somatic practices, breathwork, and grounding practices. The workshops are inclusive, trauma informed, and accessible to all levels, including complete beginners. Who These Workshops Are For WOMEN ONLY These sessions are ideal for women: seeking body based tools for managing stress and supporting calm feeling disconnected, tense, or emotionally fatigued curious about nervous system regulation and somatic practices wanting to reconnect with the body in a safe, supportive space No previous experience is required Somatics & Nervous System Regulation: Benefits for Stress, Trauma, and Emotional Regulation: Reduces chronic stress → Helps shift the body from fight-or-flight into rest-and-digest (parasympathetic state) Supports trauma recovery → Allows stored tension, stress and trauma symptoms to be released safely through the body Improves emotional regulation → Builds capacity to experience emotions without overwhelm or emotional shutdown Enhances self-awareness → Encourages a deeper connection to bodily sensations and internal states Increases resilience → Strengthens the nervous system's ability to recover from stress more quickly Promotes grounding and presence → Helps you feel more centred, calm, and connected to the present moment Reduces anxiety symptoms → Calms overactive stress responses through breath, movement, and awareness Improves sleep and rest quality → Calming the nervous system supports better rest and recovery Empowers self-regulation skills → Teaches tools to manage emotional ups and downs independently Strengthens mind-body connection → Enhances the ability to listen to and trust bodily signals Workshop Format Schedule: One in person workshop each month (October–July) Duration: 90 minutes per workshop Structure: Each workshop is a stand alone experience, attend one or as many as you choose Location: Art & Spirituality Facilitator: Led by a trauma informed integrative somatic therapist Provided: Comfort props, optional reflection prompts, and follow-up resources Each session includes: Accessible nervous system education Guided breathwork and somatic practices Restorative and grounding practices Optional moments for reflection or group connection Take home practices for integration Monthly Workshop Themes November: Befriending the Body Reconnect with body awareness through gentle movement and body scanning Learn to interpret internal signals and physical cues Cultivate presence using breath and orienting practices Workshop Outcomes By attending one or more of these workshops, participants will: Understand key nervous system principles that support emotional balance Build body awareness and confidence in reading internal cues and sensations Gain practical breath and movement tools for everyday regulation Reconnect with the body as a resource for rest, presence, and wellbeing Cultivate more compassion and awareness of widening their your window of tolerance Why This Work Matters In a fast paced and often dysregulated world, many women are seeking grounded, body based tools to support their wellbeing. These workshops offer a gentle, empowering, and science informed space to reconnect with the body’s organic intelligence. Through movement, breath, and embodied awareness, participants can cultivate more resilience, rest, and a renewed sense of aliveness, one moment, one step at a time. This FREE workshop is for Adults women only and is sponsored by CORRA and HENRY DUNCAN GRANTS By attending this class you release Cori from Koa, Giada Gaslini and Art and Spirituality Cic, from any liability arising out of any personal injuries, emotional or physical release, death, physical reaction, expectations of results, theft in the venue or damages that may happen to people and objects while attending. Pictures will be taken during the workshop, if you prefer not to be in them, please inform the teacher.

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

Level 4 NVQ Diploma in Controlling Lifting Operations - Supervising Lifts

Communication Skills 1 Day Training in Crewe

Target Audience Business professionals, leaders & executives aiming to develop their awareness of, and connection to self and others in complex or ambiguous contexts. Duration 1 Day Course Overview Adaptive social and emotional skills enable individuals to build social connections and regulate their emotions effectively in order to work well with others in an evolving organisational context. This involves strengthening emotional intelligence and shifting their mindset to become open, collaborative and focussed on forming value-driving partnerships. This course is designed by highly qualified learning design experts, assisted and guided by a Doctoral & Masters level leadership team. Working closely with subject matter leaders with extensive domain experience, this course is built on sound academic rigour and applied real world experience. Run in a cohort-based, activity-led format, it goes beyond theory to provide practical methods and frameworks that you can immediately apply in your workplace. Key Outcomes Exploring your own Emotional Intelligence Identifying common ground Gaining trust, respect and commitment Applying assertive techniques to manage and resolve conflicts