597 Finance courses in Cardiff delivered Live Online

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

Duration 3 Days 18 CPD hours This course is intended for The EXIN BCS Artificial Intelligence Foundation certification is focused on individuals with an interest in, (or need to implement) AI in an organization, especially those working in areas such as science, engineering, knowledge engineering, finance, education or IT services. Overview You will be able to Describe how Artificial (AI) is Part of 'Universal Design', and 'The Fourth Industrial Revolution' Demonstrate Understanding of the Artificial Intelligence (AI) Intelligen Agent Description Explain the Benefits of Artificial Intelligence (AI) Describe how we Learn from Data - Functionality, Software and Hardware Demonstrate an Understanding that Artificial Intelligence (AI) (in Particular, Machine Learning (ML)) will Drive Humans and Machines to Work Together Describe a ''Learning from Experience'' Agile Approach to Projects Candidates should be able to demonstrate a knowledge and understanding in the application of ethical and sustainable Artificial Intelligence (AI):- Human-centric Ethical and Sustainable Human and Artificial Intelligence (AI) Ethical and Sustainable Human and Artificial Intelligence (AI) Recall the General Definition of Human and Artificial Intelligence (AI) Describe what are Ethics and Trustworthy Artificial Intelligence (AI) Describe the Three Fundamental Areas of Sustainability and the United Nationïs Seventeen Sustainability Goals Describe how Artificial Intelligence (AI) is Part of 'Universal Design', and 'The Fourth Industrial Revolution' Understand that Machine Learning (ML) is a Significant Contribution to the Growth of Artificial Intelligence (AI) Artificial Intelligence (AI) and Robotics Demonstrate Understanding of the Artificial Intelligence (AI) Intelligent Agent Description Describe what a Robot is Describe what an intelligent Robot is Applying the Benefits of Artificial Intelligence (AI) ? Challenges and Risks Describe how Sustainability Relates to Human-Centric Ethical Artificial Intelligence (AI) and how our Values will Drive our use of Artificial Intelligence (AI) and will Change Humans, Society and Organizations Explain the Benefits of Artifical Intelligence (AI) Describe the Challenges of Artificial Intelligence (AI) Projects Demonstrate Understanding of the Risks of Artificial Intelligence (AI) Projects List Opportunities for Artificial Intelligence (AI) Identify a Typical Funding Source for Artificial Intelligence (AI) Projects and Relate to the NASA Technology Readiness Levels (TRLs) Starting Artificial Intelligence (AI): how to Build a Machine Learning (ML) Toolbox ? Theory and Practice Describe how we Learn from Data - Functionality, Software and Hardware Recall which Rypical, Narrow Artificial Intelligence (AI) Capability is Useful in Machine Learning (ML9 and Artificial Intelligence (AI) AgentsïFunctionality The Management, Roles and Responsibilities of Humans and Machines Demonstrate an Understanding that Artificial Intelligence (AI) (in Particular, Machine Learning (ML)) will Drive Humans and Machines to Work Together List Future Directions of Humans and Machines Working Together Describe a ''Learning from Experience'' Agile Approach to Projects

Become a Certified Digital Leader Designed for: IT managers and business managers Consultants Project managers Key take aways from this leadership course (non-technical): Be comfortable with digital trends and technologies Leverage digital for your business Organise digital and manage digital transformation successfully Module 1 - Digital concepts Digital building blocks Digital lifecycle Big Data strategy Module 2 - Digital strategy Strategy Golden triangle of digital transformation Opportunity analysis Module 3 - Digital marketing Advertising Funnels E-commerce Module 4 - Digital economy Competitive landscape Influencers Legislation Module 5 - Digital finance Digital investments Defining budgets for digital ROI of digital marketing Module 6 - Information risks Information security concepts AI risks Privacy and Intellectual Property Module 7 - Organising digital Organisational design Iterative approaches Module 8 - Leading the digital workforce Digital mindset Robots & human workforce Industry 4.0 Module 9 - Leading Digital Transformation programmes Product development & Innovation Programme management Organisational change Case studies 3 business cases

Course Overview: This course provides a comprehensive introduction to cryptocurrencies, blockchain technology, and their broader implications in the financial world. Learners will gain an understanding of how cryptocurrencies work, the underlying technology of blockchain, and the variety of available cryptocurrencies. The course also explores the future potential of cryptocurrencies, including opportunities in decentralised finance (DeFi) and NFTs. Upon completion, learners will be equipped with the knowledge to navigate the rapidly evolving cryptocurrency market, make informed investment decisions, and understand the legal landscape in the UK. Course Description: This course covers a wide range of topics essential to understanding the world of cryptocurrencies. Learners will delve into the fundamentals of cryptocurrencies and blockchain technology, exploring how decentralised systems work. The course introduces various types of cryptocurrencies, their uses, and the role of NFTs in the digital space. Learners will also cover the critical aspects of cryptocurrency wallets, security measures, and how decentralised finance is reshaping financial systems. The course also includes modules on cryptocurrency investment strategies and the evolving legal frameworks in the UK. By the end of the course, learners will have a solid understanding of the cryptocurrency ecosystem and its future trajectory. Course Modules: Module 01: The Fundamentals of Cryptocurrencies Module 02: The Blockchain Module 03: Types of Cryptocurrencies Module 04: NFTs Module 05: Cryptocurrency Wallets Module 06: Cryptocurrency Security Module 07: Decentralised Finance Module 08: Investing in Cryptos Module 09: Opportunities and Future of Cryptocurrencies Module 10: Cryptocurrency Laws in the UK (See full curriculum) Who is this course for? Individuals seeking to understand the basics of cryptocurrencies Professionals aiming to expand their knowledge in blockchain technology Beginners with an interest in digital finance and investment opportunities Anyone looking to stay informed about future trends in cryptocurrency Career Path: Cryptocurrency Analyst Blockchain Developer DeFi Specialist Investment Advisor (Cryptocurrencies) Financial Consultant Legal Advisor for Cryptocurrency Regulations

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Duration 1 Days 6 CPD hours This course is intended for IT Asset Managers and other IT professionals involved in Asset Management, resource budgeting, finance, software licensing, contract management and strategic planning. Overview Students earning a CHAMP certification will see financial benefits of enhanced Hardware Asset Management best practices and uncover many savings opportunities to increase their organizations' bottom line by managing the lifecycle of the hardware asset. They will receive an awareness of several avenues for savings, compliance, global disposal and revenue generation practices for properly managing the lifecycle of hardware assets. Designed to address the numerous issues plaguing professionals in managing hardware assets, the IAITAM Certified Hardware Asset Management Professional (CHAMP) Course follows the lifecycle of IT hardware assets beyond the scope of the cradle to grave analogy and discusses the business practices that can best be used to manage those assets efficiently and cost-effectively. Emphasis is placed on identifying the policies that enhance lifecycle management. In general, policies are only effective if developed by a cross-section of the impacted departments, are reviewed frequently to remain current and are consistently communicated and enforced. The course is followed by a certification test for those that wish to achieve CHAMP certification. Course Outline Basics of Hardware Asset Management The Power of ITAM Centralization Best Practices for Asset Standards Implementing a Program Project Planning Change Management Measuring Success Tools & Automation Repository Tool Discovery Tool Acquisition & Receiving Selection & Negotiations Managing the Inventory Management During Use IMAC Process Improving the Program Improving the Value of Assets Hardware Security Reuse & Disposal Processes E-waste Decisions Evaluating ITAD Vendors Additional course details: Nexus Humans Certified Hardware Asset Management Professional (CHAMP) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Certified Hardware Asset Management Professional (CHAMP) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Learn how to use Xero, Sage, or Quickbooks Onlines, whilst understanding the bookkeeping prinicples behind it.

Root Cause Analysis (RCA) is used to analyse the root causes of focus events with both positive and negative outcomes, but it is most commonly used for the analysis of failures and incidents. Causes for such events can be varied in nature, including design processes and techniques, organizational characteristics, human aspects and external events. RCA can be used for investigating the causes of non-conformances in quality (and other) management systems as well as for failure analysis, for example in maintenance or equipment testing.

Take things a step further and improve your knowledge of some of the more niche Excel techniques to help manage your data