52876 Courses in Liverpool delivered Online

Agile Sprint Planning: Virtual In-House Training The goal of the course is to provide you and your team with the ability to develop effective and realistic Sprint plans. Without effective Sprint Plans, iterations are set up for failure. But Sprint Planning cannot be improved on its own, in isolation. The Scrum processes are highly intertwined and influence each other. The surrounding artifacts, events, and roles must be examined closely, and enhanced, in order to improve Sprint Planning. This course will remind you of the theory to reinforce the principles, but will concentrate on next-level skills, so that you and the team are able to create realistic and usable Sprint Plans. This course is not introductory. You are already aware of the Scrum framework and have been implementing Scrum on your projects. Now is the time to improve efficiency and effectiveness, to facilitate successful Agile projects. What you will Learn You'll learn how to: Identify and correlate the key symptoms and root causes of ineffective sprint plans Improve key Product Backlog elements Evaluate Agile roles in sprint planning Appraise key product practices Enhance project transparency The Product Backlog User stories Acceptance Criteria Backlog Refinement Supporting Roles Product Owner (the Backlog) Development Team Stakeholders and SMEs Supporting Product Practices Roadmaps and release plans and story maps Definition of Done Technical Debt Transparency Daily Scrums Information radiators Retrospectives Sprint Planning Capacity and Velocity Sprint Planning Meetings The Sprint Backlog Summary What did we learn, and how can we implement this in our work environments?

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before In today's competitive business environment, understanding the intricacies of business law is more crucial than ever. With over 70% of UK businesses facing legal issues annually, the need for comprehensive legal knowledge cannot be overstated. Are you ready to gain confidence and protect your business from legal pitfalls? The Business Law Training - CPD Certified bundle equips you with a practical understanding of the legal principles that govern businesses in the UK. Across six in-depth courses, you'll gain essential knowledge in areas like business formation, contracts, employment law, intellectual property, and taxation. Develop the skills to identify legal risks, make informed decisions, and ensure your business operates compliantly. This Business Law Training Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Business Law Course 02: Business Studies Course 03: Business Lead Generation Course 04: Level 3 Diploma in Business Etiquette Course 05: Ultimate Microsoft Excel For Business Bootcamp Course 06: UK Tax Accounting Whether you're a new entrepreneur, an established business owner, or a professional looking to enhance your career prospects, the Business Law Training - CPD Certified bundle provides a valuable foundation for success. Invest in your future and enrol today! Learning Outcomes of Business Law Training Gain a comprehensive understanding of business law and legal frameworks. Develop expertise in business studies, strategies, and lead generation techniques. Learn professional etiquette and communication skills for effective business relationships. Master advanced Microsoft Excel skills for data analysis and reporting. Understand UK tax accounting principles and compliance requirements. Acquire time management strategies for enhanced productivity and efficiency. With this comprehensive Business Law Training bundle, you can achieve your dreams and train for your ideal career. This Business Law Training bundle covers essential aspects in order to progress in your chosen career. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Business Law Get a free student ID card with Business Law Training program (£10 postal charge will be applicable for international delivery) The Business Law is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Business Law course materials The Business Law comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Business Law Module 1: Introduction Module 2: European Community Law Module 3: The Court System Module 4: Civil and Alternative Dispute Resolution Module 5: Contract & Business Law Module 6: Employment Law Module 7: Agency Act Module 8: Consumer Protection Act Module 9: Act of Tort Module 10: Business Organisations Module 11: Company Act Module 12: Business Property Module 13: Competition Law Course 02: Business Studies Module 01: Introduction To Business Management Module 02: Operations Management Module 03: Introduction To Business Analysis Module 04: Project Management Module 05: Business Process Management Module 06: Planning & Forecasting Operations Module 07: Performance Management Module 08: Management Of Cash And Credit Module 09: Managing Risk And Recovery Module 10: Business Environment Module 11: Human Resource Management Module 12: Customer Service Course 03: Business Lead Generation Introduction To Lead Generation Module 01: Lead Generation Marketing Module 02: What Is Attraction Marketing? Module 03: Strategies For Lead Generation Module 04: Using Customer Relation Management (CRM) For Relationship Building Module 05: Using Social Media For Lead Generation Module 06: Using Pay Per Click (PPC) For Lead Generation Module 07: Conclusion =========>>>>> And 2 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*6 = £78) CPD Hard Copy Certificate: £29.99 CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Business professionals Entrepreneurs and managers Legal and compliance officers Accounting and finance professionals Marketing and sales teams Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Business Owner Consultant Manager Legal Assistant Accountant Entrepreneur Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

Have you ever wondered what drives criminal behaviour? What makes someone take the path of crime, and how do they think? This Criminal Psychology Diploma Course takes you through the fascinating world of criminal minds, exploring theories and the psychology behind criminal activities. You will delve into various psychological conditions and examine how they impact decision-making and behaviour. With a focus on mental health, criminology, and behavioural analysis, this course offers a unique perspective on crime that goes beyond the basics. The course also looks at the roles of law enforcement, the judicial system, and psychological experts in understanding crime. From profiling to risk assessments, you will learn how experts identify and manage individuals involved in criminal activity. Whether you’re curious about the minds of criminals or interested in pursuing a career in criminal psychology, this course provides insightful knowledge without requiring physical attendance. This is a valuable resource for those seeking a deeper understanding of criminal behaviour and psychology, all from the comfort of your own space. Key Features of Criminal Psychology Diploma Bundle CPD Accredited Criminal Psychology Diploma Course Instant PDF certificate Fully online, interactive Criminal Psychology Diplomacourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Criminal Psychology Diploma Bundle course to excel! To become successful in your profession, you must have a specific set of Criminal Psychology Diploma skills to succeed in today's competitive world. In this in-depth Criminal Psychology Diplomatraining course, you will develop the most in-demand Criminal Psychology Diploma skills to kickstart your career, as well as upgrade your existing knowledge & skills. Criminal Psychology Diploma Curriculum Course 01: Criminal Psychology and Intelligence Course 02: Criminology & Profiling Diploma Course Course 03: Forensic Psychology Course 04: Crime Analysis Course 05: Criminal Law Course 06: Accident investigation Course 07: Interrogations And Confessions Psychology Course 08: Decision Making and Critical Thinking Course 09: Bodyguard Training Course 10: Cyber Security Awareness Training Accreditation This Criminal Psychology Diploma bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Criminal Psychology Diploma course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 100 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Criminal Psychology Diploma basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Criminal Psychology Diploma Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Agile Practices for All Projects: Virtual In-House Training Agile methods are becoming increasingly prevalent, and have facilitated projects in reducing time to market, being adaptive to changing customer requirements, and increasing value to customers and organizations. These benefits have been implemented in both IT and non-IT environments to help all types of projects. This course will present key Agile techniques and processes that can be readily incorporated into your projects to enable greater flexibility and higher productivity, while maintaining the traditional project lifecycle framework. The overall goal of the course is for learners to be able to integrate appropriate Agile elements and/or techniques into any project in any environment. What you will Learn Course participants will understand the basic Agile approach, and the various methods for achieving agility and will be able to: Recall project management principles and methodologies Explain Agile practices and compare several Agile methods Apply Agile software development techniques in a project lifecycle framework Employ Agile processes in a project management framework Foundation Concepts Project Lifecycles What is Agile? Agile Benefits Agile Methods Agile Roles Agile Requirement Techniques Agile Requirements User Stories Just in Time (JIT) Requirements Agile Software Development Techniques Agile Design Agile Development Agile Testing Agile Deployment Agile Initiating & Planning Processes Agile Initiating Agile Planning Agile Delivery Processes Agile Execution Agile Monitoring & Control Agile Closing Implementing Agile Practices Agile Approaches Outside of Software Development Dispelling Agile Myths Applying Agile Techniques & Processes Summary and Next Steps What did we learn, and how can we implement this in our work environments?

A standalone 10 week/session course that will introduce you to the basic materials, tools, equipment and techniques used in paper crafting and mixed media work and to Craft4Smiles C.I.C and our tutors. You will be sent all the materials and equipment needed to complete the course. At the end of each lesson you will have a crafted item to take away to keep or show family and friends. You will be told about the other courses you offer so that you can make an informed choice about further learning.

