3599 Courses in Cardiff delivered On Demand

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

Excel Macros Certificate Course Finding out about Excel macros is vital for any individual who uses Excel at home or work. Regardless of whether you're hoping to build your overall Excel information or improve your abilities in the work environment, this course covers all you require. This course gives a thorough manual for Excel macros, including the references to utilize, and how to record and save macros. From proficient tips and counsel to top to bottom full scale classes and genuine equations you can quickly apply, this course covers all you require to think about each component of Excel macros.   You Will Learn: A comprehensive definition of Excel macros and how they work How to reference and record macros How to run, name and save macros Professional tips and expert advice Macro categories and practical coding   Benefits of Taking This Course: You will save time and increase productivity You will be able to interpret data faster and more effectively You will learn basic VBA coding and how to make it work for you You will be able to automate and optimise essential data You will understand the security risks associated with macros

Are you looking to enhance your Investment Manager skills? If yes, then you have come to the right place. Our comprehensive course on Investment Manager will assist you in producing the best possible outcome by mastering the Investment Manager skills. The Investment Manager course is for those who want to be successful. In the Investment Manager course, you will learn the essential knowledge needed to become well versed in Investment Manager. Our Investment Manager course starts with the basics of Investment Manager and gradually progresses towards advanced topics. Therefore, each lesson of this Investment Manager course is intuitive and easy to understand. Why would you choose the Investment Manager course from Compliance Central: Lifetime access to Investment Manager course materials Full tutor support is available from Monday to Friday with the Investment Manager course Learn Investment Manager skills at your own pace from the comfort of your home Gain a complete understanding of Investment Manager course Accessible, informative Investment Manager learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Investment Manager Study Investment Manager in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Investment Manager Course Investment Manager Curriculum Breakdown of the Investment Manager Course Course Outline: Module 01: Introduction to Investment Module 02: Types and Techniques of Investment Module 03: Key Concepts in Investment Module 04: Understanding the Finance Module 05: Investing in Bond Market Module 06: Investing in Stock Market Module 07: Risk and Portfolio Management CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Investment Manager course helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Investment Manager. It is also great for professionals who are already working in Investment Manager and want to get promoted at work. Requirements To enrol in this Investment Manager course, all you need is a basic understanding of the English Language and an internet connection. Career path Investment Analyst: £30,000 to £60,000 per year Portfolio Manager: £50,000 to £100,000 per year Financial Advisor: £40,000 to £80,000 per year Risk Manager: £45,000 to £90,000 per year Wealth Manager: £50,000 to £100,000 per year Fund Manager: £60,000 to £150,000 per year Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get a CPD accredited digital PDF certificate for FREE. Certificate of completion Hard copy certificate - £10.79 After successfully completing this course, you can get CPD accredited hardcopy certificate for free. The delivery charge for the hardcopy certificate inside the UK is Free, and international students need to pay £9.99 to get their hardcopy certificate.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

What Will I Learn? Choose a perfect automated trading strategy Build a portfolio consisting of trading algorithms Learn what criteria a trading algorithm should match Learn when to exclude a strategy from portfolio Learn advantages of using trading algorithms Learn where to find automated trading strategies Understand why it's better to trust an algorithm than a human Learn what markets to trade using trading algorithms Requirements No programming skills required Just an open mind Basic Excel Description Updated in June'16! Learn how to make 95% of profit in just 14 months! Learn how to choose automated trading strategies and force them to earn money for you! In this course, I will show you several platforms where you can find a variety of trading robots. But, more importantly, I will give you a list of criteria to choose perfect strategies and teach you how to select them in practice. I will explain what to take into account when you have to choose between two similar strategies. You will also get a basic knowledge of trading algorithms, their advantages as compared to manual trading, which markets it's better to trade using automated trading strategies. I believe by the end of this course you will be able to build your own portfolio and make profits. Take this course now and learn from my 12+ years of experience. This course is for beginners as well as for advanced traders and algorithm developers! All you need is just your aspiration to learn! With this course you also get: unlimited lifetime access at no extra costs all future additional lectures, live trading examples never any questions asked full 30-day money-back-in-full guarantee Do not hesitate to ask me any questions concerning this course or trading financial markets! Viktor Who is the target audience? Anyone interested in trading Financial Markets Professional traders and algorithm developers Anyone who wants to create a passive income on Financial Markets, but has no time to spare how to trade Forex, stocks, options and especially futures traders Those, who want to trade algorithms, but don't know where to start And finally, anyone who has bad experience in trading Introduction What this course is about FREE 00:02:00 What do you need to start this course FREE 00:02:00 Live Results 00:03:00 Performance Update (November'15) 00:04:00 Performance Update (January'16) 00:05:00 Performance update (June'16) 00:06:00 Performance Update (October'16) 00:06:00 What instruments do you prefer to invest? What are Financial Markets? 00:06:00 What is algorithmic trading? 00:03:00 Risks from using trading algorithms 00:05:00 What markets to trade (Futures against Forex) 00:06:00 The external side of the robot What criteria to use to choose a strategy 00:09:00 How to create a portfolio 00:02:00 How to exclude a strategy from portfolio 00:03:00 Where to invest 00:05:00 iSystems in details 00:09:00 Learn from experience What strategies to use. Creating a portfolio (part 1) 00:08:00 What strategies to use. Creating a portfolio (part 2) 00:07:00

Enrol in our Internal & External Auditors course to master audit skills and explore Functional Maths for audit professionals. Suitable for aspiring auditors, current professionals seeking enhancement, and anyone interested in audit processes. Kickstart your career in auditing today!

Internal Audit Skills Training Course is suitable for anyone aspiring to start working in internal audit. This course will also help anyone looking to learn in-depth about the responsibilities of an internal auditor at work. You can add this qualification to your CV. You'll be able to download your certificate instantly without any cost after completing the Internal Auditor Course. To make this course more accessible for you, we have designed it for both part-time and full-time students. This course is packed into bite-size modules for your convenience. You can study at your own pace or become accredited within hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Who is this Internal Auditor Course for? Internal Auditor Course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Internal Auditor Course is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This Course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Mastering the Five Levels of Audit Skills Module 01: How to Get the Most from This Course 00:35:00 Module 02: Techniques for Planning Useful Audits 00:30:00 Module 03: Techniques for Detailed Risk and Control Assessment 00:40:00 Module 04: Testing and Sampling Techniques 00:30:00 Module 05: Documentation and Issue Development 00:40:00 Module 06: Core Competencies You Need as an Auditor 00:30:00 Module 07: Techniques for Managing the Audit Team 00:30:00 Module 08: Techniques for Managing the Constituent Relationship 00:40:00 Module 09: Auditing 00:05:00 Module 10: Internal Audit 00:05:00 Module 11: The Audit 00:05:00 Module 12: Audit Checklist 00:05:00 Module 13: Conducting an Audit 00:05:00 Module 14: Noncompliance and Corrective Action 00:05:00 Module 15: Audit Closing 00:05:00 Mock Exam Mock Exam - Internal Audit Skills Training Course 00:20:00 Final Exam Final Exam - Internal Audit Skills Training Course 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The aim of the Recognizing and Managing Financial Risks course is to provide students with a comprehensive understanding of the different types of financial risks faced by banks and how to manage them effectively. After the successful completion of the course, you will be able to learn about the following, Understanding Bank Capital. Identifying Commercial Bank Capital. Understanding Bank Regulatory Capital and its Classification. Types and functions of Bank Capital. Understanding Capital Requirements. Understanding Capital Adequacy Ratio: CAR. Basel Committee on Banking Supervision. Importance of Capital Adequacy Ratio to Shareholders. Understanding and calculating Risk-adjusted Capital Ratio. Standardization of Risk-Adjusted Capital Ratios. Key Trends in Bank's Capital. Understanding Bank Balance Sheet. Structure of Bank's Balance Sheet. Components of Bank's Balance Sheet. Understanding Asset/Liability Management. Understanding Deposit Accounts. Types of Bank Deposit Products and Schemes. The aim of the Recognizing and Managing Financial Risks course is to provide students with a comprehensive understanding of the financial risks that banks face and the tools and techniques used to manage these risks. By the end of the course, students should be able to identify and measure the different types of financial risks, and develop effective strategies to manage them through capital and liability management. Students will also develop skills in risk assessment and management that are relevant to careers in banking, finance, and related fields. The Recognizing and Managing Financial Risks course focuses on the management of bank capital and liabilities. Students will learn about the different types of financial risks that banks face, such as credit risk, market risk, and liquidity risk. They will also learn how to measure and manage these risks through effective capital and liability management strategies. By the end of the course, students should be able to identify key financial risks and develop strategies to mitigate them. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Recognising Bank Capital and Liabilities Management Self-paced pre-recorded learning content on this topic. Recognizing and Managing Financial Risks Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Bank Analyst Risk Manager Financial Analyst Credit Analyst Investment Banker Asset and Liability Manager Portfolio Manager Internal Auditor Business Development Manager Treasury Manager Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

In today's financial landscape, the role of a Credit Control Analyst is indispensable. This course equips individuals with the necessary skills to excel in this critical field. Through modules like Credit Control Fundamentals, Risk Evaluation, and Effective Debt Management, participants gain expertise in managing credit and evaluating risks, vital for maintaining financial stability. With an increasing demand for credit management professionals in the UK, mastering these skills opens up abundant job opportunities. The average salary for Credit Control Analysts in the UK stands at £30,000 per annum, reflecting the industry's recognition of their importance. Additionally, with a 10% growth in credit management roles anticipated in the coming years, undertaking this course ensures a competitive edge in the job market. Moreover, by focusing on compliance, customer communication, and leveraging financial tools, individuals enhance their value in this evolving sector. As businesses increasingly rely on credit control for financial health, mastering the nuances of this discipline through this course becomes paramount for career advancement and professional success. Key Features: CPD Certified Credit Control Analyst Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum: Module 01: Credit Control Fundamentals Module 02: Managing Credit Module 03: Risk Evaluation and Credit Scoring Techniques Module 04: Effective Debt Management Module 05: Enhancing Customer Communication Module 06: Compliance in Credit Control Module 07: Analysis and Reporting in Finance Module 08: Utilizing Tools and Technologies in Credit Control Learning Outcomes: Understand principles of credit control for financial stability and efficiency. Apply credit management strategies to mitigate financial risks effectively. Analyze creditworthiness using risk assessment and scoring techniques proficiently. Implement debt management procedures to optimize financial recovery processes. Enhance customer relations through effective communication in credit control practices. Ensure adherence to credit control regulations and compliance standards consistently. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Credit Control Analyst course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Credit Control Analyst. Moreover, this course is ideal for: Finance professionals seeking credit control expertise. Business administrators aiming to enhance financial management skills. Graduates pursuing careers in credit risk analysis and management. Individuals aspiring to work in debt recovery and financial consulting. Entrepreneurs looking to improve credit control within their businesses. Requirements There are no requirements needed to enrol into this Credit Control Analyst course. We welcome individuals from all backgrounds and levels of experience to enrol into this Credit Control Analyst course. Career path After finishing this Credit Control Analyst course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Credit Control Analyst are: Credit Controller - £22K to 35K/year. Credit Analyst - £25K to 40K/year. Risk Analyst - £28K to 45K/year. Financial Analyst - £30K to 50K/year. Compliance Officer - £25K to 45K/year. Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Understanding the Basics of Banking is fundamental in today's interconnected financial landscape. This course delves into the core principles of banking, from its introduction to the myriad activities and services it offers. With modules covering various banking institutions, international banking, financial and risk management, and regulatory frameworks, learners gain comprehensive insights into this crucial sector. In an era where financial literacy is paramount, mastering these skills is essential for navigating personal finances and making informed decisions. Moreover, in the professional realm, proficiency in banking opens doors to lucrative job opportunities, particularly in the UK where the banking sector is robust. Acquiring expertise in banking can lead to roles such as financial analyst, bank manager, or investment banker, with salaries ranging from £30,000 to £100,000 annually, depending on experience and position. The advantages of this Banking course are evident in the increasing demand for skilled professionals in the banking sector, which has seen a steady growth of 3-5% annually, making it a promising field for career advancement. Key Features: CPD Certified Basics of Banking Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum Module 01: Banking An Introduction Module 02: Bank Activities and Services Module 03: Categories and Types of Banking Institutions Module 04: International Banking Module 05: Bank Financial Management Module 06: Bank Risk Management Module 07: Regulatory Framework in Banking Learning Outcomes: Analyze the fundamental principles shaping the foundation of banking operations. Explore diverse services offered by banks and their pivotal role. Differentiate between various banking institutions and their specific characteristics globally. Investigate the dynamics and challenges of international banking in a global context. Acquire insights into financial management strategies tailored for the banking sector. Develop a comprehensive understanding of risk management within the banking industry. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Basics of Banking course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Banking. Moreover, this course is ideal for: Aspiring bankers seeking foundational knowledge for a banking career. Finance professionals aiming to broaden their expertise in banking practices. Students pursuing degrees in finance or related disciplines. Individuals entering the financial sector and eager to grasp banking fundamentals. Career transitioners looking to enter the banking industry with essential knowledge. Requirements There are no requirements needed to enrol into this Basics of Banking course. We welcome individuals from all backgrounds and levels of experience to enrol into this Basics of Banking course. Career path After finishing this Banking Course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Banking are: Financial Analyst - £30K to 50K/year Bank Manager - £40K to 70K/year Compliance Officer - £35K to 60K/year Investment Banker - £50K to 100K/year Risk Manager - £45K to 80K/year Bank Teller - £17K to 25K/year International Banking Specialist - £40K to 80K Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.