Description: Regardless of whether you are a business writer, an advertiser, or somebody who utilizes the software for general report creation and handling, the skills incorporated into this course will enable you to maximize your use of many powerful Word features to create compelling, visually attractive, and useful documents. This online course will allow you to learn advanced Word techniques, covering all that you need to help you get started. It shows you how to open reports and control the words on the page, so they look as you mean, whatever your purpose.In this course you will learn the necessary skills, knowledge and information of Microsoft Word 2007. Who is this course for? New users, beginners, and intermediates users can benefit from this course. This course would be ideal for individuals who wish to develop their skills of using Microsoft Office Excel application. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: Microsoft Word 2007 Advanced Level will be very beneficial and helpful, especially to the following professionals: Administrative Assistant. PA. Secretary. Administrator. Office Manager. Microsoft Word 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Adding Pictures 01:00:00 Module Four - Adding Smart Art 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Advanced Table Tasks 01:00:00 Module Seven - Inserting Special Objects 01:00:00 Module Eight - Adding In-Document References 01:00:00 Module Nine - Advanced Research Tasks 01:00:00 Module Ten - Reviewing a Document 01:00:00 Module Eleven - Customizing Word 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Word 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Word 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Word 2007 Advanced Level 00:20:00
Dealing with a difficult or toxic personality can be emotionally and physically damaging, especially if the person is your boss or sits in the cubicle next to you. Many people find it difficult to confront those who compromise their comfort and job security, but standing up for yourself is important. This Dealing With Difficult People Training course provides learners with a thorough understanding of how to identify difficult personality types and effectively deal with them and provide the skills required for Dealing With Difficult People Training. By the end of the Dealing With Difficult People Training course, you will be able to deal with aggressive, manipulative, undermining, prejudiced, or otherwise difficult people. Learning Outcomes After completing this Dealing With Difficult People Training course, the learner will be able to: Identify difficult people and their difficult behaviour. Know how to communicate with difficult people. Know how to deal with bosses who drive you barmy. Recognise seven classically difficult types. Know how to deal with impossible people. Identify the temper tantrum type. Why Choose Dealing With Difficult People Training Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Dealing With Difficult People Training Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the Dealing With Difficult People Training course. ***Dealing With Dealing With Difficult People Training Bundle Course Course 01: Dealing With Difficult People Training Course 02: Level 7 Diploma in Operations Management Course 03: Level 5 Health and Safety at Work Course 04: Level 5 Diploma in Risk Management Course Course 05: Level 5 Report Writing Course Course 06: Communication Skills Course Course 07: Workplace Stress Management Course 08: Anger Management ***Other Benefits of Dealing With Difficult People Training Training Bundle Course Free 8 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Dealing With Difficult People Training course ] Course Curriculum Of Dealing With Difficult People Module 01: Difficult People and Their Difficult Behaviour Module 02: Communicating With Difficult People Module 03: Standing Up to Difficult People Module 04: A Quick Guide to the Seven Classically Difficult Types Module 05: Dealing with Bosses Who Drive You Barmy Module 06: Colleagues to Throttle Module 07: Dealing With Impossible People Module 08: The Temper Tantrum Type >>----------------<< Assessment Method After completing each module of the Dealing With Difficult People Training Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification After completing the MCQ/Assignment assessment for this Dealing With Difficult People Training course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Dealing With Difficult People Training course is ideal for executives, managers, supervisors, team leaders, project managers, and anyone else who has been affected by negativity in the workplace caused by a difficult person. Requirements There are no specific requirements for this Dealing With Difficult People Training course because it does not require any advanced knowledge or skills. Career path The Dealing With Difficult People course is meant to prepare you for the job of your dreams, an advancement at work, or to become self-employed and establish your own business. Certificates Certificate of completion Digital certificate - Included
Overview Many hidden threats lurk in our society that can cause deep scars on innocent children. Learn how to protect children from these threats with Safeguarding Children Training. This course will show you how to create a safe and secure environment for the future generations. The major aspects of child safeguarding are covered in this course. Here, you will learn about the importance of protecting and safeguarding children. Then, the course will educate you on the child protection law. Furthermore, you will understand the dangers of child abuse and exploitation. You will also develop the skills to identify and report safeguarding risks. By the end of the course will have the ability to provide mental health support to children. Course Preview Learning Outcomes Comprehend the significance of safeguarding children Understand the child protection laws and regulations of the UK Learn about the dangers of child abuse and exploitation Grasp the process of assessing risks and responding to discloser Know how to provide mental health support to children Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Safeguarding Risk Assessment Responding to Discloser Providing mental health Support Who Should Take This Safeguarding Children Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Safeguarding Children Training is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Pathâ This exclusive Safeguarding Children Training course will equip you with effective skills and abilities and help you explore career paths such as Safeguarding Officer Childcare Worker Teacher Mental Health Counsellor Social Worker Module 01: Assessing Risks and Responding to Disclosure Assessing Risks and Responding to Disclosure 00:15:00 Module 02: Child Protection History and Laws in the UK Child Protection History and Laws in the UK 00:13:00 Module 03: Keeping Records and Identifying Trafficking Keeping Records and Identifying Trafficking 00:11:00 Module 04: Supporting Children's Mental Health and Basic Needs Supporting Children's Mental Health and Basic Needs 00:13:00 Module 05: The Danger of Child Abuse and Exploitation The Danger of Child Abuse and Exploitation 00:19:00 Module 06: Why We Need to Safeguard Children Why We Need to Safeguard Children 00:13:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Microsoft Excel 2016 and VBA continues Velsoft's in-depth training material for Excel 2016. This course covers the duration of five lessons, by taking it you will get the skills you need to harness Visual Basic for Applications, or VBA, to automate many tasks you will encounter while using Excel 2016. This course will help you to get all the knowledge you need to gain about Microsoft Excel 2016 and VBA. So, if you are interested to develop your skills and knowledge, you shouldn't be late to join this course. Learning Outcomes: Best ways to utilize Macro Recorder, how to edit and debug a macro, and setting up macro security Customizing the Quick Access toolbar and hotkeys Utilizing Macros to insert and format texts, sort and duplicate data, and generate reports Determine appropriate dialog box types to use Using variety of techniques to capture user input Managing worksheets using macros Creating user-defined functions and ways to automate SUM functions with macros 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 Excel 2016 and VBA 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 Excel 2016 and VBA 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. Developing Macros Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Formatting Worksheets Using Macros Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Creating an Interactive Worksheet Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Working with Multiple Worksheets Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Performing Calculations Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 and VBA 00:00:00 Mock Exam Mock Exam- Microsoft Excel 2016 and VBA 00:20:00 Final Exam Final Exam- Microsoft Excel 2016 and VBA 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Save Up To £4,169 and get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Teaching English Level 5 including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Prove that you are committed to Social Care and Community Welfare by training for your mandatory Care Certificate. This course provides all the principles, knowledge, and skills that you will need to absorb, to carry out exemplary Social Care. The Teaching English Level 5 course has been written with the help of industry professionals and lays out all of the EU/UK standards for delivering care to the community. You will be taught how to safeguard the vulnerable, provide appropriate nutrition, respect privacy and dignity, support those with challenges and disabilities, and ensure hygiene and cleanliness. Understand your responsibilities in the Social Sector today. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Teaching English Level 5 will provide you with the CPD certificate that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Teaching English Level 5 has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Teaching English Level 5 is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this Teaching English Level 5: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills What other courses are included with this Teaching English Level 5? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Curriculum ***Teaching English Level 5*** Introduction to Teaching English Linguistics Basics Working With a Variety of Approaches Teaching Speaking Teaching Listening Teaching Reading Teaching Writing Planning Pedagogy Planning Lessons Managing Classrooms Getting a job How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this Teaching English Level 5. It is available to all students, of all academic backgrounds. Requirements Our Teaching English Level 5 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 CPD certificate 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. 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 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.
Overview This comprehensive course on Xero Projects & Job Costing will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Xero Projects & Job Costing 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? At the end of the course there will be an online written test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Xero Projects & Job Costing. It is available to all students, of all academic backgrounds. Requirements Our Xero Projects & Job Costing is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 13 sections • 35 lectures • 02:32:00 total length •Introduction: 00:02:00 •When to Use Projects: 00:03:00 •Demo Company: 00:04:00 •Tour of Screens: 00:07:00 •Adding Staff Cost Rates: 00:07:00 •Users and Permissions: 00:04:00 •Introduction - Small Project: 00:01:00 •Adding Projects: 00:04:00 •Adding Tasks & Estimated Costs: 00:09:00 •Adding Time & Expenses: 00:05:00 •Sending a Time & Expenses Invoice: 00:06:00 •Adding More Time & Expenses: 00:05:00 •Sending a Final Time & Expenses Invoice: 00:04:00 •Introduction - Quotes: 00:01:00 •Creating & Assigning Quotes: 00:03:00 •Creating Quotes from Tasks & Expenses: 00:04:00 •Creating Quotes from Project Amounts: 00:02:00 •Introduction - Products & Services: 00:01:00 •Adding Supplier Bills to Projects: 00:06:00 •Adding Services to Projects: 00:07:00 •Adding Untracked Inventory to Projects: 00:04:00 •Adding Tracked Inventory to Projects: 00:06:00 •Introduction - Invoicing: 00:01:00 •Project Amount Invoices: 00:04:00 •Deposit Invoices: 00:05:00 •Tasks & Expenses Invoices: 00:05:00 •Invoicing from Quotes: 00:07:00 •Measuring Task Performance: 00:05:00 •Project Summary Report: 00:03:00 •Introduction - Bigger Project: 00:01:00 •Bigger Project: 00:22:00 •Projects and Profit & Loss: 00:03:00 •Thank You: 00:01:00 •Resources - Xero Projects & Job Costing: 00:00:00 •Assignment - Xero Projects & Job Costing: 00:00:00
24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The UK economy is a major player on the world stage. Did you know it's the world's sixth-largest by nominal GDP? Understanding economic principles is crucial for navigating the financial world and making informed decisions. Understanding economic principles can be empowering, but navigating financial concepts can be daunting. Do you want to analyse budgets, build financial models, or even become a stock trader? This Economics Bundle equips you with a strong foundation in economic principles and practical financial skills. Courses cover everything from core economic concepts like supply and demand to practical applications like financial modeling and import/export processing. Gain expertise in budgeting, financial analysis, and investment strategies. Whether you aspire to be a business analyst, financial advisor, or tax accountant, this bundle provides the knowledge and tools you need to succeed. Courses Are Included In this Diploma in Economics Career Bundle: Course 01: Economics Course 02: Business Analyst Course 03: Accounting and Finance Course 04: Budget Analysis and Financial Report Building Course 05: Financial Modelling Course 06: Purchasing & Procurement Course 07: Import/Export Processing Course 08: Stock Trading Diploma Course 09: Financial Advisor Course 10: Financial Investigator Course 11: Tax Accounting and Administration in the UK Take control of your financial future and unlock exciting career opportunities. Enroll in the Economics Bundle today and gain the skills and knowledge to thrive in the ever-evolving world of finance. Learning Outcomes of Economics Explain key economic concepts like supply and demand, market structures, and fiscal policy. Analyse financial statements to assess a company's financial health. Develop and interpret financial models to make informed business decisions. Master the intricacies of import/export procedures and regulations. Apply financial analysis techniques to evaluate investment opportunities. Gain the knowledge and tools to navigate UK tax accounting and administration. Perhaps you want to develop a business model but don't know about production costs or pricing. Then this Intermediate Economics course is for you! The Intermediate Economics course covers the fundamentals of demand and supply, production theory, market structures, and market failures. Why Choose Our Economics Course? Get a Free CPD Accredited Certificate upon completion of Economics Get a free student ID card with Economics Training The Economics is affordable and simple to understand The Economics is an entirely online, interactive lesson with voiceover audio Lifetime access to the Economics course materials The Economics comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Course 1: Economics Module 01: An Introduction to Economics Module 02: The Market System and the Circular Flow Model Module 03: Supply, Demand and Prices Module 04: Prices Module 05: Elasticity Module 06: Market Failures Module 07: Production and Costs Module 08: Market Structure: Perfect Competition vs Monopoly Module 09: Money, Banking and the Financial System Module 10: Measuring GDP and Economic Growth Module 11: Unemployment Module 12: Inflation Module 13: Income Distribution and Poverty Module 14: International Finance Module 15: Fiscal Policy Course 2: Business Analyst Module 01: Introduction To Business Management Module 02: Operations Management Module 03: Introduction To Business Analysis Module 04: Strategic Analysis And Product Scope Module 05: Project Management Module 06: Business Development And Succession Planning Module 07- Business Process Management Module 08: Planning & Forecasting Operations Module 09: Performance Management Module 10: Management Of Cash And Credit Course 3: Accounting and Finance Module 01: Introduction To Accounting And Finance Module 02: The Role Of An Accountant Module 03: Accounting Process And Mechanics Module 04: Introduction To Financial Statements Module 05: Financial Statement Analysis Module 06: Budgeting And Budgetary Control Module 07: Financial Markets Module 08: Financial Risk Management Module 09: Investment Management Module 10: Auditing =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free ( For The First Course: Previously it was £29.99) CPD 150 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 bundle. This bundle is ideal for: Business Owners Entrepreneurs Finance Professionals Career Changers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Business Analyst Financial Analyst Stock Trader Financial Advisor Tax Accountant Import/Export Specialist Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.
Master the magic of Microsoft Excel's sought-after functions with the 'Excel Vlookup; Xlookup; Match and Index' course. This tailored journey beckons those eager to navigate datasets with dexterity, turning raw data into actionable insights. From the foundational intricacies of Vlookup to the advanced functionalities of Xlookup, this course provides a comprehensive roadmap for all spreadsheet enthusiasts. Learning Outcomes Gain proficiency in implementing and mastering the Vlookup function. Understand the nuanced differences and applications of Xlookup. Recognise when and how to best use each of these Excel functions. Enhance efficiency in data processing and analysis tasks. Elevate your Excel proficiency, becoming a reliable resource for data-driven decisions. Why choose this Excel Vlookup; Xlookup; Match and Index 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 Excel Vlookup; Xlookup; Match and Index 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 Excel Vlookup; Xlookup; Match and Index course for? Data enthusiasts keen on enhancing their Excel skillset. Business professionals aiming to streamline data analysis. Students looking to gain a competitive edge in data-driven fields. Analysts aiming for faster, more accurate data interpretations. Excel users seeking to optimise their use of lookup functionalities. Career path Data Analyst: £25,000 - £40,000 Excel Consultant: £30,000 - £55,000 Finance Analyst: £28,000 - £45,000 Marketing Analyst: £24,000 - £48,000 Operations Analyst: £26,000 - £42,000 Report Developer: £27,000 - £51,000 Prerequisites This Excel Vlookup; Xlookup; Match and Index does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel Vlookup; Xlookup; Match and Index 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. Course Curriculum Excel Vlookup; Xlookup; Match and Index 1.1 Excel vlookup 00:08:00 1.2 Excel xlookup 00:06:00 1.3 Excel vlookup 00:08:00 1.4 Excel vlookup 00:03:00 1.5 Excel vlookup 00:11:00 1.6 Excel vlookup 00:05:00 1.7 Excel vlookup 00:05:00 Assignment Assignment - Excel Vlookup; Xlookup; Match and Index 00:00:00 Resource Resource 00:00:00