3350 Courses

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Sage 50: Sage 50 Course Online Are you looking to master the popular Sage 50 accounts software? If so, our Sage 50 accounts course is the perfect opportunity for you! You will embark on an exciting adventure into accounting and financial management with our Sage 50 accounts Course. You'll also learn a great deal about inventory management, payroll processing, bookkeeping, and much more from this Sage 50 accounts course. You'll also discover insider knowledge that will enable you to master Sage 50 accounts. You can advance your career, make better decisions, and be more productive through this Sage 50 accounts course. Discover the key to financial success and take control of your business with our Sage 50 accounts Course! Learning Outcome of Sage 50 Accounts course After completing the Sage 50 accounts course, you will learn about: How to start the Sage 50 accounts and setting up Sage 50 accounts. These Sage 50 accounts help set up your chart of accounts and records. Through this Sage 50 accounts course, you can understand company tasks, banking tasks and customer tasks. This Sage 50 accounts course helps to know about support tools and proper reporting. Main Course: Sage 50 Accounts Course Free Courses are including with this Sage 50: Sage 50 Course Along with The Security Management: Security Management Course, We Offer a free Level 5 Accounting and Finance Course Along with Security Management: Security Management Course, We Offer a free HR and Payroll Management Course Special Offers of this Sage 50: Sage 50 Course This Sage 50: Sage 50 Course includes a FREE PDF Certificate. Lifetime access to this Sage 50: Sage 50 Course Instant access to this Sage 50: Sage 50 Course Get FREE Tutor Support to this Sage 50: Sage 50 Course Sage 50: Sage 50 Course Online With our Sage 50: Sage 50 Course, you will set out on an exciting journey into accounting and financial management. This Sage 50: Sage 50 Course will teach you a great deal about bookkeeping, payroll processing, inventory management, and much more. Additionally, you'll learn insider information that will help you become an expert with Sage 50 accounts. This Sage 50 accounts course can help you grow professionally, improve your decision-making, and increase your productivity. Who is this course for? Sage 50: Sage 50 Course Online Aspiring accountants, current accountants, and business owners can take this Sage 50 accounts course to make decisions and maximise profitability. Requirements 50: Sage 50 Course Online To enrol in this Sage 50: Sage 50 Course, students must fulfil the following requirements. To join in our Sage 50: Sage 50 Course, you must have a strong command of the English language. To successfully complete our Sage 50: Sage 50 Course, you must be vivacious and self driven. To complete our Sage 50: Sage 50 Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Sage 50: Sage 50 Course. Career path Sage 50: Sage 50 Course Online The Sage 50 accounts course can prepare individuals for a variety of job titles, including bookkeeper, accountant, financial manager and many more.

Begin your journey in compliance management with practical knowledge of the laws and legislations that make up the regulatory field in the United Kingdom. Do you know that FCA sets an annual CPD requirement both for senior managers and employees of financial service firms? As per TC 2.1.15 & 2.1.16, the requirement is 35 hours in each 12 months, including 21 hours of structured CPD activities. Furthermore, TC 2.1.20G27/05/2022 defines structures CPD activities as follows: “Examples of structured continuing professional development activities include participating in courses, seminars, lectures, conferences, workshops, web-based seminars or e-learning.” Our FCA Compliance Essentials Bundle, fulfilling and even exceeding the FCA requirement in terms of CPD hours, is ideal for any professional within Financial Services. Study method Online, self-paced Course format Video with subtitles Duration 40 hours Qualification No formal qualification CPD 40 CPD hours / points Certificates Certificate of Completion - Free Description LGCA's FCA Compliance Essentials eLearning library currently includes the following courses (new courses are added on a regular basis): AML Risk Assessment AML Suspicious Activity Reports and Suspicious Transaction Reports (SAR/STRs) Anti-Bribery and Corruption Anti-Money Laundering and Counter Terrorist Finance Approved Persons Regime Assessing and Managing AML Risks Building an AML Risk-based Approach CASS Introduction Complaints Handling Compliance Introduction Compliance Monitoring and Testing Conduct Rules for All Staff Conflict of Interest (COI) Consumer Duty Establishing and Maintaining a Strong CDD Programme Ethics, Integrity and Fairness in Financial Services FCA: the Role and Approach Financial Promotions Regulation Fraud Detection and Prevention GDPR Awareness Introduction to Cybersecurity Introduction to Know Your Client (KYC) and Customer Due Diligence (CDD) Market Abuse (MAR) Operational Resilience Senior Managers and Certification Regime SM&CR – The Conduct Rules Suspicious Transactions/Activity Reporting The Value of Customer Due Diligence (CDD) Treating Customers Fairly Vulnerable Customer Management Whistleblowing Creating a Compliance Culture in Financial Services Who is this course for? Financial Services Providers Accounting Offices Financial Institutions Brokers Wealth & Fund Managers Investment Firms Insurance Companies Law Firms Compliance Consultants Payment Solutions Providers FinTech & RegTech Companies Fiduciary Services Firms

