43967 Learning courses in Edinburgh delivered Online

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Buy Big. Save Big! Offer Ends Soon. Hurry Up!! With this comprehensive Horticulturist course, explore how plants photosynthesise and all the secrets of crafting a garden just in days. Learn from basic botany to plant nutrition with an industry expert and gain incredible skills to stand out as a horticulturist. Turn your dream of a career in horticulture into a reality. This e-learning horticulturist course is designed to provide participants with the practical skills which are essential to starting a professional career in garden design, landscaping, or managing a related venture. Grounded in the practical insight provided by professional garden designers & horticulture specialists. This Advanced Diploma in Horticulturist at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development and career progression related to Horticulturist substantial and easier than ever! Develop skills and knowledge to work as a horticultural worker or assistant. You will learn about planting, recognising plants, treating weeds, pests, and diseases, basic soil properties, renovating grassed areas, basic concepts of organic gardening, plant propagation, arboriculture, permaculture, and so on. Tons of learners around the UK have taken this Horticulturist course to boost their knowledge and skill to work in the related field. This Horticulturist Course is developed by industry experts and is packed with several information-rich modules to give you a proper understanding of this topic and accelerate your career. This broad-ranging Horticulturist course provides a sound introduction to management in horticulture. Find out how to make the right choices to enhance the productivity and profitability of any type of horticulture enterprise. Improve your chances of managerial roles or take this opportunity to refine your professional skills. So, join us today and gear up for excellence! Key Topics to be Covered in Horticulturist Plant Tissues & Cells: Structure and Function The Basic Structure of a Flower An Introduction to Plant Physiology How do Plants Photosynthesise? An Overview of Plant Nutrition The Classification of Plants Soil Composition & Testing Soil PH Organic Methods of Gardening Pest Control, Weed Control & Plant Diseases Skills You Will Gain Basic Botany Gardening Knowledge of plant physiology Understanding of soil science Take a step toward a brighter future! Why Prefer This Horticulturist Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another certificate accredited by CPDQS. Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of this Horticulturist Course: Module 01: Basic Botany Module 02: Plant Classification Module 03: Soil Science Module 04: Plant Nutrition Requirements Module 05: Plant Pests and Diseases Module 06: Basic Concepts of Organic Gardening Module 07: Weed Control Module 08: Plant Propagation Module 09: Amenity Horticulture, Plant Selection and Native Plants Module 10: Exotic Plants Module 11: Indoor Plants Module 12: Lawns Module 13: Planting and Plant Care Module 14: Plant Nodes and Indigenous Plants Module 15: Plant Protection, Landscaping and Garden Design Module 16: Ornamental Horticulture Module 17: Permaculture Module 18: Arboriculture Module 19: Horticulture Statistics Module 20: Results from the 2018 Seasonal Labour in Horticulture End of Year Assessment Process After completing an online course module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. After passing the Advanced Diploma in Horticulturist at QLS Level 7 exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Horticulturist course will come in handy for Gardeners. Landscape executives. Horticulturalists. Agricultural experts. Homeowners who want to do gardening. Requirements You will not need any prior background or expertise to enrol in this Horticulturist course. Career path The horticulturist course is designed for those who are looking to kickstart a career as a horticulturist or develop their expertise in gardening. Professions in this field include the following Horticulture Manager Horticulture Trainer Quality Manager - Plants Field Technician - Plants Gardener Landscaper Botanist Certificates CPD Accredited Certificate Digital certificate - £10 Advanced Diploma in Horticulturist at QLS Level 7 Hard copy certificate - £139 Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Horticulturist at QLS Level 7course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 139 GBP inside the UK 149 GBP (including postal fees) for international delivery CPDQS Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Attention all health enthusiasts and aspiring vegans! Are you looking to take your health and nutrition to the next level? Do you want to learn how to maintain a healthy and balanced vegan diet? Look no further than the Vegan Nutrition Masterclass. This comprehensive Vegan Nutrition Masterclass course is designed to provide you with all the tools and knowledge you need to optimise your vegan diet and achieve your health goals. In this Vegan Nutrition Masterclass course, you will learn everything from the basics of a vegan diet, to setting up a healthy vegan meal plan, to building muscle and losing fat on a plant-based diet. You will also discover how to avoid vitamin and mineral deficiencies and learn the different dieting tips to boost your health and immune system. With engaging video lectures and easy-to-follow modules, you will gain the confidence to take control of your health and wellness. By the end of this Vegan Nutrition Masterclass course, you will have a deeper understanding of vegan nutrition and how to optimise your diet for your specific goals. You will learn how to set up a balanced meal plan, identify the best vegan food sources for macronutrients, and how to avoid nutrient deficiencies. You will also be equipped with the knowledge to build muscle and lose fat on a plant-based diet, and how to boost your immune system and testosterone levels naturally. After this Vegan Nutrition Masterclass course, you will be able to learn: Understand the basics of a vegan diet and debunk common myths Develop a healthy and balanced vegan meal plan Identify the best vegan food sources for macronutrients Avoid vitamin and mineral deficiencies on a vegan diet Build muscle and lose fat on a plant-based diet Boost your health and immune system through different dieting tips *** Course Curriculum *** Here is the curriculum breakdown of the Vegan Nutrition Masterclass: Module 01: Introduction Vegan Promo Course Overview Get to know your instructor Module 02: Vegan Basics The Most Common Vegan Myths Debunked The Difference Between Vegan & Vegetarian Diets Explained Module 03: Setting Up A Healthy Vegan Diet The 5 Principles Of A Healthy Vegan Diet Calories Explained How To Determin Your Optimal Calorie Intake How To Calculate Your Daily Calorie Needs The Best Vegan Food Sources Protein Explained Quality Vegan Protein Sources Carbohydrates Explained Quality Vegan Carb Sources Dietary Fats Explained Quality Vegan Fat Sources Macronutrients Explained How Much Protein Should You Consume As A Vegan How Much Fat Should You Consume As A Vegan How Many Carbs Should You Consume As A Vegan Nutrient Timing Explained Nutrient Timing For Vegans Nutrient Timing Recommendations Supplements For Vegans Module 04: How To Lose Fat & Build Muscle On A Plant Based Diet Can You Build Muscle On A Vegan Diet? How To Adjust Your Diet For Muscle Growth Pre-workout meal copy Post workout meal copy HOW TO USE PROTEIN POWDER WHEN, HOW MUCH & WITH WHAT How To Adjust Your Diet For Fat Loss Everything You Need To Know About Cheat Meals & Cheat Days How To Use Creatine Vegan Foods For Energy Vegan Foods For Fat Loss Vegan Foods To Increase Your Metabolism Module 05: Avoiding Mineral & Vitamin Deficiencies As A Vegan How To Get Enough Vitamin A As A Vegan How To Get Enough Vitamin B12 As A Vegan How To Get Enough Vitamin C As A Vegan How To Get Enough Vitamin E As A Vegan How To Get Enough Vitamin K As A Vegan How To Get Enough Calcium As A Vegan How To Get Enough Copper As A Vegan How To Get Enough Iron As A Vegan How To Get Enough Magnesium As A Vegan How To Get Enough Sodium As A Vegan How To Get Enough Phosphorus As A Vegan How To Get Enough Potassium As A Vegan How To Get Enough Zinc As A Vegan Water Module 06: Different Dieting Tips How to boost testosterone naturally The 5 Best Supplements To Boost Your Immune System How To Read A Nutrition Label How To Do Your Own Diet Research Assessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Vegan Nutrition Masterclass course is for: Health enthusiasts Aspiring vegans Anyone looking to optimise their nutrition and health Requirements The Vegan Nutrition program does not require any prior knowledge; everyone may participate! This Vegan Nutrition course is open to anyone interested in learning from anywhere in the world. Career path Vegan Nutritionist: £22,000-£50,000 Health and Wellness Coach: £16,000-£38,000 Dietitian: £24,000-£43,000 Personal Trainer: £14,000-£47,000 Sports Nutritionist: £20,000-£40,000 Food and Nutrition Blogger: £12,000-£45,000 Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! If you are a parent-to-be or considering a career in midwifery, this course will launch you into the world of midwifery, pregnancy and childbirth. You will explore the role of a midwife working with pregnant women and their families during the pregnancy period, labour and birth. Also following birth, learn how to support the woman in her new role as a mother. The advanced audiovisual materials have been designed to guide you through the steps of Midwifery, Maternity Care & pregnancy and assist you with prenatal & postnatal medical care, counselling and offering support, as well as in preparing families for parenthood. Further, in the Introduction to Midwifery Certificate course, you'll develop the ability to recognise various possible infections in newborns and how to take the necessary steps. Learn how to help pregnant women & new mothers with proper nutrition & diet and also assist them in feeding their infants by gaining expertise with our online course on Introduction to Midwifery Certificate. This Introduction to Midwifery Certificate training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! What Will You Learn From This Introduction to Midwifery Certificate Programme? Discover midwifery career options in today's UK and comparison of this management & education among several countries Roles of a midwife while working in health and inequality including planning diets and pain management during labour Ability to diagnose pregnant women's health conditions and provide antenatal care Risks & side effects in induction of labour and determining the expected date of delivery The postnatal examination processes of the newborn baby & new mother Effective interpersonal skills to advise new mothers on postnatal exercise, newborn nutrition, parent consultation and family planning A clear understanding of stillbirth, neonatal death and miscarriage also caring for bereaved mothers The role of midwifery in feeding infants assisting mothers in breastfeeding, artificial feeding, and parental mental health Recognise the signs and symptoms of infection in newborns, such as infectious diarrhoea and gastroenteritis, hepatitis B virus, HIV etc How to take care of women with diabetes, heart disease and kidney disease including CAM administration and medicines management Why Prefer This Midwifery & Maternity Care Course? Midwifery & Maternity Care certificate accredited by CPDQS Get instant access to this Midwifery & Maternity Care Training course. Learn Midwifery & Maternity Care from anywhere in the world Midwifery & Maternity Care Training is affordable and simple to understand Midwifery & Maternity Care Training is an entirely online, interactive lesson with voiceover audio Lifetime access to the Midwifery & Maternity Care Training course materials Midwifery & Maternity Care Training comes with 24/7 tutor support Free assessments are available with Midwifery & Maternity Care Training Get a free student ID card! (£10 postal charge will be applicable for international delivery) with Midwifery & Maternity Care Training Take a step toward a brighter future! *** Course Curriculum of Midwifery & Maternity Care*** Module 1: Definition and Origin of Midwifery Module 2: Midwifery as a Career Option Module 3: Midwifery Management and Education Module 4: Midwives' Role in Health and Inequality Module 5: Social, Cultural and Spiritual Context of Childbearing Module 6: Antenatal Care and Screening Module 7: Midwifery Support in Labour: Intrapartum Care Module 8: Induction of labour Module 9: Postnatal Care Module 10: Nurture and Nature: The Healthy Newborn Module 11: Stillbirth, Neonatal Death and Bereavement Module 12: Infant feeding Module 13: Newborn Infection Module 14: Home Birth Module 15: Complementary and Alternative Medicines Applied to Maternity Care Module 16: Pharmacology and Medicines Management Module 17: Bleeding in Pregnancy Module 18: Medical Disorders of Pregnancy Module 19: Pre-term Labour Module 20: Twins and higher-order births Module 21: Care During the Third Stage of Labour Module 22: Terminology and Abbreviations Module 23: Perinatal mental health Module 24: Supporting a Healthy Pregnancy Module 25: Contraception and family planning Module 26: Effective Communication Module 27: Ethics Assessment Process of Midwifery & Maternity Care Once you have completed all the modules in the Introduction to Midwifery Certificate course, you can assess your skills and knowledge with an optional assignment. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Introduction to Midwifery Certificate course. This course is open to everybody. Disclaimer: Please note the completion of this course does not result in a degree or allow participants to practice professionally. Requirements You will not need any prior background or expertise to enrol in this Midwifery & Maternity Care course. Career path After completing this Introduction to Midwifery Certificate Programme you are to start your career or begin the next phase of your career. Midwife Maternity Care Assistant Neonatal Nurse Medical Staff Maternity Support Worker Health Visitor & more. Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

