1114 Learning courses in London

Face to face training customised and bespoke. Online or Face to Face

Emotional Intelligence, EQ, EI, Moccasin Approach, Moccasin Manager,

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

Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. Course Overview Develop true expertise and learn every aspect of Social Media Marketing across 10 modules of interactive content such as Facebook, LinkedIn, Snapchat, YouTube and Instagram. Gain relevant and deep knowledge of social strategy, research and content from industry skills experts. Become a certified social media marketing specialist: Join over 200,000 members around the world, working for some of the world’s top companies using DMI to keep their careers and skills relevant. 81% of our members have been promoted upon completion of one of our courses and 53% have got a salary increase. Get certified with the DMI SPECIALIST digital marketing certification and become a professional digital marketer. Get world class, specialist knowledge and insight: Develop true expertise with our DMI Specialist, Learn social strategy, research and content from industry Skills Experts. Get the latest platform knowledge and strategies including Tik-Tok, Twitch and WeChat. With 10 modules focused on every aspect of social media marketing, DMI Specialist is the most comprehensive Social Media Course available anywhere. Program learning outcomes and content: What Will I Learn? Get the know-how, experience and the insights to be able to work and speak with authority in this face-paced industry. In short, you’ll be a skilled digital marketer, capable of building digital marketing strategies from scratch. We’ve added 8 new soft skill lessons to give you the most industry ready certification available, anywhere. Who is this for? The DMI Specialist Social is for individuals who are responsible for social media marketing campaigns. This includes: • Digital marketing generalists • Marketing Specialists • Marketing Managers • Content creators • Social media consultants • Individuals pursuing profession in social media marketing. • Anyone who wants a career change Course Content: Social Research: Just who are your audience? What do they do, think, feel, eat, love, hate and ‘like’? And what do they think about you? Knowledge is power. And both knowledge and power are fascinating. This module gives you the research techniques to know your audience, and cultural and industry trends. Every day the very people you want to reach throw up gigantic amounts of data. Without the right tools and thinking, it’s a critical mass of meaningless banality. With the right tools and thinking, you have insight deep into hearts and souls. Delve into these tools and put them to use, including the new Google Analytics 4 platform. Social Content: Facebook kittens. Twitter debates. Instagram filters. People can’t get enough content on social media – so better content means better opportunities. So, what does your audience want to see, like and share? With streamlined planning, clever strategy and targeted scheduling, putting the right content in front of the right people is no longer a shot in the dark! Now, you can create amazing content formats that capture the attention of audiences across all social platforms. You can strategize and plan using cutting-edge tools that make your channels stand out from all the others. This module covers the various content formats across platforms, the power and practice of scheduling content and how you can bring it all together with super strategies. Facebook, Instagram and Pinterest: Facebook, Instagram and Pinterest are powerhouses of the social media world. They provide you and your brand with the chance to interact with your customers across the globe at scale. But, each of them has unique features, analytics, and quirks. The module gives you a deep understanding of how these platforms work, how to make your brand stand out in these different spaces, and why you need a spread of messaging across each to succeed. • Build an active, engaged and captive community across each channel. • Create compelling and clever ads that target your audience at the right time. • Use analytics to understand what your audience is doing. Then tweak your content to resonate in all the right ways. • Master the key features of each channel to advertise, strategize and optimize. • Manage each platform so you get the best reach and results. • Reach billions of social loving people every day! Twitter: Twitter marches to its own drum in the social media world – less post and wait, more what’s happening right now. It’s a platform that allows your audience to see, report and comment on world events in almost real-time. It’s also a place where the audience is young, wealthy and educated. Twitter literally challenges you to be ‘more clever’, and this module shows you how. • What a successful Twitter account looks and acts like. • How to use Twitter Ads Manager to advertise effectively. • The right Twitter Ad format for your campaign. • Using Twitter Analytics to react and connect better. • How to create more Tweet-friendly content – snappy, shareable and short. • When to post for maximum impact and engagement. LinkedIn: This module will introduce you to the platform and show you how to use features such as Company pages and Showcase pages, to create a stellar presence for your company – and gain a deep understanding of what that means on LinkedIn. You will understand the unique advertising features and content formats on offer such as Text ads, Sponsored ads, Sponsored InMails, Display ads, and the aptly named Dynamic ads. See what best practice means on this platform, strategize like a CEO and measure the effectiveness of your campaigns. Linkedin can be a tricky platform to master as the tone is hard to crack. But do Linkedin well and your competitors will be scrambling to copy you! You’ve got this – because we do. YouTube & Social Video: YouTube because you have eyes to see. And a picture speaks a thousand words – and this being social, should inspire a few thousand too. Social video is one of the most awesome tools in your new bag of digital tricks. And video is no longer the preserve of guys with film study degrees. This superpower is now yours, and here we give you all the tech and thought basics to make it happen, including how to set up and manage a YouTube channel and create strategies that don’t treat creativity like a buzzword. Learn how video sits within the rest of your mix across platforms, build your online audience and use advertising and analytics for visual campaigns that mesmerise. • Set up and manage a dynamic YouTube channel. • Get creative with social video strategies that engage and convert. • Learn how video sits within the rest of your social media mix. • Build and develop your online audience in a way that benefits your brand. • Use advertising and analytics to deliver mesmerizing visual. Social Apps: If you’re looking to create a buzz online, then social apps are the place to be. Think fun, engaging, and ‘out of the box’ as that’s what these platforms are made for and audiences flock to them (particularly a young demographic). Discover how to use TikTok, Snapchat, WeChat, WhatsApp, and Twitch to tune into your audience effectively. Take a dive into features and understand how to manage content to make the most of everything you post. You’ll also understand how to advertise on the apps that suit your brand. Plus, take inspiration from the best by seeing what campaigns worked and why, so you can TikTok your way to social success. Social Commerce and Affiliate Marketing: With so many eyes on social media, it pays (literally) to know how to market and sell your products online. Social commerce happens when an astute marketer combines the best of social media with the best of e-commerce. You’ll explore the ins and outs of social commerce along with how to create a successful online shop. The latest tactics and tools will be covered so you can make social buying seamless from the first click to the last. You’ll also explore how to optimize paid commerce activity – including cart abandonment – to get the best results. Looking for a way to earn extra money while you grow? Use your social media to tap into affiliate marketing – a great way to earn commission by promoting another company’s products or brand you admire. When it comes to influencing, social media allows you to think BIG. Tap into the world of social influencers by connecting and collaborating with people that think like you. Or reach out to your influencer crush and shine a light on your brand by getting into their social feed. Social Customer Service: One of the best dynamics of social media is how it manages to be collective – the thoughts of billions – yet also personal (it’s about what I ‘like’). This leaves scope for important personal interaction – meaning social customer service is an opportunity for your brand to stand out. This module examines the customer experience. It looks at how to break your audience down into buyer personas so you know them better – and so serve them better. It shows you which platforms do service best and how. Need a social customer service strategy? – no problem. Want to understand how to manage social customer service effectively? – that’s easy. Not sure how to measure and analyze customer service performance? – well, you will now! This module focuses on your customer’s happiness so you can build a contented online community. An audience that feels connected to your brand, so they’ll tell everyone else how great it really is. Social Strategy: So, you have the skills, tools, followers, know-how, tech, smarts and big ideas. Now learn to tie it all together with cutting-edge social strategies practiced by the world’s leading brands. And work out how your social offering sits with – or carries – the rest of your marketing mix. Here we look at planning a dynamic social media strategy that works for you. We dive into setting objectives and social KPIs so you know what you want and can track how you’re getting there. Social media and content production budgets are also explored so you put your money in the places that work, rather than those that don’t. Turn your social media dream into a reality by crafting a social strategy that lets you and your brand sparkle. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Managing Successful Programmes (MSP®) 5th Edition Foundation: In-House Training Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. MSP 5th edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. The MSP Foundation qualification is a prerequisite for the MSP Practitioner Examination, which assesses the ability to apply understanding of the MSP programme management framework in context. The MSP® 5th Edition Foundation course is a training based on the exam specification for MSP Foundation certification and is aligned with the Managing Successful Programmes (5th Edition) guide from AXELOS. What you will Learn At the end of this course, participants will be able to: Understand key concepts relating to programmes and MSP Understand how the MSP principles underpin the MSP framework Understand the MSP themes and how they are applied throughout the programme Understand the MSP processes and how they are carried out throughout the programme Key Concepts of MSP Programmes Three Lenses of MSP Principles Themes and Governance Organization Organization Theme Organization Structure Individual Roles Stakeholder Management Design Design Theme Benefits Risk Identification and Prioritization Target Operating Model Documents and Key Roles Justification Justification Theme Business Case Financial Planning Documents and Key Roles Structure Structure Theme Delivery Planning Dependencies Benefits Realization Plan Resourcing Documents and Key Roles Knowledge Knowledge Theme Knowledge Management Information Management Document and Key Roles Assurance Assurance Theme Assurance at Multiple Levels Assurance Planning Document and Key Roles Decisions Decisions Theme Issue Resolution Risk Response Data Gathering and Reporting Options and Analysis Document and Key Roles MSP Processes Identify the Programme    Design the Outcomes Plan Progressive Delivery Deliver the Capabilities Embed the Outcomes Evaluate New Information Close the Programme

Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction. For more queries, reach out to us: info@mangates.com

