• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

100 Courses delivered Online

Need to Know Advanced Excel Formulas and Functions

4.3(43)

By John Academy

Course Overview Take your Excel skills to the next level with the help of the Need to Know Advanced Excel Formulas and Functions course. In this course, the expert instructor will show you how to optimize the use of excel. You will learn a handful of useful functions and formulas that will increase your proficiency in excel. The Need to Know Advanced Excel Formulas and Functions course aims to increase your competence in excel. The course will teach you the fundamental math functions. You will understand the concept of relative reference and absolute reference. The course will educate you on Autosum. You will receive lectures on how to link sheets and workbooks. The course will enrich your understanding of vlookup and hlookup functions. You will become skilled in training functions. From this course, you will achieve the essential training to upgrade your MS excel skills in no time. This Need to Know Advanced Excel Formulas, and Functions course will help you build excellent expertise in excel. Enroll in the course to boost your abilities and your employability in the relevant job market. Learning Outcomes Understand how to build basic math formulas Enrich your understanding of Autosum and relative references Learn how to link sheets and workbooks Gain the skills for tracking functions Deepen your knowledge of Vlookup and Hlookup functions Build your skills to work with text functions Who is this course for? Those who want to upgrade their excel skills 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. Certification After you have successfully completed the course, 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 hardcopy 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  The Need to Know Advanced Excel Formulas and Functions course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Administrative Officer Need to Know Advanced Excel Formulas and Functions Building basic math formulas 00:08:00 Autosum and Relative references 00:09:00 Absolute references 00:06:00 Named Ranges 00:06:00 Linking sheets and workbooks 00:06:00 If, And, Or, and the nested If functions 00:16:00 Countif, Sumif, Averageif, Sumifs, and Countifs functions 00:09:00 Vlookup and Hlookup functions 00:15:00 Match and Index functions 00:07:00 Date and time formulas and functions 00:12:00 Text functions 00:11:00 Tracing formulas 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Need to Know Advanced Excel Formulas and Functions
Delivered Online On Demand1 hour 53 minutes
£18

Recruitment Consultant Essential Training

5.0(10)

By Apex Learning

Give a compliment to your career and take it to the next level. This Recruitment Consultant 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 skills for your next promotion, this Recruitment Consultant will help you keep ahead of the pack. The Recruitment Consultant incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your expertise and essential knowledge, which will assist you in reaching your goal. Further, this Recruitment Consultant will add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in this job sector. Consequently, you'll sharpen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Recruitment Consultant, you can equip yourself with the essentials to keep you afloat in the competition. Along with this Recruitment Consultant course, you will get 10 premium courses, an original Hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Recruitment Consultant Bundle Consists of the following Premium courses: Course 01: Recruitment Consultant - Level 4 Course 02: Employment Law Level 3 Course 03: Law and Contracts - Level 2 Course 04: HR Management Level 3 Course 05: Virtual Interviewing for HR Course 06: Resourcing and Managing Talent Course Course 07: Payroll Management - Diploma Course 08: Document Control Course 09: GDPR Course 10: Creativity and Problem Solving Skills Course 11: Time Management So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: Pay once and get 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 designed 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 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But with this special offer, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! PS The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Recruitment Consultant 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. Course Curriculum : Course 01: Recruitment Consultant - Level 4 Introduction : Importance and Implications An Overview The UK Recruitment Legislation Sales and Selling The Recruitment Process Key Performance Indicators Candidate Attraction Candidate Management Candidate Interview Processes Client Acquisition Client Strategy Client Management Steps to Starting and Running a Successful Recruiting Service Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Recruitment Consultant bundle. Requirements This Recruitment Consultant 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 (Recruitment Consultant - Level 4) 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.

Recruitment Consultant Essential Training
Delivered Online On Demand
£53

Verification of Death Training for Nurses

5.0(1)

By Course Gate

Verification of death is a critical competency for nurses, encompassing a range of skills and knowledge areas. It involves understanding the legal framework, recognizing the nuances between expected and unexpected deaths, and mastering the verification process through clinical and forensic examinations.

Verification of Death Training for Nurses
Delivered Online On Demand2 hours 3 minutes
£11.99

Workplace First Aid Training

5.0(1)

By Course Gate

Learn how to handle medical emergencies at work with our Workplace First Aid Training. This course will teach you essential skills, such as CPR, wound care, and illness identification. This course is ideal for anyone who works in an office, factory, school, or other environment.

Workplace First Aid Training
Delivered Online On Demand
£11.99

Web Design Essential Training

5.0(10)

By Apex Learning

*** 11-1 Course Complete Web Design Training*** Interested in learning a valuable trade for an exciting career? Do you want knowledge about HTML, CSS, website layout, and responsive Web Design that will allow you to learn how to design a responsive website? If so, enrol here in this Web Design course. With the help of this Web Design course, discover how to start a career as a web designer! You will learn how to use web design tools, work with HTML and CSS, and develop responsive and interactive designs in this course. We'll go over every process of turning a design into a fully functional web page in this step-by-step tutorial. Along with this Web Design course, you will get 10 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Web Design Bundle Consists of the following Premium courses: Course 01: Modern Web Designing - Level 2 Course 02: Web Design in Affinity Designer Course 03: Diploma in Animation Design Course 04: Advanced Diploma in User Experience UI/UX Design Course 05: Ultimate PHP & MySQL Web Development Course & OOP Coding Course 06: Social Media Website Development Using WordPress Course 07: Create Website for Accounting Business Course 08: Landing Page Design and Conversion Rate Optimisation Course 09: HTML Web Development for Beginners Course 10: Front End Web Development Diploma Course 11: Diploma in PHP Web Development So enrol now in this Web Design Bundle to advance your career! How will I get my Certificate? After successfully completing the Web Design 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 £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Web Design Training course is for everyone. Requirements This Web Design Training Course has been designed to be fully compatible with tablets and smartphones. Career path This Web Design bundle will prepare the participants to be even more complete and compatible in their professional careers. Hence this bundle can boost your career as - Jobs in web design, with an average annual pay of £46,468 in the US Front-end web developer with an average annual pay of £50,000 Senior web developers with an average annual pay of £50,000 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 (Modern Web Designing - Level 2) 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.

Web Design Essential Training
Delivered Online On Demand
£45

Fire Warden Safety Training

5.0(10)

By Apex Learning

Overview Protect people by learning about fire risk and safety with our Fire Warden Safety Trainingcourse.A fire warden is a must in any work premises, working with the employer to assure effective fire safety measures and evacuation procedures. And you can be that responsible fire warden with our expert-designed Fire Warden Safety Training course.This Fire Warden Safety Training course will educate you about fire hazards, safety arrangements, emergency evacuation procedures and provide you with an understanding of fire. It will also familiarise you with your legal duties and equip you with the essential training needed to be a qualified fire warden, enabling you to take responsibility for fire safety in your workplace. 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 Fire Warden Safety Training. It is available to all students, of all academic backgrounds. Requirements Our Fire Warden Safety Training 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 1 sections • 6 lectures • 02:31:00 total length •Fire Warden Safety: An introduction: 00:29:00 •Understanding Fires - The Fire Triangle: 00:35:00 •Risk Assessments: 00:28:00 •The Fire Plan and Safety Arrangements: 00:30:00 •Fire Evacuation Procedures and Strategies: 00:18:00 •Personal Emergency Evacuation Plans: 00:11:00

Fire Warden Safety Training
Delivered Online On Demand2 hours 31 minutes
£12

CSTF Patient Moving and Handling

5.0(1)

By Course Gate

Master safe patient handling techniques with the CSTF Patient Moving and Handling course. Learn best practices, equipment use, and risk management to ensure patient and caregiver safety.

CSTF Patient Moving and Handling
Delivered Online On Demand1 hour 22 minutes
£11.99

Administrator & Microsoft Office Specialist Training

5.0(1)

By Course Gate

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

Administrator & Microsoft Office Specialist Training
Delivered Online On Demand3 days
£11.99

Administrator & Microsoft Office Specialist Training

5.0(1)

By Course Gate

This bundle course has been designed to give our learners a more in-depth understanding of general office procedures, codes of practice and required skills. It provides essential training on the Microsoft Office Suite for managing everyday clerical tasks and is ideal for entry-level learners. Fast track your career and be equipped with the skills and knowledge to manage everyday office tasks efficiently with the Admin, Secretarial & PA Diploma. This comprehensive course is a general introduction to office procedures and practices, exploring the basics of administrative management and admin support. You will develop essential business writing skills, improve your telephone etiquette, learn how to communicate professionally with clients and much more. This course also includes step-by-step guidance on Microsoft Word. Master Microsoft Office suite and boost your efficiency in general administrative tasks with the Microsoft Office Applications Training course. This introductory program is ideal for beginners who have little or no experience with Office programs. You will be guided step-by-step on how to use Word, Excel, PowerPoint, Outlook and Access. On completion, you will be able to create professional slideshow presentations, automate tasks, analyse numerical data and much more. Enrol today and add valuable transferable skills to your CV. Learning Outcomes: Gain a solid understanding of administrative management and admin support Learn the fundamental principles of business writing and improve your telephone etiquette Learn how to communicate effectively and develop your body language skills Familiarise with the day-to-day responsibilities of an administrative assistant, secretary & PA Get tips on how to organise your workload and manage your time efficiently Master Microsoft Office programs - Word, Excel, Powerpoint, Outlook & Access Share documents, automate tasks, analyse data, create slideshows & much more Gain valuable transferable skills to boost your professional development Be able to customise the user interface to your desire Discover time-saving techniques, tips & shortcuts to work faster and more efficiently Who is This Course for? This bundle course is ideal for anyone who wishes to boost their professional development in an office-based role. This training program is particularly suitable for those who are new to their profession and wish to gain the skills and knowledge to prepare them for their career. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path On successful completion, learners will have a solid understanding of fundamental office procedures and practices, and will be equipped with the skills to pursue the following roles: Office Administrator Secretary Personal Assistant Receptionist Admin Assitant Data Entry Clerk

Administrator & Microsoft Office Specialist Training
Delivered Online On Demand3 days
£11.99

Basic Life Support Certification

5.0(1)

By Course Gate

Basic Life Support Certification teaches essential skills for handling emergencies, including CPR, airway management, and choking relief for all age groups. Ideal for healthcare professionals, first responders, and anyone interested in life-saving techniques.

Basic Life Support Certification
Delivered Online On Demand2 hours 39 minutes
£11.99