9643 Courses

24-Hour Flash Sale! Prices Reduced Like Never Before!! Property Development - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Get ready to position yourself to take advantage of the lucrative Property Development industry. The UK property market is booming, with a projected increase in housing demands by 24% over the next 15 years. Whether you're looking to pivot into property development, enhance your existing skills, or launch a new venture, our Property Development Career Bundle provides comprehensive training to ensure you thrive. Ignite your interest, kindle your desire to succeed, strengthen your conviction with expert knowledge, and take decisive action toward a flourishing career in property development. Spanning 25 in-depth courses, this bundle covers every facet of the property development cycle-from initial Land Surveying and Property Law to Estate Management and Financial Analysis. You will learn the essentials of Property Development, Residential Property Sales and its legal aspects. The curriculum extends further into insights on Construction Cost Estimation, Building Surveying, and even Customer Relationship Management, equipping you with the tools to handle both the strategic and day-to-day challenges of the industry. But that's not all. When you enrol in Property Development Online Training, you'll receive 25 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Property Development Career Bundle: Course 01: Property Development Diploma Course 02: Property Management Course 03: Estate Agent Diploma Course 04: Property Law Course 05: Conveyancing Online Course Course 06: Land Surveying Course 07: UK Land Management Complete Training Course 08: Construction Cost Estimation Course 09: Construction Management Course 10: Building Surveyor Training Course 11: Residential Property Sales Course 12: Customer Relationship Management (CRM) Course 13: Strategic Business Management Course 14: Contracts Law UK Course 15: Contract Management Course 16: Financial Analysis Course 17: Accounting and Finance Certification Course Course 18: Customer Service Executive Course 19: Negotiation and Agreement Training Course 20: Level 2 Diploma in Landscape Architecture Course 21: Corporate Social Responsibility (CSR) Training Course 22: Fundamentals of Stakeholder Management Course 23: Making Budget & Forecast Course 24: Business Analysis Course 25: Investment Basics Step into the dynamic world of property development with a credential that sets you apart. The Property Development Career Bundle is your gateway to becoming a recognised expert in an industry that shapes landscapes and futures. Enrol now and build the foundation for a successful and rewarding career in property development! Learning Outcomes of Property Development Master the entire property development process from ground to sale. Navigate property law and conveyancing with confidence. Effectively manage residential and commercial properties. Apply financial analysis to property investment decisions. Develop and manage construction projects efficiently. Enhance customer relationships through strategic CRM applications. Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Course Curriculum Course 01: Property Development Diploma Module 01: Introduction to Property Development Module 02: Different Types of Property Module 03: Property Research Module 04: Property and the Law Module 05: Different Methods of Finance Option Module 06: Building Regulation Module 07: The Planning Process Module 08: Project Management Module 09: Marketing Your Property Course 02: Property Management Module 01: Introduction to Property Management Module 02: The Role and Responsibilities of a Property Manager Module 03: Listing Properties and Marketing Module 04: The Letting Process and Tenancy Agreement Module 05: The Property Management Process Module 06: Keeping Tenants Long Term Module 07: Regulations of Property Management Module 08: Changes in the UK Property Market: An Opportunity Course 03: Estate Agent Diploma Module 01: Estate Agent: An Introduction Module 02: Different Types of Estate Agents Module 03: Getting Started on the Job Module 04: Listing Property: Finding the Sellers Module 05: Valuation Process Module 06: Negotiating as Estate Agent Module 07: Selling Property: Finding the Buyers Module 08: Letting Property Module 09: Technology for Estate Agents Module 10: Regulation of Estate Agents =========>>>>> And 22 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*25 = £325) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 250 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: Aspiring property developers Real estate agents Project managers Construction professionals Financial analysts Estate managers Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Property Developer: £30,000 - £100,000+ Estate Agent: £18,000 - £60,000 Construction Manager: £27,000 - £70,000 Building Surveyor: £22,000 - £50,000 Property Manager: £20,000 - £45,000 Real Estate Financial Analyst: £25,000 - £70,000 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 - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Understand how Docker works and learn its core features with this hands-on course. This is 90% practice without any useless demos! Learn how to create different containers such as Node.js, Python, WordPress, MongoDB, MySQL, Redis, Elasticsearch, and much more.