>>24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now!<< Life is too short for boring nails! If nail art is one of your hobbies, it is high time to let your imagination fly. Join us in this nail technician course to learn the principles of nail art and work your way towards a lucrative nail technician profession. This comprehensively designed course will prepare you to work with a wide range of clients and be innovative in your work. This Diploma in Nail Technician at QLS Level 5 course is Endorsed by The Quality Licence Scheme Accredited by CPDQS (with 150 CPD points) This course will teach you how to care for and design your fingers and toenails. It will discuss the anatomy of the skin and nails, as well as the many nail problems. It will then walk you through the manicure and pedicure procedure and introduce you to crucial nail care items. You'll also learn how to work with artificial nails as well as numerous nail art techniques. Finally, it will provide fantastic advice on career prospects and relevant business opportunities. Nowadays, both men and women want their nails to be in ideal condition. As a result, the demand for nail salons is increasing. A career as a nail technician would be the best approach to taking advantage of the situation. This nail technician course can help you establish a nail tech profession while also earning money on the side. So, without further ado, enrol now! We are offering two more courses with this Nail Technician at QLS Level 5 course: Main Course: Diploma in Nail Technician at QLS Level 5 Bonus Course 1: Gel Manicure and Nail Artist Diploma Bonus Course 1: Personal Hygiene Course Learning Outcome of This Nail Technician Course: Discover how to clean, cut, and shape your nails. Learn the anatomy of nails. Investigate the ideas and methods of nail art. Be able to design various nail art styles. Learn about the different types of nail disorders. Learn how to provide customers with manicures, pedicures, and other nail treatments. Understand the instruments used in manicures and pedicures. Understand the UK legislation and pandemic implications. Be able to offer aftercare guidance to a customer. Discover how to open a nail salon. Why Prefer This Nail Technician Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another accredited by CPDQS after completing the Nail Technician course Get a free student ID card! Get instant access to this nail technician course. Learn to be a nail technician from anywhere in the world Nail Technician are affordable and simple to understand Nail Technician is entirely online, interactive lesson with voiceover audio Lifetime access to the Nail Technician course materials Nail Technician comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Nail Technician course: Module 01: Nail Technician 101 Module 02: General Anatomy Module 03: Skin Structure, Growth, and Nutrition Module 04: Anatomy of Nail Module 05: Equipment for the Technician Module 06: Tools and Techniques Module 07: Basics of Chemistry and Chemicals Module 08: Nail Product Chemistry Module 09: Manicure Module 10: Pedicure Module 11: Nail Diseases and Skin Problems Module 12: Artificial Nails Module 13: Nail Art Module 14: Safety Practices Module 15: Career Prospect and Business Preparations Module 16: UK Legislations and Pandemic Implications Assessment Process of Nail Technician at QLS Level 5 Course: You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. After passing the Diploma in Nail Technician at QLS Level 5 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Beginners in nail care and design. Beauty industry professionals. Nail art enthusiasts. Freelance nail technician s. Salon owners and managers. Career changers interested in nail technology. Requirements You will not need any prior background or expertise to enrol in this Nail technician course. Career path This course delivers important abilities that would benefit you in pursuing the following professions: Nail Technician Manicurist\Pedicurist Beauty Salon Employee/Business Nail Art Influencer Nail Technician Instructor In the United Kingdom, the average salary for these occupations ranges from £24,450 to £51,503 per year. Certificates Certificate of completion Digital certificate - Included Diploma in Nail Technician at QLS Level 5 Hard copy certificate - £119 Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Nail Technician at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for International Delivery Certificate Accredited by CPDQS 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (International Delivery)

Uncover Excel 2019's potential through our comprehensive Microsoft Excel course. It empowers you to master features, calculations, data analysis, and automation. Whether you're new to spreadsheets or aiming for data expertise, this course is tailored for you. Our Microsoft Excel course simplifies Excel's complexities, making it beginner-friendly. It equips you with skills vital in today's data-driven landscape. Beyond personal growth, this Microsoft Excel course boosts career prospects. Excel proficiency is valuable in a competitive job market, opening doors to diverse opportunities. Our course is a transformative journey into Excel 2019, unlocking potential, enhancing skills, and advancing careers. Whether you're a novice or aspiring data pro, it's your key to Excel's power and your potential. Learning Outcomes of our Microsoft Excel course: Master Microsoft Excel 2019's latest features. Perform complex calculations with ease. Create visually appealing and well-formatted worksheets. Analyze and visualize data effectively using charts and PivotTables. Automate workbook tasks with Excel VBA. Why buy this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7? Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Who is this Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 for? Individuals new to Microsoft Excel looking to build a strong foundation. Students and job seekers aiming to enhance their employability. Business professionals wanting to improve data management and analysis skills. Entrepreneurs seeking to streamline their business processes. Anyone interested in harnessing the power of Excel for personal or professional growth. Prerequisites This Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £40,000 per year Financial Analyst: £30,000 - £50,000 per year Business Intelligence Analyst: £30,000 - £55,000 per year Operations Manager: £35,000 - £70,000 per year Project Manager: £40,000 - £70,000 per year Excel VBA Developer: £35,000 - £60,000 per year Certification After studying the course materials of the Advanced Diploma in Microsoft Excel Complete Course 2019 at QLS Level 7 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started with Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 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 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working with Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:23:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11: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:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07: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:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Sharing and Protecting Workbooks Collaborate on a Workbook 00:19:00 Protect Worksheets and Workbooks 00:08: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:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel VBA Data Management Create a Macro Using the Macro Recorder 01:00:00 Edit a Macro 01:00:00 Debug a Macro 00:30:00 Customize the Quick Access Toolbar and Hotkeys 00:30:00 Set Macro Security 01:00:00 Insert Text 00:30:00 Format Text 00:30:00 Sort Data 00:30:00 Duplicate Data 01:00:00 Generate a Report 01:00:00 Determine the Dialog Box Type 00:15:00 Capture User Input 01:00:00 Insert, Copy, and Delete Worksheets 00:30:00 Rename Worksheets 00:30:00 Modify the Order of Worksheets 00:15:00 Print Worksheets 00:30:00 Create User-Defined Functions 00:30:00 Automate SUM Functions 00:30:00 Excel Templates Excel Templates 00:00:00 Resources Resources - Microsoft Excel - Beginner Course - Cpd Accredited 00:00:00 Mock Exam Mock Exam - Microsoft Excel Complete Course 2019 00:20:00 Final Exam Final Exam - Microsoft Excel Complete Course 2019 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Our very special and popular Childcare and Nutrition Course teaches the two essential skills that will keep children safe and healthy. If you are a parent or a dedicated childminder, you will find a wealth of knowledge here that ensures a child's welfare in all possible ways. Using online learning modules, with each one dedicated to an essential aspect of Childcare, you can learn how to influence their lives and provide appropriate support positively. When you enrol in the course, you will be presented with an extensive range of useful guidelines. You will be taught the primary stages of child development, and how you can support this with day-to-day routines. The course also presents a masterclass on the dietary nutrients that are vital for a child's health, alongside recommended exercise, and physical activities. Learners will also be shown how to identify cases of abuse or bullying and the support methods for SEN children. The Childcare and Nutrition Course is an excellent way to acquire Childcare knowledge and nutritionist training in one complete package. The course contents have been written with the aid of experts in their respective fields and provides trustworthy recommendations for those caring for one or more children. Interactive assessments and visual/audio aids will help embed the information provided. Sign up now and protect the health and happiness of your children. Why choose this Childcare and Nutrition 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 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 materials Mock exams Multiple-choice assessment 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 £99. 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 In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? This course is ideal for expert childminders, school staff, and parents. Anyone who watches over the wellbeing and health of a young person will benefit from the knowledge given here.

Instructor-Led Online Course | CPD Accredited | 2 Free Courses + 3 PDF Certificates | Tutor Support | Lifetime Access

Do you want to give your home an updated look? Taking this Painting and Decorating Training will equip you with the skills for painting and decorating. Painting walls, furniture and other parts of the house or building could make a big difference visually. On this course, you will discover painting ideas and techniques on art and interior design. Whether it is cooking or painting, getting the right recipes and ingredients is the most vital thing you need to know. Through the course, you will understand the psychology of colour and use it to your advantage. If you have the love for interior painting and designing, then this course is highly recommended for you. Why choose this course Earn an e-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 materials Mock exams Multiple-choice assessment 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 £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is this course for? Painting and Decorating Training is suitable for anyone who want to gain extenwants knowledge, potential experience and professional skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or qualification to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all student from any academic backgrounds to learn more on this subject.

Are you ready to master the art of exceptional service? Our Concierge Training course is designed to transform you into a highly skilled and knowledgeable concierge, capable of delivering unparalleled service to your clients. Join us to enhance your career prospects and become a key player in the hospitality industry. Key Features: CPD Certified Developed by Specialist Lifetime Access In the Concierge Training course, learners will gain a comprehensive understanding of concierge services. They will explore different types of concierge services and learn the principles of running a successful concierge business. Essential skills for any concierge will be covered, including effective communication, problem-solving, and time management. Learners will also focus on delivering exceptional client service and maintaining a professional work environment. The course will teach proper etiquette for interacting with clients and colleagues. Additionally, learners will be trained in handling emergencies in a hotel setting, ensuring they are prepared to respond promptly and efficiently to any situation. Course Curriculum Module 01: Understanding the Service Module 02: Types of Concierge Service Module 03: Principles for a Concierge Service Business Module 04: Necessary Skills for Any Concierge Module 05: Delivering Client Service Module 06: Concierge Work Environment and Etiquettes Module 07: Emergency Measures for a Hotel Concierge Learning Outcomes: Understand the fundamentals of providing excellent concierge service. Differentiate between various types of concierge services. Learn principles to establish a successful concierge service business. Develop essential skills required for any concierge role. Master the art of delivering exceptional client service. Recognise proper etiquette and manage emergency situations in a hotel. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring hotel concierge professionals. Individuals interested in luxury service. People starting a concierge business. Hotel staff seeking role enhancement. Customer service enthusiasts. Career path Hotel Concierge Personal Concierge Corporate Concierge Lifestyle Manager Luxury Travel Concierge Event Concierge Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you aware of the risks posed by Hand-Arm Vibration Syndrome (HAVS)? This debilitating condition can severely impact workers' health, leading to loss of hand function and chronic pain. Protect your team and ensure compliance with health and safety regulations by enrolling in our HAVS Awareness Course. Key Features: CPD Certified Developed by Specialist Lifetime Access This course on Hand-Arm Vibration Syndrome (HAVS) provides essential knowledge to help you understand and manage the risks associated with vibration exposure in the workplace. You will learn about HAVS and its symptoms, including how it affects the hands and arms. The course covers common conditions related to HAVS, such as Vibration White Finger and Carpal Tunnel Syndrome. You will also explore the relevant laws and regulations that govern workplace safety concerning vibration hazards. The training includes practical methods for identifying and controlling risks, helping you implement effective safety measures. Additionally, you'll gain skills in conducting assessments and providing HAVS training to others. By the end of this course, you will be equipped to create a safer work environment, reducing the risk of HAVS for yourself and your colleagues. Course Curriculum Module 01: Introduction to Hand-arm Vibration and HAVS Module 02: Popular Syndromes Module 03: Laws and Regulations Module 04: Controlling Risk Module 05: HAVS Training and Assessment Learning Outcomes: Understand hand-arm vibration and its impact on health and safety. Identify common syndromes associated with hand-arm vibration exposure. Comprehend laws and regulations regarding hand-arm vibration. Implement strategies for controlling risks of hand-arm vibration. Conduct effective HAVS training and assessment in the workplace. Recognise symptoms and prevention techniques for HAVS. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Health and safety officers Occupational health specialists Construction industry workers Manufacturing industry employees Employers managing vibration risks Career path Health and Safety Advisor Occupational Health Nurse Environmental Health Officer Construction Site Manager Manufacturing Supervisor Compliance Officer Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.