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 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. 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. Certificates Certificates Certificate of completion Digital certificate - Included
This is suitable for anyone managing teams or looking to manage teams in the future. Using the participants own experiences we will look at what drives team effectiveness and the traits of High Performing Teams.
Well-being isn't just a 'nice to have' - it should be a core part of your employee strategy.
Price £750 inc VAT Finance options In Company training - £750 for groups of up to 8 delegates. Discounts for Nonprofits/Charities... Study method On-site Duration 2 days, Full-time Qualification No formal qualification Certificates Certificate of completion - Free Additional info Tutor is available to students Course Objectives At the end of this course you will be able to: Identify the components of the Microsoft Project environment Create a new project plan Create the project schedule Use different views to analyse the project plan Create, allocate and manage resources in a project plan Finalise a project plan Track progress View and report project plan information ' 1 year email support service Customer Feedback Very good course. Learnt a lot. Looking forward to the next level. Alexandra - CIAL 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. Description Introduction to Microsoft Project Recap on project management concepts Project environment overview The 3 databases: Tasks, Resources and Assignments Different ways of displaying the Project Plan Access Help Creating a Project Plan Create a New Project Plan Project Information Create and apply the project calendar Defining recurring exceptions to the calendar Defining the calendar's work weeks Create the Summary tasks Create the Work Breakdown Structure Task creation and scheduling Exploring the Entry Table and its fields Task editing and the Task Information window Task Durations Defining Milestones Manual Scheduling vs Automatic Scheduling Changing the Task's Calendar Create a split in a Task Create Task Relationships Adding Lag or Lead to a Relationship Identifying the Critical Path Adding Constraints and Deadlines to Tasks Create Recurring Activities Adding Notes and links to Tasks Managing Resources Exploring the Entry Table and its fields Resource editing and the Resource Information window Resource Types Fixed Costs vs Variable Costs Adding Resource Costs Defining when costs accrue Changing the Resource Calendar and Availability Project calendar vs Resource and Task Calendar Assigning Resources to Tasks Effort Driven Scheduling Resolving Resource Overallocation Tracking the Project Progress Setting a Project Baseline Entering Actuals Different ways of viewing the Progress Checking if the Project is on track Viewing and Reporting Project Detail Adding Tasks to the Timeline and sharing it Modifying the Timescale and Zoom level Formatting the Gantt View Filtering and Grouping Tasks Print and Troubleshoot the Gantt View Using built-in Reports in Microsoft Project Who is this course for? This course is designed for a person who has an understanding of project management concepts, who is responsible for creating and modifying project plans, and who needs a tool to manage these project plans. Requirements General knowledge of the Windows OS Career path Microsoft Office 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
A four-hour workshop for HR Professionals in the area of Attraction, Selection and Recruitment of Neurodiverse people.
A four-hour workshop on how to accelerate the learning and development of your Neurodiverse colleagues.
Introducing the Therapeutic Intervention Package: Guided Support for Positive Change and Emotional Healing Are you seeking professional guidance to overcome challenges, manage stress, and foster emotional well-being? Miss Date Doctor’s Therapeutic Intervention Package offers you a personalized and structured approach to address your concerns, providing you with expert insights and tools to facilitate positive change and emotional healing. Life can present us with various obstacles that impact our mental and emotional health. Our experienced therapists are dedicated to helping you navigate through these challenges, empowering you to make informed decisions and cultivate a healthier and more fulfilling life. Here’s how the Therapeutic Intervention Package can support you: Personalized Assessment: Our therapists will conduct a comprehensive assessment to understand your specific needs, goals, and areas of concern. Tailored Treatment Plan: We’ll work together to create a personalized treatment plan that addresses your unique challenges and supports your well-being. Evidence-Based Techniques: Therapeutic interventions will be rooted in evidence-based techniques to promote emotional healing and positive change. Skill Building: Our therapists will equip you with practical skills and coping strategies to navigate challenges and manage stress. Emotional Regulation: We’ll focus on helping you develop healthy emotional regulation techniques to manage intense feelings. Goal Achievement: Together with your therapist, you’ll set achievable goals and track your progress as you work towards positive change. Supportive Environment: The Therapeutic Intervention Package offers a safe and non-judgmental space for you to explore your thoughts and feelings. Empowerment and Growth: Our therapists are committed to empowering you to overcome obstacles, build resilience, and experience personal growth. The Therapeutic Intervention Package at Miss Date Doctor is designed to provide you with expert support and guidance on your journey to improved emotional well-being. Our experienced therapists offer insights, tools, and a compassionate space to help you navigate challenges and foster positive change. Invest in your mental and emotional health and take the first step towards positive transformation with the Therapeutic Intervention Package. Embrace the opportunity to gain insights, develop skills, and create lasting positive change in your life. Let our skilled therapists guide you towards a brighter and more empowered future. 3 sessions x1 hour https://relationshipsmdd.com/product/therapeutic-intervention-package/
Mental Health "First Aid" Training
Our 8 hour course will enable students to attain the knowledge and practical competencies needed to deal with a range of emergency first aid situations and/or take on the role of emergency first aider in the workplace. At Immerse Training we specialise in bespoke on-site courses, delivered at your premises, based on your industry. Qualification Information This qualification and learning outcomes are based on the recommendations of: The Resuscitation Council (UK) Skills for Health Assessment Principles for First Aid Qualifications Course Content Following this course students will: Understand the role and responsibilities of a first aider. Be able to assess an incident. Be able to manage an unresponsive casualty who is breathing normally. Be able to manage an unresponsive casualty who is not breathing normally. Be able to recognise and assist a casualty who is choking. Be able to manage a casualty with external bleeding. Be able to manage a casualty who is in shock. Be able to manage a casualty with a minor injury. Who should attend? This qualification is for people who deal with first aid at work enabling them to be workplace emergency first aiders under the Health and Safety (First Aid) Regulations 1981. This qualification is also for people who have a specific responsibility at work, or in voluntary and community activities, to provide basic first aid to people in a range of emergency first aid situations. Pre-requisites Students must be at least 14 years old on the first day of training. Assessment and Certifications Assessment of this course is continuous and also includes 1 theory/multiple choice question paper. Successful students will receive an Immerse Training Certificate, which is valid for three years. This certificate will be issued by Qualsafe, the awarding body for Immerse Training. Additional Information Completion of the Level 3 Award in Emergency First Aid at Work includes 1 credit at Level 3 of the Regulated Qualifications Framework (RQF). Workplace First Aid Courses First Aid courses for employers and employees. Our workplace courses are fully accredited, registered and meet Health and Safety Executive (HSE) guidelines. From 1 day Emergency First Aid at Work (previously appointed person) to 3 day First Aid at Work courses. We specialise in on-site courses at your workplace, tailored to the specific risks associated with your business. All courses can be delivered at our training centre in Poole, Dorset or we can deliver on-site across Bournemouth, Poole, Dorset, Hampshire and the South of England.