1489 Courses delivered Live Online

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

AI Short Video Creation | Turn Long Videos into Engaging Shorts

Spring Clean Your Qi – 2024 Eight Week Online Qigong Course For Spring Feel healthy vibrant and get your zing back for spring When: Tuesday Evenings 6-7.15pm and Thursday mornings 8-8.30am (via Zoom) All classes are recorded so you can catch up in your own time. Dates: Tuesdays 6-7.15pm: March 5th, 12th, 19th, and 26th and April 9th, 16th, 23rd and 30th Thursdays 8-8.30am: March 7th, 14th, 21st, 28th and April 11th, 25th and May 2nd Suitable for everyone no matter your experience Spring can be a tricky time for us, as our bodies are moving from the most still Yin restful time of the year to a very Yang active energy of new growth. It’s a massive about-turn for our whole energy system and it can be bumpy!  In Chinese medicine the liver is responsible for the smooth flow of Qi or energy in our body, and in the spring this liver Qi is being challenged, as we come out of the winter stillness it can take a while for us to feel lively and able to take on the new challenges. If our Liver Qi is struggling it can leave us feeling grumpy, irritated and restless, with headaches and brain fog, we may have sore, dry or itchy eyes and tired stiff achey joints. During this course we will use Qigong exercises, meditations, sounds and breath practices, to help bring us into our healthy balance, giving our liver the support it needs so we can move from Winter to Spring, feeling healthy and vibrant and ready to take on the new.  Together we will learn “The Eight Brocades” a simple and easy to practice Qigong form you can use every day to improve your energy and feel great. “The Eight Brocades” is one of the most popular Qigong practices dating back nearly 1000 years in China. it is made up of eight Qigong movements, each opening different meridian or energy pathways in the body, to release fatigue and harness our healthy Qi. Benefits include improved energy, vitality, bone density, strength, flexibility, balance, coordination, and longevity to name a few. Also, a great practice for reducing blood pressure, cancer support, thyroid issues, back pain, arthritis, and more. What is included:  Eight live 75min evening zoom classes Eight live 30min morning WAKE UP YOUR QI classes on zoom Access to replays of all classes so you can catch up in your own time. Learn “The Eight Brocades” A simple and powerful Qigong form to help you feel amazing Weekly supporting material for home practice including: – 10min video Guided Qigong Practice – Learn how to clear meridian pathways in the body for greater balance – Key acupuncture points for self massage – Weekly nutrition tips for a healthy spring body cleanse What will i get out of this course? Reconnect with your body Clear your mind A healthy detox for your organs Increased flexibility for all your joints Improved circulation Healthy hormonal balance Clear vision – bright eyes Better sleep Reduced pain Improved mood More energy Less stress

This course is aimed at those who would like to work as a learning support assistant in a school or further education setting. Level 3 Certificate in Supporting Teaching and Learning will give you an understanding of the skills and knowledge needed to support learners in the classroom.

What is dance psycholgy? Why does it matter? And what you as a dancer, dance teacher should defintely know about it to better improve mental well-being? All these questions will be answered in this workshop who will introduce you to dance psychology and its key aspects. The workshop will be recorded for those who cannot attend.

Online courses in the shadow yoga preludes with recognised shadow yoga teacher

Duration 4 Days 24 CPD hours This course is intended for This course is Intended for students with HTML Experience. Overview At the completion of the course, you will be able to: How PHP works. The basic syntax of PHP. Create dynamic interactive pages with PHP. Manipulate files with PHP. Work with arrays in PHP. Validate forms with PHP. Write functions in PHP. Manipulate and manage database data with PHP. Authenticate users with PHP. Manage sessions with PHP. Work with the MDB2 package. Learn advanced form validation with regular expressions. Send email with PHP. In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. PHP Basics How PHP Works The php.ini File Basic PHP Syntax Variables First PHP Script PHP Operators Creating Dynamic Pages Passing Variables via the Query String Flow Control Conditional Processing Working with Conditions Loops Working with Loops Arrays Enumerated Arrays Working with Enumerated Arrays Associative Arrays Working with Associative Arrays Two-dimensional Arrays Array Manipulation Functions PHP and HTML Forms HTML Forms Processing Form Input String Manipulation Formatting Strings Working with String Manipulation Functions Magic Quotes Reusing Code and Writing Functions Including Files Adding a Header and Footer User Functions Form Processing Form Validation and Presentation Functions Managing Data Querying a Database Inserting Records Authentication with PHP and SQL A Database-less Login Form Authenticating Users Regular Expressions Perl-compatible Regular Expression Functions Regular Expression Syntax Form Validation Functions with Regular Expressions Session Control and Cookies Sessions Cookies Authentication with Session Control Sending Email with PHP mail() PHPMailer Sending a Password by Email File System Management Opening a File Reading from a File Writing to a File Writing to a File File Locking Uploading Files via an HTML Form Getting File Information More File Functions Directory Functions Creating a Resume Management Page

