2599 Courses delivered Live Online

Vectorworks One to One Fast Track Course Master Vectorworks in Just One Day (10 Hours)

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

Introduction to Diabetes (2-Day Course)Course Description:These two days of comprehensive training are designed for nurses, nurse associates, pharmacists, paramedics, and other Allied Healthcare Professionals (AHPs), and experienced healthcare assistants (HCAs) who are new to or fairly new to the field of diabetes care. If you've recently started seeing patients with diabetes, or are planning to; this course is tailored to provide you with the fundamental knowledge and skills required to confidently care for individuals with diabetes. The primary focus is on adults with Type 2 diabetes, although key recommendations and signposting for patients with Type 1 diabetes will also be covered.Diabetes presents a significant healthcare challenge, costing the NHS £10 billion each year and impacting patients and their families. Primary care professionals play a pivotal role in managing the ever-increasing numbers of people diagnosed with Type 2 diabetes. Good diabetes care is crucial and aligns with national and local policies supported by robust NICE guidance.These interactive days of learning will incorporate various methods, including case studies, to help you progress from basic knowledge to a more confident and positive approach in reviewing and managing patients with diabetes.Day One09.15 - Coffee and Registration09.30 - Introduction and Course Objectives09.45 - Setting the Scene: - Screening, Diagnosis, and Pre-Diabetes - Pathophysiology and Symptoms - Remission in Type 2 Diabetes10.45 - Coffee Break11.00 - Diet & Diabetes: - Healthy Eating - Carbohydrate Awareness - Range of Dietary Approaches - Weight Management Services01.00 - Lunch02.00 - Benefits of Activity02.15 - Foot Care and Diabetes02.45 - Organising Structured Diabetes Care in Practice: - QoF and the Annual Review - Care & Support Planning - 8 Care Processes and 3 Treatment Targets03.15 - Case Studies03.30 - Action Plan, Evaluation, and Resources03.45 - CloseDay Two09.15 - Coffee and Registration09.30 - Review Progress Since Day 109.45 - Non-Insulin Medications10.45 - Coffee Break11.00 - Medication Management01.00 - Lunch02.00 - Complications Associated with Diabetes02.45 - Hyperglycaemia, Hypoglycaemia, and Management of Illness03.15 - Blood Glucose and Ketone Monitoring03.30 - DVLA and Diabetes03.45 - Competencies, Training, Resources, and CloseKey Learning Outcomes for Both Days:Upon completing this course, participants will be able to:1. Explain the physiology of diabetes and differentiate between Type 1 and Type 2 diabetes.2. Discuss methods for diagnosing diabetes and provide information to individuals newly diagnosed with Type 2 diabetes.3. Describe approaches that support achieving remission in Type 2 diabetes.4. Explain basic advice related to a healthy diet, various dietary approaches, and carbohydrate awareness.5. Discuss the modes of action of commonly used non-insulin medications.6. Identify major complications that may arise in individuals with long-standing diabetes and measures to limit or prevent them.7. Describe key advice for patients regarding the recognition and appropriate treatment of hypoglycaemia.8. Discuss DVLA guidance concerning driving and diabetes.9. Explain the risks of acute hyperglycaemia and provide advice to patients on self-managing illness periods.10. Provide examples of referral pathways to other services such as weight management, secondary care, podiatry, structured education, activity, and psychological services.11. Describe the process of routine foot review and factors influencing diabetic foot risk status.12. Discuss local recommendations for the appropriate use of blood glucose and ketone monitoring.13. Explain the key components and processes of an annual diabetes review and a self-management plan.Join us for this comprehensive 2-day course via Zoom and enhance your ability to provide effective diabetes care within primary care settings.

A comprehensive two days, delivered using a variety of teaching styles, by professionals who manage medical emergencies on a day-to-day basis. A number of the more common presenting conditions are covered providing a structured approach to the pathophysiology, initial assessment and management of the acutely ill medical patient.

