3297 Courses delivered Online

Microsoft Excel 2021 has quietly slipped in a bundle of new functions that can turn even the most mundane spreadsheets into efficient data-processing machines. This course introduces the latest features like XLOOKUP, LET, FILTER, SEQUENCE, and TEXTSPLIT, which not only simplify formulas but make spreadsheets smarter and tidier. Whether you’re an analyst trying to avoid circular references or someone who’s simply tired of tangled VLOOKUPs, this course brings clarity to your cells—no pun intended. Tailored for Excel users who know the ropes but want to keep up with what's new, this course ensures you don’t fall behind the curve. You’ll explore function upgrades that tidy up old formulas, save time, and help you work cleaner and quicker. With a thoughtful structure and a lightly witty tone, the course content walks you through updates that genuinely make a difference—without drowning you in geek speak. Excel’s had a makeover, and it's about time your formulas caught up. Learning Outcomes: Understand the purpose and benefits of new Excel functions. Apply the RANDARRAY function to generate random data. Use the UNIQUE function to extract unique values from a data range. Create custom number sequences with the SEQUENCE function. Sort data effectively with the SORT and SORTBY functions. Filter data easily with the FILTER function. Unlock the full potential of Microsoft Excel with our new course, "The Theory of Constraints and Throughput Accounting." In just a few modules, you'll learn how to utilise the latest functions in Excel to quickly sort, filter, and analyse data. By the end of the course, you'll be equipped with the knowledge to efficiently organise even the most complex datasets. But this course isn't just about learning new functions - it's about applying them to real-world scenarios. With practical examples and exercises throughout the course, you'll learn how to use these functions in meaningful ways. The benefits of this course are clear: increased productivity, better data analysis, and more efficient workflow. Don't miss out on this opportunity to take your Excel skills to the next level - enroll in "The Theory of Constraints and Throughput Accounting" today. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Upon completing the Functional Maths Training Course, you can venture into diverse job opportunities across various industries, encompassing positions and pay scales that include: Data Analyst - £31,000 per year (average salary) Financial Analyst - £34,000 per year (average salary) Business Intelligence Analyst - £39,000 per year (average salary) Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Description: This Microsoft Office 2013 Excel Advanced - Complete Video Course covers the advanced functions and features of Excel 2013. You will learn about working with multiple worksheets and automating and auditing worksheets, how to update workbook properties, and how to apply conditional formatting. You will also learn how to export, analyze and present Excel data. This Advanced level is designed for you to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. This course is intended for them who have intermediate skills with Microsoft Excel 2013, and want to learn more advanced skills or want to learn the topics covered in this course in the 2013 interface. So, brush up your basic and intermediate knowledge and be an expert with the help of this course. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2013 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2013 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Automating Worksheet Functionality Update Workbook Properties FREE 00:07:00 Create and Edit a Macro 00:15:00 Apply Conditional Formatting 00:09:00 Add Data Validation Criteria 00:10:00 Auditing Worksheets Trace Cells 00:05:00 Troubleshoot Invalid Data and Formula Errors 00:12:00 Watch and Evaluate Formulas 00:10:00 Create a Data List Outline 00:09:00 Analyzing and Presenting Data Create Sparklines 00:13:00 Create Scenarios 00:12:00 Perform a What If Analysis 00:19:00 Perform a Statistical Analysis with the Analysis ToolPak 00:06:00 Create Interactive Data with Power View 00:10:00 Working With Multiple Workbooks Consolidate Data 00:10:00 Link Cells in Different Workbooks 00:10:00 Merge Workbooks 00:08:00 Exporting Excel Data Export Excel Data 00:06:00 Import a Delimited Text File 00:09:00 Integrate Excel Data with the Web 00:11:00 Create a Web Query 00:08:00 Mock Exam Mock Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2013 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Easily learn the skills and knowledge you desire in tax management with our Diploma in Advanced Tax Accounting at QLS Level 5 Course, you get an unparalleled learning experience with us and you get a digital certificate, transcript and a student ID card all included with the course price. What makes us the go to choice for people who want to learn about tax management is our dedication and commitment to providing you with the best service possible. You will get unlimited access to the Diploma in Advanced Tax Accounting at QLS Level 5, no matter where you are in the world you will be able to access your Diploma in Advanced Tax Accounting at QLS Level 5 any time you want. Should you have any questions while studying this Diploma in Advanced Tax Accounting at QLS Level 5, our experienced tutors and mentors will answer them via email and live chat. With the original certificate you get after completing your Diploma in Advanced Tax Accounting at QLS Level 5 you will gain the CPD qualifications that will help you succeed out in the world and in your career. With our Student ID card you will get discounts on things like music, food, travel and clothes etc. Enrol in our Diploma in Advanced Tax Accounting at QLS Level 5 today and start learning. Why choose this Diploma in Advanced Tax Accounting at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Diploma in Advanced Tax Accounting at QLS Level 5 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. Who is this Diploma in Advanced Tax Accounting at QLS Level 5 course for? Aspiring tax accountants aiming to solidify their foundation in UK taxation. Finance students seeking in-depth knowledge on taxation and related accountancy principles. Small business owners needing to comprehend the tax implications for their ventures. Professionals in the financial sector intending to broaden their understanding of tax systems. Individuals aiming to handle their personal tax affairs with increased confidence. Career path Aspiring tax accountants aiming to solidify their foundation in UK taxation. Finance students seeking in-depth knowledge on taxation and related accountancy principles. Small business owners needing to comprehend the tax implications for their ventures. Professionals in the financial sector intending to broaden their understanding of tax systems. Individuals aiming to handle their personal tax affairs with increased confidence. Prerequisites This Diploma in Advanced Tax Accounting at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Advanced Tax Accounting at QLS Level 5 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Advanced Tax Accounting Module 01: Tax System and Administration in the UK 00:25:00 Module 02: Tax on Individuals 00:23:00 Module 03: National Insurance 00:13:00 Module 04: How to Submit a Self-Assessment Tax Return 00:12:00 Module 05: Fundamental of Income Tax 00:22:00 Module 06: Advanced Income Tax 00:39:00 Module 07: Payee, Payroll and Wages 00:18:00 Module 08: Value Added Tax 00:24:00 Module 09: Corporation Tax 00:17:00 Module 10: Capital Gain Tax 00:24:00 Module 11: Inheritance Tax 00:29:00 Module 12: Import and Export 00:20:00 Module 13: Double Entry Accounting 00:11:00 Module 14: Management Accounting and Financial Analysis 00:14:00 Module 15: Career as a Tax Accountant in the UK 00:16:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Forex Trading and AML course might help you get there! Expand your expertise with high-quality training - study the Forex Trading and AML course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Forex Trading and AML online training course. The Forex Trading and AML course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Forex Trading and AML course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Forex Trading and AML training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Forex Trading and AML course: Course 01: AML (Anti Money Laundering) Module 01: Introduction to Money Laundering What Is Money Laundering? Turning 'Bad' Money into 'Legitimate' Money How Is Money Laundered? Why Are AML Efforts Important? The Three Stages of Money Laundering Module 02: Proceeds of Crime Act 2002 Introduction The Principal Offences Contained in Part 7 of POCA 2002 The Notion of Criminal Property Elements of Criminal Property The Concept of Knowledge The Notion of Suspicion Module 03: Development of Anti-Money Laundering Regulation Introduction The First Money Laundering Directive Terrorism legislation The Proceeds of Crime Act 2002 and Serious Organised Crime and money laundering offences under the Police Act 2005 The Second Money Laundering Directive The Third Money Laundering Directive The Fourth Money Laundering Directive The Fifth Money Laundering Directive Module 04: Responsibility of the Money Laundering Reporting Officer What Is a Money Laundering Reporting Officer? Who Can be Appointed as an MLRO? The Role of The Money Laundering Reporting Officer Module 05: Risk-based Approach Introduction What Is a Risk-Based Approach (RBA)? A Risk-Based Approach to Customer Due Diligence (CDD) How to Assess the Risk Profile of The Entity How to Assess Client Risk Conducting the Client Risk Assessment Module 06: Customer Due Diligence What is Customer Due Diligence? Main Elements of a Customer Due Diligence Program Enhanced Due Diligence Enhanced Due Diligence for Higher-Risk Customers Account Opening, Customer Identification and Verification Consolidated Customer Due Diligence Module 07: Record Keeping The Purpose of Record-Keeping What Records Have to be Kept? Customer Identification In What Form Should Records be Kept? Failure to Keep Records Module 08: Suspicious Conduct and Transactions What Is Suspicious Activity? What Is a Suspicious Transaction? Avoiding a National Reporting or Record-Keeping Requirement Wire or Fund Transfers Insufficient or Suspicious Information by a Customer Other Suspicious Customer Activity The Identification of Unusual Transactions The Types of Events That Might Cause Suspicion Module 09: Awareness and Training The Importance of Staff Awareness and Training The Core Obligations of Training Legal and Regulatory Obligations Staff Responsibilities Internal Training Procedures Course 02: Forex Trading Diploma Introduction Major Currencies and Market Structure87 Kinds of Foreign Exchange Market Trading Psychology Money Management Fundamental Analysis Pitfalls and Risks Managing Risk Trading Psychology Assessment Process Once you have completed all the modules in the Forex Trading and AML course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Forex Trading and AML course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Forex Trading and AML course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

Overview 2 day course on single name CDS, index CDS and index CDS options and how to use them to express views and hedge risks in credit markets Who the course is for Consultants Analysts Managers C-Level executives People in need of knowledge to develop a blockchain strategy People working with blockchain projects Regulators Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview 1 day course covering mechanics, pricing and applications of cross currency swaps (CCS) and cross currency basis swaps (CCBS) Who the course is for Corporate treasurers and financial institution asset-liability management staff Interest rate and FX derivative traders, salespeople and quants Multi-lateral development banks Fixed income asset managers Risk management Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Overview A 1-day course on inflation-linked bonds and derivatives, focusing on the UK market in particular. We examine how inflation is defined and quantified, the choice of index (RPI vs. CPI), and the most common cash flow structures for index-linked securities. We look in detail at Index-linked Gilts, distinguishing between the old-style and new-style quotation conventions, and how to calculate the implied breakeven rate. Corporate bond market in the UK, and in particular the role of LPI in driving pension fund activity. Inflation swaps and other derivatives, looking at the mechanics, applications and pricing of inflation swaps and caps/floors. The convexity adjustment for Y-o-Y swaps is derived intuitively. Who the course is for Front-office sales Product control Research Traders Risk managers Fund managers Project finance and structured finance practitioners Accountants, auditors, consultants Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

Embark on a journey to establish a successful cleaning business in the UK with our comprehensive course. Learn start-up costs, business models, legal aspects, and client satisfaction strategies. Ideal for entrepreneurs eager to thrive in the cleaning industry.

Customer Service Manager with Telephone Etiquette & KYC Diploma Elevate your career in the service industry with our Customer Service Manager with Telephone Etiquette & KYC Diploma. Master Customer Service strategies, telephone etiquette, and KYC procedures. Become a Customer Service maven and set yourself apart. Learning Outcomes: Implement effective Customer Service models. Manage customer relationships through proven Customer Service tactics. Resolve conflicts with angry customers using Customer Service skills. Enhance telephone communication with focused Customer Service training. Apply Customer Service principles in Know Your Customer (KYC) methods. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Customer Service Manager with Telephone Etiquette & KYC Diploma: Customer Service Models: Implement and evaluate proven Customer Service models for organizational excellence. Customer Management: Excel in customer relationship management by integrating Customer Service best practices. Dealing With Angry Customers: Apply Customer Service techniques to defuse conflicts and enhance customer satisfaction. Talking The Right Way On The Phone: Master telephone etiquette, elevating your Customer Service delivery to a new level. Understanding Customer Due Diligence: Adopt Customer Service principles in conducting comprehensive customer due diligence. KYC Methods: Implement Know Your Customer (KYC) procedures, fortified by excellent Customer Service practices.

Level 4 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access