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

1670 Courses in London

Rhino Introduction to Intermediate Training Course

By ATL Autocad Training London

Why Choose Rhino Introduction to Intermediate Training Course? Learn: 3D NURBS models. Master: Surfacing modeling. Interface: Rhino's navigation. Rendering Skills: Enhance presentations with Rhino renderings. Check our Website Flexible Scheduling: 1-on-1 training sessions according to your convenience. Choose any hour between 9 a.m. and 7 p.m., Mon to Sat. You can call us at 02077202581 to book over the phone. Duration: 10 hours. Methods: Personalized training either in-person, or live online. Introduction and Navigation Become acquainted with Rhino's interface, menus, and screen layout. Efficiently traverse through Rhino models, ensuring precision in 2D lines, polylines, and NURBS curves. Utilize modeling setup features, incorporating constraints like snap, ortho, and planar for accuracy. Leverage object snaps and Smart Track functionality to enhance precision. Solid and Surface Modeling Develop rapid 3D solids and surfaces, employing Rhino's organized layering system. Utilize coordinates and constraints for meticulous modeling, exploring 3D space and elevations. Create diverse shapes, such as rectangles, circles, arcs, ellipses, and polygon curves. Elevate models with Rhino render and render color, incorporating free-form curves, helix, and spiral curves. Efficiently handle model views with pan, zoom, and view management tools. Implement various editing commands for curve manipulation and transform curves into surfaces and solids. Utilize history tracking for advanced editing and execute general editing actions: move, copy, rotate, mirror, and scale. Create arrays with both polar and rectangular arrangements and employ boolean operations like union, difference, and intersection. Offset curves and surfaces effectively, ensuring meticulous detailing. Intermediate Edit and Surfacing Introduce key NURBS modeling concepts and terminologies. Edit curves and surfaces via control point manipulation and rebuild them for optimal refinement. Employ the nudge modeling aid for precise adjustments and generate deformable shapes. Create curves through projection techniques and split surfaces using curves and surfaces. Blend surfaces seamlessly, utilizing symmetry tools, lighting, and rendering effects. Convert intricate 3D objects into detailed 2D drawings, expertly crafting page layouts. Advanced Surfacing and Solid Modeling Construct model primitives and solid text, employing techniques such as pipe and extrusion. Modify solids efficiently using Boolean tools, expanding your surface modeling capabilities. Employ techniques like extrusion, lofting, and revolving for intricate surfaces. Create sweeps using 1 and 2 rail curves, mastering surface network techniques for complex shapes. Upon completion, you will: Master Rhino Tools: Navigate interfaces, utilize advanced tools for precise modeling, and employ features like object snaps and Smart Track. Expert Solid and Surface Modeling: Develop intricate 3D solids and surfaces, create diverse shapes, and use Rhino render effectively. Advanced Editing Skills: Apply intermediate and advanced editing techniques, including symmetry tools and realistic rendering. Precision Modeling: Utilize coordinates, constraints, and advanced aids for accurate detailing and problem-solving. Professional Project Execution: Create high-quality renderings, 2D drawings, and polished 3D models for real-world design scenarios. Upon completion, you'll be adept at 3D modeling, product design, and architecture, positioning you as a valuable asset in the design industry. Why Choose Our Rhino Courses? Rhino, also known as Rhinoceros, stands as a robust 3D computer graphics and computer-aided design software, utilized extensively in domains like architecture, industrial design, and multimedia. Our Rhino courses are meticulously crafted to empower you in mastering this software. Led by seasoned instructors, our courses provide a comprehensive understanding of Rhino, enabling you to create exceptional designs. Rhino 3D Training: Our Rhino 3D training caters to beginners and those seeking advanced techniques. Course Highlights: Precise 3D Modeling: Master free-form 3D NURBS models with precision. Advanced Functionality: Explore Rhino's features, including advanced surfacing commands. User Interface Mastery: Navigate Rhino's interface and hone skills in curves, surfaces, and solids. Expert Guidance: Acquire expertise in Rhino's modeling environment under expert guidance. Modeling Techniques: Learn free-form and precision modeling techniques. Modeling Aids: Utilize tools for accurate modeling and create basic Rhino renderings. Benefits of our Courses: Expert Guidance: Receive instruction from experienced architects and designers, providing practical, real-world insights for comprehensive learning. Comprehensive Resources: Access bespoke video tutorials for additional learning and reference, enhancing your understanding of the course materials. Digital Reference Material: Receive a digital reference book to support your revision efforts, providing a comprehensive resource for your studies. Ongoing Support: Enjoy free after-support through phone or email even after course completion, ensuring continuous assistance and guidance. Tailored Learning Experience: Customize your learning journey by adapting the syllabus and projects to align with your specific needs and interests, fostering a personalized educational experience. Certificate: Upon completion, earn a certificate from us, validating your achievement and recognizing your expertise in the field.

Rhino Introduction to Intermediate Training Course
Delivered in London or OnlineFlexible Dates
£348

NLP Business Diploma (Fundamentals of Collaborative Working)

By Proactive NLP Ltd

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

NLP Business Diploma (Fundamentals of Collaborative Working)
Delivered In-PersonFlexible Dates
£675 to £750

Introduction to Agile for Executives

By IIL Europe Ltd

Introduction to Agile for Executives This session provides executives with an overview of Agile values and principles, the key benefits of an Agile approach, and its differences with the traditional Waterfall method. During the session, we compare and contrast the major Agile methods, with an emphasis on Scrum, as the most popular in the market. And most importantly, we present some criteria for Agile Transformation, possible certifications to pursue, and what is needed at the senior leadership level to achieve the best business results. What you will Learn At the end of this program, you will be able to: Explain the basics and benefits of using an Agile approach Describe the Scrum framework, its events, artifacts, and roles and responsibilities Illustrate an Agile approach outside of Software Development Define Scaled Agile Determine how to support an Agile transformation for your organization Getting Started Introduction Course structure Course goals and objectives Agile Introduction What is Agile? Agile benefits Agile myths and realities Overview of Agile Methods Overview of Agile methods Scrum method Lean and Kanban methods Criteria and certifications What Executives Need to Know About Agile Agile is not just for IT Agile can be scaled Agile transformation needs your support Summary and Next Steps Review Personal Action Plan

Introduction to Agile for Executives
Delivered In-Person in LondonFlexible Dates
£395

Introduction to Agile for Executives: In-House Training

By IIL Europe Ltd

Introduction to Agile for Executives: In-House Training This session provides executives with an overview of Agile values and principles, the key benefits of an Agile approach, and its differences with the traditional Waterfall method. During the session, we compare and contrast the major Agile methods, with an emphasis on Scrum, as the most popular in the market. And most importantly, we present some criteria for Agile Transformation, possible certifications to pursue, and what is needed at the senior leadership level to achieve the best business results. What you will Learn At the end of this program, you will be able to: Explain the basics and benefits of using an Agile approach Describe the Scrum framework, its events, artifacts, and roles and responsibilities Illustrate an Agile approach outside of Software Development Define Scaled Agile Determine how to support an Agile transformation for your organization Getting Started Introduction Course structure Course goals and objectives Agile Introduction What is Agile? Agile benefits Agile myths and realities Overview of Agile Methods Overview of Agile methods Scrum method Lean and Kanban methods Criteria and certifications What Executives Need to Know About Agile Agile is not just for IT Agile can be scaled Agile transformation needs your support Summary and Next Steps Review Personal Action Plan

Introduction to Agile for Executives: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£395

Lumion Training Course

By ATL Autocad Training London

