6369 Courses in Cardiff delivered Online

Submit tax returns and self-assessments like a pro as we simplify the jargon and provide essential information on all things HMRC Navigating Tax and Self-Assessment Join us for an online event where we'll demystify the world of taxes and self-assessment. Whether you're a freelancer, small business owner, or just curious about managing your finances as a start-up, this event is for you! Our Chartered Certified Accountant, Mandeep Ubhi, is an expert in his field and will break down complex tax jargon into easy-to-understand language, giving you the confidence to tackle your tax obligations; from understanding tax allowances to filing your self-assessment, we've got you covered. Take advantage of this opportunity to gain valuable insights and tips to easily navigate the tax landscape!

New Excel Functions   Course Description   Ross Maynard     Description In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions. The functions I am going to cover are: RANDARRAY- creating a table of random numbers or random dates UNIQUE – identifying the distinct items in a list SEQUENCE – listing numbers with a set interval SORT and SORTBY – new ways of dynamically sorting data FILTER – building the ability to filter data into formulae XLOOKUP – replacing VLOOKUP with greater flexibility IFS and SWITCH making it easier to construct IF statements The new CONCAT, and TEXTJOIN text functions   If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.         Learning Outcomes Participants in this course will learn: What the new dynamic arrays feature in Microsoft Excel means How the new RANDARRAY function works How the new UNIQUE function works How the new SEQUENCE function works How the new SORT and SORTBY functions work How the new FILTER function works How the new XLOOKUP function can replace VLOOKUP How to build IF statements with the new IFS function How the new SWITCH function works How the new TEXTJOIN function can replace CONCATENATE and CONCAT How the new functions can be used in management reporting     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.       About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

This bundle course has been specially designed to equip our learners with a more in-depth understanding of lettings negotiating by providing them with essential functional maths skills required for this role. By combining these related courses, learners will be able to apply their practical knowledge in the real world, to take their professionalism to the next level. Take steps to become a certified lettings negotiator and be equipped with the skills and practical knowledge to advise clients and support landlords in renting their properties with the Lettings negotiator Diploma. This beginners training program is designed to provide an insight into lettings management, exploring the role of a lettings negotiator and lettings agent in detail. You will learn about the different types of agents, how to carry out a property valuation, build a relationship with clients and much more. Possessing excellent maths skills is essential for anyone who wishes to work in the property market. The Functional Maths Training Course is designed to provide aspiring lettings negotiators with the necessary skills to master everyday maths problems related to lettings management. You will learn how to calculate overall profit and loss, develop crucial problem-solving skills and gain confidence in working with decimals, fractions and percentages. This training program includes practical exercises that can be applied in real-world scenarios and is an opportunity to learn valuable transferable skills. Learning Outcomes: Learn the fundamental principles and practices of lettings management Familiarise with the lettings agency agreements guideline Understand the differences between a lettings agent and estate agent Explore the day-to-day role and responsibilities of a lettings agent Develop a solid understanding of the property valuation process Gain advanced knowledge of functional maths and apply your new skills to everyday situations Develop your skills in logical thinking and problem-solving Learn how to work with decimals, percentages, fractions and much more Gain a solid understanding of ratios and proportion through practical exercises Understand how to calculate overall profit and loss Who is This Course for? This bundle course is ideal for aspiring lettings negotiators, or lettings agents who are new to the field and wish to gain the relevant skills and knowledge to take their career to the next level. This course is also ideal for anyone who works in the real estate industry and wishes to develop their skills in everyday maths. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. 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 bundle course is the ultimate package training certification for those who are interested in a career in property. On successful completion, you will have the opportunity to work in a wide range of related industries, in roles such as: Lettings Negotiator Lettings Agent Manager Estate Agent or Lettings Manager Course Curriculum **Letting Agent** Lettings Management Introduction to Lettings Management 00:20:00 Necessary Documents for Lettings Management 01:30:00 Lettings Agency Agreements Guideline 00:15:00 Types of Agents 00:15:00 Knowing Your Clients 00:30:00 Lettings Management Agent Services 00:20:00 Property Valuation 00:30:00 Property Negotiation 00:30:00 Property Management 00:30:00 Lettings Management Laws 00:30:00 Letting Agent Code of Practice Introduction to Letting Agent Code of Practice 00:20:00 Overarching Standards of Practice 00:30:00 Lettings 00:30:00 Management and Maintenance 00:20:00 Ending the Tenancy and Communications & Resolving Complaints 00:15:00 Arrangements 00:15:00 Being a Lettings Negotiator Home Loans 00:15:00 Knowing When You're Ready To Buy 00:15:00 Is Your Lake Home For Sale? 01:00:00 Legal System & Lettings Management UK An Introduction to the UK legal system 00:15:00 Different Types of Investment Structures 00:15:00 Title & Registration 00:15:00 Finance in Lettings Management 00:15:00 Investment Purchase Procedure 00:15:00 Acquisition Costs 00:15:00 Land Usage 00:15:00 Planning & Environment 00:15:00 Investment Structure & Key Legislations 00:15:00 **Functional Skills (Maths)** Integers ( Directed Numbers) Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Factors and Multiples Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Fractions Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fraction 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Simplification Rule : BODMAS Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Decimal numbers Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Rational Numbers Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Approximation Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Estimation and Scientific Notation or Standard form Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Percentage Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Ratio and Proportion Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51 To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Unitary Method and its Applications Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Profit , Loss, discount and Tax Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Compliance Management Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Compliance Management Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Compliance Management Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Compliance Management Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Compliance Management? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Compliance Management there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Compliance Management course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skills. Prerequisites This Compliance Management does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Compliance Management was made by professionals and it is compatible with all PCs, Macs, 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. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Compliance Management is a great way for you to gain multiple skills from the comfort of your home.   Compliance Management - Updated Version Module 01: Introduction to Compliance 00:17:00 Module 02: Five basic elements of compliance 00:25:00 Module 03: Compliance Management System (CMS) 00:26:00 Module 04: Compliance Audit 00:38:00 Module 05: Compliance and Ethics 00:26:00 Module 06: Risk and Types of Risk 00:25:00 Module 07: Introduction to Risk Management 00:25:00 Module 08: Risk Management Process 00:18:00 Mock Exam Final Exam Compliance Management - Old Version Module 1: Introduction to Compliance 00:10:00 Module 2: Compliance Management System 00:15:00 Module 3: Basic Elements of Effective Compliance 00:15:00 Module 4: Compliance Audit 00:20:00 Module 5: Compliance and Ethics 00:20:00 Module 6: Introduction to Risk and Basic Risk Types 00:20:00 Module 7: Further Risk Types 00:20:00 Module 8: Introduction to Risk Management 00:10:00 Module 9: Risk Management Process 00:10:00 Module 10: Risk Assessment and Risk Treatment 00:20:00 Module 11: Types of Risk Management 00:20:00 Assignment Assignment - Compliance Management 02:40:00 Recommended Materials Workbook - Compliance Management 04:00:00

This course will fully prepare you for virtually any Excel-related career path

From beginner to expert, this course will help you advance your career using Microsoft Excel skills.

A special focus will be put on advanced MS Excel tips and tricks for career advancement in this course.

Duration 3 Days 18 CPD hours This course is intended for Experienced IT Asset Managers Overview By attending this course the attendee will be able to Understand and utilize the dependencies, relationships and benefits of the KPAs found within an effective IT Asset Management Program specify and define the duties and responsibilities necessary to be an effective IT Asset Manager be able to obtain and display an understanding of the resources and commitment necessary to implement a fully functional IT Asset Management Program. Attendees will learn about the entire ITAM Program and take with them the foundation plan for starting or improving their organization?s ITAM Program. The intense three-day course with certification is packed full of information and real-world experiences designed to make your ITAM Program more effective and efficient, and the CITAM Certification will lend notable credibility to both you and your ITAM Program.This course addresses each of the Key Process Areas (KPAs) identified within the IBPL that, when combined, empowers an organization and maximizes the value of their IT assets. The course will also review the core processes that encompass the ITAM Program and the projects that will help an organization build a productive and profitable business unit.The course includes exam for CITAM certification. Course Outline IAITAM and the Mission ITAM Code of Ethics Defining Primary Roles in an ITAM Program IAITAM?s 12 KPAs Relationships, Dependencies, and Benefits KPA Interdependencies Roles and Responsibilities Creating Dynamic Job Descriptions for ITAM Programs The Role of a Program Manager Project Management Relationship Triangle Sample Projects by KPA Prioritization and the ITAM Program Lifecycle Management Process Building Best Practices Gaining Executive Buy-in Business Case Template Maturity Assessment ITAM as a Core Business Function Additional course details: Nexus Humans Certified IT Asset Manager (CITAM) 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 IT Asset Manager (CITAM) 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.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing.  Objectives   By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization