44945 Care courses

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

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

Revit Architecture Training is for 15 hours £525, and the Revit classes are one-to-one which will improve your learning. Revit Architecture course is 100% practical and hands-on training.

Course Description: Elevate your teaching career with our Level 4 Certificate in Education and Training (CET) course. Designed for both pre-service and in-service educators, this qualification equips you with essential skills and knowledge to excel in teaching roles across various disciplines and settings. Course Overview: Gain a comprehensive understanding of teaching roles, responsibilities, relationships, legislation, equality, diversity, and inclusivity in education. Learn to conduct initial assessments, plan inclusive lessons, deliver effective teaching, assess learning outcomes, and utilize appropriate resources. Course Structure: Total Credits: 36 Guided Learning Hours: 140 – 204 Method of Study: Online or Live Zoom Classroom Level: 4 CET Course Outline: Understanding roles, responsibilities & relationships in education & training Planning to meet the needs of learners in education & training Delivering education and training Assessing learners in education & training Using resources for education & training Inclusive practice Entry Requirements: Candidates must have completed Level 3 Award in Education & Training or Former PTLLS Course (C&G 6302 or 6502) and possess good verbal communication skills. Career Progression: Upon completion, candidates can progress to Level 5 Diploma in Education and Training, Level 3 Assessment and Quality Assurance (TAQA), or Level 4 Internal Quality Assurance (IQA). Assessment: No formal examination for Level 4 CET. Assessment involves the submission of a portfolio and other required documents. Course Fee: Choose between Distance learning (£539.99) or a classroom-based course (£619.99). All fees are inclusive with no hidden charges. How to Book: Secure your spot online via various payment methods or contact our dedicated team for assistance. Receive instant booking confirmation via email. Corporate or Group Booking: Enjoy special discounts for corporate or group bookings. Our trainers can conduct training sessions at your preferred location. Assistance: For any inquiries or assistance, contact our team via phone or email. We're here to support you throughout your learning journey.

Turn hobbies into hireable skills with this creative, wellness-focused 20-course bundle. Ideal for those pursuing freelance opportunities, content creation, or personal development careers, this bundle covers everything from photography and gardening to body wellness and copywriting. Don’t let your passions sit idle — turn them into professional possibilities. Description The creative economy is booming, and employers are increasingly valuing candidates with soft skills, self-discipline, and creative agility. This Recreational bundle blends artistic flair, digital communication, and personal wellbeing into one well-rounded package for those eager to build careers that reflect who they are. Whether you're exploring opportunities in social media, writing, wellness, or pet care — or simply want to package your personal skills in a way employers and clients take seriously — this bundle is your gateway. It supports you in making the shift from hobbyist to hireable, from side-interest to side-income. The best part? You don’t need to wait for enrolment windows or expensive tuition. It’s all available now. Just one bundle — 20 powerful paths. FAQ Q: Who should take this bundle? A: Ideal for creatives, aspiring freelancers, lifestyle bloggers, writers, and personal development seekers. Q: Is this just for fun or can I build a career from it? A: Both. Many people turn these exact skillsets into freelance work, side gigs, or self-employment. Q: Will this help me stand out to employers? A: Yes — especially in fields that value communication, creativity, and soft skills. Q: Can I use this to develop my personal brand? A: Absolutely. From YouTube to digital writing and photography — it's designed for that. Q: Is this a good investment? A: You're getting 20 niche skillsets for less than one short course — so yes, the value is unmatched.

The Revit MEP course (£525), offers you individual learning (One to One) to improve your skills in Revit, and this course extends to 15 hours.

The Revit Structure Training is for 15 hours, £525, and it will cover from Introduction to Intermediate in small classes with only 1 people per class.

