53594 Courses in Stanley delivered Online

This virtual modular programme develops the coaching skills of managers and leaders. This programme is delivered virtually over zoom, 4 x 180 Minute Sessions over 4 Days.

Build a smarter property business. Entrepreneurial Property Strategies. Treat property like a business and supercharge your investment returns.

Duration 3 Days 18 CPD hours This course is intended for This course is primarily designed for students who want to gain the skills necessary to use VBA to automate tasks in Excel such as collecting data from external sources, cleaning, and manipulating data. The target student may also want to learn how to create custom worksheet functions to streamline worksheet formulas and make complex worksheets easier to support, maintain, and understand. Overview In this course, you will develop and deploy VBA modules to solve business problems. You will: Identify general components of VBA and their appropriate use in solving business solutions. Record VBA macros to automate repetitive tasks. Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment. Write VBA code to create a custom worksheet function. Eliminate, avoid, or handle errors in VBA code, and optimize its performance. Control how and when macros run. Develop UserForm objects to create custom dialog boxes and windows. Use VBA to read and write data from local files and cloud services. Use VBA to clean and transform data. Run programs and commands outside of Excel and share VBA projects with other users VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft© Excel© and other applications in the Microsoft© Office application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users Prerequisites To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365? (Desktop or Online) courses, Parts 1, 2, and 3 1 - Using VBA to Solve Business Problems Topic A: Use Macros to Automate Tasks in Excel Topic B: Identify Components of Macro-Enabled Workbooks Topic C: Configure the Excel VBA Environment 2 - Automating Repetitive Tasks Topic A: Use the Macro Recorder to Create a VBA Macro Topic B: Record a Macro with Relative Addressing Topic C: Delete Macros and Modules Topic D: Identify Strategies for Using the Macro Recorder 3 - Getting Help on VBA Topic A: Use VBA Help Topic B: Use the Object Browser to Discover Objects You Can Use in VBA Topic C: Use the Immediate Window to Explore Object Properties and Methods 4 - Creating Custom Worksheet Functions Topic A: Create a Custom Function Topic B: Make Decisions in Code Topic C: Work with Variables Topic D: Perform Repetitive Tasks 5 - Improving Your VBA Code Topic A: Debug VBA Errors Topic B: Deal with Errors Topic C: Improve Macro Performance 6 - Controlling How and When Macros Run Topic A: Prompt the User for Information Topic B: Configure Macros to Run Automatically 7 - Developing Custom Forms Topic A: Display a Custom Dialog Box Topic B: Program Form Events 8 - Using VBA to Work with Files Topic A: Use VBA to Get File and Directory Structure Topic B: Use VBA to Read Text Files Topic C: Use VBA to Write Text Files 9 - Using VBA to Clean and Transform Data Topic A: Automate Power Query Topic B: Transform Data Using VBA and Workbook Functions Topic C: Use Regular Expressions Topic D: Manage Errors in Data 10 - Extending the Programming Environment Beyond the Workbook Topic A: Run Other Programs and Commands Topic B: Share Your VBA Projects

The Agile Project Manager: In-House Training: Virtual In-House Training Change isn't coming, it's already here. The project environment is becoming more volatile, uncertain, complex, and ambiguous. Project management and project managers must transform and evolve in order to keep up with these changes. Agile has been a disruptor in the field of project management, having over 20 years of successes and benefits to organizations that have adopted their frameworks. The Agile frameworks have proven themselves to be more adept in dealing with this uncertainty. But Agile isn't just about following a different way of working. What do you need to learn, do, and become in order to continue in the current and future environment? It is a powerful combination of knowledge, competencies, and mindset. In an increasingly complicated project environment, this course provides participants with the knowledge needed to not only survive but thrive. What you will Learn At the end of this program, you will be able to: Evaluate the changing project environment and the needed knowledge, skills, and behaviors Demonstrate innovative project manager competencies of leading change, servant leadership, and focus on value Utilize Lean and Agile principles to maximize value and improve project performance Construct a hybrid Agile model that is unique to your project Assess your role in Business Agility as an Agile Project Manager Getting Started Introductions Workshop orientation Expectations Foundations Recap: What is Agile? A changed project environment The future project manager Agile Project Management Competencies Focusing on value Championing change Servant leadership Coaching / mentorship Facilitation Lean and Agile Principles Optimizing flow Making things small Continuous planning Just-In-Time requirements Visualizing work Hybrid Agile Considerations Considering a Hybrid Approach Examining Strengths and Weaknesses of Each Approach Selecting Waterfall / Agile Roles, Practices, and Techniques Reviewing Three Hybrid Scenarios Constructing the Hybrid Project Implementing Agile Pitfalls and Concerns Agile in the Organization Business Agility

