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

10079 Courses delivered On Demand

Mastering the Art of Presentation

5.0(1)

By Course Gate

Powerful presentation skills are crucial since it can determine whether you are better than your competition or not. Master the art of presentation with our expertly designed course, and learn the ideas to manifest your presentations that get better and better with time. By enrolling in the Mastering the Art of Presentation course, you will learn what it takes to develop your presentation skill and steal the show. Learn the qualities of an enthusiastic presenter, to present your message with more confidence and grasp the major principles and techniques of presentations. This course will also benefit if you want to fast track your career, put forward your speech in an elegant style every time and deliver compelling presentations to get promotions. Who is this course for? Mastering the Art of Presentation is suitable for anyone who want to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Mastering the Art of Presentation is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started Welcome and Getting to Know Your Instructor FREE 00:03:00 What will you learn? 00:03:00 Who is this Course For? 00:03:00 Prepare Your Presentation Step 1 - Preparation 00:03:00 Step 2 - Get to Know Your Audience 00:03:00 Step 3 - Set Your Objectives 00:03:00 Step 4 - Consider Your Approach 00:03:00 Step 5 - Make a Presentation Plan 00:02:00 Step 6 - Presentation Strategies & Techniques - Giving People a Rea 00:03:00 Step 6 - Presentation Skills 00:04:00 Step 6 - Effective Communication 00:03:00 Step 6 - Verbal Communication 00:06:00 Step 6 - Motivational Language 00:02:00 Step 6 - Non Verbal Communication 00:08:00 Step 6 - Telling Stories 00:01:00 Step 6 - Memorable Content 00:03:00 Step 6 - RER Method 00:01:00 Step 6 - Using Case Studies 00:02:00 Step 6 - Calming the Nerves 00:04:00 Step 7 - Prepare Your Materials 00:10:00 Step 8 - Practice 00:02:00 Step 9 - Evaluation 00:03:00 Step 10 - Presentation Day 00:03:00 Contingencies 00:03:00 The Final Word Guest Interview 00:04:00 Wrap Up 00:02:00 Workbook Workbook - Mastering the Art of Presentation 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Mastering the Art of Presentation
Delivered Online On Demand1 hour 27 minutes
£11.99

Nutrition Diploma Level 3

5.0(1)

By Course Gate

'Optimal Health is a journey taken one step, one habit, and one day at a time.' -Dr. Wayne S. Andersen If you want to live a long healthy life, enrol the Nutrition Diploma Level 3 course and explore the proven methods of Optimal Health. Optimal Health is a new approach that tries to ensure longevity and healthy life through healthy eating habits. The course teaches you the procedures of adopting of taking a healthy food habit. You will learn the basics of nutrition along with the concept of vitamins, carbohydrates, proteins, fats, minerals etc. Apart from these, you will learn the foods that should be avoided from your diet. Finally, the course focuses on the importance of taking exercise, water, sleep, rest, etc. Who is this Course for? Nutrition Diploma Level 3 is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Assessment: This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work. Course Curriculum Overview Introduction to Basic Health 00:03:00 Overview of Nutritional Terms 00:03:00 Understanding Food Labels and Claims 00:06:00 The Science of Nutrition & Professionals 00:05:00 Nutritional Details Carbohydrates - Sugar 00:07:00 Carbohydrates - Starch 00:04:00 Carbohydrates - Fiber 00:02:00 Protein 00:09:00 Fat - Omega 3, 6, 9 & Cholesterol 00:07:00 Minerals Starting With Iron & Zinc 00:05:00 More Minerals - Calcium, Phosphorus, Magnesium 00:05:00 Vitamins - Starting with B's 00:03:00 Vitamins A, C, E, K - the Antioxidants 00:11:00 Couple More Minerals - Sodium & Potassium 00:03:00 Trace Minerals, B12 & Vitamin D 00:05:00 What to Avoid & Problem Areas Nutritional Deficiencies & Food Allergies 00:02:00 Organic vs Toxic Chemicals - Finding Balance 00:06:00 Fads. Trends, and Extremes in Diet 00:03:00 Beyond Food Exercise Unlocks Nutrients 00:04:00 Water 00:03:00 Rest 00:04:00 Putting It All Together Calorie Intake & Menu Development 00:05:00 Practical Application & Summary 00:04:00 Nutrition 4 Optimal Health -Handouts Nutrition 4 Optimal Health -Handouts 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Nutrition Diploma Level 3
Delivered Online On Demand1 hour 49 minutes
£11.99

