4500 Courses delivered Online

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the basics of Excel Know how to use Excel at an intermediate level Be aware of sum and numerical functions Understand how to manipulate text Know about logical functions Create effective spreadsheets Be confident with lookup functionality and date and time functions Easily use financial functions and sort and filter Progress to using Microsoft Excel at an advanced level Know how to create accurate and clear visual presentations Consolidate and validate data Use pivot table and what-if analysis Understand automation and macros Why Microsoft Excel Training Course right for you? Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course. Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions. You will learn to accelerate your tasks efficiently using Excel techniques and formulae. The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses. Microsoft Excel Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the Interface 0102 Enter Data & Saving Workbook 0103 Applying Formulas 0104 Changing a Worksheet's Structure 0105 Find, Replace & Spell Check 0106 Applying Fonts, Background Colors, and Borders 0107 Formatting Numbers and Dates 0108 Making the Fieces fit 0109 Inserting Headers & Footers and Repeating Rows 0110 Managing Large Workbooks Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) Ex 0201 Formula Writing (Don't Miss this) Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs Ex 0301 SumIf & SumIfs 0302 Count Functions Ex 0302 Count Functions 0303 AverageIf & AverageIfs Ex 0303 AverageIf & AverageIfs Text Functions - Manipulating Text 0401 Change Case (Upper, Lower,Proper) Ex 0401 Change Case (Upper, Lower, Proper) 0402 Separating Text on Symmetrical Data Ex 0402 Separating Text on Symmetrical Data 0403 Separating Text on Non-Symmetrical Data Ex 0403 Separating Text on Non-Symmetrical Data Logical Functions - Working With Conditions 0501 If Functionality Ex 0501 IF Functionality 0502 If with AND Ex 0502 If with AND 0503 If with OR Ex 0503 If with OR 0504 If with 'AND' & 'OR' / IF with Countif Ex 0504 If with 'AND' & 'OR' / IF with Countif 0505 Nested IF (A Genie with 3 wishes) Ex 0505 Nested IF (A Genie with 3 wishes) Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 Ex 0601 Vlookup (Exact Match) # 1 0602 Type of References (Use of $ sign) 0603 Vlookup (Exact Match) # 2 Ex 0603 Vlookup (Exact Match) # 2 0604 Double Vlookup Ex 0604 Double Vlookup 0605 Vlookup on Duplicate Values Ex 0605 Vlookup on Duplicate Values 0606 Vlookup (Approximate Match) Ex 0606 Vlookup (Approximate Match) 0607 Vlookup with If (Conditional Vlookup) Ex 0607 Vlookup with If (Conditional Vlookup) 0608 Hlookup (Exact Match) Ex 0608 Hlookup (Exact Match) 0609 Hlookup (Approximate Match) Ex 0609 Hlookup (Approximate Match) 0610 Lookup (Don't use this !) Ex 0610 Lookup (Don't use this !) 0611 Vlookup with Match (Create Magical Vlookup) Ex 0611 Vlookup with Match (Create Magical Vlookup) 0612 Match (Gives us Column/Row Index #) Ex 0612 Match (Gives us Column/Row Index #) 0613 Index & Match (Made for Each Other) Ex 0613 (1) Index & Match (Made for Each Other) Ex 0613 (2) Index & Match (Made for Each Other) Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 0702 Now, Today & Autofill 0703 DateValue & TimeValue 0704 Calculate WorkingDays 0705 DatedIf Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 0802 Creating a Loan Table Ex 0802 Creating a Loan Table 0803 Calculate Depriciation Ex 0803 Calculate Depriciation Sort & Filter 0901 Basic Sorting & Shortcut keys Ex 0901 Basic Sorting & Shortcut keys 0902 Sorting Using Custom List Ex 0902 Sorting Using Custom List 0903 Horizontal Sorting Ex 0903 Horizontal Sorting 0904 Basic Filter & Shortcut Keys Ex 0904 Basic Filter & Shortcut Keys 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 0906 Filter Problem # 2 (Pasting Values on Filtered Data) Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 0908 Advanced Filter (Applying Complex Criteria's) Ex 0908 Advanced Filter (Applying Complex Criteria's) Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 1002 Format Axis 1003 Plot Values on Secondary Axis 1004 Life of Pie (Charts) 1005 How to Show Axis Title 1006 How to Show Data Label 1007 Show data with chart in Data Table 1008 Column Chart 1009 Bar Chart 1010 Line Chart 1 1011 Line Chart 2 1012 Area Chart 1013 Pie Chart 1014 Pie of Pie or Bar of Pie 1015 Line Chart with Log Scale 1016 Bubble Chart 1017 Selecting Chart Elements 1018 Use of Format Dialog box 1019 Modifying Chart & Plot Area 1020 Modifying Data Series 1021 How to handle Missing Data 1022 Modifying 3-D Charts 1023 Creating Combination of upto 5 Different Charts 1025 Creating Picture Charts Data Consolidation - Multiple WorkBooks WorkSheets Consolidate Data using Excel Inbuilt Function Ex Consolidate Data using Excel Inbuilt Function Data Validation 1201 Applying Data Validation Ex 1201 Applying Data Validation 1202 Dependent Dropdown List Ex1202 Dependent Dropdown List Using Data Validation with Vlookup & Match Other Data Validation Examples Protection of Worksheet Workbook 1301 Worksheet Level Protection Ex 1301 Worksheet Level Protection 1302 Cell Level Protection Ex 1302 Cell Level Protection 1303 Hiding Formulas from Formula Bar Ex 1303 Hiding Formulas from Formula Bar 1304 Protecting Workbook Structure Ex 1304 Protecting Workbook Structure 1305 Workbook Level Protection Ex 1305 Workbook Level Protection Pivot Table & Techniques 1401 Understanding pivot Table 1402 Using Pivot Table in Real Scenario Ex 1402 Using Pivot Table in Real Scenario 1403 Grouping in Pivot Table Ex 1403 Grouping in Pivot Table 1404 Using Slicers (A Visually attractive Filter) Ex 1404 Using Slicers (A Visually attractive Filter) What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) Ex 1501 Goal Seek (A Reverse Approach) 1502 One Way Data Table 1503 Two Way Data Table 1504 Scenario Manager 1505 Solver Add-In Automation in Excel - Macros 1601 Record your first Macro 1602 Record Another Macro 1603 Assigning macro to a Shape, Button, Picture etc 1604 Editing or Deleting a Macro 1605 Security Settings of a Macro Who should take this course? Absolute beginners to Microsoft Excel People who wish to use Microsoft Excel more confidently People who wish to refresh their existing skills in Microsoft Excel Entry Requirements There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Build Your Own PC: A Beginner's Guide Course Overview "Build Your Own PC: A Beginner's Guide" is designed for individuals looking to gain an understanding of computer hardware and the process of assembling a fully functional PC. The course covers the essential components involved in building a computer, from selecting the right hardware to installing software and ensuring network connectivity. Learners will also be introduced to building gaming PCs and maintaining their machines for optimal performance. Upon completion, learners will have the skills to confidently build, troubleshoot, and maintain their own PC, opening up opportunities for personal and professional growth in the IT sector. Course Description This course provides an in-depth look into the world of computer building, starting with the basics of understanding computer components and their roles in a functional system. Learners will explore key hardware, including processors, motherboards, RAM, and storage devices, while also learning the significance of peripheral devices. The course includes modules on software installation, networking, and even building a gaming PC. With a focus on providing clear, structured guidance, learners will gain a strong foundation in assembling and maintaining PCs, preparing them for various roles in the technology sector. The course is ideal for beginners and those looking to improve their technical expertise. Build Your Own PC: A Beginner's Guide Curriculum Module 01: Introduction to Computer & Building PC Module 02: Overview of Hardware and Parts Module 03: Building the Computer Module 04: Input and Output Devices Module 05: Software Installation Module 06: Computer Networking Module 07: Building a Gaming PC Module 08: Maintenance of Computers (See full curriculum) Who is this course for? Individuals seeking to understand how computers work and how to build one. Professionals aiming to enhance their IT skills for career development. Beginners with an interest in technology and computer systems. Hobbyists interested in assembling their own custom-built PCs. Career Path IT Support Technician Systems Administrator PC Hardware Specialist Network Technician Gaming PC Builder and Technician

