20727 Other courses

Microsoft Excel Advanced Course Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions. The Microsoft (MS) Excel Certification Level 3 Course is the most comprehensive of the three Excel courses presented here. If a team member has successfully completed the Level 1 and Level 2 courses, they will be fully prepared to start the Level 3 course. Formulae or functions are what advanced users of Excel want from this tool. When you use formulae, not only can you see the data that you require for your work, you can also analyse it and get answers to complex questions. Although anyone with some Excel knowledge can use formulae, such as SUM, a user who has the advanced Excel skills presented in this course will use other formulae, both alone and combined, such as MATCH, INDEX, DSUM and VLOOKUP. In addition to knowing and using these formulae, an advanced user of Excel knows how to debug these formulae, how to audit them and how to choose the perfect formula for the particular task to be carried out.   What's Covered in the Course? Any staff member choosing to study this course can expect to gain the following skills: How to set A Password to an Excel document; VLOOKUP Advanced formula options and manipulations; Other advanced functions: OR, AND, CHOOSE, INDIRECT, REPLACE, LEN, LEFT, FIND; Functions of CEILING, CORREL, DATEDIF, DATEVALUE, DAVERAGE and EDATE; Colouring a column and row with a formula; Highlighting a cell with a formula; Functions of ISODD, ISNUMBER, ISTEXT, ISLOGICAL, ISNONTEXT, ISERR and ISBLANK; Functions of DGET, DMAX, DPRODUCT, DCOUNTA, DCOUNT and DSUM; How to calculate depreciation in Excel, including SLN depreciation and SYD depreciation; Calculating loan IPMT and EMI; Functions of DATEDIF, DATEVALUE, EDATE, EOMONTH, MATCH and INDEX; Full explanation of the INDEX and MATCH functions; Looking up data; Selecting only cells containing comments; Hiding formulae; Automatically inserting serial numbers;   The employee will also learn about calculating depreciation, calculating interest and calculating IPMT and EMI for loans, all by using Excel functions. The course features information on INDEX and MATCH functions, which is important in certain industries and roles. It also shows learners how to use the CHOOSE formula and how to create special charts. What are the Benefits of the Course? Upon completion of the Level 3 course, the employee will have access to the full functionality of Excel and will know how to use all of its formulae, functions and capabilities; The Level 3 Excel course is designed for 'power' users, but not only for programmers and those interested in financial modelling; Competent Excel users add huge value to an organisation, through advanced data analysis.

Give a compliment to your career and take it to the next level. This Food Safety & Food Processing Training will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this course will help you keep ahead of the pack. Along with this course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a free student ID card. What other courses are included with this Food Safety & Food Processing Training? Course 1: Food Processing Diploma Course 2: TACCP Training Course Course 3: Food Allergen Awareness Course 4: Nutrition and Diet Awareness Course 5: Ketogenic Diet Course 6: Immunity Boosting Food Course 7: Food and Mood: Improving Mental Health Through Diet and Nutrition Course 8: Create a Short Recipe Video Course 9: Personal Hygiene Course 10: Kitchen Gardening So, enrol now to advance your career! Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 11 CPD courses Certificate, 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 Gain valuable knowledge without leaving your home 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. Curriculum: Course 1: Food Hygiene Level 2 Diploma Level 1- Food Hygiene and HACCP Module 01: Introduction to Food Hygiene Module 02: Food Safety Hazards Module 03: Food Safety Controls Module 04: Personal Hygiene Module 05: Cleaning Activities Level 2 - Food Hygiene and HACCP Introduction Bacteria and Microbiological Hazards Physical, Chemical and Allergenic Hazards Food Poisoning and Control Measures Food Spoilage and Food Storage Personal Hygiene HACCP and Food Premises Part 01 HACCP and Food Premises Part-02 Cleaning Reopening and Adapting Your Food Business during COVID-19 Course 2: Food Processing Diploma Course 3: TACCP Training Course Course 4: Food Allergen Awareness Course 5: Nutrition and Diet Awareness Course 6: Ketogenic Diet Course 7: Immunity Boosting Food Course 8: Food and Mood: Improving Mental Health Through Diet and Nutrition Course 9: Create a Short Recipe Video Course 10: Personal Hygiene Course 11: Kitchen Gardening CPD 110 CPD hours / points Accredited by CPD Quality Standards Requirements 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 certifications will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Serious about starting your own candle business? Set yourself up for success from the very beginning, in a private course with Paula Mateo, award winning founder of Old Bexley Soap & Candle Co.

Workshop is designed to support participants in using the Six Stages Framework in Board development and Diversity, Equity and Inclusion

Do you know, Employment of lawyers is projected to grow 6% from 2018 to 2028, as fast as the average for all occupations? So this is the perfect time to dive into this sector. However, our course is an excellent way to learn about the legal aspects of employment, family law, and other areas of law. We designed this course to provide you with the fundamentals of the legal system, the various types of employment law, the various types of family law, the criminal justice system, and other areas of law. You will also be able to learn about various types of legal arguments and research methods. Further from this course, you'll learn about the various types of Employment contracts, the various types of Employment discrimination, and the various types of Employment benefits. When it comes to criminal justice, you'll learn about the different types of criminal offences, their penalties, and criminal proceedings. By taking our course, you will be able to gain a better understanding of the legal system and the different types of laws that govern various aspects of our society. You will also gain a thorough understanding of employment, family, and criminal justice laws. This knowledge can be extremely useful if you want to enter the legal profession. Along with this Law course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: English Law and Legal System Level 3 Course 02: Understanding Wills and Probate Laws - Level 2 Course 03: UK Employment Law and Employee Rights Diploma Course 04: Family Law 2021 Course 05: Criminology Law and Psychology Course 06: GDPR Data Protection Level 5 Course 07: Contract Manager Diploma Course 08: Anti Money Laundering (AML) Regulation for AML Officers Diploma Course 09: COSHH Awareness Level 3 Course 10: Mental Health Laws and Awareness - Level 2 Course 11: Stress Management Training Learning Outcomes Recognise the legal ramifications of Employment Law to Family Law. Learn various laws that govern Employment and Family Law. Assess the Employment Law policies, procedures, and legal implications concerning Family Law. Create strategies for effectively addressing Employment Law issues in the context of Family Law. Analyse and interpret Employment and Family Law case studies. Use legal reasoning to evaluate the impact of Employment and Family Law. Enrol now to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Law 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. 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 interested in studying and understanding the law. This includes those who are considering careers in law, such as lawyers, legal assistants, paralegals, and other legal professionals, as well as those who are simply interested in learning more about the legal system. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path The following professions are most familiar in this sector Attorney Judge Paralegal Legal Secretary Legal Analyst In general, these professions typically earn between £30,000 and £50,000 per year in the UK Certificates Certificate of completion Digital certificate - Included

