1489 Courses delivered Live Online

Spanish language courses

Understand what is meant by the term menopause and why we need to talk about it. Know how menopause can affect someone at work, and how to support colleagues experiencing it.

Identify some of the unique challenges women face in their personal and professional lives, and understand how to support and empower females in the workplace.

Sessions Note that this will be a three-day course run on consecutive days and the date of day one is shown in the booking system schedule. Online event This online course will be delivered using CISCO Webex. You will need to have a good internet connection, a suitable device with a camera and microphone such as a laptop, and headphones. Level of study This Level 5 programme is the equivalent standard of a unit of a foundation degree or a unit of a first year of an honours degree. Details Students will gain a comprehensive knowledge and understanding of: The principles and objectives of Risk & Resilience management The legal and regulatory requirements and the role of the regulators in respect of Risk & Resilience, including the emergence of Cyber threat The interconnected impacts that changes in Risk & Resilience make The effect of climate change on Risk & Resilience strategy The objective and purposes of a Company’s risk and resilience strategy and management structure Where Risk & Resilience management sits in the company organisational structure The decision-making process in terms of Risk & Resilience management The role and nature of risk financing and the variables that influence the process The importance of building resilience in the context of Cyber threat The principles of Risk & Resilience and its relationship to contingency planning The use and merits of quantitative and qualitative techniques in risk and resilience management How to reduce risks to personnel and the business via the emergency and business continuity planning process How to understand individuals’ risk perception behaviours The factors that influence group attitudes to risk-taking The practical meaning of business resilience and its role in disaster recovery The range of technologies and the techniques for gathering data available to assist the management of Risk & Resilience The use of probability theory and the use of normal and binomial distribution numerical methods in Risk & Resilience management The principles of scenario planning in relation to Risk & Resilience The principles of Risk, Resilience and contingency planning in commissioning assets The principles of supply chain management in relation to risk and resilience The role of logistics in relation to Risk & Resilience How to prepare the business for pre and post-emergency situations Instructions This online course will be delivered using CISCO Webex. You will need to have a suitable device with a camera and microphone such as a laptop. If you have any questions about what is required please contact us on enquiries@learninganddevelopment.associates. Qualification All learners taking the qualification will need to produce identification to enable ProQual registration. This can take the form of a: Passport Driving Licence Construction Skills Certification Scheme Card (CSCS Card) Construction Plant Competence Scheme Card (CPCS Card) If none of the above are available to the learner, a photograph with a statement confirming their identity, dated and signed, along with a utility bill, would be acceptable.

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

Understand what is meant by the term burnout to be able to identify and understand its impact on the individual and the organisation. Learn to utilise practical strategies to prevent and manage burnout.

Learn about common mental health concerns for women, the factors that can influence their wellbeing, and how to support our female colleagues.

Learn about the many benefits of supporting mental health in the workplace, identify the signs that an employee may be struggling with their mental health, and know how to have an effective conversation with them about it.

Why Choose AutoCAD Architecture Training Classes? Course info Master architectural design tools and workflows. Create precise floor plans, elevations, and sections. Utilize BIM for intelligent 3D modeling. Access recorded lessons and lifetime email support. Enroll for in-person or online sessions. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD Architecture 3D Course Outline: Introduction to AutoCAD Architecture Understanding the difference between AutoCAD Architecture and AutoCAD LT Familiarization with the user interface and 3D viewing Wall Construction and Modification Adding walls to the model Creating curtain walls for specialized designs Modifying walls to fit specific requirements Joining walls together to form complex structures Adding and modifying wall openings for doors and windows Ceiling Plans (Reflected) Creating ceiling grids and construction detailing Modifying ceiling grids to match design needs Inserting ceiling fixtures and construction detailing Structural Design and Analysis Working with structural members and online resources Creating column grids and detailing columns Modifying column grids and annotations Annotating column grids and detailing for clarity Stairs Creating stairs in the model Modifying stairs to suit design specifications Adding railings to stairs and construction detailing Modifying railings and construction detailing Floors and Slabs Creating floor slabs and construction detailing Modifying floor slabs to align with the design Editing slabs using Slab Tools and construction detailing Roofs and Construction Detailing of Roofs Creating roofs for the building Designing roof slabs for specific areas Modifying roofs and roof slabs as needed Using Roof Slab Tools for precise detailing Annotation Detail drawing for scale and annotation Adding text, leaders, and comments to the model Dimensioning in AutoCAD Architecture for accurate measurements Utilizing other annotation tools for clarity Equipment and Furnishings Adding interior and exterior furnishings to the design Incorporating blocks and online 3D models for realistic representations Utilizing Tool Palettes and Autodesk Seek resources Model Views Ready for Print PDF Creating callouts for specific views Designing elevations, sections, and construction detailing Modifying callout objects for better visualization Implementing live sections and elevations Generating reports and managing project resources Schedules Adding door and window labels to the model Editing label data for accuracy Creating schedules for better project management Modifying schedules to suit specific requirements This AutoCAD Architecture 3D course covers a comprehensive range of topics, providing participants with the skills to create detailed 3D architectural models, implement construction detailing, and manage project resources efficiently. The course enables participants to produce professional-grade architectural designs using AutoCAD Architecture software.

Getting Started – A Practical Introduction to Mindfulness. – delivered online via zoom A 10-week rolling program introducing mindfulness. There are 10 sessions with distinct content and it’s fine to join at any point. Getting Started operates on a drop-in basis, so if you miss a session you can cover the content next time it comes around. The sessions are interactive to support learning from each other's experiences. We, therefore, request that participants turn their cameras and microphone on for the sessions. Participants will be muted during meditations to reduce distractions. Getting Started is just that- an accessible introduction to mindfulness, providing a practical guide to building it into everyday life. Each session will cover a different aspect of Mindfulness and will include: Discussion about one of the foundational attitudes of mindfulness Each week focuses on a different foundation of building a mindfulness practice starting with Intention and then the nine foundational attitudes of mindfulness: Beginners Mind; Non-Judgement; Gratitude; Acceptance; Non-Striving; Letting Go; Generosity; Patience and Trust. The science which backs it up and how it applies to our lives. and Guided mindfulness practices These form the backbone of each session because practice promotes presence and Suggestions and tips for practicing in the context of our daily life and The opportunity to ask questions and An info sheet emailed to participants after each Getting Started session Session Topics: 1 | Intention – 20th October 2022 2 | Beginners Mind – 27th October 2022 3 | Non-judgement – 3rd November 2022 4 | Gratitude – 10th November 2022 5 | Acceptance – 17th November 2022 6 | Non-striving – 24th November 2022 7 | Letting Go – 1st December 2022 8 | Generosity – 8th December 2022 9 | Patience – 15th December 2022 10 | Trust – 22nd December 2022