Course Overview: This Carpet Cleaner course provides a comprehensive introduction to carpet cleaning, covering the key techniques and knowledge required for effective cleaning and maintenance. Designed for both beginners and those looking to expand their expertise, this course delves into the science behind carpet care and cleaning methods. Learners will gain a solid understanding of carpet types, stain identification, and cleaning processes, along with restoration techniques. The course is ideal for individuals aiming to enhance their skills and pursue a career in carpet cleaning or maintenance. Upon completion, learners will be equipped with the knowledge to confidently tackle various cleaning challenges and restore carpets to their optimal condition. Course Description: In this detailed course, learners will explore the various aspects of carpet cleaning, starting with an introduction to different carpet types and their specific cleaning requirements. Topics include stain identification, effective cleaning techniques, and the cleaning process step by step. The course also covers essential carpet restoration methods, ensuring learners can offer a complete range of services. The structured approach, supported by theoretical knowledge, provides a solid foundation for individuals wishing to start a career in carpet cleaning or professionals seeking to expand their skill set. By the end of the course, learners will be proficient in identifying and managing common carpet issues, cleaning efficiently, and restoring carpets to their best condition. Course Modules: Module 01: Introduction to Carpet Cleaning Module 02: Understanding Carpets Module 03: Identifying Carpet Stains Module 04: Carpet Cleaning Methods Module 05: Carpet Cleaning Process Module 06: Carpet Restoration (See full curriculum) Who is this course for? Individuals seeking to start a career in carpet cleaning Professionals aiming to expand their skillset in carpet maintenance Beginners with an interest in the carpet cleaning industry Business owners or entrepreneurs looking to offer carpet cleaning services Career Path: Carpet Cleaner Carpet Cleaning Specialist Facilities Maintenance Technician Restoration Technician Residential and Commercial Cleaning Services

Science-Based Workout: Build Muscle, Lose Fat & Get Fit Course Overview This course, Science-Based Workout: Build Muscle, Lose Fat & Get Fit, provides a comprehensive guide to improving physical fitness through evidence-backed methods. It covers the essential principles of muscle growth, fat loss, and overall health enhancement. Learners will gain knowledge of effective workout routines, nutritional basics, and motivational techniques to sustain progress. Designed to empower individuals with science-supported strategies, this course equips learners with the skills to design personalised fitness plans and track their development confidently. Whether new to fitness or looking to refine their approach, participants will leave with a clear understanding of how to optimise their workouts for lasting results and improved wellbeing. Course Description This course delves into the scientific foundation of muscle building and fat reduction, breaking down complex concepts into accessible information. Topics include the physiological processes involved in strength training, effective workout programming for beginners, and the psychological aspects of motivation and goal setting. The learning experience is structured to provide clarity and depth, enabling learners to grasp the why and how of fitness improvements. By the end, participants will have acquired essential skills to create tailored workout plans, understand the impact of exercise on the body, and maintain consistent progress towards their health and fitness goals, all within a structured and informative format. Science-Based Workout: Build Muscle, Lose Fat & Get Fit Curriculum Module 01: Introduction Module 02: The Science Behind Building Muscle & Losing Fat Module 03: Beginner Workout Program Module 04: Motivation & Goal Setting (See full curriculum) Who Is This Course For? Individuals seeking to improve muscle tone and reduce body fat. Professionals aiming to enhance their knowledge for career development in fitness or health sectors. Beginners with an interest in understanding scientific fitness principles. Anyone wanting to adopt a structured and informed approach to personal fitness. Career Path Fitness Trainer Health Coach Personal Trainer Assistant Wellness Consultant Gym Instructor

20 Courses Online Training | CPD Certified | **20 Free PDF+ 1 Hardcopy Certificate** | Learner Support | Lifetime Access

This comprehensive course on HashiCorp Vault will make you an expert in deploying, configuring, and managing all key Vault services. It covers all objectives for passing the HashiCorp Certified: Vault Associate certification exam. Learn the latest HashiCorp concepts and master the core components to become a HashiCorp Vault expert.

From building Android games to understanding DevOps, this 8-in-1 App Development course bundle gives you access to key programming languages and modern development practices. Whether you're shaping the front-end with HTML and CSS or adding logic with Python and JavaScript, this bundle covers every step of digital creation. Alongside coding, the courses offer insights into user experience (UX) principles and backend foundations with Go Lang. It’s a great blend of creative and technical knowledge delivered in digestible, structured modules—without the need for endless documentation or mystery errors. Learning Outcomes: Understand the fundamentals of mobile and web development platforms. Apply HTML, CSS, and JavaScript for structured app interfaces. Learn Python and Go Lang syntax and programming logic. Explore UI/UX principles for engaging app design approaches. Understand DevOps essentials in app deployment processes. Build foundational knowledge in Android games development projects. Who is this Course For: Beginners wanting to learn app coding from scratch. Web designers aiming to enhance development knowledge. Freelancers looking to expand into mobile development. Students interested in building digital projects independently. Professionals seeking to understand UI/UX best practices. Job seekers aiming for app-related tech roles. Entrepreneurs creating their own digital solutions. Hobbyists eager to build fun and functional apps. Career Path: App Developer – £40,000/year Front-End Developer – £38,000/year Back-End Developer – £42,000/year UX Designer – £36,000/year Game Developer – £41,000/year DevOps Engineer – £55,000/year

