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

2612 Courses

EPALS (Two Day Course) @ St John's and Elizabeth Hospital, London

5.0(3)

By Hunter Clinical Training

Advanced paediatric course for clinical staff working with children.

EPALS (Two Day Course) @ St John's and Elizabeth Hospital, London
Delivered In-Person in London
£570

SIA Security Officer Refresher Course

5.0(15)

By SWBM ACADEMY

How is SIA SO Top Up course delivered? It is a blended course. Total time is 4 hours (minimum). Online learning – minimum 4 hrs eLearning must be done online prior to the course commencement date. You will be given access to our online portal. Classroom learning – 1 day We will give you access to our learner portal for you to get ready for the exams. Exams - 45 minutes (1 exam) are allocated for exams, which will be done in the classroom. You would need to come to the centre and sit the exams. Course Benefits / Package Deal ✅ UNPARALLELED VALUE! ✅ FREE Retakes of all units ✅ TRAINING GUARANTEE: We have never postponed a course yet. You get your training or a full refund without losing a penny. ✅ BEST TRAINING: No nonsense or bla bla bla! We have trainers with a minimum of 20 years of field experience, offering you the best possible insights and practical knowledge. You will learn from industry experts who understand the real-world challenges and nuances of security work. See Reviews! ✅ FREE reading materials. Full access to our course materials and beyond, giving you comprehensive resources for your learning journey. ✅ FREE e-certificate via email upon completion (No need for a hard copy). ✅ FREE step-by-step guidance on how to apply for the SIA license, streamlining the post-training process. ✅ FREE parking (North London Centre Only) ✅ ALL-INCLUSIVE PRICES: Our pricing is transparent and all-inclusive. Course and exam fees are included, so you won't encounter any hidden costs. ✅ FREE employment support after completing your training. ✅ Customer support - via chat-box, phone, or email for any questions or assistance. ✅ We always deliver on our promise! We pride ourselves on delivering on our promises, ensuring that you receive the highest quality training and support. ✅ Hassle-Free Booking under 60 seconds / Pick a location / Select a date / Fill in the form / Click on Go To Check Out.

SIA Security Officer Refresher Course
Delivered In-PersonFlexible Dates
£99.99

TRAINING FOR FILM & GAME DESIGNERS One to One Online or Face to Face

By Real Animation Works

Film and VFX face to face training customised and bespoke. One to One Online or Face to Face

TRAINING FOR FILM & GAME DESIGNERS One to One Online or Face to Face
Delivered in London or OnlineFlexible Dates
£1,600

Permanent Makeup Course Combinations | Master - 1-2-1 Private Training

By ID Liner | Permanent Makeup Training & Supplies

The Master combines our Digital Brows training course with our Gloss & Go™ Lip Blush training course AND our Permanent Eyeliner training course AND our Microblading training course.

Permanent Makeup Course Combinations | Master - 1-2-1 Private Training
Delivered In-PersonFlexible Dates
£13,900

Special Executive Master's Programme in Business Administration

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Business Administration Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. Economic knowledge and good administration are crucial to prosperity and progress in modern society. For both customers and employees, it is important that companies and public institutions are administered well. At the same time, good administration has a significant impact on a company’s bottom line figures. One of the keywords in Business Administration is management, and as a SEMP BA student, you will gain insight into both financial and psychological aspects of management. The online Programme will provide you with a wide range of skills that will qualify you for many different positions in the public or private sectors. The courses in Business Administration will provide you with insight into Organisational theory, management psychology, marketing, planning, microeconomics and cost management. You will learn how to locate and analyze management issues, such as how to increase customer satisfaction; you will also learn to understand how companies and institutions are influenced by international conditions, technology, the global economy, or legislation. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Business Administration right for me? SEMP Business Administration Programme emphasizes preparation for practical decision making in a business environment. The online Programme will prepare you for a career in business. Students develop specialized skills and improve their capacity to analyze, communicate effectively with associates, think independently, and thrive in work situations.   Why SEMP Business Administration? The courses in Business Administration will provide you with insight into organizational theory, management psychology, marketing, planning, microeconomics and cost management. You will learn how to locate and analyze management issues, such as how to increase customer satisfaction. You will also learn to understand how companies and institutions are influenced by international conditions, technology, the global economy, or legislation. Who should enrol in this online Certificate Program? This non-credit-bearing course is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role, or fast approaching such position and are seeking an opportunity to obtain a richer and deeper understanding of management skills. It is ideal for professionals of all levels. This Programme provides practical skills to overcome daily challenges by providing participants with the latest administration principles and techniques. Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa requirements for this Course as it is an Online Course.

