• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

8381 CLO courses

The NCCH Convention

5.0(22)

By The Northern College Of Clinical Hypnotherapy

The NCCH Convention 2025 – Elevate Your Hypnotherapy Practice! Date: Saturday, November 8th & Sunday, November 9th 📍 Location: Crown Hotel, Harrogate – Bronte Room 🎟 Admission: FREE for Students and Trance Tribe Members Join us for the Northern College of Clinical Hypnotherapy Convention, a dynamic two-day event designed to enhance your skills, expand your network, and inspire your practice. Featuring expert-led workshops, hands-on learning, and guest speakers, this is the perfect opportunity to deepen your knowledge and connect with like-minded professionals. 🔹 Convention Highlights ✅ Live demonstrations of hypnotic inductions, deepening techniques, and ideomotor signaling ✅ Practical workshops on Parts Therapy, Compassionate Inquiry, and experiential learning ✅ Guest speakers covering hypnotherapy business strategies and audio production for hypnotherapists ✅ Hands-on training to refine your techniques and boost client engagement ✅ Networking opportunities with fellow hypnotherapists, trainers, and industry experts Note: All sessions include refreshments. Attendees are encouraged to bring business cards for networking opportunities. The Northern College of Clinical Hypnotherapy Convention Schedule. Saturday, November 8th 10:00 AM - 10:30 AM Registration & Welcome Check-in and networking with fellow attendees. Refreshments available. 10:30 AM - 11:30 AM Session 1: Hypnotic Inductions Explore various hypnotic induction and rapid induction techniques to enhance client engagement. 11:30 AM - 12:30 PM Session 2: Deepening Techniques Learn effective methods to deepen the hypnotic state for optimal results. 12:30 PM - 1:30 PM Lunch Break Enjoy refreshments and network with other practitioners. 1:30 PM - 2:30 PM Session 3: Ideo-Motor Signaling and EAM demo with Nicola Barragry. Discover the art of ideomotor signalling for subconscious communication. 2:30 PM - 3:30 PM Guest Speaker: Zoe from Build It Brilliant Topic: Hypno Business Strategy Masterclass Gain insights on building a successful hypnotherapy practice. 3:30 PM - 4:00 PM Q&A Session with Zoe Open floor for questions and discussion with the guest speaker. The Northern College of Clinical Hypnotherapy Convention Schedule Sunday, November 9th 10:00 AM - 10:30 AM Welcome Back & Refreshments Gather for the second day of learning and networking. 10:30 AM - 11:30 AM Session 1: Advanced Techniques - Compasionate enquiry & Parts Therapy Delve into parts therapy and its application in hypnotherapy. 11:30 AM - 12:30 PM Session 2: Practical Application of Compassionate Inquiry and Parts Therapy Hands-on practice in small groups to implement techniques learned. 12:30 PM - 1:30 PM Lunch Break Refreshments provided; continue networking. 1:30 PM - 2:30 PM Session 3: Experiential Learning Engage in experiential exercises to deepen understanding of advanced techniques. 2:30 PM - 3:30 PM Guest Speaker: Unlock your audio potential with a special session featuring hypnotherapist trainer and audio expert Louise Frank! Learn the basics of Audacity, from setup and interface navigation to capturing high-quality audio and editing techniques, take your audio skills to the next level with 3:30 PM - 4:00 PM Closing Remarks & Networking Opportunity Wrap up the convention with final thoughts and a chance to connect with peers.

The NCCH Convention
Delivered In-Person in Harrogate
£200

Cloud Computing / CompTIA Cloud+ (CV0-002)

By Course Cloud

Course Overview Gain an acute awareness of the fundamental concepts of cloud services and how customers use cloud operations with this training for Cloud Computing / CompTIA Cloud+ (CV0-002). CompTIA Cloud+ training focuses on managing cloud technologies for system operations. With this expert industry-standard tuition, you will be able to explore solutions for meeting specific business needs and resolve security or networking issues for them. This CompTIA Cloud+ tutorial concentrates on the technical processes that will complement and support desired levels of system performance. Over ten modules of professional teaching, you will learn about cloud storage, deployment, migration, networking, and security. You will also be given valuable tips for preparation when taking the CompTIA Cloud+ Certification Exam. Enrol now to gain the skills and knowledge you'll need to make an impact in cloud computing and make yourself stand out in the IT employment sector. This best selling Cloud Computing / CompTIA Cloud+ (CV0-002) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Cloud Computing / CompTIA Cloud+ (CV0-002) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Cloud Computing / CompTIA Cloud+ (CV0-002) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Cloud Computing / CompTIA Cloud+ (CV0-002) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Cloud Computing / CompTIA Cloud+ (CV0-002), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Cloud Computing / CompTIA Cloud+ (CV0-002) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Cloud Computing / CompTIA Cloud+ (CV0-002) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Cloud Computing / CompTIA Cloud+ (CV0-002)
Delivered Online On Demand
£319

Microsoft Project Introduction - In-company

By Microsoft Office Training

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. 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? 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 Requirements General knowledge of the Windows OS Career path 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 Certificates Certificates Certificate of completion Digital certificate - Included

Microsoft Project Introduction - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Microsoft Power BI Desktop (live online classes)

By Microsoft Office Training

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in 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. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualizations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Microsoft Power BI Desktop (live online classes)
Delivered OnlineFlexible Dates
£750

Microsoft Power BI Desktop (now with live online classes)

By Microsoft Office Training

This course will allow you to explore the potential of self-service business intelligence using Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, to create Visualizations, and publish Reports to different platforms . Course Objectives At the end of this course you will be able to: Connect to data from different sources. Use the Query Editor Perform Power BI desktop data Shaping and Transformation. Create Power BI desktop Modelling. Create Power BI desktop Visualizations and Reports. ' 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 and Business Intelligence. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke course Tailored training courses: in 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. 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. Introduction to Power BI Power BI Jargon explained A quick look at Power BI Desktop A quick look at the Power BI service Helpful resources Power BI and Excel Introduction to using Excel data in Power BI Upload Excel data to Power BI Import Power View and Power Pivot to Power BI Getting started with Power BI Desktop Overview of Power BI Desktop Accessing Help and Helpful resources Connect to data sources in Power BI Desktop Shaping and Transforming Data with Query Editor Introduction to the Query Editor Data Sources Power BI Desktop can Connect to Introduction to Steps and M code Combining Data Using Merge and Append Queries Data Type Properties Working with Delimiters Clean and transform your data with the Query Editor Text Specific Transformation Tools Number Specific Transformation Tools Date Specific Transformation Tools Split and Merge columns Creating an Index Column Adding Conditional Columns Columns From Examples Grouping and Aggregating data Pivoting and Unpivoting Using filters Modeling the data Introduction to modeling your data How to manage your data relationships Create calculated columns Optimizing data models Create calculated measures Show Values As and Quick Measures Create calculated tables Explore your time-based data Introduction to DAX DAX calculation types DAX functions Visualizations Introduction to visuals in Power BI Create and customize simple visualizations Modify colors in charts and visuals Shapes, text boxes, and images Page layout and formatting Group interactions among visualizations Visual hierarchies and drill-down Using custom visualizations Create a KPI Visualization Geo-Data and Maps Reports, Publishing and Sharing Introduction to the Power BI service Quick insights in Power BI Create and configure a dashboard Ask questions of your data with natural language Create custom Q&A suggestions Share dashboards with your organization Introduction to content packs, security, and groups Publish Power BI Desktop reports Print and export dashboards and reports Create groups in Power BI Use content packs Update content packs Publish to web Who is this course for? Who is this course for? This course facilitates you with knowledge on the potential for Power BI Desktop to analyse and connect to different sources of data, creating Relationships between those different datasets, Query the data using Shaping and data Modelling, and to create Visualisations, and publish Reports to different platforms. Requirements Requirements Before attending this course, delegates should have: - A general knowledge of database concepts (fields, records and relationships) - Familiarity with Excel. Career path Career path Business Intelligence Data Analysis ETL & Data Warehousing

Microsoft Power BI Desktop (now with live online classes)
Delivered In-Person in LondonFlexible Dates
£750

Sauerkraut & Kimchi Workshop

5.0(2)

By The Crafty Pickle Co.

Discover how to make your very own sauerkraut and kimchi, giving you the confidence and knowledge you need to explore the world of fermentation!

Sauerkraut & Kimchi Workshop
Delivered In-Person in Caldicot + more
£70

Microsoft Azure Expert Certification Bundle (with 3 Exams)

By Hudson

The Microsoft Certified Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned.

Microsoft Azure Expert Certification Bundle (with 3 Exams)
Delivered Online On Demand
£1,195

Level 4 Award Internal Verifier, IV, IQA - Job Ready Program with Money Back Guarantee

4.7(47)

By Academy for Health and Fitness

***Note: Offer is Valid for the First 10 Learners Only*** In the modern world, education and training standards are constantly evolving. This Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) course is a vital tool for professionals who want to succeed in the Quality Assurance field. Recognised by Ofqual and the British Government, this course isn't just another academic credential. It's your gateway to meeting and exceeding the national standards in education and training. Learn from the Best, Be the Best Under the guidance of industry experts, you'll embark on a learning journey that is both enriching and practical. Our instructors bring a wealth of experience and are dedicated to nurturing your potential. Moreover, with our course being recognised by Ofqual and the British Government, your qualification will be respected across the UK and widely acknowledged by employers and educational institutions globally. So enrol today and be one step closer to success. The course is recognised by Ofqual and the British Government as a regulated qualification that meets the national standards for education and training. Upon completing this course, you can pursue different roles such as an Internal Verifier, Quality Assurance Coordinator, or Training Manager within educational institutions, corporate training departments, or vocational training organisations. This qualification is especially beneficial for those looking to step into leadership roles in education and training. You will be able to oversee and improve the quality of teaching and assessment practices. Why this Job Ready Program is a Perfect Package for You! So, what sets us apart from other programs? Let's dive into the exceptional benefits you'll experience when you join our {Course_Title}: Personalised Guidance: Our experienced mentors will provide one-on-one counselling sessions tailored to your specific needs. Whether you're a beginner or have some experience, we will guide you towards honing your skills and developing a strong foundation in Business Analysis. One-On-One Consultation Sessions with Experts: Gain invaluable insights and guidance from seasoned professionals. Our consultation sessions provide you with insider tips, tricks, and advice, empowering you to navigate the industry with confidence and expertise. Extensive Job Opportunities: We have established partnerships with numerous companies actively seeking professionals. Through our network, we'll connect you with exclusive job openings that are not easily accessible elsewhere. Our aim is to maximise your employment prospects and provide you with a range of exciting opportunities to choose from. Interview Preparation: We provide you with access to a comprehensive database of potential interview questions curated over years of industry experience. Walk into your interviews confident, well-prepared, and ready to impress. Get Unlimited Access to Entire Library: Enjoy unlimited access to our entire course library for a year. Seize this golden opportunity to advance your skills and achieve new heights! Money-Back Guarantee: Your satisfaction is our top priority. We are confident in the quality of our training and support, which is why we offer a 100% money-back guarantee. Your journey doesn't stop there. The skills and knowledge you acquire will be instrumental in pursuing higher-level positions such as Head of Department, Director of Studies, or even a Consultant in Educational Quality Assurance. You can also pursue higher education and get better qualifications. So why wait? Enrol today and take the first step towards becoming a qualified assessor. With the Focus Awards Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF), you'll have a more fulfilling and rewarding career in education and training. The package includes the following: Qualification Specification Support Materials 24/7 access to the Course Library Assessment Guidance Tutor Support and Consultation On-Demand Customer Service Assignment, Observation, and Report Templates. **Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF)** Unit 1: Understanding The Principles And Practices Of Internally Assuring The Quality Of Assessment Unit 2: Internally Assure The Quality Of Assessment Course Duration Guided Learning Hours These hours are made up of all contact time, guidance or supervision of a learner by a lecturer, supervisor, tutor, trainer or another appropriate provider of education or training. Guided Learning Hours for this qualification is 90. Total Qualification Time This is an estimate of the total length of time it is expected that a learner will typically take to achieve and demonstrate the level of attainment necessary for the award of the qualification i.e. to achieve all learning outcomes. Total Qualification Time is GLH and an estimate of the number of hours a learner is likely to spend in preparation, study or any other learning including assessment, which takes place as directed by, but not under the supervision of a lecturer, supervisor or tutor. The credit value, where given, for a qualification is determined by TQT, as one credit corresponds to 10 hours of learning. Total Qualification Time for this qualification is 120 hours. Method of Assessment Assessment activities consist of a few short assignments that you have to complete to show evidence of general reading while adding references to your work. All assignments should be submitted via the online portal. Video Assessment You have to plan many things, such as observation, questioning/ professional discussion, and inspection of supporting work product evidence. Detailed assignment instructions will be made available to you in the 'Guidance for Achieving the Unit' section of your learning portal with a careful and clear explanation. You have to submit all your assignments via the online portal Certification Successful candidates will be awarded a Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (RQF) from Focus Awards Limited. Progression Level 4 Award in Externally Assuring the Quality of Assessment Processes and Practice Level 4 Diploma in Learning and Development. Who is this course for? The Focus Awards Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF)course is perfect for: Education and training professionals looking to improve their skills and career prospects Individuals responsible for the quality assurance of assessment processes and practices within their organisation Those seeking a regulated qualification recognised by Ofqual and the British Government Anyone looking to make a real difference to the future of education and training in the UK. Anyone looking to give their career a boost Requirements There are no specific entry requirements for this qualification. This qualification is accredited for learners who are at least 16 years old or above. Career path After receiving the Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practices (RQF) certification, you would be eligible to function as a competent professional as: Professional EQA Professional IQA Practitioner Internal quality assurer Market developer Marketing Executive Quality monitoring officer Certificates Hard copy certificate Hard copy certificate - Included

Level 4 Award Internal Verifier, IV, IQA - Job Ready Program with Money Back Guarantee
Delivered Online On Demand4 days
£999

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

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

Microsoft Excel Macros & VBA - In-company
Delivered in London or UK Wide or OnlineFlexible Dates
£750

Microsoft Azure Bundle with 3 Exams (3 Certifications)

By Hudson

The Microsoft Certified Fundamentals, Associate, and Expert is a new breed of Microsoft certification. It is referred to as a ‘role-based certification’. According to Microsoft, role-based certifications show that individuals that possess them are keeping pace with today’s technical roles and requirements. They allow a learner to skill up and prove their expertise to employers and peers, plus get the recognition and opportunities they’ve earned.

Microsoft Azure Bundle with 3 Exams (3 Certifications)
Delivered Online On Demand
£1,195