>> 12-Hour Knowledge Knockdown! Prices Reduced Like Never Before << A recent CIPD report found that 72% of UK businesses struggle to find effective people managers. Effective team leadership is crucial for business success, and it equips you with the skills to navigate challenges and empower your team. Are you ready to take your leadership skills to the next level? This Team Leader Management bundle equips you with the skills to bridge that gap. This Team Leader Management Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Leadership & Management Training Course Course 02: Team Management Course 03: Talent Management Course 04: Decision-Making in High-Stress Situations This comprehensive Team Leader Management Bundle provides you with the knowledge and tools to become a confident and inspiring leader. You'll delve into core leadership principles, explore effective team management strategies, and discover how to cultivate top talent within your team. The bundle also equips you with critical decision-making skills to navigate complex situations under pressure. Learning Outcomes of Team Leader Management Apply leadership principles to motivate and inspire your team. Implement effective team management strategies for improved performance. Develop your skills in talent identification, recruitment, and development. Master the art of clear and concise communication for a cohesive team. Make sound decisions under pressure for successful project outcomes. Build a positive and productive work environment for your team. Enrol in the Team Leader Management Bundle today and unlock your full leadership potential. Invest in your career and gain the skills to build a thriving, motivated team that consistently delivers results. Why Choose Our Team Leader Management Bundle? Get a Free CPD Accredited Certificate upon completion of Team Leader Get a free student ID card with Team Leader Training The Team Leader is affordable and simple to understand The Team Leader is an entirely online, interactive lesson with voiceover audio Lifetime access to the Team Leader course materials The Team Leader comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Leadership & Management Training Course Module 01: Defining Team Module 02: Understanding Management and Leadership Module 03: Building High-Performing Teams Module 04: Motivating Team Members Module 05: Talent Management Module 06: Stress Management and Mental Health Module 07: Succession Planning Module 08: Communication Skills Module 09: Negotiation Techniques Module 10: Managing Change and much more... Course 02: Team Management Module 01: Defining Team Module 02: Understanding Management And Leadership Module 03: Building High Performing Teams Module 04: Motivating Team Members Module 05: Talent Management Module 06: Stress Management And Mental Health Module 07: Succession Planning Module 08: Communication Skills Module 09: Negotiation Techniques Module 10: Managing Change and much more... Course 03: Talent Management Section 1: Introduction Section 2: Core Concepts Of Talent Management Section 3: Top Reasons Why Employees Leave An Organisation Section 4: Understanding The Needs And Mindset Of Employee Section 5: Steps To Create An Effective Talent Management Plan Section 6: Talent Acquisition Section 7: How To Develop High Potential Employees Section 8: Evaluating Performance Section 9: "SMR" - How You Can Retain The Employees Using This Formula Section 10: How To Retain High Potential Employees and much more... Course 04: Decision-Making in High-Stress Situations Module 1: What Is Decision Making? Module 2: Stress And Its Impact Module 3: Time Stress And Decision Making Module 4: Personal Level Decision Making Under Stress Module 5: Organisational Level Decision Making Under Stress Module 6: Decision Making For Conflict Management 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*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 40 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 COSHH course. This Team Leader Management bundle is ideal for: Team Leaders HR Professionals Project Managers Business Owners Anyone in a Leadership Role Requirements You will not need any prior background or expertise. All you need to take this course is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Career path After completing this Team Leader Management training bundle, you are to start your career or begin the next phase of your career. Team Leader Project Manager Department Head Senior Manager Executive Leader CEO 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.

An affordable way to master the skills of API documentation writing Cherryleaf’s popular online training course teaches you how the keys skills of writing and managing an API developer portal. You’ll gain confidence you’re approaching each writing project in the right way, and creating content that follows best practice. Who is this course for? This course is for anyone responsible for managing, planning or writing API documentation. For example: Developers wanting to provide API documentation that is complete and meets the needs of the users. Developers wanting to discover best practices in API documentation and developer portals Technical Authors/Writers wanting to understand APIs and how to write documentation for them. Recommended by the ASTC This course is recommended by The Australian Society for Technical Communication and The Technical Communicators Association of New Zealand to their members. It’s a great way to maintain the Continuing Professional Development (CPD) required by technical communication societies. Why attend this course? We use publicly accessible APIs, as part of this course. We also show examples of developer portals from the DevPortal awards, Google, Microsoft, and others. No programming experience is required. Who is this course for? This course is for anyone responsible for managing, planning or writing API documentation. For example: Developers wanting to provide API documentation that is complete and meets the needs of the users. Developers wanting to discover best practices in API documentation and developer portals Technical Authors wanting to understand APIs and how to write documentation for them. Technical information The course modules are delivered over the Web in small, manageable video presentations. You can pause the videos at any time and return to the course at times that suit you. You can download the course handouts. You have the option of taking the course on an iPhone or iPad, using the MyTeachable app in the Apple App Store. You can preview some of the course modules. There are a few free applications that you’ll be using, which you’ll need to install these before you start the course. Billing information You can pay by credit/debit cards or PayPal. 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. Need to train your whole team? If you have five or more people who you would like to take the course, we can offer a group booking option. Delegates get access for 12 months. Contact us for details. 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 Creating API documentation and developer portals (beta) Introduction (4:52) What is an API? (23:39) Using an API (23:28) How APIs are created (1:24) Authentication and accreditation (17:53) What documentation should I write? (17:12) The Overview section (7:04) The Concepts section (2:16) The Getting Started section (5:43) The API Reference section (2:20) Writing the API reference by hand (12:31) Cookbooks (3:46) Tutorial/Colab/Code labs (3:27) One-pagers (1:23) The Case Study section (2:21) The FAQs/Troubleshooting section (2:08) Cheat sheets (2:25) Release notes (Changelog) (2:22) Other content (3:13) Onboarding (2:11) Writing code samples (5:56) Documentation - summary (1:18) Design patterns in developer portals (14:52) Authoring tools for API documentation (37:33) Managing an API documentation project (17:53) Summary (2:58) Frequently Asked Questions When does the course start and finish? art and when you finish.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 for the current month and/or the previous month.

This Professional Certificate Course in Intercultural Management in Selected Countries aims to provide a comprehensive understanding of the unique challenges and cultural dynamics in key business regions like Germany, USA, and China. Participants will delve into the critical role of intercultural communication, examining its profound impact on effective management practices. The course will guide students in exploring and enhancing intercultural competence through targeted training and education, while also analyzing evolving trends in global business operations and the significance of cultural diversity in shaping effective intercultural management strategies.After the successful completion of the course, you will be able to learn about the following: Study the specific challenges and cultural influences of intercultural management in selected countries, such as Germany, USA, and China. Discuss the importance of intercultural communication and its impact on intercultural management. Explore intercultural competence and its development through training and education Analyze trends in intercultural management and its significance in global business operations. Discuss the impact of globalization and cultural diversity on the development and effectiveness of intercultural management. The objective of this course is to delve into the intricacies of intercultural management in selected countries like Germany, USA, and China. Participants will study specific challenges and cultural influences unique to each region, emphasizing the importance of intercultural communication in effective management. Through exploration of intercultural competence, attendees will learn how training and education contribute to skill development. The course further delves into analyzing global trends in intercultural management, highlighting its crucial role in the evolving landscape of global business operations amidst the impact of globalization and cultural diversity. This Professional Certificate Course in Intercultural Management in Selected Countries aims to provide a comprehensive exploration of the challenges and cultural nuances in intercultural management within specific nations like Germany, USA, and China. Participants will delve into the significance of intercultural communication, understanding its profound impact on effective management practices. The program further delves into the development of intercultural competence through training and education, analyzing evolving trends in intercultural management within the context of global business operations. Throughout the course, participants will critically examine the influence of globalization and cultural diversity on shaping and enhancing intercultural management strategies. Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Intercultural Management in Selected Countries Self-paced pre-recorded learning content on this topic. Intercultural Management In Selected Countries Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course.The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience, Global Business Professionals Multinational Project Managers Cross-Cultural Team Leaders International Business Students Human Resource Managers Diplomats and International Relations Practitioners Professionals Engaged in Global Trade Executives Expanding Operations Abroad Cultural Liaisons in Organizations Individuals Seeking Career Advancement in Global Settings Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