🔨 Build your carpentry career with confidence using the Carpentry & Joinery: Woodwork Training: 8-in-1 Premium Online Courses Bundle. This bundle covers key areas like Electrical Safety, CDM Regulations, Cleaning, LEED v4, Puwer, Fire Safety, PAT, and Carpentry itself. Whether you’re starting out or aiming to enhance your qualifications, this bundle gives you industry-relevant skills for construction, building maintenance, and woodwork sectors. Employers value professionals trained in safety, regulations, and craftsmanship. Take advantage of this value-packed bundle now — demand for skilled carpenters is growing! Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot — trusted by trades professionals everywhere. Description Safety is paramount in carpentry. The Electrical Safety, CDM Regulations, Puwer, Fire Safety, and PAT courses ensure you meet stringent workplace safety standards. Mastering Cleaning supports site hygiene and professionalism. Get industry-ready with the LEED v4: Building Design and Construction module, focusing on sustainable practices. The core Carpentry course hones your craftsmanship and technical skills. This comprehensive bundle prepares you for a range of carpentry and joinery roles, from apprentice to advanced professional. FAQ Q: Is this bundle suitable for beginners? A: Yes, covering fundamental to advanced topics. Q: Do I get certificates? A: Yes, for each completed course. Q: Can I access the courses anytime? A: Yes, full lifetime online access. Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot — join thousands advancing in carpentry careers!

Whether you’re updating a spreadsheet, writing a formal letter, or creating a PowerPoint worthy of applause, this Microsoft Office Specialist (MOS) bundle has your digital desk drawer sorted. From MS Word to SQL, each module is designed to sharpen your command of the Office suite and its closely linked technologies. You'll learn to glide through Excel formulas, structure Access databases, interpret dashboards with Power BI, and manage projects with confidence in MS Project. It's not about just knowing where the buttons are—it’s about knowing what to do with them. Learning Outcomes: Navigate Microsoft Office tools with confidence and accuracy. Build and analyse data using Excel and Power BI. Create structured databases using MS Access. Write, edit and format documents professionally in Word. Prepare and present slides with clarity in PowerPoint. Organise communication and schedules using Outlook effectively. Who is this Course For: Office workers looking to improve everyday digital workflow. Admin assistants needing structured Microsoft Office training. Professionals handling reports, data, and communications. Beginners aiming to develop foundational Microsoft Office skills. Jobseekers wanting up-to-date tech proficiency. Small business owners managing documents and communication. Team leaders coordinating tasks via Outlook or MS Project. Anyone curious about Power BI and data presentation. Career Path: Administrative Assistant – £21,000–£28,000 per year Data Entry Clerk – £20,000–£25,000 per year Office Manager – £28,000–£40,000 per year Project Administrator – £25,000–£32,000 per year Business Analyst (with Power BI) – £38,000–£52,000 per year IT Support Assistant – £22,000–£30,000 per year

Whether you're fluent in Python or still mistaking JavaScript for coffee, this bundle has your name scribbled somewhere in code. The 8-in-1 Computer Programming Premium Bundle rolls out a structured and digestible dive into popular languages and core computing essentials. From SQL queries to scripting secure networks, it’s all stacked neatly with zero techy overkill. Mix in a touch of Excel and computer security, and you've got the basics sorted for building a solid career foundation in programming, development, and IT roles—without rewriting your life. 🟨 Learning Outcomes Learn foundational programming skills in Python and Go language. Understand JavaScript functions and browser-side interactions. Use SQL to manage and extract data from databases. Build logic and server-side functionality with PHP. Explore basic concepts of computer and network security. Apply Excel in computing and data interpretation tasks. 🟨 Who is this Course For Beginners interested in learning multiple coding languages Aspiring web developers or software engineers Students keen on expanding programming foundations Data lovers curious about SQL and backend operations Tech enthusiasts with an eye on software development IT support staff wanting programming knowledge Professionals upskilling in coding and automation tools Curious minds ready to code without the jargon headache 🟨 Career Path (UK average salary) Junior Software Developer – £30,000/year Web Developer – £31,500/year Network Engineer – £35,000/year SQL Database Analyst – £32,000/year IT Security Technician – £33,500/year Python Developer (Entry-Level) – £36,000/year