Special Executive Master's Programme in Business Administration
Delivered Online On Demand
£2,500

Special Executive Master's Programme in Human Resources Management

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Human Resources Management Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The encapsulated Senior Executive Programme in Human Resource Management is for high-performance managers and directors who want to link the human resources with the strategic objectives of the organisation in order to improve performance. The programme is also useful for managers and directors who want the organisation policies and procedures related to employees to fit into the organization’s broader strategic plan. The SEMP (HRM) will equip you with the fundamentals needed to be effective change agents, either as an entrepreneur, manager or consultant. In addition, the programme will equip you with an awareness of business realities as they relate to Human Resources issues and real-world problem-solving skills. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Human Resource Management Programme right for me? If you want to foster a sense of team spirit and camaraderie within the organization, if your challenge is to manage the recruitment and selection of new employees as well as the training and development of new and current employees, and you want to establish and administer compensation plans and employee benefit programs, then this is just the right Programme for you. Why SEMP Human Resources Management? The SEMP (HRM) will equip you with the fundamentals needed to be effective change agents, either as an entrepreneur, manager, or consultant. In addition, the Programme will equip you with an awareness of business realities as they relate to Human Resources issues and real-world problem-solving skills. By the end of three months, you will have worked through several case studies, have access to numerous online academic materials, interact with peers from different countries and backgrounds, and also have received directions from the best business trainers in the business world today. Who should enrol in this online Certificate Program? The SEMP Human Resource Management Programme is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role, or fast approaching such position and are seeking an opportunity to obtain a richer, deeper understanding of management skills. Here are some of the people that have taken the course online: HR Professionals Business owners/Entrepreneurs Senior Managers & Executives Government officials Consultants Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as its an Online Course.

Special Executive Master's Programme in Human Resources Management
Delivered Online On Demand
£2,500

Special Executive Master's Programme in Strategic Business Management

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Strategic Business Management Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. Gaining deep insight into successful business strategies is a must for business professionals and managers alike. That’s because no matter where you are in your career, it’s critical to understand the market your business is in and the effect your leadership and decision making can have on your company’s success. How else can you maintain your company’s value proposition, increase market share, and remain competitive? Strategic management is important because it helps in setting detailed goals, analyzing all our internal and external resources, analyzing our external environment, as well as stakeholder views. Good corporate governance needs an efficient strategic management process. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Strategic Business Management Programme right for me? In this online course, you will:  Gain new perspectives for building market resilience and dominance for your organization. Understand the difference between corporate and business strategy and what it takes for a corporate headquarters to add value and increase business unit success. Study best practices in key areas of corporate strategy, including diversification, mergers and acquisitions, strategic alliances, corporate governance, and strategic leadership. Why SEMP Strategic Business Management? Strategic management is important because it helps in setting detailed goals, analyzing all internal and external resources, analyzing the external environment, as well as stakeholders’ views. Good corporate governance needs an efficient strategic management process. Who should enroll in this online Certificate Program? This non-credit-bearing course benefits professionals at all levels who want to contribute to their organization’s performance. It is ideal for directors and company executives who determine strategic directions to position their organizations well so as to lead within their different industries. The SEMP Strategic Business Management Certificate program is open to anyone interested in gaining and improving their organizational management skills.   Modules What is Strategy?· Understanding Strategic Management· Understanding the Competitive Environment· Analyzing the Competitive Environment· Stakeholder Analysis, Organisational Purpose, and Organizational Vision· Understanding Core Competence· Competitive Advantages· Competitive Strategy· Strategic Choice · Strategy Formulation· Strategy Implementation· Business Ethics and Social Responsibility Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa requirements for this course as it's an Online Course.

Special Executive Master's Programme in Strategic Business Management
Delivered Online On Demand
£2,500

Special Executive Master's Programme in Personal Development Studies

4.9(261)

By Metropolitan School of Business & Management UK

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Personal Development Studies - Education Course Overview The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP Personal Development Studies - Education deals with approaches involved in the learning process, which are useful for tackling the process of organizing and taking in new information for development purposes. Online Students who enroll in this Programme will examine a section of development studies that focuses on personal development, soft skills improvement, and project management. In the modules, participants will also study research and development, business writing, and general communication skills. Study skills are skills that can be learned in a short time and can be applied to all fields or career path. The course provides a solid ground for enhancing your reading and writing skills demonstratable in a professional environment. Apart from inculcating team leadership and project management skills, the course will ensure the learner creates the best business presentations and write academic grade reports and essays. The course also provides a detailed explanation of key tools and concepts for researching and avoiding plagiarism. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Development Studies the right Programme for me? As a professional, manager, or consultant, if you want to develop your individual skills in the following areas, then SEMP Personal Development Studies - Education is the right option for you:  Communication Problem Solving Critical Thinking and Conceptual Skill Creativity Multidisciplinary Approach Research Self- Reflector Why SEMP Development Studies? This non-credit-bearing course examines the various skills needed for the development of professionals across the education field, and how these improved skills can be harnessed together to produce a leading professional. To study comparative development effectively, one must draw upon many disciplines and construct a balanced understanding of historical and contemporary processes. Thus, studying development as a means for social transformation requires a blend of knowledge and perspectives ranging from communication, creative thinking, time management, and self-reflection. Who should enrol in this online Certificate Program? The SEMP Personal development Studies - Education Programme is designed for entry-level managers, up to mid-level managers, senior managers or directors, consultants who are in a general management role or fast approaching such a position and want an opportunity to develop their personal skills. Here is a list of people who can enrol in the Programme. Non-Governmental OrganizationMembers(NGOs) International literacy Professionals Journalists Educators Archivist Consultants Economic Development Advisor Government Relations Advisor Intelligence Officer Policy Analyst Public Administrations Professionals Public Policy Advisor Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as it's an Online Course.

Special Executive Master's Programme in Personal Development Studies
Delivered Online On Demand
£2,500

Access to Sage 50 Accounts Training in London | Sage Courses Online

By Osborne Training

Course description Sage 50 Accounting / Bookkeeping Training - Fast Track Overview Want to open the door to working in Finance and Accountancy Industry? Starting Sage Line 50 Accounting Fast Track Training course will enhance your career potentials and give you the skills and knowledge you need to get started in Finance and Accountancy Industry. Get a new direction for your career in Accountancy, according to statistics, the average salary for Accountants is £50,000 (Source: Reed), it is the sector where the employability rate is higher than any other sector. With the right skills and practical experience, you would be able to fast track your career in Accountancy and exactly that's where Osborne Training can fill the gap. The intensive programmes include all the skills required to fast track your career in professional Accountancy. Duration 6 Weeks Study Options Classroom Based - Osborne Training offers Daytime or Weekend sessions for Sage 50 Bookkeeping Training Course from London Campus. Online Live - Osborne Training offers online Evening sessions for Sage 50 Bookkeeping Training Classes through the Virtual Learning Campus. Distance Learning - Self Study with Study Material and access to Online study Material through Virtual Learning Campus. Certification You will receive a certificate from Osborne Training once you finish the course. You have an option to get an IAB Certificate subject to passing the exams. What qualification will I gain? You could Gain the following IAB qualifications provided that you book and register for IAB exams and pass the exams successfully: IAB Level 1 Award in Computerised Bookkeeping (QCF) 500/9405/1 IAB Level 2 Award in Computerised Bookkeeping (QCF) 500/9261/3 IAB Level 3 Award in Computerised Bookkeeping (QCF) 500/9407/5 Awarding body International Association of Book-Keepers Sage 50 accounts Course Syllabus Creating a Chart of Accounts to Suit Company Requirements Sole Trader Accounts preparation The Trial Balance preparation Errors in the Trial Balance Disputed Items Use of the Journal Prepare and Process Month End Routine Contra Entries The Government Gateway and VAT Returns Bad Debts and Provision for Doubtful Debts Stock Valuation, Stock Control, Work in Progress and Finished Goods Prepare and Produce Final Accounts Extended Trial Balance Exporting Data including Linking to Other Systems Management Information Reports Making Decisions with Reports Using Sage Prepare and Process Year End Accounts and Archive Data Final Accounts for Partnerships including Appropriation Accounts The Fixed Asset Register and Depreciation Accruals and Prepayments Cash Flow and Forecast Reports Advanced Credit Control

Access to Sage 50 Accounts Training in London | Sage Courses Online
Delivered in Birmingham or OnlineFlexible Dates
Price on Enquiry

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering 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

Microsoft Excel Macros & VBA - Online  classroom
Delivered OnlineFlexible Dates
£550