Efficient ways to create professional-looking diagrams, images and screenshots Cherryleaf’s elearning course on creating screenshots and images for user guides gives you the foundations for creating professional images in an efficient way. The course includes exercises and model answers for the delegates to complete and review. Why attend this course? Creating screenshots, diagrams and images is something that every technical communicator needs to do, but very few have had any formal training in how to do it. Sometimes, the result is that the user guides and online Help contain images that are unclear, inconsistent, and frankly, unprofessional. They can make the product look like it's poor quality. Creating them can also tie up the Technical Writer's time, especially if they need to be changed frequently. Who is this course for? Anyone developing user guides and online Help who wants: A foundational understanding of how to use diagrams, screenshots and images, in an effective and efficient way. To see practical, real-world examples. It’s ideal for you if you’re: Creating screenshots, diagrams or images, but you’ve never had any proper training in how to do this well. Looking for more efficient ways to create or change screenshots, diagrams or images for end user or developer documentation. We’ll take you from first principles, so all you need is a basic understanding of what is a user guide. What you'll learn Cherryleaf's e-learning course on creating screenshots and images for user guides gives you the foundations for creating professional images in an efficient way. The goal of the course is to enable you to use diagrams, images and screenshots to communicate to your audience, with a focus on simplicity and ease of understanding. This is accomplished through a mix of design theory, best practices, software, and practical application. Please note, we don’t focus on highly detailed technical illustrations or 3D drawings that you might find in the aerospace or automotive industries. Also, the course does not cover Augmented Reality or Virtual Reality. You'll go through the key stages in developing screenshots, diagrams, and other images:in developing images. You’ll learn to understand the context, choose an effective visual display method, focus the user's attention, apply design best practices, and use the appropriate software tools to communicate your message. Introduction Understand the context Choose an appropriate visual display methodScreenshotsSimplified User InterfaceDiagramsAspect ratioIconsImage mapsWordless guides Focus attention where you want itGestalt theoryWhite space Think like a designerLayoutColourAccessibilityStyle guides SoftwareSoftware toolsSVGAutomating tasksStock imagesPresentation applications Animations Summary The course contains 22 exercises (and suggested answers) for you to practice your skills. Delivery format The course comprises eight modules in total, which you can complete at your own pace. The course will take delegates approximately 1 day to complete. You will have access to the modules from the moment you subscribe. You can download the course handouts. The courses are hosted and sold by via the Teachable platform. From a VAT perspective, they are the “Merchant of Record”, and receipts contain their VAT number. You have the option of taking the course on an iPhone or iPad, using the MyTeachable app in the Apple App Store. Prerequisites We'll take you from first principles, so all you need is a basic understanding of what is a user guide. You'll need access to PowerPoint, or a similar application, in order to complete some of the exercises. And it will help if you have a copy of Snagit. Our expertise As well as teaching technical communication, we also create end-user documentation, Help and UI text for clients. This means every course is based on practical experience of technical communication in today’s environment. Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum First Section Introduction (2:37) Understand the context (14:22) Choose an appropriate visual display method (55:15) Focus attention where you want it (10:39) Think like a designer (32:18) Software (70:12) Animations (21:09) Summary (1:59) Answers  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

The MOST DEMANDED PATHWAY are WAITING for YOU. Every day, hundreds of houses get sold in the UK. And at the heart of all these transactions, there's one person who ensures that the transfer of ownership of the properties is as smooth as possible, a - CONVEYANCER. Do you think so many houses would get sold every day if the ownership transfer process was complicated and convoluted? Probably not. Conveyancers make life easier for property buyers and sellers, and thus they are always in demand. This Course is a quick and easy way to learn the essentials of Conveyancing. With its step by step lessons and no fluff method of content delivery, the course saves you time and money as it's available at a discounted price at the moment. Get 11 CPD Accredited Courses: Course 01: Conveyancing Course 02: Property Law Course 03: Conveyancing Law Course 04: Conveyancing Transactions Course 5: Conveyancing Documentation & Taxation Course 6: Fundamentals of Real Estate and Property Investment Course 7: Residential Property Sales Course 8: Influencing and Negotiation Skills Course 9: Social Housing Management Course 10: Wills and Probate Law Course 11: Property Law: License, Mortgage & Security If you are planning on becoming a conveyancer in the future, then the skills you learn here are going to be really useful. Enrol now and quickly learn Conveyancing. This Course has been designed and developed by Conveyancing industry specialists who have been in the business for years. You'll get easy to understand lessons, and you will gain valuable insights into the world of Conveyancing. Key Highlights for the Recruitment Course: 11 CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules These bundle course will cover following topics: Topic 01: Introduction to Conveyancing Topic 02: Key Conveyancing Fundamentals Topic 03: Landlord and Tenant Topic 04: Land Registry Updates and Law Topic 05: Law of Contract Topic 06: Property Law & Conveyancing Practice Topic 07: Standard Conveyancing Transactions Topic 08: Understanding Accounting Procedures for Conveyancing Transactions Topic 09: Preparing Legal Documents Topic 10: Taxation Issues for Conveyancers Each topic has been designed to deliver more information in a shorter amount of time. This makes it simple for the learners to understand the fundamental idea and apply it to diverse situations. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this course. Requirements To enrol in this course, all you need is a basic understanding of the English Language and an internet connection. Career path After completing this course, you can explore trendy and in-demand jobs, such as- Bookkeeper/Accounting Assistant Agency Advisor Real Estate Agent Projects Area Supervisor Settlement Processor Licensed Transaction Coordinator Associate Attorney Legal Assistant Certificates CPD Accredited PDF Certificate Digital certificate - Included After successfully completing this course, you can get 11 CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - £9.99 After successfully completing this course, you can get CPD accredited hardcopy certificate for £9.99 each. The delivery charge for the hardcopy certificate inside the UK is free, and international students need to pay £9.99 to get their hardcopy certificate.

***24 Hour Limited Time Flash Sale*** Level 3 Certificate in Business Studies - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you prepared to navigate the intricate landscape of the UK business world, where over 5.9 million private sector businesses thrive in a highly competitive environment? Do you possess the drive and skills necessary to unlock your true potential and leave an indelible mark on this dynamic arena? This comprehensive Business Studies Bundle equips you with the knowledge and tools to thrive in today's dynamic market. It offers a foundation in core business principles and delves deeper into specific areas like finance, management, operations, and marketing. You'll gain insights into accounting practices, financial analysis techniques, and how to manage projects effectively. Our bundle also covers legal aspects crucial for businesses, import and export processes, and data analysis - a skill high in demand! But that's not all. When you enrol in Level 3 Certificate in Business Studies Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Level 3 Certificate in Business Studies Career Bundle: Course 01: Level 3 Certificate in Business Studies Course 02: Business Administration Course 03: Diploma in Business Analysis Course 04: Business Strategy Planning Masterclass Course 05: Business Management and Finance Course Course 05: Business Development Fundamentals: Lean Strategies for Business Course 06: Business Performance Management Course 07: Branding Your Business Course 08: Business Law Course 09: Business Improvement Course 10: Business Data Analysis Course 11: BUSINESS INTELLIGENCE AND DATA MINING DIPLOMA Course 12: Digital Marketing for Business Course 13: Business Etiquette and Professional Behavior Course 14: Business Environment Course 15: AML (Anti-money Laundering) Training Course 16: Introduction to Accounting Course 17: Level 3 Tax Accounting Course 18: Financial Management Course 19: Financial Analysis Course 20: Operations Management Course 21: Import/Export Processing Course 22: Supply Chain Management Course 23: Project Management Course 24: Marketing Fundamentals Course 25: Stakeholder Management Course 26: Purchasing and Procurement Course 27: Diploma in Lean Process and Six Sigma Course 28: Cost Control Process and Management Course 29: Customer Relationship Management Course 30: PR: Public Relations With a Level 3 Certificate in Business Studies, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes Level 3 Certificate in Business Studies Develop a comprehensive understanding of business studies and its core principles. Gain expertise in accounting, financial management, and tax accounting regulations. Master the art of financial analysis and business data interpretation. Understand the legal frameworks governing business operations and compliance requirements. Learn effective operations management and supply chain management strategies. Acquire skills in project management, marketing fundamentals, and business analysis techniques. Don't let this opportunity pass you by. Enrol in Level 3 Certificate in Business Studies today and take the first step towards achieving your goals and dreams. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Business Studies Get a free student ID card with Business Studies Training program (£10 postal charge will be applicable for international delivery) The Business Studies is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Business Studies course materials The Business Studies comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Course 01: Business Studies Module 01: Introduction To Business Management Module 02: Operations Management Module 03: Introduction To Business Analysis Module 04: Project Management Module 05: Business Process Management Module 06: Planning & Forecasting Operations Module 07: Performance Management Module 08: Management Of Cash And Credit Module 09: Managing Risk And Recovery Module 10: Business Environment Module 11: Human Resource Management Module 12: Customer Service Course 02: Introduction to Accounting Section 01: Accounting Fundamental Lecture-1.What is Financial Accounting Lecture-2. Accounting Double Entry System and Fundamental Accounting Rules Lecture-3.Financial Accounting Process and Financial Statements Generates Lecture-4.Basic Accounting Equation and Four Financial Statements Lecture-5.Define Chart of Accounts and Classify the accounts Lecture-6. External and Internal Transactions with companies Lecture-7.Short Exercise to Confirm what we learned in this section Section 02: Accounting Policies Lecture-8.What are Major Accounting Policies need to be decided by companies Lecture-9.Depreciation Policies Lecture-10.Operational Fixed Asset Controls Lecture-11.Inventory Accounting and Controls Lecture-12.Revenue Accounting and Controls Lecture-13.Expenses Accounting and Working Capital Course 03: Level 3 Tax Accounting Module 01: Tax System and Administration in the UK Module 02: Tax on Individuals Module 03: National Insurance Module 04: How to Submit a Self-Assessment Tax Return Module 05: Fundamentals of Income Tax Module 06: Payee, Payroll and Wages Module 07: Value Added Tax Module 08: Corporation Tax Module 09: Double Entry Accounting Module 10: Management Accounting and Financial Analysis Module 11: Career as a Tax Accountant in the UK =========>>>>> And 27 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously, it was £12.99*30 = £390) CPD Hard Copy Certificate: Free ( For The Title Course: Previously it was £29.99) CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is ideal for: Entrepreneurs Career changers Business professionals Students Requirements This Level 3 Certificate in Business Studies doesn't require prior experience and is suitable for diverse learners. Career path This Level 3 Certificate in Business Studies bundle will allow you to kickstart or take your career in the related sector to the next stage. Business Owner Manager Accountant Marketing Specialist Project Manager Analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

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

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