Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 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 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 trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' 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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: 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. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced 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
Local authorities are being encouraged to seek the views of young people in relation to the services they receive. Schools and the whole range of support services (e.g. behaviour support, youth offending teams, social services, CAMHS etc.) are being expected to routinely ask young people for their views. This goes beyond involving young people in plans that concern them e.g care plans, individual education plans, pastoral support plans etc. Online Course now available via Teachable Platform – Ask the Children Learn at your own pace… lots of text and video support Course Category Peer Support Description Local authorities are being encouraged to seek the views of young people in relation to the services they receive. Schools and the whole range of support services (e.g. behaviour support, youth offending teams, social services, CAMHS etc.) are being expected to routinely ask young people for their views. This goes beyond involving young people in plans that concern them e.g care plans, individual education plans, pastoral support plans etc. This training will focus on how young people can be effectively engaged in giving their views and will present a model for use in evaluating services to young people based on the concept of resilience. This model enables young people to be clear about what has helped and hindered them in being able to overcome difficulties. It also provides a framework for evaluating the extent to which services are reducing risk and increasing protective factors to enable young people to develop the resilience. Testimonials ‘Yet again inspiring and opening more doors than I can go through’? ‘This opened a lot of avenues for thought and reflection. It will help me to help colleagues to see where they can improve practice to create a more inclusive environment within the whole school.’ ‘Some great ideas and restored my self belief! Fantastic’ Learning Objectives Strategies for engaging young people Knowledge and Understanding of resilience In relation to system and environmental factors Strategies for reducing risk and increasing protective factors In relation to Individual young people and services Evaluation framework for services to young people Who Is It For ? Youth offending teams Social services CAMHS Primary and secondary teachers Heads and Deputies SENCOs Learning Support and Guidance staff Advanced Skills Teachers Parents Local Authority Support Services Community Development workers Early Years and School based Practitioners Social work staff Health Services Course Content The course answers the questions : How can we truly involve pupils? Practically how do we go about listening to pupils views? What if we do not like what they tell us? How can we involve our most disaffected young people? Key themes Tools for engaging young people and gaining their views The concept of resilience System and environmental risk and protective factors that impact on young people’s resilience Reducing risk and Increasing protective factors Resilience planning for Individuals and services Evaluating services to young people If you liked this course you may well like: CIRCLES OF FRIENDS
***24 Hour Limited Time Flash Sale*** Cleaning, Plumbing & Infection Prevention and Control Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unleash Your Potential in Cleaning, Plumbing & Infection Prevention and Control with Our Comprehensive Course Bundle! Are you ready to become a master in the vital fields of Cleaning, Plumbing, and Infection Prevention and Control? Look no further! Introducing our exclusive bundle of 8 courses designed to equip you with the knowledge and expertise needed to excel in these essential areas. With a combination of three QLS-endorsed courses and five CPD QS accredited programs, this bundle is your key to success. At the heart of this bundle lie three prestigious QLS-endorsed courses: Cleaning, Professional Plumbing, and Principles of Infection Prevention and Control. By enrolling in this bundle, you gain access to these top-tier courses recognized by the Quality Licence Scheme. Upon completion, you will receive hardcopy certificates, a testament to your dedication and expertise, providing a tangible proof of your accomplishments. In addition to the QLS-endorsed courses, our bundle includes five relevant CPD QS accredited programs that further enhance your knowledge and skills. These courses, including Heating, Ventilation & Air Conditioning (HVAC) Technician, Spill Management Training, Infection Prevention Training, COSHH Training for Assessors, and First Aid at Work, provide comprehensive insights into crucial aspects of the cleaning, plumbing, and infection prevention fields. Key Features of the Cleaning, Plumbing & Infection Prevention and Control Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Cleaning, Plumbing & Infection Prevention and Control bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Cleaning QLS Course 02: Professional Plumbing QLS Course 03: Principles of Infection Prevention and Control 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Spill Management Training Course 03: Infection Prevention Training Course 04: COSHH Training for Assessors Course 05: First Aid at Work In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Cleaning, Plumbing & Infection Prevention and Control courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: By completing this Cleaning, Plumbing & Infection Prevention and Control bundle, you will: Develop a comprehensive understanding of cleaning techniques, plumbing principles, and infection prevention and control practices. Gain expertise in HVAC systems and their maintenance, ensuring optimal performance. Acquire the skills to effectively manage spills and mitigate their impact on the environment. Understand the principles and best practices for preventing infections in various settings. Learn how to assess and manage hazardous substances to ensure a safe working environment. Gain knowledge in providing first aid in workplace emergencies, ensuring the well-being of individuals. Master essential techniques and protocols for maintaining cleanliness, plumbing systems, and infection prevention in diverse environments. This comprehensive package offers a unique opportunity to delve deep into these critical disciplines, equipping you with the knowledge and skills necessary to excel in today's demanding environment. Within this bundle, you'll discover three QLS-endorsed courses that serve as the foundation of your learning journey. These courses are meticulously designed to provide you with a solid understanding of theoretical principles and their practical applications. Complementing the QLS-endorsed courses are five CPD QS accredited programs that further enhance your knowledge and proficiency. From mastering HVAC systems and spill management to infection prevention training, COSHH assessment, and first aid protocols, these courses cover a range of essential topics, empowering you to make informed decisions and contribute effectively in your chosen profession. By enrolling in this bundle, you'll gain in-depth insights into the intricacies of HVAC systems, the management of spills, infection prevention strategies, hazardous substances assessment, and first aid protocols. Armed with this knowledge, you'll be equipped to address challenges and implement effective solutions in a variety of environments. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals seeking to enhance their knowledge and skills in cleaning, plumbing, and infection prevention and control. Aspiring practitioners looking to establish a solid foundation in these fields. Individuals interested in gaining expertise in HVAC systems, spill management, infection prevention, hazardous substances assessment, and first aid. Those aiming to advance their careers and contribute effectively to the cleaning, plumbing, and infection prevention industry. Career path Upon completing this bundle, you can pursue various career paths in cleaning, plumbing, and infection prevention and control, with positions such as: Facilities Manager: £30,000 - £60,000 per annum Plumbing Engineer: £25,000 - £45,000 per annum Infection Control Officer: £25,000 - £45,000 per annum Health and Safety Manager: £30,000 - £60,000 per annum Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included
Management of Value (MoV®) Foundation This interactive MoV® Foundation course provides a modular and case-study-driven approach to learning Management of Value (MoV). The core knowledge is structured and comprehensive; and well-rounded modules cover the methodology and various techniques. A case study is used to help appreciate the relevance of MoV in its practical application. What you will Learn Upon completion of an MoV course candidates should be able to discuss and explain: The main processes and techniques used within MoV and the reasons for using them How MoV may be applied at portfolio, program, project and operational levels The differences in applying MoV at different stages in a project and the expected outputs from a MoV Study at each stage The circumstances under which MoV should be used The concept of value and how value may be improved The main benefits arising from the use of MoV Approaches for implementing MoV How to respond to external and internal influences The principles of embedding MoV into an organization The key topics in document checklists, the toolbox, health check, organizational maturity and individual competence. Upon successful completion of this course, you will be able to: Organize and contribute constructively to a Management of Value (MoV) Study Demonstrate a knowledge of MoV principles, processes, approach and environment Analyse a company, program or project to establish its organizational value; includes identification and weighting of Value Drivers Pass the AXELOS MoV Foundation Examination Introduction to value management and MoV Value and Value Management Capabilities, Outcomes, Benefits and Disbenefits What is Value? What is Management of Value (MoV)? Why use MoV? Where use MoV? When MoV should be used? What using MoV involve? Selected MoV benefits Relationship with other AXELOS Global Best Practices and Models How MoV fits with other AXELOS Global Best Practice Guides MoV principles Align with organization's objectives Focus on functions and required outcomes Balance the variables to maximise value Apply throughout the investment decision Tailor MoV to suit the subject Learn from experience and improve Assign clear roles and responsibilities and build a supportive culture MoV processes Frame the programme or project Gather information Analyse information Process information Evaluate and select Develop Value Improving Proposals Implement and share outputs MoV techniques Function Analysis Function Analysis System Technique (FAST) Traditional (or classic) FAST Technical FAST Customer FAST Value Trees Measuring value Value profiling (a.k.a. value benchmarking) Simple multi-attribute rating technique (a.k.a. SMART) Value index Value metrics Value for money (VfM) ratio Value Engineering / Analysis Common techniques used in MoV Analysis of information Benchmarking Process Mapping Root Cause Analysis Discounted Cash Flow Analysis Generating Ideas Brainstorming Evaluation and option selection Option Selection Matrix Idea selection Allocation to Categories Idea Selection Matrix Weighting techniques Paired Comparisons Points Distribution Developing VIPs Developing Proposals Cost Benefit Analysis Building Decisions Implementing VIPs Implementation Plans Feedback Following up Tracking Benefits Approach to Implementation Generic approach to MoV implementation Plan the MoV activities Understand and articulate value Prioritize value Improve value Quantify value Monitor improvements in value Learn lessons Environmental factors Portfolio Considerations Programme considerations Project considerations Operational Considerations Embedding MoV into an organization Benefits of Embedding MoV into an organization MoV Policy MoV Policy Composition Embedding MoV into an organisation Key steps Suggested MoV Management Structure Overcoming barriers We do it anyway It takes up too much time We can't afford to make the changes What's in it for me? Don't fix it if it ain't broke Fixed returns on investment MoV products Briefing Meeting Agenda (A.1) Communications Checklist (A.2) Equipment list for an Effective Study/Workshop (A.3) Invitation to join the Study Team (A.4) Option Evaluation Matrix (A.5) Plan the Study (A.6) Recording Idea Selection (A.7) Reporting Study outputs (A.8) Scoping the Study (A.9) Study or Workshop Handbook (A.10) Value-Improvement Proposal Forms (A.11) Value Improvement Tracking Report (A.12) MoV toolbox MoV health check and maturity model P3M3 Maturity Model MoV Maturity Model (aligned with P3M3)
RQF level 1 Awareness of First Aid for Mental Health Each year approximately 1 in 4 people in the UK will experience a mental health condition and at least 1 in 6 employees experience common mental health problems in the workplace. Research has shown that work is the biggest cause of stress which can stop people performing at their best. Mental health conditions are often hidden due to stigma and fear of discrimination and research has shown that a culture of fear and silence around mental health is costly to employers. The HSE guidance 'First aid needs assessment’ refers to mental health in the workplace. This 4-hour qualification provides learners with the knowledge to recognise a range of mental health conditions, how to start a supportive conversation and when and how to signpost a person to seek appropriate professional help. Learners will know how to recognise and manage stress. Learners will not diagnose or treat mental health conditions as this can only be carried out by healthcare professionals but will gain the knowledge to identify when a person may have a condition and know where they can go to get help. Suitability - Who should attend? Here are some examples of who may benefit from attending the RQF Level 1 Award in Awareness of First Aid for Mental Health: Employees and workers: This course is relevant for individuals in any industry who may encounter colleagues or clients experiencing mental health difficulties. It can be particularly valuable for human resources personnel, line managers, supervisors, or team leaders responsible for the well-being of employees. Teachers and educators: Professionals working in schools, colleges, or other educational institutions can benefit from this training to better understand and support the mental health needs of students. Healthcare and social care workers: Individuals working in healthcare or social care settings, such as nurses, care assistants, support workers, or counsellors, can enhance their understanding of mental health issues and improve their ability to provide appropriate support. Community and voluntary workers: People involved in community or voluntary organizations, including youth workers, social workers, volunteers, or community leaders, can gain valuable insights into mental health awareness and support. Personal relationships and caregivers: The Level 1 training can also be beneficial for individuals who have personal relationships with someone experiencing mental health challenges. This may include family members, friends, or caregivers who want to enhance their understanding and offer appropriate assistance. It is important to note that the Level 1 Award in Awareness of First Aid for Mental Health RQF is an introductory course and does not qualify participants to provide formal mental health interventions or therapy. However, it serves as a foundation for further training and can contribute to creating a more mentally healthy and supportive environment in various settings. Outcome / Qualification etc. Upon successful completion of the RQF Level 1 Awareness of First Aid for Mental Health course, participants can expect to achieve the following outcomes: Increased Awareness and Understanding: Participants will develop a basic awareness and understanding of mental health and mental health issues. They will gain knowledge about common mental health conditions, their signs and symptoms, and the importance of mental health in overall well-being. Recognition of Mental Health Signs: Participants will learn to recognize common signs of mental health issues in themselves and others. They will gain an understanding of the importance of early identification and intervention in promoting mental health and seeking appropriate support. Reduced Stigma and Improved Attitudes: The course aims to challenge stigmas and stereotypes associated with mental health. Participants will develop a more empathetic and supportive attitude towards individuals experiencing mental health challenges, promoting a positive and inclusive environment. Enhanced Communication Skills: Participants will learn basic communication skills for engaging with individuals experiencing mental health issues. They will gain an understanding of the importance of active listening, empathy, and non-judgmental communication in providing initial support. Signposting and Seeking Help: Participants will be equipped with knowledge about available resources, services, and support networks for mental health. They will learn about signposting individuals to appropriate professional help and self-help resources. Self-Care and Well-being Strategies: The course may provide participants with practical strategies for maintaining their own mental well-being. They may learn basic self-care techniques and stress management strategies to support their own mental health. Certificate of Completion: Upon successful completion of the course, participants will receive a certificate indicating their achievement of the RQF Level 1 Awareness of First Aid for Mental Health qualification. It's important to note that the Level 1 course provides a basic introduction to mental health awareness and first aid. It is not intended to provide participants with the qualifications or skills to diagnose or treat mental health conditions. Instead, it aims to promote mental health literacy, reduce stigma, and provide individuals with the knowledge to offer initial support and signposting to individuals in need. The Level 1 course can serve as a foundation for further learning and progression in the field of mental health. Individuals may choose to pursue higher-level courses or qualifications to develop more advanced skills and knowledge in mental health first aid or other related areas. Training Course Content MODULE 1 INTRODUCTION Session content Trainer/assessor introduction Learner introductions Course information • Administration • Learning outcomes and assessment criteria • Reasonable adjustments • Certification • Complaints and appeals • Assessment information Session duration 15 minutes MODULE 2 WHAT IS FIRST AID FOR MENTAL HEALTH? Session content Definitions Role and responsibilities of a First Aider The impact of mental health issues Mental health stigma Statistics Session duration 25 minutes MODULE 3 IDENTIFYING MENTAL HEALTH CONDITIONS Session content Mental health continuum Mental health risk factors Early warning signs Session duration 25 minutes MODULE 4 PROVIDING ADVICE AND STARTING A CONVERSATION Session content How to start a difficult conversation Non-judgemental listening skills When to contact the emergency services The First Aider’s own health and emotions Session duration 40 minutes MODULE 5 STRESS Session content What is stress? Causes of stress Effects of stress Coping strategies Session duration 25 minutes MODULE 6 MENTAL HEALTH CONDITIONS Session content Depression Anxiety Psychosis Eating disorders Suicide Self-harm Session duration 70 minutes MODULE 7 ASSESSMENT AND COURSE CLOSURE Session content Written assessment paper Course administration Course closure Session duration 40 minute Course delivery details Classroom-Based A minimum of 4 hours spread over at least one day. Ideally, the course should be run in one day, but must be completed within 2 weeks of starting the course, with each training session a minimum of two hours. Online/Virtual classroom The qualification has 2 assigned guided learning hours (GLH) and 5 hours total qualification time (TQT). GLH indicates the number of contact hours that the learner will have with the trainer/assessor. TQT includes GLH but considers unsupervised learning and is an estimate of how long the average learner will take to achieve the qualification. 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 Expenses Travel costs and lunch required, there are many cafes and sandwich bars here in Much Wenlock to buy your lunch, you may eat it in the training room. All training material, books, qualification certificates are included in the price. Continuing Studies After completing the RQF Level 1 Awareness of First Aid for Mental Health course, individuals can consider various progression options to further their knowledge and skills in mental health support. Here are some potential pathways: RQF Level 2 Award in First Aid for Mental Health: This qualification builds upon the knowledge gained in the Level 1 course and provides a more comprehensive understanding of mental health issues and how to provide appropriate support. It covers topics such as recognizing mental health conditions, promoting well-being, and providing initial support to those in crisis. RQF Level 3 Award in Supervising First Aid for Mental Health: For individuals who aspire to take on leadership or supervisory roles in mental health support, the Level 3 qualification is a logical progression. It provides in-depth knowledge and skills to supervise and manage a team of individuals providing first aid for mental health. Continued Professional Development (CPD): Engaging in ongoing CPD activities is essential for staying updated with the latest developments in mental health support. Individuals can attend workshops, seminars, or conferences related to mental health, trauma, or specific areas of interest within the field. Applied Practice: Applying the knowledge gained from the Level 1 course in real-world settings is crucial for developing practical skills. Individuals can seek opportunities to work or volunteer in environments where mental health support is needed, such as community organizations, schools, or helplines. Mental Health Support Training Programs: There are various specialized training programs available that focus on specific aspects of mental health support, such as suicide prevention, trauma-informed care, or supporting individuals with specific mental health conditions. These programs can provide individuals with additional expertise and deepen their understanding of specific areas within mental health support. Higher Education: Individuals who wish to pursue a more in-depth study of mental health can consider higher education programs in psychology, counseling, social work, or related fields. These programs provide comprehensive knowledge and training in mental health support and may lead to professional certifications or degrees. It's important for individuals to research and explore progression options that align with their specific career goals, interests, and local requirements. Different countries or regions may have varying certification or training requirements for mental health support roles, so it's advisable to check with relevant regulatory bodies or professional associations for specific guidance.
This course is designed to enhance your ability to manage critical conversations in the workplace in a way that both inspires growth and engagement and moves people, processes, and the organization forward. We will explore various obstacles to delivering 'challenging' messages effectively, including those that come from the external environment as well as those we encounter internally. After gaining insight into the brain science behind the biology of conflict and emotion, we will then examine a 5-step framework for delivering difficult messages. Paired and small group activities comprise a large portion of this interactive course, which culminates in a role play.
Duration 5 Days 30 CPD hours This course is intended for Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam. This course teaches developers how to create end-to-end solutions in Microsoft Azure. Students will learn how to implement Azure compute solutions, create Azure Functions, implement and manage web apps, develop solutions utilizing Azure storage, implement authentication and authorization, and secure their solutions by using KeyVault and Managed Identities. Students will also learn how to connect to and consume Azure services and third-party services, and include event- and message-based models in their solutions. The course also covers monitoring, troubleshooting, and optimizing Azure solutions. Prerequisites To be successful in this course, learners should have the following: Hands-on experience with Azure IaaS and PaaS solutions, and the Azure Portal. Experience writing in an Azure supported language at the intermediate level. (C#, JavaScript, Python, or Java) Ability to write code to connect and perform operations on, a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar) Experience writing code to handle authentication, authorization, and other security principles at the intermediate level. A general understanding of HTML, the HTTP protocol and REST API interfaces. 1 - Explore Azure App Service Examine Azure App Service Examine Azure App Service plans Deploy to App Service Explore authentication and authorization in App Service Discover App Service networking features 2 - Configure web app settings Configure application settings Configure general settings Configure path mappings Enable diagnostic logging Configure security certificates 3 - Scale apps in Azure App Service Examine autoscale factors Identify autoscale factors Enable autoscale in App Service Explore autoscale best practices 4 - Explore Azure App Service deployment slots Explore staging environments Examine slot swapping Swap deployment slots Route traffic in App Service 5 - Explore Azure Functions Discover Azure Functions Compare Azure Functions hosting options Scale Azure Functions 6 - Develop Azure Functions Explore Azure Functions development Create triggers and bindings Connect functions to Azure services 7 - Explore Azure Blob storage Explore Azure Blob storage Discover Azure Blob storage resource types Explore Azure Storage security features Discover static website hosting in Azure Storage 8 - Manage the Azure Blob storage lifecycle Explore the Azure Blob storage lifecycle Discover Blob storage lifecycle policies Implement Blob storage lifecycle policies Rehydrate blob data from the archive tier 9 - Work with Azure Blob storage Explore Azure Blob storage client library Create a client object Manage container properties and metadata by using .NET Set and retrieve properties and metadata for blob resources by using REST 10 - Explore Azure Cosmos DB Identify key benefits of Azure Cosmos DB Explore the resource hierarchy Explore consistency levels Choose the right consistency level Explore supported APIs Discover request units 11 - Work with Azure Cosmos DB Explore Microsoft .NET SDK v3 for Azure Cosmos DB Create stored procedures Create triggers and user-defined functions Explore change feed in Azure Cosmos DB 12 - Manage container images in Azure Container Registry Discover the Azure Container Registry Explore storage capabilities Build and manage containers with tasks Explore elements of a Dockerfile 13 - Run container images in Azure Container Instances Explore Azure Container Instances Run containerized tasks with restart policies Set environment variables in container instances Mount an Azure file share in Azure Container Instances 14 - Implement Azure Container Apps Explore Azure Container Apps Explore containers in Azure Container Apps Implement authentication and authorization in Azure Container Apps Manage revisions and secrets in Azure Container Apps Explore Dapr integration with Azure Container Apps 15 - Explore the Microsoft identity platform Explore the Microsoft identity platform Explore service principals Discover permissions and consent Discover conditional access 16 - Implement authentication by using the Microsoft Authentication Library Explore the Microsoft Authentication Library Initialize client applications 17 - Implement shared access signatures Discover shared access signatures Choose when to use shared access signatures Explore stored access policies 18 - Explore Microsoft Graph Discover Microsoft Graph Query Microsoft Graph by using REST Query Microsoft Graph by using SDKs Apply best practices to Microsoft Graph 19 - Implement Azure Key Vault Explore Azure Key Vault Discover Azure Key Vault best practices Authenticate to Azure Key Vault 20 - Implement managed identities Explore managed identities Discover the managed identities authentication flow Configure managed identities Acquire an access token 21 - Implement Azure App Configuration Explore the Azure App Configuration service Create paired keys and values Manage application features Secure app configuration data 22 - Explore API Management Discover the API Management service Explore API gateways Explore API Management policies Create advanced policies Secure APIs by using subscriptions Secure APIs by using certificates 23 - Explore Azure Event Grid Explore Azure Event Grid Discover event schemas Explore event delivery durability Control access to events Receive events by using webhooks Filter events 24 - Explore Azure Event Hubs Discover Azure Event Hubs Explore Event Hubs Capture Scale your processing application Control access to events Perform common operations with the Event Hubs client library 25 - Discover Azure message queues Choose a message queue solution Explore Azure Service Bus Discover Service Bus queues, topics, and subscriptions Explore Service Bus message payloads and serialization Explore Azure Queue Storage Create and manage Azure Queue Storage and messages by using .NET 26 - Monitor app performance Explore Application Insights Discover log-based metrics Instrument an app for monitoring Select an availability test Troubleshoot app performance by using Application Map 27 - Develop for Azure Cache for Redis Explore Azure Cache for Redis Configure Azure Cache for Redis Interact with Azure Cache for Redis by using .NET 28 - Develop for storage on CDNs Explore Azure Content Delivery Networks Control cache behavior on Azure Content Delivery Networks Interact with Azure Content Delivery Networks by using .NET
Mastering Critical Conversations: In-House Training We will explore various obstacles to delivering 'challenging' messages effectively, including those that come from the external environment as well as those we encounter internally. After gaining insight into the brain science behind the biology of conflict and emotion, we will then examine a 5-step framework for delivering difficult messages. Paired and small group activities comprise a large portion of this interactive course, which culminates in a role play. What You Will Learn At the end of this program, you will be able to: Recognize how a perceived threat by the brain translates into a physiological response of fight, flight, or freeze Utilize various techniques to mitigate an 'amygdala hijack' state Leverage a 5-step model to deliver 'challenging' news effectively Managing Difficult Conversations Obstacles to managing difficult conversations Understanding human nature Brain Science and the Biology of Emotion The unique challenge of social and emotional learning The limbic system and the amygdala hijack Self-regulation strategy for the amygdala hijack Delivering Challenging Messages Managing difficult conversations 5 steps for delivering a challenging message Verbal active listening techniques Preparing to deliver a challenging message (scenarios) Conversations Involving Emotion and Conflict Two types of conflict Spectrum of responses to conflict Psychological type preferences and conflict Creating an action plan
Project Accounting and Finance Skills: Virtual In-House Training Do you manage both project schedules and budgets, but do not have insight into how actual results relate to the approved budget? Do you desire to have more clarity about the relationship between your project's performance with the accounting and financial systems in your organization? Do you need to understand financial and accounting terminology to bridge the gap between the 'world of finance' and the 'world of project management? Organizations have a need to manage-by-projects, because projects are the means to deliver on strategic goals and objectives. Therefore, the project manager must have an understanding of the financial world of investments to ensure the organization will realize expected business value. This requires a foundation in the principles of accounting and finance to comprehend how the project's contribution provides an organization with a competitive advantage. Learn what you must do to give your organization the assurance it needs that its investment in your project will realize business value. Learn what you must do to give your organization the assurance it needs to know that its investment in your project will realize business value. What You Will Learn At the end of this program, you will be able to: Explain the aspects of classical corporate accounting and finance effects on managing projects Determine how your project fits into the corporate income statement, balance sheet, and cash flow statement Analyze the financial aspects of managing projects Use earned value management as the basis for decision making throughout the project life Recognize the importance of the project manager's financial responsibilities Focus on what PMs do and should be doing, in support of accounting and finance Use financial information within a project environment to meet financial results Track and analyze the project's financial status and forecast with the goal of realizing benefits Generate work performance data to ensure a project's outcome aligns with financial metrics Foundation Concepts Accounting and Finance Terms and Concepts Accounting and Finance Essentials Financial Terms and Concepts Projects as Financial Investments Overview of 'Two Worlds' Project as Investments Accounting and Finance World: Standards, Principles and Practices Accounting and Finance Standards and Principles Accounting and Finance Practices Capital Budgeting Corporate Budgeting Accounting and Finance World: Economic Project Selection Methods Economic Project Selection Methods Economic Project Selection and the Business Case Project Management World Project Management and Financial Controls Project Management and Work Performance Data Project Management and Earned Value Management Project Management and Work Performance Reporting