Diploma in Budgets and Financial Reports

5.0(1)

By Course Gate

The core role of Budgeting and preparing Financial Reports is to create a spending plan for your money, as they ensure that you always have enough money for the things that are crucial to you. The Diploma in Budgets and Financial Reports course introduces you with the budgeting trends and policy issues, budget processes and methodologies for organizing budget estimates. The importance of creating financial reports, effective budget planning, and bookkeeping guidelines are an integral part of this course. Additionally, the course advises you how to keep yourself out of debt or how to help your family, friends or clients way out of debt. Who is the course for? Professionals, who work in the business or corporate setting, especially people who are assigned to the finance department and are trying to figure out the ridiculous amount. People who are interested in learning more about payroll management and bookkeeping. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Budgets and Financial Reports Module One - Getting Started 00:15:00 Module Two - Glossary 00:30:00 Module Three - Understanding Financial Statements 00:30:00 Module Four - Analyzing Financial Statements (I) 01:00:00 Module Five - Analyzing Financial Statements (II) 00:30:00 Module Six - Understanding Budgets 00:30:00 Module Seven - Budgeting Made Easy 00:30:00 Module Eight - Advanced Forecasting Techniques 00:30:00 Module Nine - Managing the Budget 00:30:00 Module Ten - Making Smart Purchasing Decisions 01:00:00 Module Eleven - A Glimpse into the Legal World 01:00:00 Module Twelve - Wrapping Up 00:15:00 Budgets and Money Management Finance Jeopardy 00:15:00 The Fundamentals of Finance 00:15:00 The Basics of Budgeting 00:15:00 Parts of a Budget 00:15:00 The Budgeting Process 00:30:00 Budgeting Tips and Tricks 00:15:00 Monitoring and Managing Budgets 00:15:00 Crunching the Numbers 00:15:00 Getting Your Budget Approved 00:15:00 Comparing Investment Opportunities 00:15:00 ISO 9001:2008 00:15:00 Directing the Peerless Data Corporation 00:30:00 Mock Exam Mock Exam- Diploma in Budgets and Financial Reports 00:20:00 Final Exam Final Exam- Diploma in Budgets and Financial Reports 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Diploma in Budgets and Financial Reports
Delivered Online On Demand11 hours 10 minutes
£11.99

Creative Writing Course: Writing Storybooks For Children

5.0(1)

By Course Gate

Do you love kids and want to write for them? The Creative Writing Course: Writing Storybooks For Children teaches the step by step procedures of writing an excellent book for the kids that will be accepted by them. Writing for children is more challenging and tough as your psychology and children's psychology is different. Apart from this, most of the children cannot be able to hold attention for a long time. SO, to give a message within limited work is difficult. Throughout the course, you will learn the practical techniques for engaging your little readers. The course shows you the exact format and style of writing for kids. Finally, the course teaches you the path for publishing your books through Amazon or other publishers. After finishing the Creative Writing Course: Writing Storybooks For Children course, you will be confident enough to write a kid's book and publish it through the proper channel. Who is this Course for? Creative Writing Course: Writing Storybooks For Children is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Assessment: This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work. Course Curriculum Introduction Introduction to Children's Storybook Writing 00:02:00 02info-1 00:02:00 03keys-1 00:02:00 04aim-1 00:04:00 Coming Up With Ideas 05ideas-1 00:02:00 06characters-1 00:02:00 07plotting-1 00:04:00 The Mechanics of Writing 08planning-1 00:03:00 09storytelling-1 00:03:00 Important Technical Issues 10pov-1 00:04:00 11technical-1 00:04:00 12structure-1 00:02:00 Types of Children's Books 13picturebooks1-1 00:03:00 14picturebooks2-1 00:03:00 15picturebooks3-1 00:02:00 16easyreaders-1 00:03:00 17transition-1 00:01:00 18chapterbooks-1 00:02:00 19junior-1 00:02:00 20youngadult-1 00:04:00 Advanced Fiction Techniques 21dialogue-1 00:05:00 22showdonttell-1 00:05:00 Conclusion 23conclusion-1 00:02:00 Resources Resources - Creative Writing Course: Writing Storybooks For Children 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Creative Writing Course: Writing Storybooks For Children
Delivered Online On Demand1 hour 6 minutes
£11.99

Diploma in Blogging

4.3(43)

By John Academy

Are you into blogging and does not consider blogging as merely a hobby? Or are you a blogger who earns through blogging and wants to upgrade your blogging skills? Do you want to learn how to succeed now that you're finally a blog expert? Then this will be the course you will be needing right now since you will be able to the advanced skills for blogging and how to earn more through your blogging site. Description This course will equip you with the necessary skills, knowledge and information of blogging. You will be taught how to create a blog and how to make your blog settings count. After knowing all the basics in blogging and pinging, you will be able to drive traffic to your website and increase your earnings. When it comes to having a lifestyle and profitable medium, blogging appears to have it all. You will find the opportunity to work from home, focus on a state of intrigue and offer your imaginative gifts. If you genuinely need to go from preoccupation blogger to ace, you ought to have the ability to lock in, place assets into get ready and stick it out for the entire arrangement and plan to hold up a year or more before you can pull in enough movement to adjust your blog and wind up plainly productive. Be that as it may, to keep away from the imagine a scenario in which's and battles you may experience in blogging, taking this course will effectively help you turn into a specialist in blogging to end up noticeably beneficial. There's one more basic idea to consider the benefit condition: Even in case you don't obtain anything from advancing or sponsorship wages on your blog, you may procure a not too bad pay because of your blog that gave the correct ideas and contents. This course will surely help you upgrade and level up your blogging skills as well as your income from blogging. Who is the course for? Bloggers and other online professionals who are into blogging marketing. People who have an interest in being profitable through blogging What will I learn? Introduction to Advance Blogging The Anatomy of a Profitable Blog Quick and Easy Optimization Template Customization Turbo Charged Profit Strategies And Many More! Entry Requirement This course is available to all learners, of all academic backgrounds. However, although an education and experience related to online marketing and communication will be of great advantage. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working day. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The Diploma in Blogging course will be very beneficial and helpful, especially to the following careers: Bloggers Blog Marketing and Promotions Specialists Blog Marketing Managers Online Sales Managers Online Sales and Promotions Specialists And Many More! Blogging Basics Introduction 01:00:00 The Anatomy Of A Profitable Blog 02:00:00 Quick & Easy Optimization 00:30:00 Extending Your Blog's Functionality 00:15:00 Turbocharged Profit Strategies 01:00:00 Blogging Set Up a WordPress Blog 01:00:00 Set Up a Blogger Blog 00:30:00 Naming Your Blog 00:30:00 When To Blog or Not to Blog 00:30:00 Top Common Mistakes of Bloggers 00:30:00 Linking Your Blog to SMM Accounts 00:30:00 Blog Set-Up - Plug-Ins 00:30:00 Blogging for Beginners - Comments 00:30:00 Monetizing Your Blog 01:00:00 Blogging for a Target Market 00:30:00 Blogging - Choosing a Theme 01:00:00 Blogging - Length of Posts 00:30:00 Blogging - How Often Should I Post? 00:30:00 Multi-Purpose Blog Content 00:30:00 Blog Style and Tone 00:30:00 Blogging Non-Original Content 01:00:00 Blogging Absences 00:30:00 Using Videos on Your Blog 01:00:00 The Uses of Images on Your Blog 01:00:00 Addressing Competitors on Your Blog 00:30:00 A Flaming on Your Blog 02:00:00 Keep SPAM Off Your Blog 00:30:00 Guest Bloggers on Your Blog 01:00:00 Affiliate Programs and Blogs 00:30:00 Benefits of Blogging How Can You Benefit from Blogging? 01:00:00 What on Earth is Blogging? 01:00:00 Ways to Optimize Your Blog for Maximum Traffic 01:00:00 Putting Your Posts to Work 01:00:00 Selling Blog Branded Merchandise 01:00:00 Cash in on eBook Mania 01:00:00 The Power of Ad Space 01:00:00 Look For Sponsorship 00:30:00 Don't be Afraid to Ask and Conclusion 00:30:00 Blogging And Social Media Blogging And Social Media Basics 00:30:00 Treat Your Followers The Right Way 01:00:00 Portion Out Your Time 00:30:00 Use Social Media Video To Get People To Your Blog 01:00:00 Build A Community 00:15:00 Direct All Of This To Your Blog 00:15:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Diploma in Blogging 00:20:00 Final Exam Final Exam- Diploma in Blogging 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Blogging
Delivered Online On Demand34 hours
£11.99

Learning How to Learn

By Compete High

Unlock Your Potential with 'Learning How to Learn' Course! 🚀 Are you tired of struggling to retain information? Do you find it challenging to stay focused and productive while learning new skills or subjects? Welcome to 'Learning How to Learn' - the ultimate course designed to empower you with the essential tools and strategies to master the art of learning effectively and efficiently.   📚 What is 'Learning How to Learn'? 'Learning How to Learn' is a transformative course that delves into the science behind effective learning techniques. From understanding how the brain processes information to implementing practical strategies for memory retention and concentration, this course equips you with the knowledge and skills you need to become a proficient learner. In today's fast-paced world, the ability to learn efficiently is more critical than ever. Whether you're a student aiming to excel academically, a professional looking to enhance your skills, or an individual passionate about lifelong learning, this course is your gateway to success.   Benefits of 'Learning How to Learn': 🔍 Gain Insight into the Learning Process: Understand the cognitive mechanisms involved in learning and discover how to leverage them to your advantage. 🧠Enhance Memory and Retention: Learn proven techniques to improve memory retention, recall information effortlessly, and conquer complex subjects with ease. 🎯 Boost Productivity and Focus: Uncover strategies to overcome distractions, maintain focus, and maximize your learning potential in any environment. 📈 Accelerate Skill Acquisition: Whether you're learning a new language, mastering a musical instrument, or honing professional skills, this course provides you with the tools to accelerate your learning journey. 💡 Develop Lifelong Learning Habits: Cultivate habits and practices that promote continuous learning and personal growth, setting you on the path to success in both your personal and professional endeavors.   Who is this for? Students at any level of education seeking to improve their study habits and academic performance. Professionals looking to enhance their skills and stay competitive in today's rapidly evolving job market. Lifelong learners committed to personal development and intellectual growth.   Career Path By mastering the art of learning, you open doors to limitless opportunities in various career paths. Whether you aspire to excel in academia, climb the corporate ladder, or pursue entrepreneurial endeavors, the skills and knowledge gained from 'Learning How to Learn' will serve as a cornerstone for your success.   FAQs (Frequently Asked Questions): Q: Is this course suitable for beginners? A: Absolutely! 'Learning How to Learn' is designed to cater to learners of all levels, from beginners to advanced. Whether you're just starting your learning journey or looking to refine existing skills, this course provides valuable insights and strategies for learners at any stage. Q: How long is the course, and can I study at my own pace? A: The course duration may vary depending on the format and structure. However, most courses offer flexible scheduling, allowing you to study at your own pace and convenience. Whether you prefer to dive deep into the content or take it one step at a time, you have the freedom to tailor your learning experience according to your needs and schedule. Q: Will I receive a certificate upon completion of the course? A: Many courses offer certificates of completion to participants who successfully finish the program requirements. Certificates not only validate your achievement but also serve as tangible evidence of your commitment to continuous learning and personal development. Q: Can I apply the skills learned in this course to different areas of my life? A: Absolutely! The skills and strategies taught in 'Learning How to Learn' are highly transferable and can be applied to various aspects of your personal and professional life. Whether you're studying for exams, tackling new projects at work, or pursuing hobbies and interests, the principles of effective learning will empower you to succeed in any endeavor.   Don't let inefficient learning methods hold you back from reaching your full potential. Enroll in 'Learning How to Learn' today and embark on a transformative journey toward becoming a masterful learner! 🌟 Course Curriculum Module 1 The Basics of Learning Science. The Basics of Learning Science. 00:00 Module 2 Effective Learning Habits and Memory Recall. Effective Learning Habits and Memory Recall. 00:00 Module 3 Study Resources and Motivation. Study Resources and Motivation. 00:00 Module 4 Creativity and Problem Solving. Creativity and Problem Solving. 00:00 Module 5 Effective Communication Skills and Time Management. Effective Communication Skills and Time Management. 00:00

Learning How to Learn
Delivered Online On Demand5 hours
£4.99

Algebra for Beginners

4.3(43)

By John Academy

Description: Algebra is an area of mathematics that uses symbols to represent numbers in formulas and equations. Understanding these symbols and how they work together and provide structure to equations allows mathematicians to more efficiently write formulas and solve math problems.  This Algebra for Beginners is an introduction to the basic principles and skills of algebra. Topics include Variables, Grouping Symbols, Equations, Translating Words Into Symbols, and Translating Sentences Into Equations. With this course you will learn to manipulate and solve basic algebraic expressions, solve rational expressions, changing the subject of formulae and using formulae. You will learn to work with integers, decimals and fractions, how to evaluate powers and roots and how to solve single and multi-variable equations and inequalities. Learn how to apply algebra to a wide range of real-world problems and study critical algebraic concepts like functions, domains and ranges. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Algebra for Beginners is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Algebra for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Lecture 1 Intro video Algebra Introduction final 00:02:00 Fundamental concepts on Algebraic Expressions Lecture 2 Terminology used in Algebra 00:05:00 Lecture 3 Language of Algebra 00:06:00 Lecture 4 Practice Questions 00:06:00 Lecture 5 Finding numerical value of an algebraic expression 00:14:00 Operations on Algebraic Expressions Lecture 6 Revision of Directed number ( integers 00:06:00 Lecture 7 Addition and subtraction of monomial expressions 00:06:00 Lecture 8 Addition of algebraic expressions with many terms 00:10:00 Lecture 9 Subtraction of algebraic expressions 00:10:00 Indices ( Exponents) Lecture 10 The rules of Indices in algebra 00:11:00 Lecture 11 Fractional indices 00:10:00 Lecture 12 Understanding indices (practice questions) 00:07:00 Lecture 13 Problems from IGCSE Last year papers 00:05:00 Multiplication and Division of Algebraic expressions Lecture 14 Multiplication of monomial algebraic expressions 00:05:00 Lecture 15 Multiplication of monomial with binomials and trinomials 00:11:00 Lecture 16 Division of algebraic expression by a monomial 00:07:00 Lecture 17 Division of algebraic expression by another polynomial 00:09:00 Lecture 18 Division of a polynomial by another polynomial with remainder 00:11:00 Brackets in Algebra Lecture 19 Rules of brackets 00:04:00 Lecture 20 Simplification by removing brackets 00:11:00 Linear equations in one variable Lecture 21 Simplification of algebraic fractions 00:07:00 Lecture 22 Rules to solve linear equations in one variable 00:03:00 Lecture 23 Solving linear equations in one variable 00:07:00 Lecture 24 Solving complex linear equations in one variable 00:10:00 Lecture 25 Word problems on linear equations in one variable 00:13:00 Algebraic Identities Lecture 26 Standard Identities (a + b )² and (a - b )² identities 00:11:00 Lecture 27 Standard Identity ( a - b ) ( a + b) = a ² - b ² 00:08:00 Lecture 28 Standard Identities ( a + b + c ) ² = a ² + b ² + c ² + 2 a b + 2 a c +2 b c 00:07:00 Lecture 29 Standard Identities ( a + b ) ³ and ( a - b ) ³ 00:09:00 Lecture 30 Standard Identities a ³ + b ³ and a ³ - b ³ 00:06:00 Lecture 31 Standard Identities a ³ + b ³ + c ³ - 3 a b c 00:10:00 Formula : Change of subject of formula Lecture 32 -Changing the subject of formula 00:08:00 Linear Inequalities Lecture 33 Linear Inequalities 00:12:00 Resolve into factors Lecture 34 Factorization by taking out common factor 00:10:00 Lecture 35 Factorization by grouping the terms 00:09:00 Lecture 36 Factorize using identity a ² - b ² 00:07:00 Lecture 37 Factorize using identity (a + b )² and (a - b )² 00:08:00 Lecture 38 Factorize using identity ( a + b + c ) ² 00:05:00 Lecture 39 Factorization by middle term split 00:12:00 Algebraic Fractions Lecture 40 Simplification of algebraic fractions 00:06:00 Coordinate axis - points and Line graph Lecture 41 All that you need to know about co ordinate axis 00:04:00 Lecture 42 Some important facts needed to draw line graph 00:03:00 Lecture 43 How to draw a line graph on coordinate plane 00:03:00 Lecture 44 Drawing line graphs 00:06:00 System of simultaneous linear equations in two variables Lecture 45 Simultaneous Linear Equations in two variables- intro 00:03:00 Lecture 46 Graphical method of solving linear equations 00:06:00 Lecture 47 Graphical method - more sums 00:10:00 Lecture 48 Method of Elimination by substitution 00:09:00 Lecture 49 Method of Elimination by Equating coefficients 00:11:00 Lecture 50 Method of Elimination by cross multiplication 00:07:00 Lecture 51 Equations reducible to simultaneous linear equations 00:12:00 Lecture 52 Word Problems on Linear equations 00:18:00 Polynomials Lecture 53 Polynomials and Zeros of polynomials 00:10:00 Lecture 54 Remainder Theorem 00:04:00 Lecture 55 Factor Theorem 00:08:00 Lecture 56 Practice problems on Remainder and Factor Theorem 00:09:00 Lecture 57 Factorization using factor Theorem 00:10:00 Quadratic Polynomials Lecture 58 Zeros of polynomials α, β & γ 00:10:00 Lecture 59 Relation between zeros and coefficients of a polynomials 00:13:00 Lecture 60 Writing polynomials if zeros are given 00:06:00 Lecture 61 Practice problems on zeros of polynomials 00:10:00 Lecture 62 Problems solving with α and β (part 1) 00:11:00 Lecture 63 Problems solving with α and β (part 2) 00:10:00 Quadratic Equations Lecture 64 what are Quadratic equations 00:03:00 Lecture 65 Solutions by factorization method 00:12:00 Lecture 66 Solutions by completing square formula 00:06:00 Lecture 67 Deriving Quadratic formula 00:05:00 Lecture 68 Practice problems by Quadratic formula 00:07:00 Lecture 69 Solving complex quadratic equations by Quadratic Formula 00:11:00 Lecture 70 Solutions of reducible to Quadratic Formula 00:09:00 Lecture 71 Skilled problems on Quadratic Equations 00:07:00 Lecture 72 Exponential problems reducible to Quadratic Equations 00:06:00 Lecture 73 Nature of Roots of Quadratic Equations 00:09:00 Lecture 74 Word problems on quadratic Equations Part 1 00:13:00 Lecture 75 Word problems on quadratic Equations Part 2 00:11:00 lecture 76 word problems on Quadratic 00:12:00 Mock Exam Mock Exam - Algebra for Beginners 00:20:00 Final Exam Final Exam - Algebra for Beginners 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Algebra for Beginners
Delivered Online On Demand11 hours 8 minutes
£18

Advanced Excel Models using Formulas, VBA & Power Query

4.3(43)

By John Academy

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

Advanced Excel Models using Formulas, VBA & Power Query
Delivered Online On Demand6 hours 8 minutes
£18

Advanced Diploma in Health & Fitness

4.3(43)

By John Academy

Description: The Advanced Diploma in Health Fitness will help people in looking for nutritious guidance on staying healthy to help in upgrading well-being and wellness. Health Fitness is not just about weight loss, its main objective is to live healthily without sacrificing happiness in the duration of the course. You will be able to know the definition of what healthy is and how you can improve the status of your health in this course. You will be able to take the strategies, complemented by activity based worksheets and reasonable contextual analyses to be able to understand more about health and fitness. Lastly, you will be able to mind fitness and live a healthy emotional life. Who is the course for? Trainers, professionals and other busy people who are into health and fitness. Health conscious people who want to strengthen their bodies and maintain their wellness. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Advanced Diploma in Health Fitness will be very beneficial and helpful, especially to health and sport-related careers like: Athletes Fitness Instructor Personal Trainer Sports Administrator Sports Businessmen Sports Specialists Wellness Coach And Much More! Health and Fitness Introduction 00:30:00 Fitness And Where You Stand Right Now 01:00:00 Body Fitness And Its Effect On Your Life 00:30:00 Diet Fitness, You Are What You Eat, Really! 00:45:00 Mind Fitness, A Healthy Emotional Life 00:45:00 Lifestyle Fitness, You Are What You Do, Too 00:45:00 Conclusion 00:15:00 Fitness and Wellness Today's Concerns about Wellness and Fitness 01:00:00 The Blissful Union of Wellness and Fitness 00:30:00 The Interchangeability of Wellness, Fitness and Health 00:30:00 The Quality of Life: Is Health Important? 00:30:00 Wellness Terminology 00:30:00 What Makes Us Well? 00:30:00 Wellness 00:30:00 Information on Wellness 00:30:00 How Do We Evaluate Wellness? 00:30:00 What Are Your Wellness Needs? 00:30:00 Wellness of the Body 00:30:00 Wellness of the Spirit 00:30:00 Wellness of the Mind 00:30:00 Benefits of Meditation for the Wellness of Ourselves 00:30:00 Do We Need Meditation? 00:30:00 Are You Well? 00:30:00 Fitness Terminology 00:15:00 Fitness 00:30:00 Information on Fitness 00:30:00 What Are Your Fitness Needs? 00:30:00 Benefits from Being Fit 01:00:00 Metabolism: What Is It? 00:30:00 Metabolism for the Fit Individual 00:30:00 Metabolism: Can We Control It? 00:30:00 Obesity in Adolescents 00:30:00 Fitness of the Body 00:30:00 Fitness of the Spirit 00:30:00 Fitness of the Mind 00:30:00 Are You Fit? 00:30:00 Where You Live Affects Your Fitness 00:30:00 Fitness Centers: An Investigation 00:30:00 Does Your Income Affect Your Health? 00:30:00 What Role Does Our Intelligence Play in Our Health? 00:30:00 What Role Does Nutrition Play in Our Health? 00:30:00 Is There Health Without Water? 00:30:00 Vitamins: To Be or Not To Be? 00:30:00 How the Brain Affects Our Health 00:30:00 What Are Your Nutritional Needs? 00:30:00 Exercise and Play: What Do We Learn? 00:30:00 The Benefits of Walking 00:30:00 The Mind, Body and Soul Interconnectivity 00:30:00 Chiropractic Care: A Benefit to the Well Individual? 00:30:00 Acupuncture: A Benefit to the Well Individual? 00:30:00 The Benefits of Being Well 00:30:00 Where You Live Affects Your Wellness 00:30:00 The Benefits of Being Fit 00:30:00 Music: Our Connection to the Higher Conscious 00:30:00 The Yin and Yang of the Healthy Individual 00:30:00 Right Hand vs. Left Hand: Who's Healthier? 00:30:00 Is Your Mind Playing Tricks? 00:30:00 Diet and Nutrition Low Carb (No Carb) Diets 01:00:00 Women's Health Look Good Naked Diet 00:30:00 Prevention System's Flat Belly Diet 00:30:00 Weight Watchers International's Pro Points 01:00:00 Mike Geary's Truth about Abs Diet 00:30:00 HCG Diet 00:30:00 Diet Supplements and Weight Loss 00:30:00 Diets that Provide Food Supplements 00:30:00 Mock Exam Mock Exam- Advanced Diploma in Health & Fitness 00:20:00 Final Exam Final Exam- Advanced Diploma in Health & Fitness 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Advanced Diploma in Health & Fitness
Delivered Online On Demand35 hours
£11.99

Web Development Complete Course

4.3(43)

By John Academy

Description: In today's world websites are a basic necessity for everyone. All businesses have a website to advertise their products and services to existing and new customers. This course is what you need to understand web development basics as it will help you discover niche, identify platforms, select web host, use SEO & social sites and more. You do not want to fall behind everyone else, which is why you should consider taking this accredited Web Development Complete Course. You will be able to find out website design terminologies, discover new techniques to build your website for free, creating your site layout and a lot more. This is all geared towards helping you build your desired websites. In the next section, you focus on programming languages including HTML, CSS and PHP to see if these intrigue you enough to take the challenging yet unique road to web development. If you decide against that though, this course is prepared to teach you to use Joomla in order to get started in creating your first ever website. Who is the course for? People who want to learn PHP, HTML and CSS programming People interested in website development Entrepreneurs or business owners wanting to develop a website for their business Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Web Development Complete Course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Web developers Entrepreneurs Website designers Programmers Basic Coding for Web Development HTML Basics 00:30:00 CSS Basics 01:00:00 Web Design & Development: HTML5, CSS3 and JavaScript 02:00:00 Web Development Basics What Are Niche Website? 01:00:00 The Role Of Visualization In Education 00:15:00 Identify Your Best Platform Or Software 01:00:00 Select A Web Host 01:00:00 Collect Your Site 00:15:00 Building A Content Rich Website 00:15:00 Build Backlinks 00:30:00 Use SEO, Multimedia And Social Sites 01:30:00 Use Analytics 01:00:00 Wrapping Up 00:15:00 Web Designing The Best Website Design for Your Business 01:00:00 What's in a Domain Suffixes 00:31:00 Website Design Terminology 01:00:00 CSS Explanation 01:00:00 Website Designs & Power Stations 01:00:00 How Can I Build my Website for Free 01:00:00 Six Steps to Website Design for Beginners 01:00:00 Dreamweaver or CoffeeCup for Website Design 01:00:00 Using Dreamweaver to Create your Site Layout 00:30:00 Three Crucial Steps to Creating Your Website 01:00:00 Dos and Don'ts of Website Creation9 01:00:00 SEO Basics for Effective Website Design 01:30:00 Ideas for Your Internet Business Website Design 01:00:00 Immediately Applicable Design Tips for a User-Friendly Website 01:00:00 6 Best Reasons to Create a Website 01:00:00 Common Mistakes in Website Design 01:00:00 Too Much or Too Little 00:30:00 Why Successful Website Development is Committed to Design 01:00:00 Ideas for Your Personal Website Design 01:00:00 How to Create a Social Networking Website to Enhance your Business 01:00:00 Tips for Designing an Affiliate Website 01:00:00 How to Use WordPress for your Website 01:30:00 Top 14 Reasons to Create a Blog 00:30:00 Tips for Designing a Successful Blog 00:30:00 More Tips Ahead 00:30:00 PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Using Joomla INTRODUCTION TO JOOMLA 00:30:00 SCOPE OF JOOMLA 00:30:00 BENEFITS OF JOOMLA 00:30:00 COMPARISON WITH OTHER CONTENT MANAGEMENT SYSTEMS 01:00:00 WHY DEVELOPERS DRAWS TO JOOMLA? 00:30:00 How do I in install Joomla? 03:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Web Development Complete Course 00:30:00 Final Exam Final Exam- Web Development Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Web Development Complete Course
Delivered Online On Demand48 hours
£11.99