Conflict in the workplace is inevitable—how you handle it determines your leadership potential. This 20-in-1 Conflict Resolution Training bundle is your secret weapon for building a career in HR, leadership, healthcare, or mental wellness sectors, where soft skills are a hard requirement. If you want to become the go-to person for calm under pressure, this bundle sets you apart. Description Mastering conflict resolution isn’t just for managers—it's a core competency in nearly every profession. From navigating tough conversations to promoting workplace wellbeing, this collection empowers you with the tools employers actively seek in team leads, HR assistants, care workers, and educators. Don’t miss the chance to level up with in-demand skills that rarely get taught, but frequently get rewarded. For anyone who wants to lead with empathy, manage with confidence, or support others in high-stakes environments, this bundle delivers exceptional career value—without the premium price tag. FAQ Who should take this bundle? HR professionals, team leaders, support workers, educators, mental health workers, and anyone in people-facing roles. How does this help me get hired? Employers are actively searching for candidates with emotional intelligence, communication mastery, and leadership potential—this bundle ticks all the boxes. Is there any certification included? Yes. Each course comes with a completion certificate, giving your CV and professional profile a credibility boost. Which industries find this most relevant? HR, healthcare, education, social work, non-profits, and management consulting, to name a few. Can I learn in my spare time? Yes! All courses are self-paced and come with lifetime access. What makes this bundle worth it now? These skills are evergreen—but opportunities to master them in one place, at this price, are limited. Don’t miss the window.

Managing tension is no longer optional—it’s a critical workplace skill. The Art of Conflict Management equips you with the emotional intelligence, leadership polish, and communication finesse employers value most in team leaders, HR assistants, healthcare professionals, and client-facing roles. Whether you're aiming for a promotion or pivoting to people-centred careers, this 20-in-1 course bundle offers the soft-power toolkit to make you more hirable—and more valuable—instantly. Description The most successful professionals aren’t just technically capable—they know how to de-escalate, motivate, and communicate when stakes are high. This bundle is tailored for those who want to lead calmly, communicate clearly, and support others with empathy. From HR departments and mental health roles to education and support services, your ability to manage conflict professionally can be the difference between a good hire and a great one. Why wait? Secure your place before this offer rotates or pricing changes. With 20 professionally recognised certifications under one roof, this bundle is a smart career investment—at a fraction of the cost of piecemeal training. FAQ Who should enrol in this bundle? HR professionals, aspiring team leaders, support staff, care providers, and anyone in people-centric roles. How does this help with job applications? It demonstrates emotional intelligence and communication mastery—qualities highly sought after in modern workplaces. Which industries find this most relevant? Healthcare, education, human resources, public service, NGOs, and corporate team environments. Are certificates provided? Yes. Each course includes a certificate to boost your CV and digital profile. Do I need any prior experience? No. The bundle is designed for both beginners and professionals looking to sharpen their skillset. Why buy now? You’ll gain 20 targeted certifications at a fraction of what they’d cost individually—and hiring season won’t wait.

Procurement isn’t just about buying—it’s about managing resources, budgets, and timelines across departments. The Procurement Administrator 20-in-1 bundle prepares you for the cross-functional, detail-oriented roles that businesses rely on every day. This is your moment to stand out in a field that rewards smart, structured professionals. 🔍 Description Procurement administrators play a vital part in making sure operations run efficiently—and employers are actively looking for candidates who can balance finance, compliance, logistics, and supplier communication. This bundle covers all those key areas and more. Whether you’re aiming for roles in construction firms, government agencies, or corporate offices, this training suite boosts your profile with a well-rounded, job-focused skill set. It’s also ideal for those moving into procurement from admin, finance, or operations roles. Packed with 20 job-relevant topics and certifications, this bundle offers serious value for those serious about career mobility. Hiring cycles move quickly—start building your advantage now. ❓ FAQ Q: What careers does this bundle support? A: Procurement Administrator, Contract Admin, Supply Chain Coordinator, Operations Assistant, or Purchasing Manager Trainee. Q: Will it help me stand out to hiring managers? A: Yes—each course gives you a certificate and a demonstrable skill employers care about. Q: Does this bundle cover safety and compliance topics? A: It includes several subjects that support compliance-heavy roles, especially in construction and logistics. Q: How do I access the courses? A: You’ll get instant access online, with lifetime availability to complete them at your pace. Q: Is this better than taking a one-topic course? A: Absolutely. You’re getting 20 targeted areas for the price of one—broadening your job prospects significantly.