Why Book Revit Basic to Advanced Training Course? Learn BIM and Revit for engineers and architects, supporting 2-D and 3-D design for large-scale projects and combing with AutoCAD. Check our Website How to Book? 1-on-1 training tailored to your schedule. Book your sessions from Monday to Saturday between 9 am and 7 pm or call 02077202581 to book over the phone. Training Details: Duration: 16 hours Flexible scheduling, split across multiple days Method: 1-on-1 (In-person or Live Online) and Personalized attention Course Overview: I. Revit Fundamentals (1 hour) Understanding Revit's Purpose and Applications Navigating the Revit Interface and Essential Tools Mastering Navigation and Viewport Controls Creating and Managing Projects II. Project Setup (1 hour) Initiating a New Project Configuring Project Levels, Grids, and Site Information Defining Project Units for Precision III. Basic Modeling Techniques (2 hours) Building Walls, Doors, and Windows Designing Floors, Ceilings, Roofs, Stairs, and Railings IV. Advanced Modeling Skills (4 hours) Crafting Custom Parametric Families Utilizing Conceptual Modeling Tools Designing Complex Forms and Shapes Enhancing Models with Lighting and Materials Achieving Realism through 3D Rendering V. Views, Sheets, and Annotations (2 hours) Managing Views and Sheets Effectively Incorporating Schedules and Tags Crafting Detail Annotations for Construction Documents VI. Phasing, Worksharing, and Collaboration (2 hours) Understanding Phasing and Design Options Mastering Work Sharing and Collaboration Techniques VII. Project Collaboration and Management (1 hour) Establishing Work Sharing Environments Monitoring Worksets and User Activities Synchronizing Worksets for Seamless Collaboration VIII. Advanced Documentation Skills (2 hours) Creating Advanced Schedules and Legends Developing Construction Documents with Sheets and Title Blocks Customizing Schedules and Keynotes for Precision IX. Course Conclusion and Next Steps (1 hour) Reviewing Course Highlights Exploring Further Learning Resources and Tips Interactive Q&A Session and Feedback Opportunities Download Revit Master Revit Proficiency: Acquire advanced skills in Revit for 3D modeling, parametric design, and efficient project management. Craft Complex Architectural Designs: Create intricate building components, custom families, and detailed construction documents. Seamless Collaboration: Expertise in project collaboration, phasing, and work sharing, ensuring smooth teamwork and synchronization. Enhanced Visualization: Learn advanced rendering techniques for realistic 3D visualizations of architectural concepts. Customize Workflows: Adapt Revit tools, optimize workflows, and enhance efficiency in project execution. Career Opportunities: Architectural Designer: Create architectural plans, 3D models, and construction documents. BIM Specialist: Develop detailed digital models in collaboration with architects and engineers. Construction Documenter: Prepare comprehensive construction documents, including plans and schedules. Project Manager: Oversee projects, ensuring timely completion and adherence to design specifications. Revit Specialist/Trainer: Provide Revit training and support services to individuals, firms, or educational institutions. Elevate Your Revit Skills with Our Advanced Training! Our Revit Basic to Advanced Training Course is tailored to enhance your expertise in Autodesk Revit. Delivered through in-person or live online sessions, this program covers advanced modeling, parametric families, collaboration tools, and project phasing. Course Benefits: Master Advanced Skills: Learn intricate 3D modeling, design complex building components, and implement advanced BIM workflows. Expert Instruction: Industry professionals guide you through advanced concepts via engaging demonstrations and hands-on exercises. Flexible Learning: Choose in-person or live online sessions with interactive instruction and personalized guidance. Lesson Recordings: Access class recordings for convenient review and practice, reinforcing your learning. Lifetime Support: Benefit from lifetime email support for ongoing guidance from our experienced instructors. Enhance your Revit proficiency, streamline design processes, and boost project efficiency. Whether you're an architect, engineer, or design professional, this course unlocks advanced Revit skills. Join our training for comprehensive learning and expert support! Individualized Training: Experience personalized attention and tailored guidance. Flexible Learning Hours: Select your preferred schedule for training sessions. Ongoing Support: Access complimentary online assistance even after course completion. Comprehensive Learning Materials: Receive detailed PDF resources for effective learning. Certificate of Attendance: Earn a certificate acknowledging your course completion. Affordable Pricing: Enjoy budget-friendly training rates. Software Setup Help: Get assistance with software configuration on your device. Referral Benefits: Receive discounts on future courses by referring a friend. Group Discounts: Avail special rates for group training sessions. Extended Availability: Access training sessions every day with extended operating hours. Customized Curriculum: Engage in tailored training designed to meet your specific requirements.

Managing Successful Programmes (MSP®) 5th Edition Practitioner Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers, and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges of managing programmes and larger, more strategic, or multiple projects. MSP 5th Edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP 5th Edition Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. MSP 5th Edition Practitioner is for project, programme, and business change managers that want to build on their knowledge of MSP in order to practically apply the MSP framework to real-life scenarios, providing the skills to lead and manage a programme. It is a must-have certification for both project and programme management professionals to deliver organizational value to their employers and boost their careers. What you will Learn At the end of this course, participants will be able to: Understand how to apply the MSP principles in context Understand how to apply and tailor relevant aspects of the MSP themes in context Understand how to apply and tailor relevant aspects of the MSP processes in context Course Introduction Application of MSP Principles Program Strategy and Themes Application of Organization Theme Application of Design Theme Application of Justification Theme Application of Structure Theme Application of Knowledge Theme Application of Assurance Theme Application of Decisions Theme Application of MSP Processes

Managing Successful Programmes (MSP®) 5th Edition Foundation Managing Successful Programmes (MSP®) is a globally-recognized framework for best practice programme management. MSP certification provides guidance for programme managers, business change managers and the next step for project managers to develop their knowledge and skills to be able to positively respond to the challenges for managing programmes and larger, more strategic or multiple projects. MSP 5th edition emphasizes flexibility, adaptability, and responsiveness by adopting an incremental approach to the programme lifecycle and thus enabling organizational agility. AXELOS offers two levels of MSP Examination: MSP Foundation and MSP Practitioner. The MSP Foundation Examination is intended to assess whether the candidate can demonstrate sufficient recall and understanding of the MSP programme management framework. The MSP Foundation qualification is a prerequisite for the MSP Practitioner Examination, which assesses the ability to apply understanding of the MSP programme management framework in context. The MSP® 5th Edition Foundation course is a training based on the exam specification for MSP Foundation certification and is aligned with the Managing Successful Programmes (5th Edition) guide from AXELOS. What you will Learn At the end of this course, participants will be able to: Understand key concepts relating to programmes and MSP Understand how the MSP principles underpin the MSP framework Understand the MSP themes and how they are applied throughout the programme Understand the MSP processes and how they are carried out throughout the programme Key Concepts of MSP Programmes Three Lenses of MSP Principles Themes and Governance Organization Organization Theme Organization Structure Individual Roles Stakeholder Management Design Design Theme Benefits Risk Identification and Prioritization Target Operating Model Documents and Key Roles Justification Justification Theme Business Case Financial Planning Documents and Key Roles Structure Structure Theme Delivery Planning Dependencies Benefits Realization Plan Resourcing Documents and Key Roles Knowledge Knowledge Theme Knowledge Management Information Management Document and Key Roles Assurance Assurance Theme Assurance at Multiple Levels Assurance Planning Document and Key Roles Decisions Decisions Theme Issue Resolution Risk Response Data Gathering and Reporting Options and Analysis Document and Key Roles MSP Processes Identify the Programme    Design the Outcomes Plan Progressive Delivery Deliver the Capabilities Embed the Outcomes Evaluate New Information Close the Programme

You will also learn how to visually improve scarring and areola asymmetries resulting from breast reduction and uplift surgical procedures. The specialist knowledge and techniques are gained through theory and step-by-step practice, which progresses from drawing on paper, to breast mound exercises and finally working on models. Course Prerequisites This course is suitable for those with no prior experience and is designed to provide the student with the ability to seek employment or start their own business upon qualification. Course Pre Study Before beginning practical training, students are required to complete: 30 hours of easy to access e-learning A series of online assessments Course Structure This is a 1 day course with intensive theory and practical sessions. All courses are kept intimate with a maximum of 4 students per course. Areas of study: The fundamental theory of cosmetic tattooing Anatomy and Physiology Health and Safety Colour Theory Client Assessment and Suitability Legal requirements, obtaining consent with consultation techniques and documentation Clinical setup procedures Pre-treatment drawing techniques Practical technique sessions on practice materials and model clients. Professional live demonstrations Industry leading pre and post treatment care for your clients Practical areas included in depth within the course are: Correct areola design planning Blending techniques Sanitation and sterilisation Correct station set up Skin colour matching analysis Needle specification