3125 Management courses in Frome delivered Live Online

The Food Hygiene Regulations 2006 are considered to be the most important food safety and hygiene regulations in the UK. These regulations go one step further than the Food Safety Act 1990 as they specify that ALL food businesses have a legal obligation to make sure that food they prepare and serve to the public is safe and hygienic.

Duration 48.125 Days 288.75 CPD hours Cisco Learning Library: Collaboration provides on-demand training to help your IT staff design, implement, manage, and troubleshoot your organization?s collaboration and video infrastructure based on Cisco collaboration and unified communications solutions.This comprehensive technical training library includes full-length interactive certification courses, product and technology courses with labs, and thousands of reference materials. Collaboration Library Certification Courses CCNP Collaboration Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Implementing Cisco Collaboration Applications (CLICA) v1.0 Implementing Cisco Advanced Call Control and Mobility Services (CLACCM) v1.0 Implementing Cisco Collaboration Cloud and Edge Solutions (CLCEI) v1.0 Implementing Automation for Cisco Collaboration Solutions (CLAUI) v1.0 CCIE Collaboration Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Product and technology training Cisco Video Infrastructure Design (VID) v1.0 Developing Applications for Cisco Webex and Webex Devices (DEVWBX) v1.0 Implementing Automation for Cisco Collaboration Solutions (CLAUI) v1.0 Implementing Cisco Advanced Call Control and Mobility Services (CLACCM) v1.0 Implementing Cisco Collaboration Applications (CLICA) v1.0 Implementing Cisco Collaboration Cloud and Edge Solutions (CLCEI) v1.0 Implementing Cisco Collaboration Core Technologies (CLCOR) v1.0 Understanding Cisco Collaboration Foundations (CLFNDU) v1.0

Duration 2.25 Days 13.5 CPD hours This course is intended for The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions. Overview Work with functions. Work with lists. Analyze data. Visualize data with charts. Use PivotTables and PivotCharts. Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data This course provides the knowledge to create advanced workbooks and worksheets that can deepen the understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it and present that information to decision makers. In addition this course will give you the ability to collaborate with colleagues, automate complex or repetitive tasks and use conditional logic to construct and apply elaborate formulas and functions which will allow you to work through a lot of data and generate the answers that your organisation needs. WORKING WITH FUNCTIONS Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date and Time Functions Topic E: Work with Text Functions WORKING WITH LISTS Topic A: Sort Data Topic B: Filter Data Topic C: Query Data with Database Functions Topic D: Outline and Subtotal Data ANALYZING DATA Topic A: Create and Modify Tables Topic B: Apply Intermediate Conditional Formatting Topic C: Apply Advanced Conditional Formatting VISUALIZING DATA WITH CHARTS Topic A: Create Charts Topic B: Modify and Format Charts Topic C: Use Advanced Chart Features USING PIVOTTABLES AND PIVOTCHARTS Topic A: Create a PivotTable Topic B: Analyze PivotTable Data Topic C: Present Data with PivotCharts Topic D: Filter Data by Using Timelines and Slicers WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS Topic A: Use Links and External References Topic B: Use 3-D References Topic C: Consolidate Data SHARING AND PROTECTING WORKBOOKS Topic A: Collaborate on a Workbook Topic B: Protect Worksheets and Workbooks AUTOMATING WORKBOOK FUNCTIONALITY Topic A: Apply Data Validation Topic B: Search for Invalid Data and Formulas with Errors Topic C: Work with Macros USING LOOKUP FUNCTIONS AND FORMULAS AUDITING Topic A: Use Lookup Functions Topic B: Trace Cells Topic C: Watch and Evaluate Formulas FORECASTING DATA Topic A: Determine Potential Outcomes Using Data Tables Topic B: Determine Potential Outcomes Using Scenarios Topic C: Use the Goal Seek Feature Topic D: Forecast Data Trends CREATING SPARKLINES AND MAPPING DATA Topic A: Create Sparklines Topic B: Map Data

First Aid for Mental Health | RQF Level 2 First Aid for Mental Health qualification is designed to provide individuals with the knowledge and skills to support individuals experiencing mental health issues. This course aims to increase awareness of mental health, reduce stigma, and promote early intervention and support. The course covers various aspects of mental health, including common mental health conditions, signs and symptoms, and the impact of mental health issues on individuals and society. Participants will learn about different approaches to mental health, including self-help, accessing support, and signposting to appropriate services. The content of the RQF Level 2 First Aid for Mental Health course typically includes: Understanding Mental Health: An overview of mental health, including common mental health conditions such as depression, anxiety disorders, and stress. Participants will learn about the prevalence of mental health issues and their impact on individuals and society. Recognizing Mental Health Conditions: Understanding the signs, symptoms, and potential triggers of various mental health conditions. Participants will learn to identify early warning signs and risk factors for mental health issues. Promoting Positive Mental Health: Strategies and techniques for promoting positive mental health and well-being. This may include stress management techniques, self-care practices, and maintaining good mental health hygiene. Providing Mental Health First Aid: Techniques for providing initial support to individuals experiencing mental health crises or deteriorating mental health. Participants will learn how to offer non-judgmental listening, empathy, and reassurance to individuals in distress. Signposting and Referral: Understanding the importance of signposting individuals to appropriate professional help and support services. Participants will learn about local resources, helplines, and mental health organizations that can provide ongoing assistance. Self-Help and Resilience: Exploring self-help strategies and resilience-building techniques that individuals can use to manage their mental health and well-being. This may include relaxation techniques, mindfulness exercises, and developing healthy coping mechanisms. The course may be delivered through a combination of classroom-based instruction, group discussions, case studies, and practical activities. All our trainers are qualified and experienced in mental health education and support. Upon successful completion of the RQF Level 2 First Aid for Mental Health course, participants will receive a qualification that demonstrates their understanding of mental health issues and their ability to provide initial support to individuals experiencing mental health challenges. It's important to note that this course is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. It aims to equip individuals with the knowledge and skills to provide initial support and signposting to appropriate services. Suitability - Who should attend? First Aid for Mental Health course is suitable for a wide range of individuals who are interested in gaining knowledge and skills to provide initial support to individuals experiencing mental health challenges. Here are some examples of who the course may be suitable for: General Public: The course is open to anyone who wants to increase their understanding of mental health and learn how to support others effectively. It is suitable for individuals who want to develop their knowledge and skills in mental health first aid for personal reasons or to support friends, family members, or colleagues. Workplace Settings: The course is particularly relevant for individuals working in various professional settings, including but not limited to workplaces, schools, colleges, universities, community organizations, and voluntary sectors. It can benefit employees, supervisors, managers, and HR professionals who want to create a mentally healthy and supportive work environment. Healthcare Professionals: Healthcare professionals, such as nurses, doctors, paramedics, and allied health professionals, can benefit from the course to complement their existing medical knowledge and skills. The course equips them with additional tools and strategies to effectively respond to the mental health needs of their patients. Customer Service and Support Roles: Individuals working in customer service, hospitality, retail, or other client-facing roles can benefit from the course to enhance their ability to provide empathetic and supportive interactions with customers or clients who may be experiencing mental health challenges. Community Leaders and Volunteers: Community leaders, volunteers, and individuals involved in community organizations, charities, or support groups can gain valuable knowledge and skills from the course. It enables them to offer informed support and signposting to individuals within their communities who may be in need. It's important to note that the course does not require any previous qualifications or specific professional background in mental health. Participants should have a willingness to learn, an open mind, and a compassionate attitude toward individuals experiencing mental health challenges. However, it's also important to recognize that the course does not provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it focuses on providing initial support, promoting awareness, and signposting individuals to appropriate professional help and services. Before enrolling in the course, individuals should consider their personal interest, commitment to learning about mental health, and their motivation to support others in this area. It is also recommended to check any specific requirements or prerequisites set by the training provider to ensure suitability for participation. Overall, the RQF Level 2 First Aid for Mental Health course is suitable for individuals from various backgrounds who want to develop their understanding of mental health and gain practical skills to provide initial support and signposting to individuals in need. Outcome / Qualification etc. Upon successful completion of the First Aid for Mental Health course, participants can expect to achieve the following outcomes: Increased Awareness and Understanding: Participants will develop a greater awareness and understanding of mental health, including common mental health conditions, their signs and symptoms, and the impact they can have on individuals and society. They will gain knowledge about the prevalence of mental health issues and the importance of promoting positive mental health. Enhanced Ability to Recognize Mental Health Conditions: Participants will acquire the skills to recognize signs and symptoms of various mental health conditions. They will be better equipped to identify early warning signs and risk factors, enabling them to provide timely support and intervention. Improved Mental Health First Aid Skills: Participants will learn techniques and strategies for providing initial support to individuals experiencing mental health crises or deteriorating mental health. They will develop skills in active listening, non-judgmental communication, and empathy, allowing them to offer appropriate assistance and reassurance to individuals in distress. Knowledge of Signposting and Referral: Participants will gain an understanding of the importance of signposting individuals to appropriate professional help and support services. They will learn about local resources, helplines, and mental health organizations, enabling them to provide accurate information and guide individuals to the appropriate sources of assistance. Enhanced Self-Help and Resilience Strategies: Participants will learn self-help strategies and resilience-building techniques that individuals can use to manage their own mental health and well-being. They will acquire practical tools for stress management, relaxation, and developing healthy coping mechanisms. Confidence in Supporting Others: The course aims to enhance participants' confidence in providing support to individuals experiencing mental health challenges. Through knowledge, skills, and practical exercises, participants will feel more prepared to respond appropriately and effectively in a compassionate and understanding manner. Qualification: Upon successful completion of the course, participants will receive an RQF Level 2 qualification in First Aid for Mental Health. This qualification demonstrates their understanding of mental health issues and their ability to provide initial support to individuals in need. It's important to note that the RQF Level 2 First Aid for Mental Health qualification is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it aims to equip individuals with the necessary knowledge and skills to offer initial support and signposting, fostering a supportive and empathetic environment for individuals experiencing mental health challenges. Training Course Content Module 1 Introduction Module 2 What is first aid for mental health? Module 3 Identifying mental health conditions Module 4 Providing advice and starting a conversation Module 5 Stress Module 6 Mental health conditions Module 7 Drugs and alcohol Module 8 First aid action plan for mental health - including practical assessment Module 9 Mental health in the workplace Module 10 Assessment and course closure Course delivery details Classroom-Based or Virtual Instruction: The course may be delivered through traditional classroom-based instruction, where participants attend in-person training sessions led by a qualified instructor. The instructor will cover the course content, facilitate discussions, and provide guidance on practical activities. Blended Learning: Some training providers offer a blended learning approach, combining both online and face-to-face components. Participants may complete certain modules or topics online through interactive e-learning platforms or virtual classrooms. This allows for self-paced learning and flexibility before attending practical sessions or assessments in person. Interactive Discussions: The course often includes interactive discussions where participants can share their experiences, ask questions, and engage in conversations related to mental health. This encourages active participation, promotes peer learning, and provides opportunities for clarification and deeper understanding of the course content. Case Studies and Scenario-Based Activities: To enhance practical application, trainers may present case studies or scenarios related to mental health issues. Participants can work in groups or individually to analyse the situations, identify appropriate responses, and discuss possible strategies for providing support. Practical Skills Demonstrations: Trainers may demonstrate practical skills and techniques for providing mental health first aid, such as active listening, empathetic communication, and crisis intervention. Participants will have the opportunity to observe and learn from these demonstrations before practicing the skills themselves. Role-Playing and Simulations: Role-playing exercises and simulations may be used to simulate real-life scenarios and provide participants with hands-on practice in responding to mental health crises. This allows them to develop their skills in a safe and controlled environment and receive feedback from the trainer and peers. Assessment and Certification: Participants will undergo assessments to demonstrate their understanding of the course content and their ability to apply their knowledge and skills in practical scenarios. Successful completion of the assessments leads to the awarding of the RQF Level 2 First Aid for Mental Health qualification. It's important to note that the specific delivery methods and approaches may vary depending on the training provider, course duration, and the resources available. Participants should check with the training provider for detailed information on the course delivery format and any specific requirements or prerequisites for participation. Overall, the aim of the course delivery is to create an engaging and interactive learning environment that allows participants to gain the necessary knowledge, skills, and confidence to provide effective support to individuals experiencing mental health challenges. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively. This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA). Introduction to Macros Recording Macros Absolute and Relative How to Run a Macro Basics of Code Writing The VBA Environment (the ?VBE? window) Essential Tips, Tricks, Shortcuts Understanding VBA and Best Practice Crucial VBA Objects and Structures Variables and Data Types Conditionals (If, Select Case) Loops (For, Do) Interaction Interact with Data, Sheets, the Excel Application Interact with User (Message Box, Input Box) Errors Run Editing Debuging Handeling Errors Additional course details: Nexus Humans Excel - VBA Bootcamp 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 Excel - VBA Bootcamp 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.

To increase your awareness and understanding of what safeguarding children means, in order to increase your confidence to enable you to make a positive contribution towards the process.

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Expand your VBA knowledge further and learn some of the more advanced coding features. Course overview Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models Objectives  By the end of the course you will be able to: Use comparison operators and system functions Use Arrays Work with ranges Work with the worksheets and workbooks collections and objects Use application objects Use the FileSystemObject Create function procedures Import and save text files Connect to other applications Content Comparison operators Using Comparison operators and functions The LIKE function Wildcards Using SELECT Case System functions The VAL function Case functions Trim functions Text functions Date functions Excel worksheet functions Using Excel functions in VBA Arrays Creating arrays Using arrays Ubound and Lbound Single and multi dimensional arrays Static vs dynamic arrays Working with ranges Creating range objects Passing data between range objects and arrays Using Transpose The Excel object model The object browser Working with collections Collections Creating object variables Setting object variables The For Each . . . Next Loo Sheet collections The worksheets collection The worksheet object The sheets collection Using object Grouping worksheets Using Typename The Workbook collection The workbooks collection Setting workbook variables Application objects Excel default information Display/alerts Screen updating Status bar On Time Using Wait Systems dialog boxes Showing dialog boxes Using dialog boxes Working with files Searching for files and folders The DIR function The FileSystemObject Function procedures Creating functions Adding arguments Calling functions Working with text files Searching for files and folders The DIR function The FileSystemObject Using the FILE and FOLDER collections Sharing data with other applications Early vs Late Binding Setting references to other applications Creating application variables Setting application variables