20290 Addition courses

Embark on a transformative journey with 'Definitive Sports Nutrition', a comprehensive course meticulously designed to revolutionize your understanding of sports nutrition. Imagine a world where every morsel you consume is a step towards your peak physical performance. This course opens that door, guiding you through the labyrinth of dietary choices and nutritional strategies. From the foundational Module 01, where you meet your expert instructor, to the final congratulations in Module 36, every step is a leap towards nutritional mastery. Dive deep into the core of sports nutrition with this course, tailored to unravel the complexities of energy systems, macro and micronutrients, and the impact of different diets on athletic performance. Whether it's understanding caloric intake in Module 05, mastering the art of balancing macros without a scale in Module 12, or exploring the nuanced roles of various supplements from Module 15 to 21, each module is a treasure trove of knowledge. The curriculum is not just about what to eat; it's a holistic approach to nutrition, addressing crucial aspects like hydration, hormonal influences, and even practical tips for eating out as an athlete. This educational odyssey doesn't just stop at imparting knowledge; it transforms you into a beacon of nutritional wisdom. It arms you with the tools to set realistic goals, align your diet with your energy needs, and make informed choices about supplements and meal timings. By the end of this course, you'll not only have a profound understanding of sports nutrition but also the ability to apply this knowledge in real-world scenarios, reshaping not just your diet but your entire approach to fitness and health. Learning Outcomes Gain comprehensive knowledge of energy systems and their role in sports performance. Understand the principles of the Nutrition Pyramid and apply them in diet planning. Learn to calculate Basal Metabolic Rate (BMR) and Total Daily Energy Expenditure (TDEE) for tailored nutrition. Acquire the skill to balance macronutrients and micronutrients effectively for optimum athletic performance. Master the use of supplements, including protein powders and vitamins, to enhance training outcomes. Why buy this Definitive Sports Nutrition? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Definitive Sports Nutrition there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring or current athletes seeking to optimize their dietary habits for improved performance. Fitness enthusiasts eager to deepen their understanding of sports nutrition. Coaches and trainers aiming to provide evidence-based nutritional advice. Individuals interested in a career in sports nutrition or dietetics. Health-conscious individuals looking to incorporate sports nutrition principles into their lifestyle. Prerequisites This Definitive Sports Nutrition does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Definitive Sports Nutrition was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Sports Nutritionist: £25,000 - £50,000 per annum Fitness Coach: £20,000 - £35,000 per annum Dietitian: £26,000 - £41,000 per annum Wellness Consultant: £22,000 - £40,000 per annum Health Educator: £23,000 - £37,000 per annum Personal Trainer: £19,000 - £35,000 per annum Course Curriculum Definitive Sports Nutrition Module 01: Welcome - Meet Your Instructor 00:04:00 Module 02: Setting Goals 00:03:00 Module 03: Energy System 00:03:00 Module 04: The Nutrition Pyramid 00:02:00 Module 05: Caloric Intake 00:02:00 Module 06: How to Calculate Your BMR and TDEE 00:04:00 Module 07: Muscle Gain - Fat Loss Specifics & Realistic Goals 00:04:00 Module 08: Protein 00:01:00 Module 09: Carbohydrates 00:03:00 Module 10: Fats 00:02:00 Module 11: How Much of Each 00:04:00 Module 12: A Simple Trick to Count Your Macros without a Scale 00:01:00 Module 13: Vitamins & Minerals 00:02:00 Module 14: The Ideal Meal & Nutrient Timing 00:09:00 Module 15: Introduction to Supplements 00:01:00 Module 16: Protein Powder 00:01:00 Module 17: Creatine 00:01:00 Module 18: Magnesium 00:01:00 Module 19: Multivitamins 00:01:00 Module 20: Omega-3 Fatty Acid 00:01:00 Module 21: Curcumin 00:01:00 Module 22: Pre-workouts & Energy Drinks 00:03:00 Module 23: Electrolyte Drinks 00:01:00 Module 24: Food Composition 00:02:00 Module 25: Food Rotation 00:01:00 Module 26: Insulin 00:03:00 Module 27: Cortisol 00:05:00 Module 28: Testosterone 00:02:00 Module 29: Leptin 00:04:00 Module 30: Hydration 00:03:00 Module 31: The Athlete's Guide to Eating Out 00:02:00 Module 32: Alcohol 00:02:00 Module 33: Vegan and Vegetarian 00:01:00 Module 34: FAQ 00:05:00 Module 35: Course Note 00:01:00 Module 36: Congratulation 00:01:00 Assignment Assignment - Definitive Sports Nutrition 00:00:00 Additional Study Materials - Definitive Sports Nutrition Additional Study Materials - Definitive Sports Nutrition 00:00:00

Have you ever wonder have to put together a tuition business to become profitable? Are you wondering if this kind of business is for you? Then worry no more! This course is what you need! Description: If you want to become a businessmen or entrepreneur, you need to have a solid background on how to run a business by understanding what kind of business you will be entering. This course will be helping you to assess you for your business, specifically a tuition business. The course will start by introducing you to the tuition business basics and reasons why this is a good idea. Through this course, you will learn about the benefits of running tuition business and help you decide if this is the kind of business is what you should start.  Who is the course for? Professionals, businessmen, entrepreneurs, and administrator of schools People who have an interest in tuition 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. Certification: After successful completion of the course, our students can buy an Accredited Certificate of Achievement from John Academy. The certificate will be given in PDF format. If any of our students want a hard copy of the certificate, it is available for an additional fee. Career Path: The Tuition Business Basics is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Entrepreneurs School Administrator School Auditor School Accountant Chapter-1 Introduction To Tuition Business Basics 00:30:00 Chapter-2 Reasons To Start A Tuition Business 00:30:00 Chapter-3 Arranging Your Tuition Business 00:30:00 Chapter-4 How To Start A Successful Tuition Business 00:30:00 Chapter-5 Best Way To Grow Your Tutoring Business 00:30:00 Chapter-6 The Essential Benefits Of running A Tuition Business 00:15:00 Chapter-7 Wrapping Up 00:15:00 Additional Supporting Materials Tutor business book preview 00:00:00 Mock Exam Mock Exam- Tution Business Basics 00:20:00 Final Exam Final Exam- Tution Business Basics 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Safeguarding and Counselling Course . You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Safeguarding and Counselling Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Safeguarding and Counselling Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Safeguarding and Counselling Course , like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Safeguarding and Counselling Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Safeguarding and Counselling Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Safeguarding and Counselling Course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Safeguarding and Counselling Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Safeguarding and Counselling Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Safeguarding and Counselling Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Safeguarding and Counselling Course Module 01: Introduction to Safeguarding 00:21:00 Module 02: An Introduction to Safeguarding of Vulnerable Adults 00:30:00 Module 03: Laws and Guidance 00:43:00 Module 04: Safeguarding Legislations 00:30:00 Module 05: Understanding Abuse and Neglect 00:36:00 Module 06: Child Abuse 00:49:00 Module 07: Sexual Abuse 00:38:00 Module 08: Understanding the Importance of Communication in Care 00:30:00 Module 09: Sharing Information and Responding To a Disclosure 00:30:00 Module 10: Record Keeping 00:18:00 Module 11: Risks and Risk Assessment 00:16:00 What Causes Depression Introduction 00:05:00 Melancholy and the History of Counselling 00:07:00 Signs of Depression 00:07:00 Depression and the Brain 00:06:00 Depression and Neurons 00:09:00 Stress and depression 00:10:00 Environmental and Health Factors 00:04:00 Depression and Sleep Disorders 00:06:00 Somatic Symptoms 00:06:00 Risk Factors 00:07:00 Module 1: Assessment Questions 00:05:00 Different Types of Depression Classifying Depression & Different Classification Methods 00:07:00 Cyclothymia 00:06:00 Depression and Creative Minds 00:07:00 Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression 00:07:00 Bipolar / Manic Depression 00:06:00 Antenatal & Postpartum Depression 00:09:00 Bereavement and Grief 00:09:00 Dysthymia in Children and Adolescents 00:04:00 Depression and the Elderly 00:06:00 Psychosocial & Health Factors in the Elderly 00:03:00 Module 2: Assessment Questions 00:04:00 Different Types of Medicine Neurogenesis 00:04:00 Monoamine Oxidase Inhibitors 00:04:00 Serotonin Syndrome 00:03:00 Selective Serotonin Reuptake Inhibitors 00:03:00 Tyramine 00:03:00 Medication Statistics and Doctors in the UK & USA 00:10:00 Module 3: Assessment Questions 00:03:00 Complementary Alternative Therapies Lifestyle management, Diet, Exercise, Meditation 00:07:00 St John's Wort (hypericum perforatum) 00:05:00 Omega 3 Fatty Acids 00:04:00 Tai chi, Qigong 00:04:00 Yoga 00:04:00 Acupuncture 00:03:00 Art Therapy & Music Therapy 00:08:00 Module 4 Assessment Questions 00:04:00 Counselling Approaches to Depression Person Centred Therapy 00:07:00 Family or Couples Therapy 00:09:00 Stepped Care Model (approach) 00:10:00 Psychodynamic/Dynamic Interpersonal Therapy 00:06:00 Rational Emotive Behavioural Therapy 00:06:00 Clinical Hypnotherapy & Cognitive Behavioural Therapy 00:05:00 Clinical Hypnotherapy for Post Traumatic Stress Disorder 00:05:00 Gestalt Therapy 00:06:00 The Therapeutic Relationship 00:07:00 Knowledge and Qualities Necessary to a Counsellor 00:03:00 Module 5 assessment questions 00:03:00 Thank You and Good Bye! 00:03:00 Additional Study Materials Additional Study Materials: Online Depression Counselling Training 00:00:00 Assignment Assignment - Safeguarding and Counselling Course 00:00:00 Workbook - Safeguarding and Counselling Course Workbook - Safeguarding and Counselling Course 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Banking and Finance Accounting Statements Financial Analysis Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Banking and Finance Accounting Statements Financial Analysis Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Banking and Finance Accounting Statements Financial Analysis Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Banking and Finance Accounting Statements Financial Analysis Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Banking and Finance Accounting Statements Financial Analysis? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Banking and Finance Accounting Statements Financial Analysis there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Banking and Finance Accounting Statements Financial Analysis course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Banking and Finance Accounting Statements Financial Analysis does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Banking and Finance Accounting Statements Financial Analysis was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Banking and Finance Accounting Statements Financial Analysis is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction and Welcome to the Course Introduction to Financial Statements and Analysis 00:05:00 Why are Financial Statements Important 00:07:00 Section 02: Introduction to Accounting What do we mean by Financial Accounting? 00:04:00 Accounting Standards and why they are important 00:06:00 The Concepts and Principles Underlying Accounting 00:06:00 Single Entry vs Double Entry Book Keeping 00:08:00 Understanding The Accounting Equation 00:06:00 The Accounting Cycle 00:05:00 Financial Statements 00:07:00 Section 03: Introduction to Financial Statements Section Introduction - Understanding Financial Statements 00:02:00 Overview of Financial Statements 00:03:00 GAAP: Accruals and Cash Accounting 00:06:00 Income Statement or Profit and Loss Account 00:08:00 Introduction to the Balance Sheet 00:11:00 Introduction to the Cash Flow Statement 00:06:00 Cash Flow Metrics Explained 00:09:00 Case Study- Apple Financial Statements 00:04:00 Section 04: Understanding Working Capital What is Working Capital 00:03:00 What is the Working Capital Cycle? 00:05:00 Why is working Capital Management important 00:05:00 Working Capital Analysis 00:05:00 Working Capital Ratios 00:07:00 Working Capital Policies 00:05:00 Working Capital Summary 00:03:00 Section 05: Introduction to Financial Analysis Section Introduction: Strategic Financial Analysis 00:01:00 What is Financial Analysis? 00:11:00 Measures of Profitability Financial Analysis 00:04:00 Balance Sheet Ratio Analysis 00:12:00 Cash Flow Statement Analysis 00:05:00 Valuation Ratios 00:04:00 Section 06: Financial Analysis - Case Study and Assignment Section Introduction: Financial Analysis - Case Study and Assignment 00:01:00 Case Study Assignments Apple Inc Financial Analysis 00:06:00 Apple Inc Financial Analysis - Solution 00:03:00 Discussion of Measurements of Growth Analysis 00:05:00 Discussion of Measures of Profitability Analysis 00:07:00 Discussion of Trading Performance Analysis 00:03:00 Discussion of Working Capital (Liquidity and Efficiency) Analysis 00:12:00 Section 07: Financial Ratio Analysis in Corporate Finance What do we mean by Corporate Finance? 00:06:00 Financial Ratios in Corporate Finance 00:03:00 Liquidity Ratios in Corporate Finance 00:08:00 Operational Risk Ratios in Corporate Finance 00:08:00 Profitability Ratios in Corporate Finance 00:08:00 Efficiency Ratios in Corporate Finance 00:07:00 Section 08: Financial Modelling for Mergers and Acquisitions Why is modelling so critical 00:03:00 Three Models You Will Need 00:08:00 Understanding The Integrated Financial Statements Model 00:06:00 The Integrated Financial Statements Model Example 00:07:00 Key Tips to Modelling the Integrated Financial Statements Model 00:02:00 The Discounted Cash Flow Model - DCF 00:07:00 Understanding the Discounted Cash Flow Formula 00:06:00 Understanding the Merger Model 00:08:00 Section 09: Course Summary and Wrap Up Course Summary and Wrap Up 00:03:00 Additional Resource Additional Materials 00:00:00

Immerse yourself in the dynamic world of digital content creation with our 'Content Writing & Copywriting for SEO and Sales' course. This program is meticulously structured to transform novices into skilled artisans of the written word, tailored specifically for digital marketing and sales. You begin with an enlightening introduction, easing you into the fascinating realm of content creation. As you progress, a free taster session showcases the course's value, followed by an in-depth exploration into the 12 essential steps of great copywriting in Section 03. Understanding the building blocks of copywriting is simplified in Section 04, providing a solid foundation. From crafting compelling headlines in Section 05 to refining sales copy through proofreading and editing in Section 06, each section is designed to enhance your skills incrementally. Delving deeper, Section 07 unveils the psychological aspects behind effective copywriting, an essential tool for creating impactful content. Subsequent sections are dedicated to specialised formats including blogging, landing pages, sales letters, video scripts, emails, advertisements, social media posts, and promotional videos. These targeted modules offer a comprehensive learning experience, equipping you with the skills to excel across various platforms. By the time you reach the course's conclusion, you'll have acquired a profound understanding of content writing and copywriting, specifically tailored for SEO and sales, ready to make your mark in the digital world. Learning Outcomes Master the art of creating engaging and SEO-optimized content. Develop proficiency in writing compelling headlines and sales copy. Understand the psychological principles behind effective copywriting. Learn to craft specialized content for diverse digital platforms. Enhance editing and proofreading skills to deliver polished content. Why choose this Content Writing & Copywriting For SEO and Sales course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Content Writing & Copywriting For SEO and Sales course for? Aspiring content writers and copywriters seeking to specialize in SEO and sales. Marketing professionals aiming to enhance their content creation skills. Business owners looking to improve their online content strategy. Freelancers wanting to offer specialized content writing services. Individuals interested in understanding the interplay between psychology and writing. Career path SEO Content Writer: £20,000 - £30,000 Copywriter: £23,000 - £35,000 Digital Marketing Specialist: £25,000 - £40,000 Content Strategist: £28,000 - £45,000 Freelance Writer: £18,000 - £50,000 (varies with projects) Social Media Manager: £24,000 - £38,000 Prerequisites This Content Writing & Copywriting For SEO and Sales does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Introduction Introduction 00:01:00 How to Navigate This Course - Watch This Video 00:03:00 Section 02: Free Taster 13 Copywriting and Sales Buttons You Need to Know How to Push 00:07:00 Copywriting to Sell 10 Steps you must know 00:06:00 14 Step Formula to Writing Great Sales Copy 00:06:00 Section 03: BASICS: 12 Essential Steps to Great Copy Writing AIDA is not just an Opera! 00:02:00 Have you any idea who you are talking to? 00:02:00 Who cares what format you use? 00:03:00 Hurting? Want someone to heal your pain? 00:02:00 I haven't got time or money for Objections! 00:02:00 Don't worry, there's always plenty of Scarcity to go round! 00:02:00 So, why are YOU reading my Headlines? 00:02:00 Why do you always want to know whats in it for you? 00:02:00 Endorsements? Pah! Prove it to me! 00:03:00 I Guarantee to you that I love Risk! Or do I? 00:02:00 Right it Wright to Be Red! or you won't be Readable! 00:03:00 Right it Wright to Be Red! or you won't be Readable! 00:03:00 Section 04: BASICS: Copywriting Formulation - Understanding Copywriting Building Blocks Introduction to Copywriting Formulation 00:02:00 Starting with AIDA 00:06:00 PAS - Problem, Agitation, Solution 00:04:00 The 4 Ps 00:03:00 QUEST 00:04:00 Section 05: BASICS: How to Write Headline What You Need to Know to Write Great Headlines 00:06:00 Section 06: BASICS: Proofreading and Editing - How to Edit Sales Copy Writing Editing: Can You Write Better Copy? 00:06:00 Proof Reading and Editing: 20 Ways to Write Better Copy 00:11:00 Editing Writing: Seven Guidelines for Editing Writing 00:06:00 Section 07: PSYCHOLOGY: The Psychology behind Copywriting Get Your Copywriting Psychology Right! 00:06:00 What are the Eight Universal Motivators? 00:07:00 100 Motivations 00:05:00 Overcoming Objections 00:08:00 Section 08: COPYWRITING FOR Blogging - Web Posts Copywriting for Blogs 00:09:00 A Simple Formula for Blog Posts 00:04:00 Blog Post Copywriting Formula 00:09:00 Blog Post Editing Checklist 00:08:00 Section 09: COPYWRITING FOR Landing Pages Copywriting for Landing Pages 00:04:00 Copywriting for Testimonials 00:06:00 Copywriting for Bullet Points 00:05:00 Section 10: COPYWRITING FOR Sales Letters Five Formulations for Sales Letters 00:03:00 The Five Point Sales Letter Formula 00:03:00 The Seven Step Copywriting Formula for Sales Letters 00:05:00 The Nine Point Formula 00:06:00 The 18 Step Sales Letter 00:06:00 The 21 Part Sales Letter Formula 00:08:00 Bonus: 32 Step Power Copywriting Formula 00:08:00 Section 11: COPYWRITING FOR Video Sales Letters What is a Video Sales Letter 00:03:00 How to Write an Attention Grabbing Video Sales Letter Headline 00:03:00 Video Sales Letter Basics - Some Simple Guidance for Better VSLs 00:04:00 Video Sales Letter Outline - with Downloadable Templates 00:07:00 Section 12: COPYWRITING FOR Email Copywriting for Email 00:07:00 How to Write Effective Welcome Emails 00:10:00 ACTIVITY: Analysis of a Long Form Story Telling Email 00:07:00 Email Copywriting Analysis 1 00:05:00 Copywriting Formulas for Email Sequences 00:06:00 Section 13: COPYWRITING FOR Advertisements Copywriting for Advertisements 00:04:00 Section 14: COPYWRITING FOR Twitter Copywriting for Twitter - Engage, Entertain, Be Brief! 00:07:00 Section 15: COPYWRITING FOR Promotional Videos How to Create a High Converting Promotional Video 00:06:00 The Promotional Video for This Course Following the Script 00:02:00 The Promotional Video - Version 2 00:02:00 Promotional Video SlideDeck 00:20:00 Promotional Video Script Checklist 00:04:00 2018 Update: The Formula for an Effective Promotional Video 00:04:00 2018 New Copywriting Course Promo Video 00:03:00 Section 16: Conclusion and Course Wrap Up Conclusion and Course Wrap Up 00:03:00 Additional File Additional File 00:00:00 Assignment Assignment - Content Writing & Copy Writing For SEO and Sales 00:00:00

Are you currently in the Sales Industry? Or are you someone who has your own business? Either way, are you having a hard time increasing your sales? Then this course is perfect for your needs! Description: Sales industry is a very fast-paced sector that should be understood and adapted to its trends to be able to succeed. In this course, you will be introduced to sales which happen on a daily basis and how offering additional products is an essential for the business. Then you will learn when and how to offer promos and discounts to increase your sales. You will learn how to train your people and make your store presentable for your clients to be able to maximise your sales. Lastly, you will know about the importance of the after-sales services you should provide. Who is the course for? Sales professionals, businessmen, and entrepreneurs who want to increase their sales People who have an interest in sales and marketing 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 Level 2 Certificate in Increasing Sales is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Entrepreneurs Independent Sales Operator Marketing Specialists Sales Consultant and Specialists Sales Person Sales Representatives Self-publisher. Module 01 Introduction 00:15:00 Making Additional Sales More Effectively 01:00:00 Up Selling More Effectively 00:30:00 Cross-­Selling More Effectively 00:30:00 Offer Promos And Discounts More Effectively 00:15:00 Offer Freebies At No-­Cost or Little Cost 00:15:00 Module 02 Doing Product Presentation More Effectively 00:30:00 Advertising More Effectively 00:30:00 Absorb Losses More Effectively 01:00:00 Break the Competition More Effectively 01:00:00 Search Engine Optimizing Your Website More Effectively 00:30:00 Making Your Product More Attractive 00:15:00 Module 03 Train Your People More Effectively 01:00:00 Doing Store Presentation More Effectively 01:00:00 Using Perfect Timing To Maximize Sales 00:30:00 Offer After-­Sales Services More Effectively 00:30:00 Miscellaneous Tips 00:30:00 Conclusion 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description A good childhood and youth development completely depend on the environment they live in and grow up. Social networking is hugely popular nowadays. Due to the modern channels of communication and entertainments children tend to spend more time in online than sports and so parents should be ever more vigilant in making sure that their children are not being harmed through online or their safety are not being compromised. Many young people are sophisticated in the way they use social media apps and websites, tailoring their communication for different audiences, and accessing them from a range of devices including smartphones, tablets, and games consoles. But social media, like all forms of public communication, comes with some risks. Not all of these risks turn into actual problems; and if children never face any risks, they never learn how to deal with them. By helping your child understand what the risks are, you can play a big part in preventing them from turning into problems. This course has been designed to teach you all fundamental elements of child safety online and the strategies how to protect your children from harm. Who is the course for?  This course is for people who are willing to teach the children about their personal safety around the neighbourhood. This course is for individuals who are willing to help in keeping the neighbourhood safe. 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 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 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 Child Safety Online is a useful qualification to possess, and would be beneficial for the following careers: Child care worker Social worker Child care instructor. Diploma in Child Safety Introduction to Child Safety 00:30:00 Warning Signs 01:00:00 Parental Monitoring 00:15:00 Monitoring and Protection Software 01:00:00 Tips to Avoid Sexual Predators 00:30:00 The Truth About Online Content 01:00:00 Identity Theft 00:30:00 Spyware And Malware 01:00:00 The Children's Online Privacy Protection Act (COPPA) 00:15:00 Privacy Policy 00:15:00 Social Networking Safety 01:00:00 Additional Rules For Child Safety Online 00:30:00 Warnings For Children Online 00:15:00 Additional Tips For Parents 01:00:00 Mock Exam Mock Exam- Diploma in Child Safety Online 00:20:00 Final Exam Final Exam- Diploma in Child Safety Online 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Communication Skills Master Class . You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Communication Skills Master Class is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Communication Skills Master Class has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Communication Skills Master Class , like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Communication Skills Master Class? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Communication Skills Master Class there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Communication Skills Master Class is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Communication Skills Master Class does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Communication Skills Master Class was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Communication Skills Master Class is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Basic Communication Skills Definition of Communication 00:03:00 Elements of Communication 00:04:00 Communication Styles 00:03:00 Steps in Communication Process 00:01:00 Step 1 of Communication Process 00:02:00 Step 1 Explained - Goal and preparation 00:05:00 Step 1 Explained - Practicing Positive Intent 00:02:00 Step 1 Explained - Understanding Assumptions 00:06:00 Step 2 of Communication Process 00:04:00 Characteristics of Clear Message 00:04:00 Three Different Communication Styles 00:06:00 Assertive Communication Style 00:02:00 Body Language and Signals 00:03:00 Third Step in Communication - Seeing Feedback 00:04:00 Listening Skills - Listen with Compassion 00:04:00 Listening Skills - Meaning of Paraphrasing 00:02:00 Ways to Improve Communication and Knowledge Check 00:05:00 Increase Effectiveness of Communication 00:08:00 8 Guidelines for Giving Praise and Feedback 00:05:00 Additional Tips for Effective Communications 00:09:00 Section 02: Communication in Organisations & Strategic Communications Communication Requirements in Business 00:08:00 Skills required in corporate communication 00:06:00 Interactive Communications 00:08:00 Reason why Communication Fails 00:03:00 Communication Channels and Their Problems 00:06:00 Indications of Incompetent Communication 00:06:00 Other reasons for Communication failure 00:04:00 Strategic Communication Liner Model 00:05:00 Strategic Communication Adaptive Model 00:04:00 Strategic Communication Interpretive Model 00:04:00 Strategic Communication in Public Communication 00:09:00 Resources and Audience for Strategic Public Communication 00:07:00 Source of Strategic Communication 00:05:00 Strategic Communication - Summary of three models 00:12:00 Strategic Communication - Guidelines for Interpretative Models 00:05:00 Strategic Communication - Public Communications 00:11:00 Internal Communication - Orientation 00:09:00 Internal Communication - Moral Compansation and Benefits 00:07:00 Internal Communication - Organisation Change 00:07:00 External Communication - Issues Management 00:06:00 External Communication and PR 00:05:00 External Communication - Issue Management - Organisation Response 00:13:00 External Communication - Image Management and Issue Advocacy 00:06:00 External Communication - Risk and Crisis Communication 00:10:00 Case Study on Corporate Strategic Communication 00:09:00 Section 03: How to Make Strategic Communication Plans What is Strategy? 00:06:00 What is Communication Strategy? 00:05:00 When Communication Strategy is required 00:04:00 Why Communication Strategy is required 00:03:00 Information we need before making strategy 00:08:00 Setting Goals and Identify Audience 00:08:00 Catagorise your Audience to help draft right message 00:04:00 Drafting Message to cater your audience 00:04:00 Channels and Timing of Communication 00:05:00 Resources risk and Evaluation of communication strategy 00:04:00 Summary of Communication Strategy 00:03:00 Strategic Communication Plan Template 00:04:00 Strategic Communication Plan 00:04:00 Difference between Strategic and Tactical Communication 00:03:00 Traditional Planning and why Refreshed Approached 00:05:00 Change Management - What are concerns? 00:03:00 Refreshed Approach to Communication Planning 00:07:00 Possible Problems in Communication Plan, Success measurement 00:06:00 Measure, Feedback and Manage Cynics 00:03:00 Social Aspects of Communication Strategy 00:12:00 Additional Planning on Social Aspects of Communication Strategy 00:04:00 Strategic Communication - American Airlines Case Study 00:33:00 Section 04: Group Discussions Skills How to Succeed in Group Communication 00:10:00 Defining Group Communication 00:08:00 Elements of Group Communication and Types of Group 00:08:00 Advantages and Disadvantages of Group Discussion 00:08:00 How to prepare for group Discussion 00:07:00 Practice for group Discussion and other aspects 00:08:00 Dos and Don't group Discussion 00:08:00 Section 05: Communication Skills for Conflict Resolution Summary of previous class 00:05:00 What is conflict - class discussion? 00:07:00 Communication in Conflict 00:08:00 Meaning of Positive intent in difficult situations 00:09:00 Positive Intent - Example 00:05:00 De-escalating Emotions as a method to communicate in Conflicts 00:06:00 Detached Responsibility method in resolving conflicts 00:13:00 Keys to handle Angry Peoples 00:06:00 Keys to deal with denial 00:04:00 Uncovering Hidden Agendas 00:06:00 Giving Negative Feedback 00:09:00 Receiving Negative Feedback and Exercise 00:08:00 Assignment Assignment - Communication Skills Master Class 00:00:00

Description: Psychology studies the human mind and its functions. The Advanced Diploma in Psychology Level 4 course covers the advanced theories and principles related to human psychology. Have you ever thought why people act differently? Or why different people have different behaviour and thought? Do you know how children psychology develops in various age? Psychology tries to answer these questions. In this course, you will explore these issues. The course introduces you to the multiple theories of psychology, cognitive theory and concepts of developmental psychology. You will learn about the ideas of perception, attention and thinking will also be covered in the course. The course also discusses anxiety, depression, and other emotional disorders and guides you the techniques of treating this 'abnormal behaviour'. In short, the course helps you to gain a crystal clear knowledge about psychology and its prominent theories. Who is the course for? Students who are aware of what Psychology is Students who took a basic level of Psychology in the past 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 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. 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: 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. Perspectives in Psychology Promo Video FREE 00:01:00 What is Psychology 00:08:00 The Biological Approach 00:10:00 Behaviourist and Cognitive Approaches 00:10:00 Person-Centred Approaches 00:09:00 Research Methods in Psychology 00:12:00 Debates in Psychology 00:13:00 Social Psychology Social Influence: Compliance, Obedience and Conformity 00:10:00 Social Cognition 00:09:00 Applied Social Psychology 00:10:00 Cognitive Psychology and Its Applications Perception 00:10:00 Attention 00:07:00 Remembering (Memory) 00:10:00 Forgetting (Memory) 00:07:00 Language 00:10:00 Thinking (Cognition) 00:07:00 Attitudes 00:10:00 Problem-Solving and Artificial Intelligence 00:09:00 Child Development Issues in Child Development 00:05:00 Cognitive Development 00:07:00 The Development of Language and Communication 00:06:00 Social Perception (Interpersonal Perception) 00:06:00 Moral Development 00:09:00 The Psychology of Atypical (Abnormal) Behaviour The definition and Diagnosis of Atypical (Abnormal) Behaviour 00:07:00 Treatments of atypical (abnormal) behaviour 00:07:00 Emotional disorders 00:05:00 Research Methods Research Methods 00:06:00 Research Issues 00:06:00 Data Analysis 00:07:00 Thank You and Good Bye! 00:02:00 Additional Study Materials Additional Study Materials: Advanced Diploma in Psychology Level 4 00:00:00 Mock Exam Mock Exam - Advanced Diploma in Psychology Level 4 00:20:00 Final Exam Final Exam - Advanced Diploma in Psychology Level 4 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum 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 Thank you 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 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00