From dreaming to constructing, the transition is an intricate journey. 'From Blueprint to Reality: Building Construction Fundamentals' is your key to unravelling the multifaceted universe of construction. With a comprehensive curriculum encompassing everything from Construction Management to the nuances of Demolition, this course delves deep, offering insightful perspectives on the construction industry's inner workings. Stepping into this course, one gets a holistic view of the industry, covering a range of topics including site set-up, vital regulations, risk management, and even the intricate aspects of electricity. A significant emphasis is laid on modules such as Occupational Health Management and Construction Project Management, ensuring learners are well-equipped with robust knowledge. Learning Outcomes Understand the core concepts of construction management and site preparation. Grasp the essentials of CDM regulations and their application. Evaluate and manage risks, focusing on occupational health. Develop expertise in cost estimation and materials management for construction projects. Master the practical aspects like working at heights, scaffolding, and excavations. Why buy this From Blueprint to Reality: Building Construction Fundamentals? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this From Blueprint to Reality: Building Construction Fundamentals for? Aspiring construction managers seeking a comprehensive understanding of the field. Architects desiring an in-depth look at construction operations. Safety officers keen to enhance their knowledge in construction health and safety. Quantity surveyors aiming to expand their expertise in cost estimation. Professionals in the construction sector looking to upskill and gain a competitive edge. Career path Construction Manager: £50,000 - £70,000 Site Supervisor: £30,000 - £45,000 Health and Safety Manager: £35,000 - £55,000 Quantity Surveyor: £40,000 - £60,000 Project Manager: £45,000 - £75,000 Demolition Specialist: £30,000 - £50,000 Prerequisites This From Blueprint to Reality: Building Construction Fundamentals does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Construction Management Construction Management 00:08:00 Module 02: Site Set-Up Site Set-Up 00:16:00 Module 03: Construction Design and Management (CDM) Regulations Construction Design and Management (CDM) Regulations 00:08:00 Module 04: Risk Identification, Assessment and Management Risk Identification, Assessment and Management 00:11:00 Module 05: Management of Occupational Health Management of Occupational Health 00:12:00 Module 06: Cost Estimation in the Construction Industry Cost Estimation in the Construction Industry 00:19:00 Module 07: Management of Material for Construction Management of Material for Construction 00:10:00 Module 08: Electricity Electricity 00:15:00 Module 09: Working at Height Working at Height 00:14:00 Module 10: Scaffolding Scaffolding 00:07:00 Module 11: Excavations and Confined Space Excavations and Confined Space 00:15:00 Module 12: Demolition Demolition 00:12:00 Module 13: Construction Project Management Construction Project Management 00:20:00

The Level 4 Certificate gives a broad understanding of the professional and provides the skills needed to complete complex, non-routine tasks within workplace and facilities management. It's for you if you work at an operational management level or if you are aspiring to these roles and want to stretch and develop your knowledge and capability.

Duration 2 Days 12 CPD hours This course is intended for The COBIT 2019 Foundation course would suit candidates working in the following IT professions or areas: IT Auditors IT Managers IT Quality professionals IT Leadership IT Developers Process practitioners Managers in IT service providing firms The above list is a suggestion only; individuals may wish to attend based on their own career aspirations, personal goals or objectives. Delegates may take as few or as many Intermediate qualifications as they require, and to suit their needs. Overview This COBIT 2019 Foundation course is designed as an introduction to COBIT 2019 and enables you to understand how an integrated business framework for the governance and management of enterprise IT can be utilized to achieve IT business integration, cost reductions and increased productivity. The syllabus areas that this course is designed to cover are: New framework introduction Key concepts and terminology Governance and Framework Principles Governance system and components Governance and management objectives Performance management Designing a tailored governance system COBIT 2019 builds on and integrates more than 25 years of development in this field, not only incorporating new insights from science, but also operationalizing these insights as practice. The heart of the COBIT framework updates COBIT principles while laying out the structure of the overall framework including: New concepts are introduced and terminology is explained?the COBIT Core Model and its 40 governance and management objectives provide the platform for establishing your governance program. The performance management system is updated and allows the flexibility to use maturity measurements as well as capability measurements. Introductions to design factors and focus areas offer additional practical guidance on flexible adoption of COBIT 2019, whether for specific projects or full implementation. From its foundation in the IT audit community, COBIT has developed into a broader and more comprehensive information and technology (I&T) governance and management framework and continues to establish itself as a generally accepted framework for I&T governance. 1 - COBIT 5 OVERVIEW AND INTRODUCTION Course Administration Course Objectives Exam Overview Certification Scheme History of COBIT COBIT 2019 Improvements Major differences with 2019 Misconceptions about COBIT COBIT and Other Standards 2 - KEY CONCEPTS AND TERMINOLOGY Introduction to Enterprise Governance of Information and Technology Benefits of Information and Technology Governance COBIT Information and Technology Governance Framework Distinction of Governance and Management Three Principles of a Governance Framework Six Principles for a Governance System 3 - GOVERNANCE SYSTEMS AND COMPONENTS Introduction to the Components of a Governance System Processes and Capability Levels Organizational Structures and Defined Roles Information Flows and Items People, Skills and Competencies Principles, Policies and Frameworks Culture, Ethics and Behavior Services, Infrastructure and Applications 4 - GOVERNANCE MANAGEMENT OBJECTIVES Governance and Management Objectives Publication Governance and Management Objectives Governance and Management Objectives Core Model Evaluate, Direct and Monitor Align, Plan and Organize Build, Acquire and Implement Deliver, Service and Support Monitor, Evaluate and Assess 5 - GOALS CASCADE Governance and Management Objective Relationships Governance and Management Objective Descriptions High-Level Information Example Introduction to the Goals Cascade Enterprise Goals Alignment Goals Mapping Tables ? Appendix A 6 - PERFORMANCE MANAGEMENT Introduction to Performance Management COBIT Performance Management Principles COBIT Performance Management (CPM) Overview Process Capability Levels Rating Process Activities Focus Area Maturity Levels Performance Management of Organizational Structures Performance Management of Information Items Performance Management of Culture and Behavior 7 - DESIGNING A TAILORED GOVERNANCE SYSTEM The Need for Tailoring Design Factors Enterprise Strategy Enterprise Goals Risk Profile I&T Related Issues Threat Landscape Compliance Requirements Role of IT Sourcing Model for IT IT Implementation Methods Technology Adoption Strategy Enterprise Size Focus Areas Designing a Tailored Governance System Management Objective Priority and Target Capability Levels Component Variations Specific Focus Areas Stages and Steps in the Design Process 8 - IMPLEMENTING ENTERPRISE GOVERNANCE OF IT The Business Case The COBIT Implementation Guide Purpose COBIT Implementation Approach Phase 1 ? What are the Drivers Phase 2 ? Where are we Now Phase 3 ? Where do we Want to be Phase 4 ? What Needs to be Done Phase 5 ? How do we get There Phase 6 ? Did we get There Phase 7 How do we Weep the Momentum Going? EGIT Implementation Program Challenges

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

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 classroom, one to one, tailored and bespoke courses. Tailored In Company training: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. 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. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills