3093 Courses delivered On Demand

Overview With the ever-increasing demand for Computer Maintenance in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Computer Maintenance may be. Learning about Computer Maintenance or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Computer Maintenance . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Computer Maintenance is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Computer Maintenance course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Computer Maintenance course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Computer Maintenance course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Computer Maintenance , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Computer Maintenance , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Computer Maintenance , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Computer Maintenance course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.  Course Curriculum Computer Maintenance Module 01 - Introduction to Computers Module 01 - Introduction to Computers 00:00 Computer Maintenance Module 02 - Structure of Computers Module 02 - Structure of Computers 00:00 Computer Maintenance Module 03 - Hardware Module 03 - Hardware 00:00 Computer Maintenance Module 04 - Software and Interface Module 04 - Software and Interface 00:00 Computer Maintenance Module 05 - Viruses and Computer Maintenance Module 05 - Viruses and Computer Maintenance 00:00 Computer Maintenance Module 06 - Internet and IT Module 06 - Internet and IT 00:00 Computer Maintenance Module 07 - Cyber Security Module 07 - Cyber Security 00:00

🚀 Unlock the Power of Web Design with Fundamentals of CSS Course Are you ready to take your web design skills to new heights? Dive into the world of cascading style sheets (CSS) with our comprehensive course, Fundamentals of CSS. Whether you're a budding web developer, a seasoned programmer looking to enhance your skill set, or a creative individual eager to unleash your design potential, this course is your gateway to success in the digital realm.   Why CSS Matters: CSS is the backbone of modern web design, allowing developers and designers to control the layout, presentation, and overall aesthetics of websites. With CSS, you can transform static web pages into dynamic, visually stunning experiences that captivate and engage users. By mastering CSS fundamentals, you'll gain the ability to create responsive designs, implement animations, and optimize user interfaces for maximum impact.   What You'll Learn: In our Fundamentals of CSS course, you'll embark on a journey of discovery through key concepts such as selectors, properties, and values. You'll learn how to style text, manipulate images, and craft immersive layouts that adapt seamlessly to various screen sizes and devices. With hands-on exercises and real-world examples, you'll build a solid foundation in CSS that will empower you to tackle any design challenge with confidence.   Benefits of Taking This Course: 🎨 Unleash Your Creativity: Learn how to express your unique vision through custom styles and design elements. 🌐 Enhance Your Skill Set: Add valuable skills to your repertoire and stay ahead in today's competitive job market. 💼 Boost Your Career Prospects: Open doors to exciting opportunities in web development, UI/UX design, and beyond. 📈 Increase Your Marketability: Stand out to employers and clients with a portfolio showcasing your CSS proficiency. 👩‍💻 Join a Thriving Community: Connect with like-minded individuals and expand your network within the tech industry.   Who is This For? Our Fundamentals of CSS course is perfect for: Aspiring web developers eager to learn the building blocks of modern web design. Design enthusiasts looking to expand their skill set and create visually stunning websites. Programmers seeking to enhance their proficiency in front-end development technologies. No prior experience in web design or programming is required-all skill levels are welcome!   Career Path: Upon completing the Fundamentals of CSS course, you'll be well-equipped to pursue a variety of exciting career paths, including:   👨‍💻 Front-End Developer: Create captivating user experiences by translating design concepts into functional, responsive websites. 🎨 UI/UX Designer: Craft intuitive interfaces and optimize user interactions to deliver exceptional digital experiences. 💼 Freelance Designer: Showcase your CSS expertise to clients and build a thriving freelance business offering web design services. 🌐 Digital Marketing Specialist: Develop visually compelling websites and landing pages that drive conversions and engage audiences. Don't miss out on this opportunity to master the art of CSS and unlock a world of possibilities in web design and development. Enroll in our Fundamentals of CSS course today and take the first step towards transforming your creative vision into reality!   FAQs (Frequently Asked Questions) Is this course suitable for beginners? Absolutely! Our Fundamentals of CSS course is designed to cater to learners of all skill levels, including those who are completely new to web design and programming. We provide step-by-step guidance and clear explanations to ensure that even beginners can grasp the core concepts of CSS with ease. Do I need any special software or tools to participate in the course? No, you don't need any specialized software or tools to enroll in our course. All you need is a computer with internet access and a modern web browser. We'll provide you with everything you need to get started, including access to online resources, code editors, and practice exercises. How long does it take to complete the course? The duration of the course can vary depending on your individual learning pace and schedule. On average, most students complete the Fundamentals of CSS course within [insert average duration here] weeks. However, you're free to study at your own pace and can access the course materials at any time, allowing you to tailor your learning experience to fit your needs. Will I receive a certificate upon completing the course? Yes, upon successfully completing the Fundamentals of CSS course, you'll receive a certificate of completion to showcase your achievement. This certificate can be added to your resume, LinkedIn profile, or portfolio to demonstrate your proficiency in CSS fundamentals to potential employers or clients. Are there any prerequisites for this course? While there are no strict prerequisites for enrolling in the Fundamentals of CSS course, having a basic understanding of HTML would be beneficial. However, we cover essential HTML concepts as part of the course curriculum, so you can still succeed even if you're not familiar with HTML beforehand. Is there any instructor support available during the course? Yes, we provide dedicated instructor support to assist you throughout your learning journey. Whether you have questions about course material, need clarification on a concept, or require additional assistance, our team of experienced instructors is here to help. You can reach out to us via email, discussion forums, or live chat for personalized support and guidance. Can I access the course content after completing it? Yes, once you've completed the Fundamentals of CSS course, you'll have lifetime access to the course materials. This means you can revisit the lessons, review the concepts, and continue honing your CSS skills whenever you like, even after completing the course. We hope these FAQs have addressed any concerns you may have had about our Fundamentals of CSS course. If you have any further questions or would like more information, feel free to reach out to our support team-we're here to help you succeed! Course Curriculum Chapter 1_ Introduction To CSS Chapter 1_ Introduction To CSS 00:00 Chapter 2_ Element Properties Chapter 2_ Element Properties 00:00 Chapter 3_ Colours Chapter 3_ Colours 00:00

Course Title: Basic Fundamentals of Electricity and DC Circuit Analysis Unlock the Power of Understanding with Our Comprehensive Course!   Overview: Welcome to the 'Basic Fundamentals of Electricity and DC Circuit Analysis' course, where we demystify the world of electrical circuits and empower you with essential knowledge. Whether you're a novice looking to grasp the basics or a professional seeking a refresher, this course is designed to cater to all skill levels.   Key Features: Foundational Understanding: We start at the very beginning, ensuring that you build a strong foundation in the principles of electricity. You'll gain insights into voltage, current, resistance, and the fundamental laws governing DC circuits. Practical Application: Theory comes to life through hands-on, practical exercises. Learn to analyze and troubleshoot DC circuits using real-world examples, enhancing your ability to apply knowledge in practical scenarios. Interactive Learning: Our engaging course structure incorporates multimedia elements, quizzes, and interactive sessions to keep you actively involved. We believe in making the learning process dynamic and enjoyable. Expert Instruction: Led by seasoned professionals with extensive experience in the field, our instructors are dedicated to ensuring that you not only understand the concepts but also gain valuable insights from their real-world expertise. Comprehensive Curriculum: From the basics of electrical components to in-depth DC circuit analysis, this course covers a wide spectrum. Topics include Ohm's Law, Kirchhoff's Laws, circuit theorems, and more. Industry-Relevant Skills: Equip yourself with skills directly applicable to various industries. Whether you're pursuing a career in electronics, electrical engineering, or simply want to enhance your DIY projects, this course provides the knowledge you need.   Who Should Enroll: Students pursuing studies in electrical engineering or related fields. Professionals seeking a refresher on fundamental electrical concepts. Hobbyists and DIY enthusiasts looking to expand their skill set. Anyone curious about understanding the principles behind electrical circuits.   Why Choose This Course: Versatile Skill Enhancement: Acquire skills applicable to a broad range of industries and personal projects. Career Advancement: For students, this course serves as a stepping stone to more advanced studies. Professionals can use the knowledge gained to excel in their current roles or explore new opportunities. Confidence in Handling Electrical Systems: Gain the confidence to handle electrical systems responsibly and troubleshoot issues effectively. Investment in Your Future: Electrical knowledge is a valuable asset. By investing in this course, you're investing in your personal and professional development. Don't miss out on the opportunity to master the 'Basic Fundamentals of Electricity and DC Circuit Analysis.' Enroll now and embark on a journey towards electrical expertise! Course Curriculum Introduction To Basic Fundamentals Of Electricity And Dc Circuit Analysis Course Introduction To Basic Fundamentals Of Electricity And Dc Circuit Analysis Course 00:00 The Nature Of Electricity The Nature Of Electricity 00:00 Conductors Insulators Conductors Insulators 00:00 Current And Electric Circuits Current And Electric Circuits 00:00 Ohm S Law Ohm S Law 00:00 Electric Power Electric Power 00:00 Series Parallel Circuits Series Parallel Circuits 00:00 Circuit Theorems Circuit Theorems 00:00 Electric Fields And Capacitance Electric Fields And Capacitance 00:00 Magnetism And Inductance Magnetism And Inductance 00:00 Transient Response Capacitors Inductors Transient Response Capacitors Inductors 00:00

🚀 Unleash the Power of C++ with our Exclusive Advanced Master Classes! 🚀 Ready to elevate your C++ skills to the next level? Dive deep into the world of Object-Oriented Programming (OOP) and Templates with our cutting-edge online course: 'Learn C++ Advanced: Master Classes on OOPs and Templates.'   🔥 What You'll Gain: ✅ Mastery of OOP Concepts: Go beyond the basics and discover advanced OOP principles that will make your code more robust, scalable, and maintainable. ✅ Template Magic: Unlock the true potential of C++ templates and learn how to leverage them for generic programming, creating flexible and efficient code. ✅ Real-world Applications: Gain practical insights by working on hands-on projects and real-world case studies, applying your newfound knowledge to solve complex problems. ✅ Expert Guidance: Learn from industry experts with years of experience in C++ development. Our instructors are dedicated to helping you grasp even the most challenging concepts. ✅ Comprehensive Curriculum: Cover a wide range of advanced C++ topics, from smart pointers and inheritance to template metaprogramming and design patterns. ✅ Lifetime Access: Get access to course materials, updates, and a vibrant community for a lifetime. Stay current with the latest C++ trends and technologies. ✅ Certification of Completion: Showcase your expertise with a prestigious certificate upon successfully completing the course. Stand out to employers and peers alike.   💡 Who Is This Course For? Whether you're a seasoned C++ developer looking to enhance your skills or a passionate learner eager to delve into advanced programming concepts, this course is tailored for you. It's the perfect stepping stone for those aiming to become elite C++ developers.   🌐 Why Choose Our Course? 🚀 Engaging Content: Our modules are designed for maximum engagement, combining video lectures, coding exercises, quizzes, and real-world projects.   🤝 Community Support: Join a thriving community of learners and interact with instructors and peers. Exchange ideas, seek help, and collaborate on projects.   🌟 Proven Results: Our students have reported increased confidence and success in their professional endeavors after completing our courses. Don't miss the opportunity to become a C++ master! Enroll now and unlock the full potential of your programming journey. Course Curriculum Module- 1 Introduction 00:00 Course Curriculum 00:00 Getting started on windows, mac or Linux 00:00 How to ask great questions 00:00 FAQ's 00:00 Get and Installing Visual Studio Editor 00:00 Creating First Project 00:00 C++ Hello World Program 00:00 Compile and Run a CPP Program 00:00 Module- 2 Introduction 00:00 What are oops 00:00 Data structures 00:00 What are access modifiers 00:00 Module- 3 Introduction 00:00 Creating a class 00:00 Creating an objects 00:00 Class methods 00:00 Adding parameters 00:00 Constructors 00:00 Constructor with parameters 00:00 Default constructor 00:00 The destructor 00:00 Get and set methods 00:00 Access modifiers 00:00 Static members 00:00 Module- 4 Introduction 00:00 Constant objects and functions 00:00 Pointers to class and object 00:00 Array of objects 00:00 Module- 5 Introduction 00:00 Overloading the equality operator 00:00 Overloading the stream insertion operator 00:00 Overloading the stream insertion operator 00:00 Overloading the binary arithmetic operators 00:00 Overloading the assignment operators 00:00 Overloading the unary operators 00:00 Overloading the subscript operator 00:00 Inline functions 00:00 Module- 6 Introduction 00:00 Inheritance 00:00 Protected members 00:00 Constructors and Inheritance 00:00 Destructors and Inheritance 00:00 Overriding methods 00:00 Polymorphism 00:00 Abstract classes 00:00 Final classes and methods 00:00 Deep inheritance and methods 00:00 Multiple Inheritance 00:00 Module- 7 Multiple Inheritance 00:00 What are exceptions 00:00 Throwing an exception 00:00 Catching an exception 00:00 Catching multiple exceptions 00:00 Create custom exceptions 00:00 Module- 8 Introduction 00:00 Creating a function template 00:00 Function template arguments 00:00 Overloading a function template 00:00 Creating a class template 00:00 Templates with multiple parameters 00:00

Overview With the ever-increasing demand for Microsoft PowerPoint in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Microsoft PowerPoint may be. Learning about Microsoft PowerPoint or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Microsoft PowerPoint. That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Microsoft PowerPoint is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Microsoft PowerPoint course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Microsoft PowerPoint course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Microsoft PowerPoint course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Microsoft PowerPoint, Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Microsoft PowerPoint, Anyone looking for a certificate of completion on doing an online training on this topic, Students of Microsoft PowerPoint, or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Microsoft PowerPoint course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 Introduction to Microsoft PowerPoint Introduction to Microsoft PowerPoint 00:00 Module 2 Setting up and Managing presentations Setting up and Managing presentations 00:00

Ready to stand out in the legal profession? The Legal Secretary: 20-in-1 Premium Bundle is built to give you the edge law firms, chambers, and in-house legal departments are hiring for. Combining practical office support with essential legal frameworks, this all-in-one training solution helps you become the backbone every legal team needs. Act now—opportunities in legal admin move quickly, and this is your shortcut to getting noticed. Description Legal secretaries aren’t just typists—they’re trusted support professionals who keep legal operations running smoothly. With this 20-in-1 course bundle, you’ll be equipped with the multifaceted skills expected by recruiters across law firms, corporate legal departments, and even public sector agencies. Whether you're applying for your first legal admin role or upskilling to take on more responsibility, this bundle is built for one clear goal: employability. From communication and compliance to employment and property law, each course adds real-world value to your CV—without wasting your time on irrelevant theory. Best of all, you get everything in one package, at one unbeatable price. No need to piece together your qualifications across random platforms. Don’t wait for job ads to dictate your worth—train now and put yourself ahead of the competition. FAQ Who should enrol in this bundle? Aspiring legal secretaries, paralegals, legal PAs, or admin professionals aiming to specialise in the legal field. What industries is this bundle relevant to? Law firms, corporate legal teams, real estate agencies, government departments, and any organisation requiring legal admin support. Do I need legal experience to start? Not at all—this bundle is beginner-friendly but also valuable for those already in admin roles. Will this help with remote or hybrid legal work? Yes. Many firms now offer hybrid roles, and this training supports both on-site and remote office skills. Is this recognised for legal admin roles in the UK? Yes—it covers core legal and admin competencies that match UK job market expectations. Why act now? Legal admin roles are competitive. Those with targeted training get shortlisted first—don’t wait and get left behind.

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Data Analysis In Excel for School Administrators is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Data Analysis In Excel for School Administrators and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language numeracy and IT Desire for entrepreneurship over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:06:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:08:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:06:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:06:00

Microsoft Excel is more than just rows and columns — it's a powerhouse for professionals who know how to make it work for them. This course zeroes in on four of Excel’s most essential lookup functions: VLOOKUP, XLOOKUP, MATCH, and INDEX. Whether you're reconciling data, building dynamic reports, or navigating large spreadsheets, these tools save time, reduce errors, and make you look like you actually enjoy spreadsheets — even if you don’t. You'll learn how each function behaves, when to use one over the other, and how to string them together to achieve powerful results. The course is designed for learners who want to use Excel efficiently, without getting buried in formulas that behave like they’ve had too much coffee. With clear explanations, useful examples, and a touch of logic that even your sleep-deprived Monday brain can follow, this course gets straight to the point. If you've ever stared at a dataset wondering where to begin, you're in the right place — no fluff, just formulas that do the heavy lifting. Learning Outcomes: Utilise Vlookup and Xlookup to retrieve data efficiently Understand how to use Match and Index functions Learn to compare and match large data sets Automate data processing and analysis Improve data accuracy and reliability Increase productivity and save time on manual calculations Course Curriculum: 1.1 Excel vlookup 1.2 Excel xlookup 1.3 Excel vlookup 1.4 Excel vlookup 1.5 Excel vlookup 1.6 Excel vlookup 1.7 Excel vlookup 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 Data Analyst (£26,000 - £45,000) Financial Analyst (£25,000 - £50,000) Business Analyst (£26,000 - £52,000) Accountant (£22,000 - £48,000) Operations Manager (£24,000 - £61,000) Project Manager (£29,000 - £65,000) 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.