61873 Courses

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

Are you ready to make your own silver clay ring? We'll give you the skills, tools and the space to manipulate, join and decorate in silver clay. Choose from 4 styles of rings to create your own unique design. In this workshop you will learn how to make a ring from scratch. You can develop your own design for a special occasion or just for fun! Have you got that special someone in your life or want to make a statement ring for yourself? Whoever the ring is for you'll make a ring that's completely unique. It's the perfect gift for any occasion—and an experience that will last long after the day.

The IMI Light Vehicle Inspection Technician Accreditation is for experienced mechanics who would like to gain recognition for their skills and knowledge. It is also accepted by the Driver and Vehicle Standards Agency (DVSA) as the stage 1 entry qualification for mechanics and technicians who wish to train to become an MOT Tester for class 4 and 7 vehicles (cars and vans) It is normally valid for 3 years and successful candidates, as well as receiving a certifcate, photo card and pin badge, will also be entered on to the IMI Professional Register. This is a public-facing register to showcase individuals working in the motor industry, who have been recognised for their experience, professionalism and commitment to ethical working practices. However, there will be no requirement for you to re-accredit if you go on to complete your IMI Level 2 Award in MOT testing (classes 4 & 7) within the 3 year period. As an Inspection Technician you must be able to work unsupervised – ideally, you should be in full time employment with at least 3 years experience (4 years if you wish to become an MOT tester) to ensure you are familiar with the techniques for vehicle servicing, inspection and system(s) diagnosis. There are 5 practical assessments for this route and two online exams, one containing 30 questions and a second containing 10 questions. Please click on the links below to get an overview of the contents of each assessment. AOM – 071 – Emissions System – Inspection AOM – 072 – Electrical System – Inspection AOM – 073 – Braking Systems – Inspection AOM – 074 – Steering and Suspension Systems – Inspection AOM – 075 – Vehicle Structure – Inspection AOM – 076 – Vehicle Appraisal – Inspection   5 Day Training and Assessment. This training is aimed at experienced technicians who might need some training input prior to assessment. The assessments will take place over a 5 day period with the online assessment taking place mid week to allow for any re-sits that may be necessary. You will receive a copy of Tom Denton’s 4th edition Advanced Automotive Fault Diagnosis book which you can use in the intervening period to study and practice your knowledge and skills prior to attending the course. PLEASE NOTE THESE ASSESSMENTS ARE TO A LEVEL 3 STANDARD AND ARE DESIGNED TO BE TOUGH. THEY CONCENTRATE ON FAULT FINDING WITHIN A GIVEN TIMESCALE. SUCCESSFUL CANDIDATES WILL FIND ALL OF THE FAULTS WITHIN 1 HOUR. The next step If this accreditation is of interest to you, particularly if you wish to become an MOT tester, have a go at our initial assessment test. Our administrator will be in touch with you once we receive your result so that we can best advise you on the way forward.

An amazing art holiday with cultural visits, food tasting, drawing en plein air... and a complete course to discover the secrets of oil painting.

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of the Level 5 Diploma in Accounting and Business (fast track) qualification accredited by OTHM is to provide learners with the knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Level 5 Diploma in Accounting and Business (Fast track mode) Key Highlights of fast track Level 5 Diploma in Accounting and Business qualification 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 Level 5 Diploma in Accounting and Business qualification will help you get knowledge and skills required by a middle manager in an organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. You can look forward to middle management role in organisation that may be involved in financial management, financial planning and control, financial reporting, taxation and people management. Upon successful completion of this fast track Level 5 Diploma in Accounting and Business programme, you will also become eligible to gain direct entry into Final Year of a three-year UK Bachelor's degree programme. 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. 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 4 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 fast track Level 5 Diploma in Accounting and Business, you can progress to Year 3 of a Three-year UK Bachelor's degree Completion of your fast track Level 5 Diploma in Accounting and Business qualification will meet the University standard academic entry requirements.

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.

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.

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of this fast track Level 4 Diploma in Accounting and Business qualification is to provide learners with an understanding of accounting and business in the broader business context, and to provide them with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. Top Skills You Will Learn You will have an understanding of accounting and business in the broader business context. The programme will provide you with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. Opportunities You will have immense career opportunity in banking to manufacturing, from huge service industries to micro businesses. You will get the ability to manage, plan and account for money which is still the ultimate measure of business success and the key driver of growth. Who is this course for? Working Professionals, A-Level holders, Professionals working in range of industries looking for a career in finance and accountancy 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. Career path Progress to: Year 2 of a Three-year UK Bachelor's degree Completion of your qualification will meet the University standard academic entry requirements to progress to Year 2 of a 3 Year UK Bachelor's Degree. In addition to Progression to the Universities, you also have an option to progress to the following Level 5 qualifications offered by LSBR, UK

Diploma in Business Studies - Level 3 (Fast-Track mode) The objective of the Diploma in Business Studies - Level 3 qualification (Accredited by OTHM) is to provide learners with an in depth understanding of the operations and structure of businesses. Successful completion of this qualification will equip learners with the underpinning knowledge and skills required to succeed in employment or further studies. Diploma in Business Studies Key Highlights Program Duration: 6 Months (Regular Mode available) Program Credits: 60 Credits Designed for working Professionals Course Delivery: 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 Understanding of operations and structure of businesses. Underpinning knowledge and skills required to succeed in employment or further studies. Successful completion of the Program enables learners' direct entry into Year 1 of a three-year UK Bachelor's degree or pursue Level 4 Diplomas Mandatory units (Total Credits: 40) The Level 3 Diploma in Business Studies qualification consists of 4 mandatory units plus 2 optional unit for a combined total of 60 credits, 600 Total Qualification Hours (TQT) and 360 Guided Learning Hours (GLH) for the completed qualification. Introduction to Research and Academic Skills (10 credits) Using IT for Business (10 credits) Introduction to Economics and Accounting (10 credits) Introduction to the Business Environment (10 credits) Optional Units (Total Credit: 20) Choose any two of the below Optional Units Introduction to Customer Service (10 credits) Managing Business Events (10 credits) Introduction to Marketing (10 credits) Introduction to People Management (10 credits) Who is this course for? Working Professionals O-Level holders, Sales Marketing Professionals Requirements Open Entry. No formal qualification is required Career path Completion of your Level 3 Diploma in Business Studies 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.

This fast track Diploma in Continuing Professional Development (CPD) for Leadership (Accredited by Qualifi, UK) qualification has been created to develop CPD (continuing professional development) in Leadership, for those who want to draw from their personal experience and develop their leadership understanding and skills, professionally academically and practically for their personal and professional development. The focus of this qualification is the exploration and practical research into leadership as a subject in order to apply this knowledge into a new environment. The fast track Level 7 Diploma in Continuing Professional Development (CPD) in Leadership qualification will require Learners to critically evaluate, challenge and synthesise a wide range of current leadership roles, tools, techniques and models. The emphasis placed on current Leadership concepts and models is on those that are relevant to the 21st century business environment and context and goes beyond the normal examination of Anglo-American management models. Program Overview: Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 (Fast Track) Key Highlights of fast track Diploma in CPD (Continuing Professional Development) for Leadership - Level 7 qualification are: Program Duration: 3 Months (Regular Mode Available) Program Credits: 60 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 Career Progression after completion of your Diploma in Continuing Professional Development for Leadership qualification: Learners completing the fast track Diploma in Continuing Professional Development for Leadership - Level 7 can progress to: A University partner to complete a Dissertation to then receive a full master's degree, subject to approval or Directly into employment in an associated profession University Exemptions QUALIFI has exemptions for learners to progress to a number of universities to complete a Master's Degree after completing their Diploma in Continuing Professional Development for Leadership - Level 7 in fast track mode. The pathways are an indication of a learner's progress towards a university degree and are based on the university's review of QUALIFI's learning programmes and outcomes. As our Qualifi accredited qualifications are approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation) and Qualifications 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.