702 Macro courses delivered Online

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £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 and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thankyou Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview: Intermittent fasting is a popular and effective way to improve your health and lose weight. But what is intermittent fasting, and how does it work? This Intermittent Fasting For Health & Maximal Weight Loss course will answer all these questions. You will learn the science behind intermittent fasting, the different fasting methods, and how to choose the best one. You will also learn how to plan your meals, track your calories and macronutrients, and optimise your nutrition for intermittent fasting. You will discover how intermittent fasting affects your metabolism, hormones, inflammation, and cellular repair and how it can help you prevent or manage various chronic diseases. You will also learn how to combine intermittent fasting with different types of exercise, such as resistance training, cardio, or high-intensity interval training (HIIT), to maximise your muscle growth and fat loss. You will also learn about the potential pitfalls and challenges of intermittent fasting and how to overcome them. Enrol today and start your journey to a healthier and happier you! Key Features of the Course: This Intermittent Fasting For Health & Maximal Weight Loss course offers a CPD certificate upon completion, demonstrating your commitment to professional development in health and nutrition. You will have 24/7 learning assistance to support your journey, and the course materials are designed to be engaging and informative, providing a rich learning experience. Who is This Course For? This Intermittent Fasting For Health & Maximal Weight Loss course is ideal for anyone interested in health, nutrition, and weight loss. Whether you're a fitness enthusiast, a health professional, or someone looking to improve their health and lose weight, this course will provide valuable insights and practical knowledge. What You Will Learn: The science and benefits of intermittent fasting. How to debunk common myths about intermittent fasting. The role of macronutrients in fasting and how to manage them. The importance of meal planning in intermittent fasting. The relationship between intermittent fasting and fitness. How to use intermittent fasting for muscle growth and fat loss. The potential synergy between intermittent fasting and ketogenic diets. Why Enrol in This Course: This Intermittent Fasting For Health & Maximal Weight Loss course is top-rated by learners and has recently been updated with the latest research and trends in intermittent fasting. By enrolling, you will develop skills in health and nutrition that are highly sought after in today's health-conscious society. Requirements: There are no specific prerequisites for this course. All you need is an interest in health, nutrition and a willingness to learn. Career Path: Upon completion of this course, you could explore a variety of professions, including: Nutritionist (£29,000 per year) Fitness Trainer (£19,500 per year) Health Coach (£25,000 per year) Wellness Consultant (£40,000 per year) Dietician (£35,000 per year) Health Writer (£31,000 per year) Health and Wellness Speaker (£45,000 per year) Certification: Upon completing the Intermittent Fasting For Health & Maximal Weight Loss course, learners will receive a CPD certificate, demonstrating their commitment to professional development in health and nutrition. Course Curriculum 6 sections • 37 lectures • 02:35:00 total length •Welcome to the course: What You Will Learn: 00:03:00 •Intermittent Fasting Explained: 00:03:00 •The Different Types Of Intermittent Fasting: Which Is Best?: 00:07:00 •Intermittent Fasting vs Regular Fasting: 00:02:00 •The Health Benefits Of Intermittent Fasting: 00:06:00 •Intermittent Fasting Myths Debunked: 00:09:00 •Breakfast: How Important Is It Really?: 00:06:00 •Who Intermittent Fasting Is Right For: 00:02:00 •Introduction: 00:01:00 •The Intermittent Fasting Priorities: 00:05:00 •Calories In Intermittent Fasting: 00:05:00 •Macronutrients In Intermittent Fasting: Protein, Carbs & Fat: 00:02:00 •Protein Explained & How Much You Should Eat: 00:06:00 •Dietary Fat Explained & How Much You Should Eat: 00:05:00 •Carbohydrates Explained & How Many You Should Eat: 00:12:00 •When To Eat In Intermittent Fasting: 00:01:00 •The Perfect Pre- & Post-Workout Meals: 00:05:00 •Foods For Intermittent Fasting Overview: 00:02:00 •The Best Protein, Fat & Carb Foods: 00:05:00 •Top 3 The Supplements For Intermittent Fasting: 00:06:00 •Setting Up Your Meal Plan Introduction: 00:01:00 •How To Find Your Calories For Intermittent Fasting: 00:03:00 •How To Correctly Track Calories: 00:05:00 •How To Find Your Macronutrients For Intermittent Fasting: 00:04:00 •Bringing Everything Together: 00:02:00 •Organizing Your Meals: How Many & When To Eat: 00:04:00 •Your Meals & Workouts: 00:02:00 •Should You Train Fasted?: 00:06:00 •Filling Your Meal Plan With Quality Foods: 00:04:00 •Intermittent Fasting & Fitness Introduction: 00:01:00 •Intermittent Fasting For Muscle Growth: 00:06:00 •How To Train With Intermittent Fasting: 00:07:00 •Intermittent Fasting For Fat Loss: 00:05:00 •Intermittent Fasting & Ketogenic Diets: Should You Do Both?: 00:05:00 •Is Intermittent Fasting Bad For Women?: 00:02:00 •How Does Intermittent Fasting Benefit Longevity: 00:03:00 •Who Should Avoid Intermittent Fasting?: 00:02:00