The aim of the Level 2 Diploma in Care - fast track mode (Accredited by Qualifi, UK) is to confirm occupational competence for Adult Care Workers or Healthcare Support Workers. This Level 2 Diploma in Care (fast track mode) qualification offers the opportunity for learners to demonstrate their knowledge, understanding and practical skills required to be an Adult Care Worker in an adult care setting or a Healthcare Assistant; Support Worker or Personal Assistant in a healthcare support environment. At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care (fast track mode) qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant The Level 2 Diploma in Care (fast track) will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding The Level 2 Diploma in Care qualification links with the requirements for the National Occupational Standards (NOS) for Health and Social Care. Program Overview: Level 2 Diploma in Care Key Highlights of Level 2 Diploma in Care qualification are: Program Duration: 9 Months (Fast track mode available) Program Credits: 46 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. Alumni Status No Cost EMI Option Mandatory units (Total Credits: 24) The Qualifi Level 2 Diploma in Care qualification consists of 9 mandatory units for a combined total of 24 credits Communication in Care Settings (3 credits) Duty of Care (1 credits) Equality, Diversity and Inclusion in Care Settings (2 credits) Handle Information in Care Settings (1 credits) Health, Safety and Well-being in Care Settings (4 credits) Implement Person-Centred Approaches (5 credits) Personal Development in Care Settings (3 credits) Responsibilities of a Care Worker (2 credits) Safeguarding and Protection in Care Settings (3 credits) Optional Units (Total Credits: 22) The learner must also achieve a minimum of 22 credits from these units. Introductory Awareness of Autistic Spectrum Conditions (2 credits) Understand the Context of Supporting People with Learning Disabilities (4 credits) Assist in the Administration of Medication (4 credits) Contribute to Support Positive Risk-Taking of Individuals (3 credits) Contribute to Support Learning Disabilities to Access Healthcare (3 credits) Promote Positive Behaviour Support (6 credits) Awareness of the Mental Capacity Act 2005 (3 credits) Understand Mental Health Problems (3 credits) Understand Mental Well-Being and Mental Health Promotion (3 credits) Enable Individuals to Develop Strategies to Manage their Behaviour (8 credits) Support Independence in the Tasks of Daily Living (5 credits) Understand how to Support Individuals to be part of a Community (3 credits) Understand the Impact of Acquired Brain Injury on Individuals (3 credits) Who is this course for? At Level 2, the UK sector skills council decided that there would be a common qualification for both Health and Adult Care settings. This means that there will be no barrier to entering either the Adult Care or Health Workforces. The content of the Level 2 Diploma in Care qualification links with the knowledge and skills required for the Apprenticeship Standards 'Adult Care Worker' and 'Healthcare Support Worker'. The content is applicable to a variety of roles, examples of which are included below: Adult care worker Healthcare Assistant / Support Worker Personal Assistant Requirements The Level 2 Diploma in Care will require learners to demonstrate understanding and effective practice in the following areas: Communication Person development Values and behaviours Health and wellbeing Responsibilities Safeguarding Career path Achievement of Level 2 Diploma in Care qualification confirms the learner has gained the knowledge and skills required to: Gain employment as a Healthcare Assistant / Support Worker or Adult Care Worker / Personal Assistant Progress onto the Qualifi Level 3 Diploma in Health and Social Care Progress onto the Level 3 Lead Adult Care Worker Apprenticeship.