Who is this coure for? Lumion Training Course. Whether you're an architect, designer, 3D artist, or simply someone passionate about crafting captivating architectural visualizations, this course equips you with the essential skills to harness Lumion as a potent tool within your creative process. Click here for more info: Website Duration: 10 Hours Customize your training. Choose any hour from Mon to Sat, 9 a.m. to 7 p.m. Call 02077202581 or WhatsApp at 07970325184 to book. Lumion 3D Course Outline Module 1: Introduction to Lumion 3D Explore Lumion 3D's Features and Navigate the Interface. Master Efficient Workflow with Shortcut Keys. Customize Settings for Optimal Performance. Module 2: 3D Models and Materials Import 3D Models in Various Formats. Apply and Fine-Tune Materials. Create Procedural Materials and Achieve Glass Effects. Troubleshoot Common Issues. Module 3: Building Projects in Lumion Craft Scenes and Sculpt Terrain. Enhance Realism with Alpha and Height Maps. Module 4: The 3D World Manage Multiple 3D Objects and Their Properties. Implement Grass and Scattering Elements. Module 5: Lighting in Lumion 3D Utilize Weather Settings for Dynamic Scenes. Master Lumion Lights, Interior and Exterior Illumination. Create 3D Reflections and Spotlight Effects. Module 6: Realistic Visualizations Integrate Special Effects like Fire, Smoke, and Fog. Achieve Realism with Camera Effects and Shadow Manipulation. Render Still Images and Dynamic Animations. Module 7: NPR Visualizations Create Non-Photorealistic Visualizations with Artistic Effects. Implement Unique Styles for Enhanced Visual Impact. Module 8: Artistic Effects in Lumion 3D Explore Conceptual Visualizations with Painting and Sketch Effects. Craft Cartoon Effects and Understand Perspective Concepts. Module 9: Animation in Lumion 3D Master Timing and Camera Techniques for Dynamic Shots. Compose Animation Clips and Incorporate Effects. Utilize Layers and Control Objects for Precise Animation. Module 10: Advanced Features Understand Import and Output Formats in Lumion. Expand Your Asset Library with the 3D Model Library. Integrate Animated Characters and Sound Effects. Maximize the Advanced Material Library's Potential. Control Environments and Weather for Dynamic Scenes. Efficient Scene Management and Movie Editing in Lumion 3D. For students, download Lumion at: Lumion for Students Download Lumion for Students  https://lumion.com›  Upon completing the Lumion 3D course, participants will: Master Lumion Tools: Navigate the interface, optimize settings, and use shortcuts efficiently. 3D Modeling and Materials: Import models, refine materials, troubleshoot, and enhance realism. Scene Crafting: Create detailed scenes, manage objects, and implement elements for lifelike environments. Lighting Mastery: Utilize weather settings, create reflections, and manage dynamic lighting. Visual Effects Integration: Add special effects, manipulate shadows, and create still images and animations. Artistic Visualization: Explore artistic effects, conceptual visualizations, and cartoon techniques. Advanced Animation: Master timing, camera techniques, and precise animation control. Advanced Features: Understand formats, expand asset libraries, and manage scenes efficiently. Effective Communication: Communicate design concepts effectively to clients and stakeholders. Independence in 3D Rendering: Gain expertise to create complex visualizations independently. Course Overview: What is Lumion? Lumion is specialized 3D rendering software designed for architects and designers. It enables the swift transformation of 3D design models, allowing application of materials, interior and exterior furnishing, and showcasing lighting and shadows without specialized training. Course Objectives: This course focuses on initiating Lumion projects, integrating environments, cameras, lighting, populating scenes, creating terrains, and producing animations. Expectations from the Course: By enrolling, you'll master high-quality render creation, enhance your portfolio, impress clients with top-tier visuals, and gain confidence to elevate your service rates. This course equips you with tools and skills to craft exquisite architectural renders, elevating your work significantly. Intended Audience: Architects, landscape architects, interior architects, civil engineers interested in 3D visualization, and students exploring the realm of 3D visualization. Course Benefits: Delve into Lumion's world-class rendering with speed and precision. This course emphasizes achieving superior quality and realism in the shortest rendering time. Whether you're an architect, interior designer, 3D visualization artist, or Lumion enthusiast, this course empowers you to create exceptional 3D render images. Essential assets, including 3D models and textures, are provided, allowing you to follow the step-by-step process at your own pace. Advantages of Personalized Training: Expertise in Real-Time Rendering: Gain in-depth mastery of Lumion, mastering its features for creating stunning real-time visualizations. Navigate the interface seamlessly and leverage powerful tools for immersive architectural experiences. Enhanced Design Presentations: Elevate design presentations with dynamic visualizations that effectively communicate concepts, lighting nuances, material details, and spatial relationships. Rich Asset Repository: Access a wide variety of high-quality assets, from vegetation to weather effects, enhancing realism and creating captivating scenes that engage viewers. Authentic Landscapes and Effects: Develop skills to create lifelike landscapes, atmospheric weather effects, and unique visual elements that add depth and intrigue to your projects. Flexible Learning Options: Choose between in-person or live online sessions, ensuring convenient and accessible learning tailored to your preferences. Additionally, access recorded lessons for self-paced review and revision. Continuous Support: Benefit from lifelong email support, allowing you to stay connected with instructors for ongoing learning and guidance, even after completing the course.

Lumion Training Course
Delivered in London or OnlineFlexible Dates
£396

H&S Rep (Onsite Only)

4.9(182)

By You Can Do It .Training

This course is designed to help give you a sound understanding of the role and benefits of well...

H&S Rep (Onsite Only)
Delivered In-Person in Stoke on Trent or UK WideFlexible Dates
£747

Motivational Intelligence - Executive Leadership & Management Program

By The Power Within Training & Development Ltd

Our Motivational Intelligence Executive Management course is targeted at transitional leadership development to adapt to market dynamics. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Executive Diploma: Leading With Motivational Intelligence Leading your team or business through transitions or adapting to change is a vital leadership skill that most find challenging. The Power Within Training is dedicated to giving leaders, managers, and businesses throughout England and the UK the executive leadership skills needed to transform their businesses. Neuroscientists have now discovered why people perceive risk, resist change, and cling to the legacy ways they approach their role. With this discovery, we’ve found a practical approach for removing this resistance and fostering greater employee accountability, adaptability, and resilience. The answer was uncovered in the emerging field of Motivational Intelligence. This course has completely changed my outlook on my responsibilities as a manager/leader. To say I have a new perspective is an understatement; I now have the tools to make a massive difference in how I run my company and my life; it has put a new voice in my head that is now directing me in ways I had not thought of before. "If you want a better chance in life and business, do not hesitate to do this course." MANAGING DIRECTOR RBT UNDERFLOWING LIMITED The Role of Motivational Leadership Our motivational leadership courses are rooted in the science of Motivational Intelligence. Motivational Intelligence is designed as an individual’s ability to identify and manage negative thoughts and self-limiting beliefs to overcome obstacles and accomplish goals. Using motivational intelligence and our management development program provides you with the skills and tools needed to face high-level challenges and put thoughts into action while paving the way to a vision. Motivation relies on the learning process of an individual and their ability to observe the relationship between performance and outcome. Motivational leaders can evoke and see the best in their employees and inspire them to work toward a common goal. LEADING WITH MOTIVATIONAL INTELLIGENCE Objectives of our Motivational Leadership Courses The management development program we offer is the world’s first accredited Executive Diploma specifically designed to help progressive-minded leaders adapt to today’s business environment. We focus on issues and challenges created by disruption and turbulence. Our motivational leadership courses address topics ranging from leading/managing virtual teams to helping employees more readily orient to an ever-changing world. The Power Within focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. Leadership training provides valuable knowledge to leaders of all levels. The management portion of our leadership training teaches participants how to define the proper team goals, translate them into actionable plans and communicate them in a way that encourages buy-in. Lastly, the leadership portion focuses on developing people by shifting negative thoughts and self-limiting beliefs such that individuals give themselves permission to learn, grow, and execute new strategies and plans. Here are some additional objects of our motivational leadership courses: To Understand the Role of Motivation in the Workplace To Develop a Deep Understanding of the Different Types of Motivation and How They Can Be Applied to Improve Team Performance To Learn How to Use Motivational Intelligence to Create a Positive and Productive Work Environment To Develop the Skills Needed to Increase Employee Engagement and Drive Business Results To Practice Effective Leadership Techniques that Foster Motivation and Engagement LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. ABOUT THE MQ EXECUTIVE DIPLOMA Are There Different Types of Motivational Leadership? Motivation is the fuel that drives the accomplishment of a goal; without any motivation, the goal becomes another difficult task. Motivational leadership means understanding that regardless of whether you’re leading a small group or an entire business, your leadership and motivational style can significantly impact the effectiveness of your effort. There are several leadership and motivation styles, but the challenge comes with finding the most appropriate for you and your team. In our leadership development program, we’ll discuss leadership motivational skills while working with you to find the best one. Motivational leadership either takes the form of intrinsic or extrinsic motivation. Intrinsic motivation motivates your team to be rewarded internally, and extrinsic motivation uses compensation as a driving force. Compensation can be salary, bonuses, goods, money, or even an appraisal. Here are some examples of different intrinsic and extrinsic motivational types: Competence Motivation – This style is driven by curiosity and a willingness to know more and cultivate additional skills. This style’s central pillar is building more expertise on a subject matter as a noncompetition among peers. Achievement Motivation – Achievement motivation is similar to competence, as it aims to achieve personal development goals. This could take the form of a title within the company. An example could be in your sales department, where a leaderboard or wall of fame is used to track sales. Reward-Based Motivation – This is probably the only motivational type most are aware of, as it’s the easiest way to get a fast motivational boost. The main issue with this type of motivation is that employees get used to it, and the effects don’t last long. Understand the Importance of Motivation Skills in Leadership Motivation drives nearly every action of our lives. Motivational leadership drives the why behind every business idea that’s ever been put into action. As a leader or manager, you must understand the importance of motivating team members, and being able to do this effectively is a requirement in every manager, leader, or business owner’s toolkit. Our management development program builds on best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Focusing on imparting fundamental skills to our executive development course offers powerful insights into the human side of the business. You’ll gain the skills needed to foster a growth mindset within your team. Here are some additional reasons why motivational leadership matters: Improved Performance – Motivated employees can drive the performance of your business. When your employees are motivated, you’ll find lower levels of absenteeism, improved relationships between managers and employees, and improved worker performance throughout your business. Enhanced Innovation – Motivation is a significant force behind innovative ideas. You’re more likely to identify workplace improvement opportunities when your team is motivated. Improved Workplace Culture – Employee motivation and your workplace culture are closely linked. When you take our leadership development program, you’ll discover that a motivated workforce brings commitment, and drive, which enhances your business’s overall morale and creates a positive work culture. Register your interest Motivational Leadership Techniques That Foster Engagement When employees are unmotivated or disengaged, it’s easy to blame tools, processes, or contributing factors. Often, disengagement comes down to a lack of effective leadership. Our leadership training program will help you unlock what leaders need to inspire their employees to do their job and find purpose within their roles. Here are some ways you can apply what you learned during your leadership development program to encourage collaborative leadership and inspire your team to do their very best work: Employees Trust Leaders Whom Both Lead and Follow – Good leaders don’t needlessly exhibit authoritative behaviour. Good leaders show their team that they are willing to roll up their sleeves and work with their team to improve the business. Passion and Positivity Increase Employee Performance – Effective motivational leadership combines finding meaning in work, leveraging connection and community, converting stress into opportunity, taking actions despite the risk, and lastly, maintaining the energy of others through motivation. Show enthusiasm in your business, which will convey your passion to others and can help increase performance and employee engagement. Effective Leadership Prioritizes Business – Successful leaders are more about short-term goals than reaching the next milestone and contributing to your overall business. Practical leadership qualities include providing growth opportunities, inspiring and motivating employees, being open and trusting, and assessing and managing risks. These decisions lead to more long-term success for your business. How To Register For Our Leadership Development Program   Our motivational leadership courses are open to leaders, managers, and business owners looking to quickly adapt their team to change and effectively mentor every team member. The modules in our leadership development program are live virtual instructor-led sessions that meet twice per month for about three and a half hours. These modules incorporate insightful discussions and engaging group conversations designed to shift limiting mindsets, isolate best practices and foster actionable strategies that can be applied immediately. To apply for the course, we ask that you register your interest. Once submitted, The Power Within will contact you to discuss options for fully-funded or partially-funded training opportunities. Register your interest today Book Your Motivational Leadership Course Today   The Power Within is the Motivational Intelligence company dedicated to helping your business become more accountable, resilient, adaptable, and capable of handling all the challenges they encounter. Our leading with Motivational Intelligence Executive Diploma course has been built leveraging Nobel Prize-winning research and the latest advancements to ensure everything necessary for meaningful change is in place. Our leadership development program is fully accredited and internationally recognized for its effectiveness in developing world-class leaders. We want to give you the tools, techniques, and knowledge to think bigger, be better, and achieve more. Don’t hesitate to contact us to learn more about our leadership development program.

Motivational Intelligence - Executive Leadership & Management Program
Delivered in Motherwell or UK Wide or OnlineFlexible Dates
Price on Enquiry

Rural Facilitator (bespoke)

By Ruralink Training

Ruralink Training the home of The Rural Facilitator and the only source of professional learning for Integrated Local Delivery (ILD) practitioners.

Rural Facilitator (bespoke)
Delivered In-Person in Cirencester or UK WideFlexible Dates
£500

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

Recruiting great people to our organisations is the key to high performance and sustainable business success.

Values Based Recruitment
Delivered in Loughborough or UK Wide or OnlineFlexible Dates
£359