Why Choose Rhinoceros 3D Night Training Course? Learning Rhino 3D opens doors to advanced 3D modeling, making it essential for architects, designers, and engineers. Its versatility, ease of use, and powerful features make it an industry favorite for creating intricate designs, from architecture to product design. Click here for more info: Website Personalized Learning: 1-on-1 sessions tailored to your needs Flexible Timing: Convenient evening classes (5 pm - 7 pm) Mon to Sat Duration: 10 hours. Choose your own day and time Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Upon completing this course, you will: Master Rhino's Interface: Gain proficiency in Rhino's commands, toolbars, and menus, enabling efficient 3D modeling. Create Complex 3D Models: Develop the skills to create intricate 3D objects using curves, surfaces, and solids with various techniques like lofts, sweeps, and revolves. Refine Modeling Techniques: Learn advanced editing methods, such as filleting, chamfering, and curve Booleans, to refine and modify objects. Navigate the 3D Space: Understand 3D navigation, viewports, and construction planes, enabling precise modeling in a virtual space. Prepare Models for Production: Master techniques for analyzing and preparing 3D models for manufacturing, prototyping, and 3D printing. Enhance Rendering and Visualization: Learn rendering techniques to create realistic visuals of your models for presentations and proofs. Job Opportunities: After completing this course, you can pursue a variety of careers, including: 3D Modeler: Create detailed 3D models for industries like gaming, animation, or virtual reality. Product Designer: Design and visualize products for manufacturing using 3D modeling software. Architectural Visualization Specialist: Develop detailed architectural models for presentations and client approvals. Industrial Designer: Design consumer products, furniture, or appliances for manufacturing companies. Jewelry Designer: Craft intricate jewelry designs with precise detailing using 3D modeling techniques. Prototyping Specialist: Work in industries like aerospace or automotive, creating prototypes for testing and development. Freelance 3D Artist: Offer your skills on platforms like Upwork or Fiverr, creating custom 3D models for clients worldwide. Rhino 3D Training Overview Our Rhino 3D Training offers in-person or live sessions suitable for beginners and those aiming to optimize their workflow in Rhinoceros 3D. Course Highlights: Master precise free-form 3D NURBS modeling. Explore advanced surfacing commands and the Rhino interface. Develop skills in curve, surface, and solid modeling. Learn effective modeling practices for various industries, from industrial design to jewelry and graphic design. Who Should Attend? This course is perfect for individuals starting their Rhino journey or aiming to refine their modeling skills. If jewelry modeling is your focus, check out our specialized Rhino Training for Jewelry Design Course. Why Choose Us? Hands-on, instructor-led sessions with flexible scheduling (weekdays, evenings, or weekends from 9 am to 7 pm). Expert instruction from Rhino professionals. Real-time practice with industry-aligned projects. Comprehensive electronic notes and course completion certificate. Ongoing support and career advice from experienced trainers. Benefits of Rhino Training Ideal for enthusiasts in animation, modeling, NURBS curves, surfaces, or solids, Rhino Training empowers you with industry-standard skills. No prerequisites are required, ensuring accessibility for all learners. Advantages: Personalized Rhino 3D Evening Training with individual attention. Flexibility to select your preferred time and day for the training. Access to free online support even after completing the course. Comprehensive PDF notes and handouts provided for effective learning. Receive a certificate upon completing the Rhino 3D Evening Training Course. Affordable pricing options tailored to your budget. Assistance in computer configuration for seamless software installation. Referral benefits: Recommend a friend and enjoy exclusive discounts. Special discounts available for group training sessions. Operating hours from Monday to Saturday, extending into the evening for convenience. Tailored training programs designed to meet your specific needs and requirements.

WE WORK HARD TO BE MORE PRODUCTIVE AND AVOID WASTING TIME. THEREFORE, THE MEETINGS WE HAVE SHOULD BE IMPORTANT. In order to make the best use of our time, we need to be efficient. Our main goal is to increase productivity and avoid wasting time. Therefore, it is important that the meetings we have are meaningful and necessary. Unlike the story of “The Boy Who Cried Wolf,” we want our meeting attendees to understand the value of our work. We show them by setting a good example. Over time, they realize that our meetings are held for important reasons. When attendees know that our meetings are productive, respectful (in terms of length and content relevance), and serve a purpose, they are happy to attend and contribute their best. This class will help participants organize their ideas and communicate clearly. As facilitators, you will learn to be concise and communicate with confidence. By running more productive sessions, you will increase satisfaction and open up dialogue with your audience. FORGE AHEAD – THE REWARDS AWAIT.THROUGH THE IMPROVING COMMUNICATIONS RUNNING EFFECTIVE MEETINGS CLASS, YOU WILL: Gain new perspective and methods to create better, more productive sessions; Have a clear purpose to keep focus and engage with interest; Inspire facilitator-audience dialogue, ensuring a genuine exchange of ideas; Manage distractions and disruptions appropriately, keeping efficiency; and Probe for information, getting the most useful level of detail for improvement.   Online Format—Running Effective Meetings is a 4-hour interactive online class for up to six people. Register for this class and you will be sent ONLINE login instructions prior to the class date. As a trainer and human resources professional, I truly believe in the value that Dr. Atkins can add to any organization. The seminar he provided was easy to follow and thought provoking. His personable demeanor along with his humble spirit and obvious expertise make his sessions gems that you cannot afford to pass up. Deirdre Cash, PHRPaco Group, NYC

A personalised resilience profile and 60 minute coaching and exploration session for those who want to develop their capacity to adapt positively in an ever changing world.