This course will help you become familiar with the implementation of creational design patterns. Featuring real-world examples written in modern C++, each pattern is explained in detail to help you to understand how the pattern can be implemented efficiently using language features.

Overview This comprehensive course on Complete AutoLISP Programming will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete AutoLISP Programming comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. 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 Complete AutoLISP Programming. It is available to all students, of all academic backgrounds. Requirements Our Complete AutoLISP Programming is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 15 sections • 81 lectures • 07:26:00 total length •Module 01: Introduction: 00:01:00 •Module 02: Course Outline: 00:05:00 •Module 03: Introduction to AutoLISP: 00:02:00 •Module 04: Who is this Course for?: 00:02:00 •Module 05: What will I Learn?: 00:01:00 •Module 06: About the Author: 00:02:00 •Module 07: Why Learn AutoLISP?: 00:02:00 •Module 08: Tools: 00:04:00 •Module 01: Create Zoom Command Macros: 00:13:00 •Module 02: Create Layer Command Macros: 00:10:00 •Module 03: Create Insert Command Macros: 00:07:00 •Module 04: Create Audit Commands: 00:06:00 •Module 01: AutoLISP Rules: 00:05:00 •Module 01: Understanding AutoLISP Variables: 00:05:00 •Module 02: Using Variables in a Real World Program - Part 1: 00:08:00 •Module 03: Using Variables in a Real World Program - Part 2: 00:08:00 •Module 04: Using Variables in a Real World Program - Part: 00:05:00 •Module 05: Using Variables in a Real World Program - Part 4: 00:07:00 •Module 01: Math Functions in Theory: 00:06:00 •Module 02: Math Functions by Example: 00:15:00 •Module 01: List Functions Theory - Part 1: 00:06:00 •Module 02: CAR Function - Demo: 00:02:00 •Module 03: CDR Function - Demo: 00:02:00 •Module 04: CADR Function - Demo: 00:02:00 •Module 05: CADDR Function - Demo: 00:02:00 •Module 06: CAAR Function - Demo: 00:02:00 •Module 07: CDDR Function - Demo: 00:01:00 •Module 08: List Functions Theory - Part 2: 00:05:00 •Module 09: list Function - Demo: 00:01:00 •Module 10: cons Function - Demo: 00:02:00 •Module 11: nth Function - Demo: 00:01:00 •Module 12: Foreach Function - Demo: 00:04:00 •Module 13: List Functions Theory - Part 3: 00:05:00 •Module 14: Assoc Function - Demo: 00:04:00 •Module 15: Subst Function - Demo: 00:06:00 •Module 16: Last Function - Demo: 00:02:00 •Module 17: Reverse Function - Demo: 00:02:00 •Module 01: User Input Functions Theory - Part 1: 00:05:00 •Module 02: User Input Functions Theory - Part 2: 00:04:00 •Module 03: GetPoint Function - Demo: 00:02:00 •Module 04: GetInt Function - Demo: 00:03:00 •Module 05: GetString Function - Demo: 00:04:00 •Module 06: GetReal Function - Demo: 00:02:00 •Module 07: GetDist Function - Demo: 00:04:00 •Module 08: GetCorner Function - Demo: 00:04:00 •Module 09: GetAngle Function - Demo: 00:10:00 •Module 10: GetKword Function - Demo: 00:05:00 •Module 01: Object Handling Functions - Theory: 00:04:00 •Module 02: Entsel Function - Demo: 00:03:00 •Module 03: Entnext Function - Demo: 00:03:00 •Module 04: Entlast Function - Demo: 00:02:00 •Module 05: Entget Function - Demo: 00:04:00 •Module 06: Object Handling Functions - Exercises: 00:02:00 •Module 07: Object Handling Functions - Solutions to Exercises: 00:06:00 •Module 01: Selection Sets - Theory: 00:08:00 •Module 02: Ssget Function - Demo: 00:11:00 •Module 03: Ssadd Function - Demo: 00:05:00 •Module 04: Ssdel Function - Demo: 00:03:00 •Module 05: Ssmemb Function - Demo: 00:03:00 •Module 06: Ssname Function - Demo: 00:03:00 •Module 07: Sslength Function - Demo: 00:05:00 •Module 08: Selection Sets - Exercises: 00:04:00 •Module 09: Selection Sets - Solutions to Exercises: 00:13:00 •Module 01: Using If and Progn Statements: 00:05:00 •Module 02: Using While and EQ Functions: 00:05:00 •Module 03: Using Cond and And Functions: 00:04:00 •Module 01: AutoCAD Objects: Re-examined (Part 1): 00:04:00 •Module 02: AutoCAD Objects: Re-examined (Part 2): 00:05:00 •Module 03: Line Object: Re-examined (Demo): 00:05:00 •Module 04: Circle Object: Re-examined (Demo): 00:04:00 •Module 05: Text Object: Re-examined (Demo): 00:08:00 •Module 06: Dimension Object: Re-examined (Demo): 00:11:00 •Module 07: Block/Attribute Object: Re-examined (Demo): 00:28:00 •Module 01: Symbol Table and Dictionary-Handling Functions - Theory: 00:05:00 •Module 02: Tblsearch - Demo: 00:13:00 •Module 03: Tblnext - Demo: 00:09:00 •Module 01: CDIM - Project: 00:12:00 •Module 02: CHSTYLE - Project: 00:16:00 •Module 03: EXTATTR - Hands-On Project: 00:26:00 •Module 01: Conclusion Message and Thank you!: 00:01:00 •Assignment - Complete AutoLISP Programming: 00:00:00

This course covers everything you need to know about food and nutrients, focusing on how to implement and maintain a healthy, balanced diet. You will learn about food groups and superfoods, the benefits of vitamins, unhealthy foods to avoid and much more. You will also gain valuable information about the metabolic and immune systems and how they function. Throughout this training program, you will also develop your understanding of how healthy eating aids weight loss and how to detox and diet safely. This course is ideal for those looking to gain fundamental skills and practical knowledge to pursue a career in nutrition. Learning Objectives Increase your awareness of food intolerances, allergies and weight-related health diseases Learn about the functions of the metabolic and digestive systems Know the key to a balanced diet and how to maintain a healthy weight through exercise and nutrition Familiarise with the different food groups, with an introduction to vitamins and macronutrients Understand how the body burns calories, uses energy and stores fat Get tips and advice on detoxing the body for mental clarity and physical wellbeing Learn how to read food labels to understand the nutritional content Who is this course for? This course is suitable for anyone who wants to know more about dieting and nutrition, whether for professional or personal growth. It is an entry-level course designed to introduce the basics of maintaining a healthy diet. There are no entry requirements for this course, which can be studied full-time or part-time. Entry Requirement: This course is available to all learners, of all academic backgrounds. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion 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 of this course, learners will be equipped with the practical skills and knowledge to kickstart their career or healthy lifestyle. This course is ideal for aspiring nutritionists and dieticians, with related professions in this field including: Company Nutritionist Dietician Nutrition Specialist Research Nutritionist Course Curriculum Module 1: Basics of Food and Nutrition Basics of Food and Nutrition 00:15:00 Assessment Module 01 Module 01 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Module 2: Macronutrients: Classification & Functions of Carbohydrates Macronutrients: Carbohydrates 00:20:00 Assessment Module 02 Module 02 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Module 3: Macronutrients: Classification & Functions of Lipids and Proteins Macronutrients: Lipids and Proteins 00:25:00 Assessment Module 03 Module 03 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Module 4: Micronutrients I & II Micronutrients I 00:10:00 Micronutrients II 00:20:00 Assessment Module 04 Module 04 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Module 5: Digestion and Absorption Digestion and Absorption 00:15:00 Assessment Module 05 Module 05 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Module 6: Detoxification Detoxification 00:25:00 Assessment Module 06 Module 06 Final Quiz Exam - Diet and Nutrition Fundamentals Level 2 00:10:00 Order Your Certificate 00:00:00

Understand the impact of food and dieting on human health and enrich your knowledge of nutrition and healthy eating with the Nutrition Fundamentals Level 2 course. In this course, you will gain an understanding of how diet affects our health, with an introduction to food groups, nutrients and the digestive system. You will learn how to create a healthy eating plan that promotes weight loss and boosts energy levels, breaking down the benefits of each superfood and why they are such important for heart health. Throughout this instructor-led training program, you will explore the role of proteins, fats and carbohydrates, their health benefits, and how to incorporate them into your diet. You will also learn about calorie intake and how the body works to store and burn fat.  Learning Objectives: Gain a comprehensive knowledge of food, nutrition and healthy dieting Understand the role of macronutrients, including their functions and benefits Learn about the average requirements for energy and nutrients in men, women and children Have a solid understanding of the functions of the digestive and metabolic systems Discover the key to maintaining a healthy weight and what should be included in a balanced diet Understand how to read food labels to determine the nutritional value Develop your understanding of detox diets and how to detox the body safely Who is this Course for? This course is suitable for those who are looking to kickstart their healthy eating journey, as well as those who are interested in a career in health and nutrition. It is an introductory program ideal for beginners who wish to gain the fundamental knowledge to implement new changes in their diet or increase their professional knowledge. There are no entry requirements for this course and learners of all academic backgrounds are welcome to enrol. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion 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 of the course_title] course, learners gain the accreditation and skills to kickstart their healthy eating journey and explore the following professions: Certified Nutritionist Dietician Health Educator Dietetic Assistant Course Curriculum Module 1: Basics of Food and Nutrition Basics of Food and Nutrition 00:15:00 Assessment Module 1 Module 01 Final Quiz Exam - Nutrition Fundamentals Level 2 00:10:00 Module 2: Macronutrients: Classification & Functions of Carbohydrates Macronutrients: Carbohydrates 00:20:00 Assessment Module 2 Module 02 Final Quiz Exam - Nutrition Fundamentals Level 2 00:10:00 Module 3: Macronutrients: Classification & Functions of Lipids and Proteins Macronutrients: Lipids and Proteins 00:25:00 Assessment Module 3 Module 03 Final Quiz Exam - Nutrition Fundamentals Level 2 00:10:00 Module 4: Micronutrients I & II Micronutrients I 00:10:00 Micronutrients II 00:20:00 Assessment Module 4 Module 04 Final Quiz Exam - Nutrition Fundamentals Level 2 00:10:00 Module 5: Digestion and Absorption Digestion and Absorption 00:15:00 Assessment Module 5 Module 05 Final Quiz Exam - Nutrition Fundamentals Level 2 00:10:00 Order Your Certificate

Overview Learn the remedial qualities of natural foods and nutrients and open your eyes to a new world of healthy possibilities. By taking this fascinating course, you will learn how food can prevent illness and genuinely treat a variety of ongoing conditions. This Food as Medicine Level 2 course provides a wealth of knowledge regarding the use of food to maintain health and wellbeing for the mind and body. You will be taught the history of medicinal food and how it is still in use today. Alongside this, you can expect to learn how certain nutrients positively affect pregnancy and systems like digestion and cognitive thinking. 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 Food as Medicine Level 2. It is available to all students, of all academic backgrounds. Requirements Our Food as Medicine Level 2 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 14 sections • 21 lectures • 13:15:00 total length •Basics of Food and Nutrition: 00:30:00 •Macronutrients: Carbohydrates: 00:45:00 •Macronutrients: Lipids and Proteins: 00:45:00 •Micronutrients I: 01:00:00 •Micronutrients II: 00:45:00 •Digestion and Absorption: 00:45:00 •Detoxification: 01:00:00 •Balanced Diet: 00:30:00 •Food labelling: 00:30:00 •Nutrition Requirements: 00:30:00 •Food Intolerances and Allergies: 00:30:00 •Health Conditions: Diabetes: 00:30:00 •Health Conditions: Heart disease: 00:30:00 •Health Conditions: Cancer: 00:30:00 •Healthy Weight: 00:45:00 •Eating Problems: 00:45:00 •Women's Health: 00:30:00 •Common Concerns during Pregnancy: 01:00:00 •Nutrition for the Baby: 00:45:00 •Some Special Foods: 00:30:00 •Assignment - Food as Medicine Level 2: 00:00:00

A healthy body and mind come from a well-balanced diet. Learn about nutrition and healthy eating habits by taking this Diet and Nutrition Level 2 course.  This Diet and Nutrition Level 2 course will explain the importance of healthy dieting and nutritional balance. In addition, It will teach you about the keto diet fundamentals. It will educate you about micronutrients and macronutrients. The course will also discuss how to use food as medicine to prevent various diseases. You'll discover the role of diet and nutrition in weight control management and determine the role of a nutritionist. By the end of the course, you'll have better knowledge of designing nutrition meals plans. This course serves as a stepping stone for a fascinating nutritionist career.  Learning Objectives Familiarise yourself with the role of a nutritionist Learn about micronutrients and macronutrients Understand the nutrition requirements for adults and various groups Familiarise yourself with the various eating disorders Know about the diet and nutrition-related diseases Determine the role of nutrition in different diseases Understand the role of nutrition in weight loss and weight control management Enrich your knowledge of the ketogenic diet fundamentals Who is this Course for? This Diet and Nutrition Level 2 Course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of diet and nutrition or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement Anyone interested in learning more about this subject should take this Diet and Nutrition Level 2 course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Diet and Nutrition Level 2 Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Professional Nutritionist Public Health Nutritionist Child Nutritionist Community Nutritionist Consultant Nutritionist Dietetics Researcher Research Nutritionist Course Curriculum Module 01: Introduction to Nutrition Introduction to Nutrition 00:14:00 Module 02: Nutrients for Life - Nutrients for Life Macronutrients Nutrients for Life - Nutrients for Life Macronutrients 00:17:00 Module 03: Nutrients for Life - Micronutrients Nutrients for Life - Micronutrients 00:18:00 Module 04: Nutrition Requirements from Pregnancy to Teenage Nutrition Requirements from Pregnancy to Teenage 00:16:00 Module 05: Nutrition Requirements for Adults and Various Groups Nutrition Requirements for Adults and Various Groups 00:17:00 Module 06: Healthy Dieting Healthy Dieting 00:17:00 Module 07: Eating Disorders Eating Disorders 00:20:00 Module 08: Diet and Nutrition Related Diseases Diet and Nutrition Related Diseases 00:18:00 Module 09: Use of Nutrition in Different Illnesses/Diseases Use of Nutrition in Different Illnesses/Diseases 00:20:00 Module 10: Weight Control Management Weight Control Management 00:13:00 Module 11: Weight Loss Management Weight Loss Management 00:18:00 Module 12: Basics of Ketogenic Diet Basics of Ketogenic Diet 00:24:00 Module 13: The Role of Nutritionist The Role of Nutritionist 00:19:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview Eat good and live smart with your self-planned diet by enrolling in the highly effective Diet and Nutrition Complete Food Composition Diploma course. An Ayurvedic proverb says, 'When diet is wrong, medicine is of no use. When diet is correct, medicine is of no need'. Wherefore, there's certainly no magic shot other than eating healthy to live healthy. But, due to having inadequate knowledge of diet and nutrition, we tend to depend on experts where we often fail to understand their instructions. So, here is the well-researched course, outlined by a top nutritionist, offering you an opportunity to be a diet expert with in-depth knowledge regarding nutritious diets and a healthy lifestyle. Last but not least, the course modules are approached using scientific and theoretical concepts which will foster your professional skill development as well. 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 Diet and Nutrition Complete Food Composition Diploma. It is available to all students, of all academic backgrounds. Requirements Our Diet and Nutrition Complete Food Composition Diploma 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 10 sections • 75 lectures • 03:01:00 total length •Course Promo: 00:02:00 •Introduciton & What you will learn in the course: 00:04:00 •who this course is for: 00:02:00 •what is nutrition: 00:01:00 •The principles of healthy dieting: 00:04:00 •the true dieting pyramid: 00:04:00 •Calories Explained: 00:04:00 •bodyweight and health: 00:05:00 •Calories & bodyweight in a healthy diet: 00:02:00 •the twinkie diet: 00:02:00 •weight loss and health: 00:03:00 •How many calories do you need daily: 00:02:00 •How To Determin Your Optimal Calorie Intake: 00:03:00 •healthy weight ranges: 00:02:00 •How to lose weight if you are close to the optimal range: 00:03:00 •How to lose weight when you start from a higher weight: 00:02:00 •Diet breaks: 00:05:00 •How to track calories: 00:05:00 •How to lose weight without tracking calories: 00:04:00 •food composition intro: 00:03:00 •Protein Composition copy: 00:02:00 •Carbohydrate Composition copy: 00:03:00 •Fat Composition copy: 00:01:00 •Overview food composition: 00:03:00 •Macros intro: 00:01:00 •Protein Explained: 00:02:00 •protein needs for overall health: 00:02:00 •How Much Carbs should you eat per day copy: 00:01:00 •How Much Fat Should You Eat Per Day copy: 00:04:00 •Overview Macronutrients: 00:03:00 •Nutrient Timing Intro: 00:02:00 •Nutrient Timing Facts: 00:04:00 •Nutrient Timing Recommendations: 00:02:00 •Supplements intro: 00:04:00 •Why Mulitvitamins arent a good idea: 00:02:00 •supplements for vegans and vegetarians: 00:02:00 •supplements for joint health: 00:02:00 •supplements for improved sleep: 00:02:00 •supplements for better memory and focus: 00:02:00 •Supplements Overview: 00:01:00 •How to naturally increase testosterone: 00:07:00 •basics of healthy dieting: 00:02:00 •making changs towards a healthier diet: 00:04:00 •How to read a nutrition label copy: 00:03:00 •diet myths into: 00:01:00 •Dieting myth #1 Carbs are bad for you copy: 00:02:00 •Dieting Myth #2 Fat is bad for you copy: 00:02:00 •Dieting Myth #3 Protein is bad for you copy: 00:04:00 •Dieting Myth #4 Eating Eggs Raises Cllesterol copy: 00:01:00 •Dieting Myth #5 Avoid Salt At All Cost copy: 00:01:00 •Dieting Myth #6 Eat several small meals throughout the day to lose weight copy: 00:01:00 •Dieting Myth #7 Diet Foods Will Lead To Weight Loss copy: 00:01:00 •Red meat always causes cancer copy: 00:03:00 •Common Diets Intro 2 copy: 00:01:00 •Gluten Free Diet Explained copy: 00:03:00 •Paleo Diet Explained copy: 00:04:00 •Low Carb Diet Explained copy: 00:03:00 •Intermittend Fasting Explained copy: 00:03:00 •Vegan Diet Explained copy: 00:05:00 •Micronutrients Introduction 2 copy: 00:01:00 •Vitamin A copy: 00:02:00 •Vitamin B copy: 00:01:00 •Vitamin C copy: 00:01:00 •Vitamin D copy: 00:02:00 •Vitmain E copy: 00:01:00 •Vitamin K copy: 00:01:00 •Calcium copy: 00:02:00 •Magnesium copy: 00:01:00 •Phosphorus copy: 00:01:00 •Potassium copy: 00:01:00 •Sodium copy: 00:01:00 •Copper copy: 00:01:00 •Iron copy: 00:01:00 •Zinc copy**: 00:02:00 •water copy: 00:04:00

Overview Ensure you have all the knowledge and facts needed to craft a safe and effective fitness plan for your personal goals. This intuitive course will raise your awareness of the need for nutrition and exercise in a lifestyle and drive you to a healthier state. The Improving Personal Health and Nutrition Level 3 course understands that people need help and guidance to get truly fit and healthy, so you will be taught the many different aspects you need to consider when striving for your goals. Alongside dietary changes and exercise routines, you will be advised on your personal anatomy and also your psychological requirements. 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 Improving Personal Health and Nutrition Level 3. It is available to all students, of all academic backgrounds. Requirements Our Improving Personal Health and Nutrition Level 3 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 11 sections • 76 lectures • 03:01:00 total length •Course Promo: 00:02:00 •Introduciton & What you will learn in the course: 00:04:00 •who this course is for: 00:02:00 •what is nutrition: 00:01:00 •The principles of healthy dieting: 00:04:00 •the true dieting pyramid: 00:04:00 •Calories Explained: 00:04:00 •bodyweight and health: 00:05:00 •Calories & bodyweight in a healthy diet: 00:02:00 •the twinkie diet: 00:02:00 •weight loss and health: 00:03:00 •How many calories do you need daily: 00:02:00 •How To Determin Your Optimal Calorie Intake: 00:03:00 •healthy weight ranges: 00:02:00 •How to lose weight if you are close to the optimal range: 00:03:00 •How to lose weight when you start from a higher weight: 00:02:00 •Diet breaks: 00:05:00 •How to track calories: 00:05:00 •How to lose weight without tracking calories: 00:04:00 •food composition intro: 00:03:00 •Protein Composition copy: 00:02:00 •Carbohydrate Composition copy: 00:03:00 •Fat Composition copy: 00:01:00 •Overview food composition: 00:03:00 •Macros intro: 00:01:00 •Protein Explained: 00:02:00 •protein needs for overall health: 00:02:00 •How Much Carbs should you eat per day copy: 00:01:00 •How Much Fat Should You Eat Per Day copy: 00:04:00 •Overview Macronutrients: 00:03:00 •Nutrient Timing Intro: 00:02:00 •Nutrient Timing Facts: 00:04:00 •Nutrient Timing Recommendations: 00:02:00 •Supplements intro: 00:04:00 •Why Mulitvitamins arent a good idea: 00:02:00 •supplements for vegans and vegetarians: 00:02:00 •supplements for joint health: 00:02:00 •supplements for improved sleep: 00:02:00 •supplements for better memory and focus: 00:02:00 •Supplements Overview: 00:01:00 •How to naturally increase testosterone: 00:07:00 •basics of healthy dieting: 00:02:00 •making changs towards a healthier diet: 00:04:00 •How to read a nutrition label copy: 00:03:00 •diet myths into: 00:01:00 •Dieting myth #1 Carbs are bad for you copy: 00:02:00 •Dieting Myth #2 Fat is bad for you copy: 00:02:00 •Dieting Myth #3 Protein is bad for you copy: 00:04:00 •Dieting Myth #4 Eating Eggs Raises Cllesterol copy: 00:01:00 •Dieting Myth #5 Avoid Salt At All Cost copy: 00:01:00 •Dieting Myth #6 Eat several small meals throughout the day to lose weight copy: 00:01:00 •Dieting Myth #7 Diet Foods Will Lead To Weight Loss copy: 00:01:00 •Red meat always causes cancer copy: 00:03:00 •Common Diets Intro 2 copy: 00:01:00 •Gluten Free Diet Explained copy: 00:03:00 •Paleo Diet Explained copy: 00:04:00 •Low Carb Diet Explained copy: 00:03:00 •Intermittend Fasting Explained copy: 00:03:00 •Vegan Diet Explained copy: 00:05:00 •Micronutrients Introduction 2 copy: 00:01:00 •Vitamin A copy: 00:02:00 •Vitamin B copy: 00:01:00 •Vitamin C copy: 00:01:00 •Vitamin D copy: 00:02:00 •Vitmain E copy: 00:01:00 •Vitamin K copy: 00:01:00 •Calcium copy: 00:02:00 •Magnesium copy: 00:01:00 •Phosphorus copy: 00:01:00 •Potassium copy: 00:01:00 •Sodium copy: 00:01:00 •Copper copy: 00:01:00 •Iron copy: 00:01:00 •Zinc copy**: 00:02:00 •water copy: 00:04:00 •Assignment - Improving Personal Health and Nutrition Level 3: 00:00:00