6453 Finance courses

------------------------NEW YEAR SALE ENDS TODAY------------------------ Give a compliment to your career and take it to the next level. This Fraud Management & Anti Money Laundering Awareness Complete Diploma bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Fraud Management & Anti Money Laundering Awareness Complete Diploma bundle will help you stay ahead of the pack. Throughout the Fraud Management & Anti Money Laundering Awareness Complete Diploma programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Fraud Management & Anti Money Laundering Awareness Complete Diploma course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Fraud Management & Anti Money Laundering Awareness Complete Diploma Bundle Consists of the following Premium courses: Course 01:Fraud Management & Anti Money Laundering Awareness Complete Diploma Course 02:Financial Investigator Course 03:Financial Analysis Course 04:Team Management Course 05:Internal Audit Training Diploma Course 06:Training of Compliance Officer Level 3 Course 07:Level 3 Tax Accounting Course 08:GDPR Data Protection Level 5 Course 09:English Law and Legal System Level 3 Course 10:Workplace Confidentiality Course 11:Human Rights Enrol now in Fraud Management & Anti Money Laundering Awareness Complete Diploma to advance your career, and use the premium study materials from Apex Learning. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Fraud Management & Anti Money Laundering Awareness Complete Diploma expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum Course 01: Fraud Management & Anti Money Laundering Awareness Complete Diploma Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Office Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Course 02: Financial Investigator Module 01: Introduction to Financial Investigator Module 02: Introduction to Financial Investigation Module 03: Characteristics of Financial Crimes Module 04: Categories of Financial Crimes Module 05: Financial Crime Response Plan Module 06: Collecting, Preserving and Gathering Evidence Module 07: Laws against Financial Fraud Course 03: Financial Analysis Section-1. Introduction Section-2. Profitability Section-3. Return Ratio Section-4. Liqudity Ratio Section-5.Operational Analysis Section-6. Detecting Manipulation And Much More... CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Fraud Management & Anti Money Laundering Awareness Complete Diploma bundle. Requirements This Fraud Management & Anti Money Laundering Awareness Complete Diploma course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Fraud Management & Anti Money Laundering Awareness Complete Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost

In the dynamic landscape of the UK job market, staying abreast of industry demands is paramount. The recent surge in construction hazards in the UK has underscored the critical need for adept professionals in Payroll Management. Our comprehensive diploma courses not only address this pressing issue but also equip you with a multifaceted skill set crucial for diverse financial roles. Learning Outcomes Upon completion of this Payroll Management bundle, you should be able to: Master payroll administration for effective financial management. Navigate accounting complexities with a diploma in accounting and bookkeeping. Understand the intricacies of UK pension systems for sound financial planning. Enhance legal acumen through Law and Contracts - Level 2. Harness the power of Sage 50 Accounts for streamlined financial processes. Develop essential office skills and advanced proficiency in Microsoft Excel. Gain expertise in GDPR data protection and anti-money laundering practices. Our curriculum, ranging from Payroll Management to Bookkeeping and Payroll Administration, not only delves into the intricacies of financial management but also extends to areas like pension schemes, legalities, and data protection. Moreover, our courses integrate practical tools such as Sage 50 Accounts and Microsoft Excel Level 3, ensuring you are proficient in the latest technologies. This Payroll Management Bundle Consists of the following Premium courses: Course 01: Payroll Management - Diploma Course 02: Bookkeeping and Payroll Administration Diploma Course 03: Payroll Management - Diploma Course 04: Diploma in Accounting and Bookkeeping Course 05: Pension UK Course 06: Law and Contracts - Level 2 Course 07: Sage 50 Accounts Course 08: Office Skills Course 09: Microsoft Excel Level 3 Course 10: GDPR Data Protection Course 11: Certificate in Anti-Money Laundering (AML) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking a comprehensive understanding of financial management. Professionals aiming to enhance their proficiency in payroll administration. Aspirants looking to broaden their knowledge in accounting and bookkeeping. Those interested in gaining insights into pension schemes and financial planning. Individuals keen on advancing their legal acumen in contracts and legislation. Anyone desiring expertise in data protection and anti-money laundering practices. Requirements No requirements to enrol this Payroll Management Training course. Career path Payroll Administrator: £25,000 - £35,000 per annum Bookkeeper: £22,000 - £30,000 per annum Accounting Assistant: £23,000 - £32,000 per annum Legal Support Officer: £26,000 - £35,000 per annum Compliance Analyst: £30,000 - £40,000 per annum Data Protection Officer: £35,000 - £45,000 per annum Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Payroll Management - Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

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.

This Diploma in Internal Audit Skills at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Internal Audit at QLS Level 5 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Internal Audit at QLS Level 5 course. Due to Internal Audit at QLS Level 5's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Internal Audit at QLS Level 5 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Internal Audit at QLS Level 5 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 Internal Audit at QLS Level 5 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 Internal Audit at QLS Level 5 course. This Internal Audit at QLS Level 5 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 This Internal Audit at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. 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 Internal Audit at QLS Level 5 course: Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Auditor Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Internal Audit Skills at QLS Level 5 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Internal Audit at QLS Level 5 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Internal Audit at QLS Level 5 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included Diploma in Internal Audit Skills at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Internal Audit Skills at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

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

Overview This comprehensive course on Landscape Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Landscape Photography comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Landscape Photography. It is available to all students, of all academic backgrounds. Requirements Our Landscape Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 79 lectures • 05:13:00 total length •Module 01: Introduction to Nature Photography: 00:02:00 •Module 02: What Is Landscape Photography?: 00:01:00 •Module 01: Overall: 00:01:00 •Module 02: Camera: 00:02:00 •Module 03: Sensors: 00:02:00 •Module 04: Lenses: 00:03:00 •Module 05: Pro vs Budget Lenses: 00:03:00 •Module 06: Prime Lenses: 00:02:00 •Module 07: Tripod: 00:03:00 •Module 08: Filters: 00:02:00 •Module 09: Other Accessories: 00:04:00 •Module 01: Introduction to Camera Basic: 00:01:00 •Module 02: ISO: 00:03:00 •Module 03: ISO Practical: 00:03:00 •Module 04: ISO Practical Night: 00:02:00 •Module 05: Shutter Speed: 00:01:00 •Module 06: Practical of Shutter Speed: 00:03:00 •Module 07: Shutter Speed Waterfall: 00:04:00 •Module 08: Aperture: 00:03:00 •Module 09: Practical Aperture: 00:05:00 •Module 10: Aperture Low Light Photography: 00:03:00 •Module 11: Exposure Triangle: 00:03:00 •Module 12: Aperture Priority: 00:03:00 •Module 01: Introduction to Advanced Camera Basics: 00:02:00 •Module 02: Histogram: 00:03:00 •Module 03: Expose to the Right: 00:02:00 •Module 04: Metering Modes: 00:02:00 •Module 05: Exposure Compensation: 00:02:00 •Module 06: RAW vs JPEG: 00:03:00 •Module 07: What is RAW?: 00:02:00 •Module 08: Dynamic Range: 00:03:00 •Module 09: White Balance: 00:03:00 •Module 01: Introduction to Focusing: 00:01:00 •Module 02: Hyperfocal Distance vs Single Point: 00:03:00 •Module 03: Aperture in Focusing: 00:02:00 •Module 04: Aperture, Focusing & Lens: 00:03:00 •Module 05: Focusing with a Wide-Angle Lens: 00:05:00 •Module 06: Focusing For Telephoto Photography: 00:04:00 •Module 01: What is a Polarizing Filter?: 00:02:00 •Module 02: How a Polarizer Works Near Waterfalls: 00:03:00 •Module 03: How a Polarizer Works Reducing Haze: 00:03:00 •Module 04: What is Nd Filter?: 00:02:00 •Module 05: Nd Filter to Achieve Silky Water: 00:04:00 •Module 06: What is Color Cast?: 00:02:00 •Module 01: Introduction to Exposure: 00:01:00 •Module 02: Dynamic Range & Expose to the Right: 00:04:00 •Module 03: The Impact of Light in Photography: 00:03:00 •Module 04: Finding the Correct Light: 00:04:00 •Module 05: Single Exposure Sunset: 00:04:00 •Module 06: Why Exposure Bracketing Helps You to Take Better Image: 00:05:00 •Module 01: Introduction to Composition: 00:01:00 •Module 02: Element of Composition: 00:03:00 •Module 03: Rules of Third: 00:04:00 •Module 04: Farming a Subject: 00:02:00 •Module 05: Leading Lines: 00:05:00 •Module 06: Diagonals: 00:03:00 •Module 07: Using S and Z curves: 00:05:00 •Module 08: Changing Perspective with Different Focal Ranges: 00:05:00 •Module 09: Changing Perspective through Framing: 00:02:00 •Module 10: Simple Reflection Photography: 00:03:00 •Module 01: Wide-Angle Photography: 00:04:00 •Module 02: Telephoto Photography: 00:06:00 •Module 03: Focus Stacking: 00:12:00 •Module 04: Panoramic: 00:07:00 •Module 05: Creating Scales: 00:03:00 •Module 06: Minimalist Nature Photography: 00:04:00 •Module 07: Creating Leading Lines from Long Exposure: 00:04:00 •Module 01: Introduction to Photo Editing: 00:01:00 •Module 02: Editing in Lightroom: 00:06:00 •Module 03: Global Adjustment: 00:21:00 •Module 04: Local Adjustment: 00:12:00 •Module 05: Histogram (Expose to the Right): 00:07:00 •Module 06: Grab Filter Effect: 00:12:00 •Module 07: Editing an Image like a Professional: 00:17:00 •Module 08: How to Focus Stack: 00:12:00 •Module 09: How to Remove Color Cast: 00:04:00 •Module 10: How to Blend Multiple Image: 00:05:00 •Module 11: How to Stitch a Pano: 00:07:00 •Assignment - Landscape Photography: 00:00:00

Course Description Get instant knowledge from this bite-sized Financial Wellness: Managing Personal Cash Flow Part - 2 course. This course is very short and you can complete it within a very short time. In this Financial Wellness: Managing Personal Cash Flow Part - 2 course you will get fundamental ideas of managing personal cash flow, the key understanding of designing a personal budget, personal insurance and so on. Enrol in this course today and start your instant first step towards learning about borrowing, credit and debt. Learn faster for instant implementation. Learning Outcome Understand borrowing, credit and debt Know how to design a personal budget Understand tax and financial strategies Learn about managing personal insurance Gain an excellent understanding of money and mental health How Much Do Cashflow Managers Earn?  Senior - £64,000 Average - £38,000 Starting - £23,000 Requirement Our Financial Wellness: Managing Personal Cash Flow Part - 2 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. Financial Wellness: Managing Personal Cash Flow Part - 2 Module 01: Borrowing, Credit and Debt 00:19:00 Module 02: Managing Personal Insurance 00:19:00 Module 03: Understanding Tax and Financial Strategies 00:40:00 Module 04: Designing a Personal Budget 00:17:00 Module 05: Money and Mental Health 00:15:00 Assignment Assignment - Financial Wellness: Managing Personal Cash Flow Part - 2 00:00:00

Imagine stepping into a world where you hold the key to making lives better. The Caregiver course is like a superhero guide for those wanting to help people in health and social care. It's not just about learning; it's about becoming a real-life hero. As caregivers, the importance of understanding communication, rights, and responsibilities cannot be overstated. It's a field where empathy meets expertise, and this course delves into legal, ethical, and safety aspects crucial for effective caregiving. By unravelling the intricacies of healthcare economics and service delivery, learners gain a holistic perspective, ensuring they contribute meaningfully to the well-being of individuals and communities. The course addresses a pressing need in society - the demand for competent caregivers who navigate the multifaceted challenges of healthcare. Aspiring caregivers embark on a journey that not only transforms them into professionals but empowers them to safeguard the vulnerable. The benefits of mastering these modules are profound - from promoting inclusivity to ensuring the highest standards of ethical practice. The ripple effect is healthier communities, better services, and a sense of fulfilment for those choosing the carer path. This course is tailor-made for those passionate about making a difference in people's lives, aspiring to be caregivers, or already working in Health and Social Care. Whether you are a novice or an experienced professional, this bundle offers a comprehensive understanding of the intricacies of caregiving, making it an invaluable resource for personal and professional growth. Learning Outcomes Understand the fundamental principles of Health and Social Care. Demonstrate effective communication skills in caregiving contexts. Recognise and uphold rights and responsibilities as a healthcare worker. Define and fulfil the role of a caregiver and healthcare professional. Promote equality, diversity, and rights while working in healthcare. Apply important principles and policies in Health and Social Care work. Analyse legal, professional standards, and ethical aspects of healthcare. Safeguard vulnerable individuals with appropriate knowledge and skills. Gain insights into the economics and strategic marketing of healthcare. Who Is This Caregiving: Certificate in Caregiver at QLS Level 3 Course For Aspiring caregivers seeking foundational knowledge. Current healthcare workers aiming to enhance their skill set. Individuals passionate about promoting equality and diversity. Novices entering the field of Health and Social Care. Experienced professionals looking to update their expertise. Why Choose This Caregiving: Certificate in Caregiver at QLS Level 3 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. Career Path Caregiver/Healthcare Assistant - £18,000 - £25,000 per annum. Social Care Worker - £20,000 - £30,000 per annum. Healthcare Support Worker - £18,000 - £28,000 per annum. Care Home Manager - £25,000 - £40,000 per annum. Health and Social Care Consultant - £30,000 - £50,000 per annum. Prerequisites This Caregiving: Certificate in Caregiver at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 £85 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 Caregiving: Certificate in Caregiver at QLS Level 3 Introduction to Health and Social Care 00:16:00 Communication and its Relevance 00:41:00 Rights and Responsibilities as a Health and Social Care Worker 00:39:00 Role as A Caregiver and Healthcare Professional 00:23:00 Working in Health and Social Care; Promoting Equality, Diversity and Rights 00:46:00 Important Principles and Policies in Health and Social Care Work 00:20:00 Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 00:50:00 Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 00:48:00 Safeguarding Vulnerable Individuals 00:49:00 Health and Safety Responsibilities 00:51:00 The Economics of Healthcare 00:11:00 Strategic Marketing for Health and Social Care 00:09:00 Managing Finance in Health and Social Care 00:21:00 Managing Service Delivery in Health and Social Care 00:11:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

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