A 6-week inner child healing course to help you to improve your mental health and wellbeing by understanding your childhood experiences and the beliefs and limitations these may have created in your present-day life. An introduction to connecting with your inner child, developing a relationship with them, learning how to parent them, protect them and empower them. This will enable you to understand your feelings, needs and boundaries and give you a set of tools to develop acceptance, love and compassion for yourself.

A 6-week inner child healing course to help you to improve your mental health and wellbeing by understanding your childhood experiences and the beliefs and limitations these may have created in your present-day life. An introduction to connecting with your inner child, developing a relationship with them, learning how to parent them, protect them and empower them. This will enable you to understand your feelings, needs and boundaries and give you a set of tools to develop acceptance, love and compassion for yourself.

Talk the argument through Ascertain the cause Analyse possible options and solutions Relationship conflict coaching support and mediation tips conclusion and emotional intelligence training tips 3 x 45 mins sessions https://relationshipsmdd.com/product/m-d-d-argument-with-my-girl-package/

Training duration: 20 hrs Click here for more info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. 20-hour Adobe After Effects Course Outline covering both basic and advanced techniques: Module 1: Introduction to After Effects (2 hours) What is After Effects and its applications Understanding the After Effects interface and workspace Creating projects and compositions Importing and managing media Basic navigation and keyboard shortcuts Module 2: Basic Animation Techniques (4 hours) Adding and animating text Creating and animating shapes Keyframing and easing motion Animating with effects and presets Using masks and track mattes for animation Applying motion blur for realistic movement Module 3: Working with Layers and Effects (4 hours) Organizing and managing layers in the timeline Understanding blending modes and layer styles Applying and customizing effects for creative enhancements Creating and using presets for efficiency Advanced compositing techniques with masks and tracking Using motion tracking to add effects to moving objects Module 4: 3D Space and Camera Animation (4 hours) Introduction to 3D space in After Effects Creating and animating cameras for dynamic shots Working with lights and shadows for realism Utilizing depth of field for focus effects Creating 3D text and shapes for engaging visuals Building 3D environments with multiple layers Module 5: Audio and Expressions (3 hours) Adding and manipulating audio in After Effects Creating audio visualizations Applying audio effects for synchronization Introduction to expressions and scripting Using expressions to automate animation Creating custom expressions for advanced control Module 6: Advanced Techniques (3 hours) Advanced animation techniques for complex motion Compositing and creating visual effects Applying motion graphics design principles Implementing advanced motion graphics techniques Working with third-party plugins and tools for expanded capabilities Color grading and color correction for visual enhancement Module 7: Rendering and Exporting (2 hours) Understanding the render queue and output settings Creating and using render templates for efficiency Exporting animations for various platforms and formats Best practices for optimizing render performance Finalizing and presenting your After Effects projects After Effects Free Download & Free Trial https://www.adobe.com › products › free-trial-download Download the full official version of Adobe After Effects for free.  By the end of this 20-hour Adobe After Effects Course, participants will: Gain a comprehensive understanding of After Effects' interface and navigation. Master basic animation techniques for text and shapes. Effectively manage layers and apply creative effects. Utilize advanced compositing and motion tracking. Explore 3D space and camera animation for dynamic shots. Integrate audio and use expressions for automation. Create advanced motion graphics and visual effects. Enhance visuals through color grading and correction. Export and render projects for various platforms and formats. Upon completion, participants will be skilled in creating professional motion graphics, animations, and visual effects using Adobe After Effects.

3Com switches training course description A hands on course covering the product specifics of 3Com switches. Installation, configuration, maintenance and troubleshooting are all covered in a practical oriented way. What will you learn Install 3Com switches. Use the command line interface and the web based interface to manage 3Com switches. Configure and troubleshoot 3Com switches. Configure and troubleshoot 3Com switches. Perform software upgrades. 3Com switches training course details Who will benefit: Anyone working with 3Com switches. Particularly aimed at engineers and technicians supporting 3Com switches. Prerequisites: None. Duration 2 days 3Com switches training course content Introduction How Ethernet works with hubs, How Ethernet works with switches. Installing 3Com switches. Hands on Building a network with a hub, building a network with a 3Com switch. Basic troubleshooting The 3Com switch range, LEDs, cabling issues, system resets, default settings. Hands on Building a network with multiple 3Com switches. Configuration methods Managed vs. unmanaged switches, Console port access, telnet, web based access, SNMP, saving configurations, NVRAM, switch stacks. Hands on Accessing the switch using the console, IP address configuration, telnet. Console interface Default users, passwords, the menus, menu options, online help, CLI commands. Hands on Setting passwords, displaying the switch configuration. Web based interface Getting started, basic format. Hands on Configuring the switch using the web interface. Port configuration Common port configuration tasks, port aggregation, resilient links. Hands on Configuring ports. STP configuration What is STP? Configuring STP. Hands on Enabling and disabling STP, configuring STP. VLAN configuration What are VLANS? 802.1Q, tagged/untagged, creating VLANS, applying VLANS. Hands on Setting up VLANS, setting up 802.1Q, Inter VLAN traffic. Housekeeping TFTP, software upgrades Hands on Software upgrade. SNMP SNMP configuration, Transcend, other NMS's. Hands on Using SNMP to manage a 3Com switch, putting it all together: troubleshooting.

Essential IMS training course description The IP Multimedia Core Network Subsystem (IMS) is defined by 3GPP as a new mobile infrastructure. This course studies the discreet elements in the IMS. What will you learn Describe the IMS. Describe the IMS architecture. Explain how charging, security and QoS is handled in the IMS. Explain how the IMS supports service enablers such as Push to talk and Presence. Essential IMS training course details Who will benefit: Telecommunications staff. Prerequisites: Mobile communications overview Duration 2 days Essential IMS training course contents Mobile communications review The role of IP in telecommunications. GSM to IMS. Enhanced multimedia services, Push To, convergence, conferencing, roaming. What is IMS? What it is, why IMS, standard bodies: 3GPP, IETF, OMA, IMS services. MMD comparison. IMS architecture blocks Overview, IMS functions, IMS interfaces, IMS protocols, IMS elements, IMS reference points. Access network, IMS in GSM, CDMA, WiFi & PSTN networks. Core network. Application, Control and Call planes. HSS - User database Identification. The user database, role of HSS, SLF and multiple HSSs. 'Normal' identities, IMPI, IMPU. IMS signalling: SIP What is SIP? SIP URI, contact address, UAs, Proxies, basic SIP call flow, SIP sessions. IMS other protocols Megaco, Diameter, XML, XCAP, COPS, RTP/RTCP, SDP, H.324M, IM and MSRP. Call/Session Control Call Session Control Functions (CSCF). Domains. Home networks, visited networks. CSCF and SIP. P-CSCF, P-CSCF discovery, P-CSCF functions. I-CSCF, DNS and I-CSCF. S-CSCF, S-CSCF functions, ENUM lookups. QoS. Example call flows. IMS services Open service platform, Application Servers, profiles, AS interface with S-CSCF. 'Normal' services (Caller ID, Call waiting, transfer…) Push to talk Over Cellular (PoC), IMS conferencing, Group management, IMS Presence, IMS Messaging. Other possible applications. Media servers. (MRFC, MRFP). Gateways IMS PSTN procedures, BGCF, PSTN interface. SGW, MGCF, MGW Charging Architecture, Offline, online and flow based charging, charging reference points, CCF, DIAMETER, ICID, IOI. IMS security IMS security architecture, identities, AAA, public and private user ID, service filters, Cx interface, RADIUS, Diameter protocol, 3GPP AKA, integrity, privacy, NDS, IPSEC, trust, assertion.