The objective of the Level 7 Diploma in Tourism and Hospitality Management (Fast-Track mode) qualification (Accredited by Othm, UK) is to provide tourism industry professionals with the specialist knowledge needed to advance their careers. This fast track Level 7 Diploma in Tourism and Hospitality Management is also helpful for graduates who are entering the tourism and hospitality sector for them to gain the skills needed to manage business operations. The qualification provides learners with a contemporary, critical, and international programme that supports their development as managers with a lifelong-learning orientation. Complete your Diploma in Tourism in 6 months with Fast Track mode The qualification also enables the learners to analyse complex management problems and to apply and adapt specialist skills and technical terminology to propose solutions to these problems informed by best practice and contemporary research. Successful completion of Level 7 Diploma in Tourism and Hospitality Management (Fast Track mode) enable learners to progress into or within employment and/or continue their study towards a relevant Master's programme with advanced standing. With Fast track mode you can complete your diploma in tourism really quick. Tourism and Hospitality Management (Fast Track) Key Highlights of fast track Diploma in Tourism and Hospitality Management Level 7 are: Program Duration: 6 Months (Regular Mode Available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This fast track Diploma in Tourism and Hospitality Management at Level 7 will teach you to analyse complex management problems and to apply and adapt specialist skills and technical terminology to propose solutions to these problems informed by best practice and contemporary research. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's and MBA degree programme. Mandatory units (Total Credits: 120) The OTHM Level 7 Diploma in Tourism and Hospitality Management qualification consists of 6 mandatory units for a combined total of 120 credits Strategic Management and Marketing (20 credits) Destination Management (20 credits) International Tourism Policy and Development (20 credits) E-Tourism and Social Media (20 credits) Advanced Research Methods (20 credits) Organisational Behaviour in International Contexts (20 credits) Who is this course for? Working Professionals Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal Postgraduate qualification leading to award of degrees in future. Requirements For entry onto the Level 7 Diploma in Tourism and Hospitality Management qualification, learners must possess: An honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path Become eligible to gain direct entry into relevant Master's degree programme after completion of your Level 7 Diploma in Tourism and Hospitality Management in Fast Track mode Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

The objective of fast track Level 4 Diploma in Tourism and Hospitality Management qualification (approved by OTHM) is to support learners' development as managers within the tourism and hospitality industry. This fast track Diploma in Tourism and Hospitality Management - Level 4 qualification enables learners to develop their knowledge of theories applicable to management in the tourism and hospitality industry. It enables learners to make well-informed and confident decisions about the management of work areas in the tourism and hospitality industry. Successful completion of this qualification will provide learners with the opportunity to progress to further study or employment. Level 4 Diploma in Tourism and Hospitality Management Key Highlights Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This fast track Diploma in Tourism and Hospitality Management - Level 4 programme will develop your knowledge of theories applicable to manage businesses in the tourism and hospitality industry. It enables learners to make well-informed and confident decisions about the management of work areas in the tourism and hospitality industry The qualification is ideal for those who have started, or are planning to move into, a career in tourism and hospitality industry. Upon successful completion of the programme, you will become eligible to gain direct entry into Year 2 of a three-year UK Bachelor's degree programme. Mandatory units (Total Credits: 120) The OTHM Level 4 Diploma in Tourism and Hospitality Management consists of 6 mandatory units for a combined total of 120 credits, 1200 hours Total Qualification Time (TQT) and 480 Guided Learning Hours (GLH) for the completed qualification. Tourism and Hospitality Business Management (20 credits) Services Marketing and Customer Service (20 credits) Accounting and Finance (20 credits) Academic and Professional Development (20 credits) Events Management (20 credits) Development of the Tourism and Hospitality Industry (20 credits) Who is this course for? Working Professionals, A-Level holders, learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 3 Award / Diploma or at the level of GCE / GCSE or equivalent qualification. Please speak to the Admission Counsellors for waiver information. Career path After completion of your Level 4 Diploma in Tourism and Hospitality Management in fast track mode you progress to: Year 2 of a Three-year UK Bachelor's degree Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

Key Highlights of this fast track Diploma in Accounting and Finance - Level 7 qualification are: Program Duration: 6 Months (Regular mode also available)) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option The objective of this fast track Level 7 Diploma in Accounting and Finance (accredited by Othm) qualification is to provide learners with an understanding of: Contemporary and specialised approaches to accountancy and finance Key practical, theoretical and empirical issues, and academic research The complexity of the ever-changing legal framework in which the financial sector operates The latest developments in accountancy and reporting required by local, national and European government. This fast track Level 7 Diploma in Accounting and Finance qualification equips learners with the essential skills and knowledge needed to pursue high level careers in all types of organisations in the public and private sector and within industry and commerce, both in the UK and abroad. The Level 7 Diploma in Accounting and Finance qualification in fast track mode also provides learners with the opportunity to work toward a relevant Master's programme with advanced standing. This qualification is designed for learners who wish to pursue a career in the: Financial Services industry, Professional Accountancy, Banking and Finance or Management. Who is this course for? Who is this Program For?Working Professionals, Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal Postgraduate qualification leading to award of degrees in future. Requirements Minimum EligibilityFor entry onto the fast track Level 7 Diploma in Accounting and Finance qualification, learners must possess an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counsellors for waiver information. Career path OpportunitiesYou may look forward to role in Financial Services industry, Professional Accountancy, Banking and Finance or Management. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's degree programme.

This fast track Level 6 Diploma in Information Technology (accredited by Othm) is designed to ensure that each learner is a confident, independent thinker with a detailed knowledge of Information Technology, and equipped with the skills to adapt rapidly to change at a junior or middle management level and aspiring into higher management within their organisation or industry. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Information Technology - Level 6 (fast track) Key Highlights of this fast track Diploma in Information Technology - Level 6 programme are: Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option This fast track Diploma in Information Technology - Level 6 qualification will make you a confident, independent thinker with a detailed knowledge of Information Technology. You would be equipped with the skills to adapt rapidly to change at a junior or middle management level and make you aspire into higher management within your organisation or industry. Upon successful completion of the Diploma in Information Technology - Level 6 programme in fast track mode, you will also become eligible to gain direct entry into relevant Master's degree programme. Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. A formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 5 Diploma or equivalent recognised qualification. Please speak to the Admission Counsellors for waiver information. Career path Upon successful completion of your Diploma in Information Technology - Level 6 in fast track mode, you become eligible to gain direct entry into relevant Master's degree programme Completion of your fast track Diploma in Information Technology - Level 6 qualification will meet the University standard academic entry requirements.

The objective of fast track Level 6 Diploma in Tourism and Hospitality Management qualification (accredited by Othm) is to develop learners' management knowledge and skills within the tourism and hospitality industry. Learners will critically evaluate contemporary knowledge and theories and use these to propose solutions to complex management problems. Successful completion of Level 6 Diploma in Tourism and Hospitality Management qualification in fast track mode will equip learners with the specialist skills and knowledge they need to plan and manage their work areas, to make effective decisions, and to adapt effectively to the needs of a range of tourism and hospitality organisations. Level 6 Diploma in Tourism and Hospitality Management Key Highlights Program Duration: 6 Months (Regular mode also available) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This fast track Level 6 Diploma in Tourism and Hospitality Management qualification will develop your management knowledge and skills within the tourism and hospitality industry. You will be able to critically evaluate contemporary knowledge and theories and use these to propose solutions to complex management problems. Upon successful completion of fast track Level 6 Diploma in Tourism and Hospitality Management programme, you will also become eligible to gain direct entry into relevant Master's degree programme. Mandatory units (Total Credits: 120) The OTHM Level 6 Diploma in Tourism and Hospitality Management consists of 6 mandatory units for a combined total of 120 credits Strategic Marketing (20 credits) Tourism Policy and Planning (20 credits) Organisational Behaviour and Performance (20 credits) Technology in the Tourism and Hospitality Industry (20 credits) Tourism and International Development (20 credits) Researching Tourism and Hospitality Management (20 credits) Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression A formal undergraduate qualification leading to award of degrees in future. Requirements Open Entry. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. For others, the learners should have relevant NQF / QCF / RQF Level 5 Diploma or equivalent recognised qualification. Please speak to the Admission Counsellors for waiver information. Career path Upon completion of your Level 6 Diploma in Tourism and Hospitality Management in fast track mode you become eligible to gain direct entry into relevant Master's degree programme Completion of your qualification will meet the University standard academic entry requirements.However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry