9010 Management courses in Cardiff delivered Online

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

Land Your Dream Job! Get Personalised Career Support & Expert Tips, Craft Your CV, Explore Top Jobs & Ace Interviews!

The Level 7 qualifications in Strategic Management and Leadership Practice are designed for directors and senior managers who have the authority and personal inspiration to translate organisational strategy into effective performance. These qualifications require directors and senior managers to build on their skills in strategic management and leadership and to focus on the requirements of inter-organisational strategy.

The objective of the Level 5 Diploma in Logistics and Supply Chain Management (accredited by OTHM, UK) is intended to develop learners' understanding of policy, management theory and practice in logistics and supply chain management. It provides learners with an opportunity to engage with the challenges facing professionals and policy makers in their own country. They will provide knowledge that underpins the ability to work as an effective manager in the sector. They combine both theoretical and practical knowledge in the profession and will develop and enhance knowledge and skills in the areas of leading change, effective planning and risk assessment and forecasting. You will be able to work in a variety of roles within logistics and supply chain management. Level 5 Diploma in Logistics and Supply Chain Management (Fast Track) Key Highlights Program Duration: 9 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 The Level 5 Diploma in Logistics and Supply Chain Management (fast track) qualification will develop your understanding of theory and practice relating to your role in Logistics and Supply Chain Management sector. Since, the units combine both theoretical and practical knowledge in the profession, the course will develop and enhance your knowledge and skills in the areas of effective performance, planning and accountability, development and team working. Upon successful completion of the programme, you will also become eligible to gain direct entry into Year 3 of a three-year UK Bachelor's degree programme. This qualification also provide you with an opportunity for academic progressions to Level 5 Diploma in Logistics and Supply Chain Management. Mandatory units (Total Credits: 120) The OTHM Level 5 Diploma in Logistics and Supply Chain Management qualification consists of 6 mandatory units for a combined total of 120 credits Business Communication (20 credits) Purchasing, Supplier Management and Negotiation (20 credits) Supply Chain Management (20 credits) Business Ethics and Corporate Social Responsibility (20 credits) Strategic Management (20 credits) Supply Chain Risk Assessment and Forecasting (20 credits) Who is this course for? Working Professionals, or learners with relevant NQF/QCF/RQF Level 4 diploma or equivalent recognised qualification or for learners who are interested in pursing an Undergraduate Qualification or who are looking for Career Progression and a formal qualification leading to award of degrees in future. Requirements For entry onto the Level 5 Diploma in Logistics and Supply Chain Management qualification, learners must have relevant NQF/QCF/RQF Level 4 diploma or equivalent recognised qualification. You must also 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 Year 3 of a three-year UK Bachelor's degree programme after completion of your Level 5 Diploma in Logistics and Supply Chain Management 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 the Level 6 Diploma in Logistics and Supply Chain Management (accredited by OTHM) qualification is to provide learners with the knowledge and skills required by a middle or senior manager in an organisation, and who may be involved in managing organisational logistics and supply chain. Level 6 Diploma in Logistics and Supply Chain Management Key Highlights Program Duration: 9 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 The Level 6 Diploma in Logistics and Supply Chain Management qualification will provide you with the knowledge and skills required by a Middle or Senior Manager in an organisation, and who may be involved in managing organisational Logistics and Supply Chain. Upon successful completion of the 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 Logistics and Supply Chain Management qualification consists of 6 mandatory units for a combined total of 120 credits Entrepreneurship Development (20 credits) Global Logistics and Supply Chain Management (20 credits) International Logistics Management (20 credits) Project Management (20 credits) Strategic Procurement (20 credits) Supply Chain Planning and Control (20 credits) Who is this course for? Working Professionals, or learners with relevant NQF/QCF/RQF Level 5 Diploma or equivalent recognised qualification or for learners who are interested in pursing an Undergraduate Qualification or who are looking for Career Progression and a formal qualification leading to award of degrees in future. Requirements For entry onto the Level 6 Diploma in Logistics and Supply Chain Management qualification, learners must have relevant NQF/QCF/RQF Level 5 diploma or equivalent recognised qualification. You must also 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 University Progression after completion of your Level 6 Diploma in Logistics and Supply Chain Management qualification Upon successful completion of your Level 6 Diploma in Logistics and Supply Chain Management, you will also become eligible to gain direct entry into relevant Master's degree programme.

The objective of the Level 4 Diploma in Logistics and Supply Chain Management (accredited by OTHM, UK) is to develop learners' understanding of theory and practice relating to their role in this sector. The qualification will provide learners with an opportunity to engage with the challenges facing professionals and policy makers in their own country. It will provide knowledge that underpins the ability to work as an effective practitioner in the logistics and supply chain sector. The units combine both theoretical and practical knowledge in the profession and will develop and enhance knowledge and skills in the areas of effective performance, planning and accountability, development and team working. Learners will be able to work in a variety of roles within logistics and supply chain management. Logistics and Supply Chain Management Key Highlights Program Duration: 9 Months (Can be Fast tracked) 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 The Level 4 Diploma in Logistics and Supply Chain Management qualification will develop your understanding of theory and practice relating to your role in Logistics and Supply Chain Management sector. Since, the units combine both theoretical and practical knowledge in the profession, the course will develop and enhance your knowledge and skills in the areas of effective performance, planning and accountability, development and team working. Upon successful completion of the programme, you will also become eligible to gain direct entry into Year 2 of a three-year UK Bachelor's degree programme. This qualification also provide you with an opportunity for academic progressions to Level 5 Diploma in Logistics and Supply Chain Management. Mandatory units (Total Credits: 120) The OTHM Level 4 Diploma in Logistics and Supply Chain Management qualification consists of 6 mandatory units for a combined total of 120 credits Financial Accounting and Analysis (20 credits) Introduction to Models and Frameworks for Operations Management (20 credits) Management and Organisational Behaviour (20 credits) Introduction to Business Economics (20 credits) Introduction to Production and Operations Management (20 credits) Purchasing and E-Procurement (20 credits) Who is this course for? Working Professionals Level 3 / A-Level GCSE or learners who are interested in pursing an Undergraduate Qualification or who are looking for Career Progression A formal qualification leading to award of degrees in future. Requirements For entry onto the Level 4 Diploma in Logistics and Supply Chain Management qualification, learners must relevant NQF/QCF Level 3 Award / Diploma or at the level of GCE/GCSE or equivalent. You must also 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 As our OTHM accredited qualifications are approved and regulated by Ofqual (Office of the Qualification and Examinations Regulation) and Qualification Wales , learners are also eligible to progress to a Top-Up Degree, Master's programme, or MBA at many universities in UK and Overseas with advanced standing.

The objective of the OTHM Level 4 Diploma in Business Management qualification is to provide learners with an excellent foundation for building a career in a range of organisations. It designed to ensure each learner is 'business ready': a confident, independent thinker with a detailed knowledge of business and management and equipped with the skills to adapt rapidly to change. The content of the qualification is focused on: managing business communication understanding the business environment and organisations in a global context business functions including people management quantitative methods in business finance for managers research and academic writing. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the Level 4 Diploma in Business Management qualification will enable learners to progress to further study or employment. Program Overview Key Highlights Program Duration: 9 Months (Can be Fast tracked) 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 Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn You will become 'business ready' with a confident outlook, independent thinker with a detailed knowledge of business and management and equipped with the skills to adapt rapidly to change. Who is this course for? Working Professionals, A-Level holders, professionals working in range of industries looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

The objective of Level 6 Diploma in Business Management qualification (accredited by Othm) is to provide learners with an excellent foundation for a career in a range of organisations. It is designed to ensure that each learner is 'business ready': a confident, independent thinker with a detailed knowledge of business and management and equipped with the skills to adapt rapidly to change. The content of the qualification is focused on leadership and people management, strategic human resource management, operations management, sustainable business practice, financial decision making as well as the business research skills expected of a manager. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the Level 6 Diploma in Business Management qualification will provide learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 9 Months (Can be Fast tracked) 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 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 and a formal undergraduate qualification leading to award of degrees in future.

Diploma in Project and Quality Management - Level 7 is a 120 credits qualification. Project and quality management can be used in a variety of industries to bring projects in on time, on budget and to the right quality. Project management elements of this Diploma in Project and Quality Management - Level 7 course will focus on management techniques and applications to help you plan and implement activities to complete projects to your customers expectations. Quality management elements of the course will help you make sure that the outcome of the project is fit for your customer's purposes. Program Overview: Diploma in Project and Quality Management - Level 7 Key Highlights of Diploma in Project and Quality Management - Level 7 qualification are: Program Duration: 9 Months (Fast Track Mode 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 Masters Degree programme. Alumni Status No Cost EMI Option Key facts about Level 7 Diploma in Project and Quality Management 100% Online: Study online with the UK's leading online course provider. Global programme: Study anytime, anywhere using your laptop, phone or a tablet. Study material: Comprehensive study material and e-library support available at no additional cost. Payment plans: Interest free monthly, quarterly and half yearly payment plans available for all courses. Why choose LSBR ? Transform your career: Enrol today and make a life changing decision, get necessary knowledge to transform your career. Move up in your career: With our fully accredited course, you can move up to the next level in your organisation with ease. Upgrade your skills: Add value to your current educational profile and achieve skill sets to compete in your job role. Cost effective: Typically a British qualification starts from GBP £3000 per annum, but with LSBR, you enjoy savings of up to 60% on your educational investment. Assessments: Assessment is done through written assignments and/ or dissertation project. Support: We offer live tutor support via online chat and email for all qualifications delivered by us. Career ProgressionLearners completing the Diploma in Project and Quality Management - Level 7 can progress to: A University partner to complete a dissertation to then receive a full master's degree, or Level 8 Diploma qualification, or Directly into employment in an associated profession University ExemptionsLearners can progress to a number of universities to complete a Master's Degree after completing their Diploma in Project and Quality Management - Level 7. This generally requires completion of a Dissertation only. The pathways are an indication of a learner's progress towards a university degree and are based on the university's review of Eduqual's learning programmes and outcomes. As our EduQual accredited qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation)and Scottish Credit and Qualifications Framework (SCQF), learners are also eligible to progress to a Top-Up Degree, Master's programme, or MBA at many universities in UK and Overseas with advanced standing. Our qualifications are credit-rated for the Scottish Credit and Qualifications Framework (SCQF), a globally-recognised national qualifications framework aligned to other recognised frameworks such as the European Qualifications Framework (EQF) and the Ofqual Regulated Qualifications Framework (RQF).

The objective of Level 5 Diploma in Business Management qualification (accredited by OTHM) is to provide learners with an excellent foundation for a career in a range of organisations. It is designed to ensure that each learner is 'business ready': a confident, independent thinker with a detailed knowledge of business and management, and equipped with the skills to adapt rapidly to change.The content of the qualification is focused on people management, managing projects, marketing, finance for managers, business law, business ethics and social responsibility. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the Level 5 Diploma in Business Management qualification will provide learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 9 Months (Can be Fast tracked) 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 Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn You will get knowledge and skills required by a middle manager who is involved in people management, managing projects, marketing, finance, business law, business ethics and social responsibility. Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.