QA Level 2 Award In Basic Life Support For Adults And Children (RQF) This page is here if you'd like us to run this course for you and your people, at our venue or yours (within 45 minute drive from Chesterfield, Derbyshire). If you'd like us to run this course for you and you're further away, please contact us direct for a quote.   If, instead, you're interested in an open/public course, please go here. Half day course Also called Basic Life Support, BLS, or BLS training Teaches the basics of first aid for adults, children and infants (babies) Useful for many occupations. Also available as a bolt-on to certain other courses, at just a third of the price. Course Contents: Managing an Unresponsive Casualty Recovery Position for an adult, a child and an infant (baby) CPR for an adult, a child and an infant (baby) Safe Use of an AED (Automated External Defibrillator) Choking for an adult, a child and an infant (baby) Benefits of this course: 1.1 million workers in Britain had an accident at work in 2014/2015 Of those, 2,700 were from the East Midlands On average, one out of every 370 people received an injury at work Children are prone to minor injuries, but can also suffer from serious ones More than 2 million children have accidents in the home for which they're taken to A&E every year. Under 5s account for 7% of all hospital emergency treatments This Level 2 Award in Basic Life Support for Adults and Children course teaches the skills and knowledge needed to provide basic life support for adults and children It is also useful for those who are already qualified in first aid, to refresh their skills and knowledge and broaden it to cover both adults and children This course is taught in a hands-on, practical way Accredited, Ofqual regulated qualification: Our Basic Life Support for Adults and Children's course is a nationally recognised, Ofqual regulated qualification accredited by Qualsafe Awards.This means that you can be rest assured that your Basic Life Support for Adults and Children's Certificate is a very good way to make sure you and your employees are trained in First Aid for both adults and children.The Ofqual Register number for this course is 603/2547/1

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This Nail Technician & Beauty Therapy will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Nail Technician & Beauty Therapy will help you keep ahead of the pack. The Nail Technician & Beauty Therapy incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Nail Technician & Beauty Therapy 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 profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Nail Technician & Beauty Therapy, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Nail Technician & Beauty Therapy course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. This Nail Technician & Beauty Therapy Bundle Consists of the following Premium courses: Course 01: Online Nail Technician Diploma Course 02: Beauty Therapist Level 3 Training Course Course 03: Skin Care Treatment Course 04: Bridal and Occasional Makeup Artist Masterclass Course 05: Makeup Artistry Course Course 06: Brow Lamination and Lash Lift, Brow Tint and Lash Tint Course 07: Manicure and Pedicure Course 08: Hairdressing Level 3 Course 09: Aging and Longevity Secrets Course 10: Nutrition and Hydration Course 11: Personal Hygiene So, enrol now to advance your career! The bundle 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. Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Nail Technician & Beauty Therapy bundle. Requirements Our Nail Technician & Beauty Therapy is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. Career path Having these various expertise will increase the value in 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 (Online Nail Technician Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

***Premium Version*** **Be prepared for the upcoming Hiring Season by enhancing your professional skillsets with Apex Learning! Get Hard Copy + PDF Certificate + Transcript + Student ID Card as a Gift - Enrol Now** Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Purchasing and Procurement and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Purchasing and Procurement bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Purchasing and Procurement course that will enhance your skills and prepare you for the competitive job market. Also, our Purchasing and Procurement experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Purchasing and Procurement, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Purchasing and Procurement Bundle Consists of the following Premium courses: Course 01: Purchasing & Procurement Course - Level 3 Course 02: Logistic Management Course 03: Retail Operations Training Level 3 Course 04: Merchandising Course 05: Commercial Law 2021 Course 06: Level 3 Tax Accounting Course 07: Diploma in Lean Process and Six Sigma Course 08: Import/Export Processing Course 09: Quality Management Course 10: Warehouse Course 11: SAP Controlling (CO) - Product Costing S4HANA Course 12: Budgeting and Forecasting Course 13: Business Analysis Level 3 Course 14: Effective Communication Skills Diploma Benefits you'll get choosing Apex Learning: One payment, but lifetime access to 14 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 The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Purchasing & Procurement 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: Purchasing & Procurement Course - Level 3 Supply Chain Basics Role of Procurement in an Organisation The Purchasing Cycle Purchasing Toolkits Managing Competitive Bids Quality Management Supplier Relationship Management Improving Efficiency and Accuracy Category Management 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 (For The Title Course) 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. Learners inside the UK will enjoy free delivery of the hardcopy certificate, and learners outside the UK will need to pay a £9.99 postal delivery charge. CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Purchasing and Procurement bundle. Requirements Our Purchasing and Procurement course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this Purchasing and Procurement expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Stop Smoking With Confidence Training Program, you'll learn the skills you need to finally stop smoking and stay smoke-free. A swift, no-nonsense primarily audio course of action to become a Non-Smoker within the next seven days, includes hypnosis. Your trainer is Caroline Anderson MSc Psych, BSc Clinical Hypnosis,Mstr NLP, EFT3, Dip Personnel Mgmt.

Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 175 fully featured services from data centers globally. Millions of customers—including the fastest-growing startups, largest enterprises, and leading government agencies, are using AWS to lower costs, become more agile, and innovate faster.