Getting Started The OTHM Level 7 Diploma in Occupational Health and Safety Management is a qualification for ambitious health and safety professionals. It is intended to make learners accountable for developing and applying health and safety procedures daily in an organisation. This course aids the learners to improve their knowledge and skills. The objective of the OTHM Level 7 Diploma in Occupational Health and Safety Management qualification is to advance occupational health and safety management expertise for managers with the authority and personal attributes to translate organisational strategy into effective operational performance. This qualification reflects current practice in Occupational Health and Safety Management and allows learners to develop and expand their high-level understanding of occupational health and safety. Key Benefits   The course taker will benefit from gaining in-depth knowledge on multidisciplinary topics such as health and safety management practice and systems, strategic risk intervention and its factors, strategies to improve occupational wellbeing, and sustainability and ethics. The Advanced Research Methods unit will allow learners to develop a critical understanding of research and philosophical, practical and ethical concepts within a health and safety environment. The qualification will enable learners to become autonomous, self-directed learners with tools and motivation to continue learning, developing, and reflecting on practice throughout their careers. The OTHM Level 7 Diploma in Occupational Health and Safety Management qualification enables learners to progress into or within employment or continue their further study. As this qualification is approved and regulated by Ofqual (Office of the Qualifications and Examinations Regulation), learners can progress to a Master's top-up at many universities in the UK and overseas with advanced standing. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. What is included?   Outstanding tutor support that gives you supportive guidance all through the course accomplishment through the SBTL Support Desk Portal. Access our cutting-edge learning management platform to access vital learning resources and communicate with the support desk team. Quality learning materials such as structured lecture notes, study guides, and practical applications, which include real-world examples and case studies, will enable you to apply your knowledge. Learning materials are provided in one of the three formats: PDF, PowerPoint, or Interactive Text Content on the learning portal. The tutors will provide Formative assessment feedback to improve the learners' achievements. Assessment materials are accessible through our online learning platform. Supervision for all modules. Multiplatform accessibility through an online learning platform facilitates SBTL in providing learners with course materials directly through smartphones, laptops, tablets or desktops, allowing students to study at their convenience. Live Classes (for Blended Learning Students only) Assessment Time-constrained scenario-based assignments No examinations Entry Requirements   For entry into the OTHM Level 7 Diploma in Occupational Health and Safety Management, learners must possess the following: An honours degree in a related subject or a UK level 6 diploma or an equivalent overseas qualification Mature learners (over 21 years) with management experience International students whose first language is not English will need to have a score of 5.5 or above in the IELTS (International English Language Testing System)   Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Health and Safety Management Practice Reference No : M/618/8236 Credit : 20 || TQT : 200 The aim of this unit is to provide learners with the knowledge, understanding and skills to translate organisational policy into an effective occupational health and safety management operation, including evaluating and reviewing health and safety management practices and operations. UNIT2- Effectiveness of Health and Safety Management Systems Reference No : T/618/8237 Credit : 20 || TQT : 200 The aims of this unit are to provide learners with extensive knowledge and understanding to demonstrate their influence of effective system management and operation. Learners will determine the core drivers for effective health and safety systems within an organisation, evaluating traditional and proactive safety management models, along with the importance of communication systems for the organisation. UNIT3- Factors Affecting Risk and Strategic Risk Intervention Reference No : A/618/8238 Credit : 20 || TQT : 200 This unit aims to develop learners' understanding of the principles of implementing and maintaining a sensible risk management programme. Learners will also gain knowledge on how to assess health and safety risks within the organisation and develop appropriate risk control measures. UNIT4- Strategic Commitment to Health and Well-Being Reference No : F/618/8239 Credit : 20 || TQT : 200 This unit will explore strategies for securing commitment to improve occupational health and well-being. UNIT5- Sustainability and Ethics in Health and Safety Practice Reference No : T/618/8240 Credit : 20 || TQT : 200 The aim of the unit is to evaluate the influences the workplace has on the safety and health of workers and evaluate the evidence for creating an all-inclusive approach to improving safety, health and wellbeing at work. UNIT6- Advanced Research Methods Reference No : Y/618/8246 Credit : 20 || TQT : 200 The unit aim is to allow learners to develop key knowledge, understanding and skills relating to health and safety research and the theoretical and methodological problems that may be associated with the research. Learners will be able to cover key topics relating to research problem, conducting literature reviews, referencing, data collection and analysis techniques, and drawing conclusions from the analyzed data. This unit will enable learners to develop critical awareness of key research skills as researchers and/or independent health and safety practitioners. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Getting Started The OTHM Level 3 Foundation Diploma in Information Technology aims to provide learners with the competencies and understanding necessary for a career in the IT industry or to advance to higher education. This qualification is structured to ensure that every learner can cultivate industry-specific knowledge and acquire contemporary proficiencies in computer systems, networks, programming, web development, mobile communications, cybersecurity, and social media for business.The OTHM Level 3 Foundation Diploma in Information Technology aims to provide learners with the competencies and understanding necessary for a career in the IT industry or to advance to higher education. This qualification is structured to ensure that every learner can cultivate industry-specific knowledge and acquire contemporary proficiencies in computer systems, networks, programming, web development, mobile communications, cybersecurity, and social media for business. Key Benefits Understand the purpose of computer systems. Understand the purpose and types of coding. Understand networking principles Understand the uses and features of mobile communication devices. Assess the importance of cyber security for businesses. Understand the importance of using social media in a business environment. Key Highlights This qualification will offer learners the requisite skills and knowledge to enter the world of work in their chosen sector. We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The Assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our qualified tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. Assessment Internally assessed by the centre and externally verified by OTHM Assignment based Assessment No exam Entry Requirements Learners must be 18 years of demonstrate the ability to undertake the learning and Assessment A learner not from a majority English-speaking country must provide evidence of English language competency. Progression Relevant undergraduate programmes OTHM Level 4 Diplomas Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Computer Systems Reference No : L/618/6090 Credit : 10 || TQT : 100 This unit's objective is to acquaint learners with the fundamental components of computer systems in terms of hardware and software. It further aims to enable learners to perform basic installations and configurations. The unit is designed to foster learners' comprehension of the essential constituents of computer systems and how these components can be adapted to individual needs. UNIT2- Coding and Website Development Reference No : R/618/6091 Credit : 10 || TQT : 100 The primary goal of this unit is to equip learners with an understanding of the fundamental processes involved in creating simple programs and applications, as well as the rudiments of basic website design. UNIT3- Networks Reference No : Y/618/6092 Credit : 10 || TQT : 100 This unit seeks to empower learners with the knowledge of the significance of networks in computer systems and their vital role in various applications. Learners will also acquire insights into network technologies and the delivery of a wide spectrum of networked services. UNIT4- Mobile Communications Reference No : M/618/6096 Credit : 10 || TQT : 100 The objective of this unit is to explain the evolution of mobile communication and its transformative impact on everyday life. It also aims to provide learners with an understanding of the underlying functionality that supports crucial business and e-commerce applications. UNIT5- Cyber Security Reference No : T/618/6097 Credit : 10 || TQT : 100 This unit aims to enable learners to grasp the concept of cyber security and the drawbacks and implications of inadequate cyber security measures. Learners will gain an understanding of essential terminology and the motivations of both ethical and unethical actors. Additionally, they will explore the advantages and disadvantages of implementing security by design. UNIT6- Social Media for Business Reference No : A/618/6098 Credit : 10 || TQT : 100 This unit will allow learners to explore how businesses leverage social media to promote their products and services. Learners will also be tasked with creating a social media policy and a strategic plan tailored to meet the business's specific requirements. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

ICA Specialist Certificate in Financial Crime Risk in Global Banking and Markets Gain an understanding of money laundering risks and vulnerabilities in capital markets by exploring the financial market product, customer risk and service risk typologies. The course will examine the specific financial crime risk factors involved in key customer types such as funds and exchanges. It compares the vulnerabilities of major financial markets products, such as derivatives and foreign exchange. You will also learn more about the importance of the CDD process in mitigating these risks. ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. Regulatory environment, risks and impacts on the world of corporate banking and financial markets Market abuse, fraud and manipulation, tax evasion, sanctions risk Risk exposure and specific customer typologies Financial markets products and their susceptibility to financial crime The CDD process

ICA Specialist Certificate in Financial Crime Risk and New Technology Explore the landscape of new and emerging technology in today's world, viewed through the lens of financial crime risk management. This practical course is ideal for compliance professionals and will help you: understand innovations impacting the financial sector understand the definitions and subsets of RegTech and FinTech and how to potentially leverage big data to prevent financial crime assess the benefits and risks of new technologies adopt the horizon-scanning approach to emerging technologies. ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. What will I learn? Applying financial crime concepts to emerging technology Emerging technologies and financial crime risk The impact of innovation on financial services Harnessing RegTech to minimise financial crime Predicting the next wave of disruptive technology for financial services

ICA Specialist Certificate in Corporate Governance - Course Overview Corporate governance is a key driver in delivering the right outcomes for organisations and helping them to meet corporate objectives. Regulators view effective corporate governance mechanisms as good indicators of a firm's culture of compliance because good governance is likely to indicate good internal culture. This online course will help you: get to grips with the purpose, key success factors and risks associated with governance understand the impact of good governance on the success of organisational strategies assess and design frameworks that serve your firm's objectives and improve performance evaluate the impact of the digital revolution on governance and future developments ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. Upon successful completion of this course, students will be awarded the ICA Certificate in Corporate Governance and will be entitled to use the designation -Spec.Cert(CorpGov) The function and purpose of the organisation The governance of regulated enterprise and the purpose of the Board of Directors The importance, impact and opportunity of organisational culture Conflict management in the organisation Organisational structure, hierarchy and policy frameworks Communication strategy Internal control and influence power Broad-base governance - beyond the balance sheet The digital revolution and its influence on governance Governance - a never ending story

ICA Specialist Certificate in Anti-Corruption - Course Overview Manage your firm's bribery and corruption risk exposure more effectively with this accessible, online course. Manage your firm's bribery and corruption risk exposure more effectively with this accessible, online course. You will examine global anti-corruption frameworks and identify key anti-corruption controls to help mitigate the risks. You will consider and evaluate fundamental area's including PEPs, third parties and appraise geographical & sectoral risks. ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. There are many benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Upon successful completion of this course, students will be awarded the ICA Certificate in Anti-Corruption and will be entitled to use the designation- Cert(ABC) What will you learn by studying the ICA Certificate in Anti-Corruption? Understanding corruption The craft of corruption Who are the stakeholders? High-risk countries, industries and customers Anti-corruption legislation Enforcement An holistic approach to corruption risk mitigation Future trends and the rise of the anti-corruption professionals

ICA Specialist Certificate in Trade Based Money Laundering Trade-based money laundering is a highly effective way to launder the proceeds of crime or finance terrorism. By exploiting the complexities of international trade, criminals can transmit vast amounts of value across borders and fund wider organised crime. This course will enable you to understand and compare trade-based money laundering typologies such as variable pricing and goods, understand how financial crime risk can manifest and be mitigated against in this huge global marketplace. ICA Specialist Certificates, awarded in association with Alliance Manchester Business School, the University of Manchester, will help you quickly gain actionable knowledge to boost your confidence and credibility. What will I learn? In addition to the essential concepts of AML and CTF, you will also cover the following areas: International trade and receivables finance Introduction to money laundering, terrorist financing and proliferation International laws, regulations and industry guidance Managing risk Money laundering typologies Terrorist financing, resourcing and sanctions Further financial crime risk considerations