14785 CV courses in Liverpool delivered Online

The Professional Presenter Training provides you with the knowledge and skill building in the planning, preparation and delivery of truly engaging presentations. Exploring all aspects of concept, design and delivery, you will gain a range of tools and techniques to help you plan and deliver engaging and effective presentations to a range of audiences. You'll learn how to use specific tools and techniques for presentation creation and delivery which will enable you to conduct powerful presentations that engage your audience every time. This course will give you the framework needed to develop and deliver an effective, memorable presentation. You will learn proven tips and examples that will guide you through the presentation process no matter how large the audience. Who is this course for? Excel 2019 Intermediate is suitable for anyone who wants 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 Excel 2019 Intermediate is open to all from all academic backgrounds and there are 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 Intro Introduction 00:01:00 Section 01 Linking Worksheets and Workbooks 00:07:00 Linking Worksheets with 3D References 00:05:00 Understanding the Consolidate Feature 00:06:00 Section 02 What are Range Names 00:06:00 Creating Range Names Using the Name Box and Define Name 00:06:00 Creating Range Names Using Create from Selection 00:03:00 Section 03 Understanding the Differences Between Sorting and Filtering 00:03:00 Sorting Lists 00:07:00 Filtering Lists 00:06:00 Creating Subtotals 00:05:00 Section 04 Creating Tables and Understanding the Benefits 00:06:00 Understanding the Elements of a Table 00:05:00 Formatting a Table 00:05:00 Sorting and Filtering Tables 00:04:00 Filtering with Slicers 00:07:00 Calculating with Tables 00:06:00 Removing Erroneous Table Data 00:05:00 Exporting, Refreshing, and Converting Tables 00:05:00 Section 05 What is Conditional Formatting 00:03:00 Conditional Formatting-HIghlight Cells and Top Bottom Rules 00:06:00 Conditional Formatting-Data Bars, Icon Sets, and Color Scales 00:06:00 Using Custom Fonts and Colors 00:03:00 Using Custom Conditional Formatting 00:05:00 Modyfing or Removing Conditional Formatting 00:04:00 Section 06 What are Charts 00:06:00 Forecasting with Trendlines 00:05:00 Creating a Chart Template 00:04:00 Displaying Trends with Sparklines 00:08:00 Creating Charts 00:05:00 Understanding Chart Elements 00:05:00 Modifying Chart Elements 00:05:00 Changing and Moving Charts 00:03:00 Filtering a Chart 00:04:00 Formatting Charts 00:13:00 Adjusting Numbering 00:06:00 Creating Dual Axis Charts 00:05:00 Section 07 What is a PivotTable 00:05:00 Creating a PivotTable 00:07:00 Working with the PivotTable Fields Pane 00:10:00 Basic Data Organization and Analysis with PivotTables 00:08:00 Formatting PivotTables 00:05:00 Creating a PivotChart 00:04:00 Modifying and Formatting a PivotChart 00:04:00 Using Slicers and Timeline Slicers 00:08:00 Section 08 Using the PivotTable and PivotChart Wizard 00:03:00 Adding a Calculated Field 00:04:00 Adding a Calculated Item 00:04:00 Applying Conditional Formatting to a PivotTable 00:06:00 Creating Filter Pages for a PivotTable 00:04:00 Enabling the PowerPivot Add-in 00:11:00 Recap Recap 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Are you a compassionate person with an interest in social care? Learn how to work with vulnerable adults and kickstart your career in safeguarding with the Adult Safeguarding Level 3 course. This training course is ideal for those who are new to this field and want to gain practical skills and knowledge for this role. Anyone who works with adults at risk is required to know their professional and legal responsibilities. This training program will teach you how to comply with the Care Act 2014 and the Mental Capacity Act 2005. You will also learn when to report a safeguarding concern and how to report it. Throughout the course, you will explore safeguarding policies and principles and develop essential leadership and social skills. Your Learning Goals Understand your professional and legal responsibilities for safeguarding vulnerable adults Develop your knowledge of safeguarding policies, principles, and procedures Learn how to conduct an adult protection investigation Understand the challenges that come with the role and how to deal with them in a professional manner Get an introduction to the legal framework of the Care Act 2014 Familiarise with the rules of whistleblowing and disclosure Develop your communication, leadership and interpersonal skills Learn how to report a safeguarding concern Who is this Course for? Adult Safeguarding 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. 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 Safeguarding Vulnerable Adults Introduction to Safeguarding 00:30:00 Abuse 00:45:00 Mental Capacity Act 2005 00:30:00 Other Key Legislations 00:30:00 Responding to Safeguarding Alerts 00:30:00 Protocol of Information Sharing 00:30:00 Investigation 00:30:00 Psychology of Older Age What is 'Developmental Psychology'? 00:05:00 What is 'Gerontology'? 00:09:00 What we consider as 'old age' 00:09:00 What is 'ageing' and how it happens 00:08:00 Common stereotypes of older people 00:08:00 How stereotyping affects older people 00:08:00 Life stages and Theories 00:11:00 What do we look forward to in our older age? 00:06:00 Mental Capacity Act (MCA) Introduction to MCA 00:15:00 Statutory Principles & Their Applications 00:15:00 How to Help People to Make Their Own Decisions 00:20:00 How to Assess Mental Capacity 00:30:00 What 'Best Interests' Mean? 00:45:00 Protection for the People Providing Treatment or Care 01:00:00 Lasting Powers of Attorney (LPAs) 01:00:00 Role of the Court of Protection and Court-appointed Deputies 01:00:00 Advance decisions to Refuse Treatment 01:00:00 The New Independent Mental Capacity Advocate Service 01:00:00 Mental Health and Old Age Memory-related issues 00:12:00 Learning disabilities 00:08:00 Alzheimer's disease and Dementia 00:09:00 Chronic illness and Disabilities 00:08:00 Substance abuse (addictions) 00:06:00 Improving Health and Wellbeing The effects of exercising 00:09:00 Is it worth eating 'healthy' in older age? 00:09:00 What else affects 'health' and 'wellbeing'? 00:08:00 Caring for older people 00:06:00 Dementia Care Awareness and Misunderstanding 00:30:00 Symptoms of Dementia 00:10:00 Prevention and Treatment 00:05:00 The Impact Of Stigma 01:00:00 Caring for Dementia Victims 00:20:00 Home Adaptations for People with Dementia 01:00:00 Mock Exam Mock Exam- Safeguarding Vulnerable Adults 00:20:00 Final Exam Final Exam- Safeguarding Vulnerable Adults 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on Makeup Artistry Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Makeup Artistry Course comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Makeup Artistry Course. It is available to all students, of all academic backgrounds. Requirements Our Makeup Artistry Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 29 sections • 144 lectures • 06:16:00 total length •Promo: 00:01:00 •Introduction: Makeup Artistry from Basic to Masterclass: 00:02:00 •Personal Hygiene: 00:01:00 •Brush Hygiene: 00:02:00 •Product Contamination: 00:01:00 •Contraindications & how to deal with them: 00:01:00 •Product Expiry: 00:01:00 •Make Up Kit Hygiene: 00:01:00 •Sum Up: 00:01:00 •Intro & Must- Have Brushes for your Make Up Starter Kit: 00:08:00 •The Different Kind of Eye Blending Brushes: 00:03:00 •The Different Kind of Foundation Brushes: 00:02:00 •How to prepare for a professional & organized Make Up appointment: 00:04:00 •Intro: Color Theory in Make Up Artistry: 00:02:00 •Understanding the Pocket Color Wheel: 00:01:00 •Warm and Cool based Colors & the meaning of Complementary Colors: 00:02:00 •Why do we Color Correct?: 00:01:00 •Correcting Dark Eye Circles on different Skin Tones: 00:02:00 •Correcting other Surface Tones : Redness & Dullness: 00:02:00 •Begin with the Skin: 00:03:00 •Intro : What are Primers ?: 00:01:00 •An Overview of the main different Primers: 00:01:00 •Silicon Based Primers : A Good or Bad Choice for the skin?: 00:01:00 •Alternative to a Primer?: 00:01:00 •How to Prepare & Prime common skintypes : Dry/ Dehydrated & Combinational/Oily: 00:03:00 •The first Step before Foundation Matching: 00:02:00 •Introducing the Undertones: 00:01:00 •What is a Surface Tone?: 00:01:00 •How to determine the Undertone visually: 00:01:00 •Foundation Matching: Striping Method: 00:03:00 •The Different Foundation Coverages: 00:05:00 •How to apply Foundation correctly: 00:05:00 •Concealer's Purpose & Tools to apply: 00:02:00 •The Correct Concealer Application: 00:02:00 •The Term : 'Baking' in Make Up Artistry: 00:01:00 •Intro : What is the Purpose of Highlighting & Contouring ?: 00:01:00 •The Steps you need to take & The different Face Shapes: 00:01:00 •Highlight & Contour EVERY Face Shape easily: 00:02:00 •Products : Which Texture & Shade ?: 00:02:00 •Tools: 00:01:00 •Practice Time : Master the Highlight & Contour Game!: 00:04:00 •Blush : A pop of Color for a more healthy looking Face: 00:03:00 •The Different Parts of the Eyes & How to apply Eye Products on them: 00:02:00 •Tools for perfect Application + Shade & Texture of Eyeshadows: 00:02:00 •Practice Time: Flawless Eye Make Up Application: 00:06:00 •Intro Eyeliner : What to avoid ( Do's & Dont's): 00:04:00 •An Overview of the different Eyeliner Products: 00:02:00 •The Different Eyeshapes: 00:01:00 •Practice Time: Basic & Winged Eyeliner Application: 00:03:00 •Recommendations & Tips: 00:02:00 •The correct Mascara Application: 00:03:00 •How to apply False Lashes correctly: 00:04:00 •Determining the Shape of the Eyebrows: 00:01:00 •Different Eyebrow Products, different Applications: 00:01:00 •Practice Time: Eyebrow Application with Brow Pomade: 00:03:00 •Practice Time 2: Eyebrow Application with a Brow Pencil: 00:03:00 •Intro : Lip Product Application & How to Prep & Prime the Lips: 00:02:00 •Which Lip Shade & Texture to Choose: 00:01:00 •Practice Time : Apply the Perfect Red Lips + Strobe: 00:04:00 •Finding out the suitable Make Up look for your Client: 00:04:00 •The Definition of a 'Natural Look' to you and your Clients: 00:02:00 •Analyzing the Clients Facial Features: 00:02:00 •Build a good Clientelle: 00:02:00 •Create your own Price-List: 00:02:00 •Manage your Bookings: 00:01:00 •Consultation & Meeting with your Client: 00:06:00 •Foundation Matching: on Neutral Light Skin Undertone: 00:01:00 •Skin Prep & Prime on a dry Skintype: 00:01:00 •Halo Eye Make Up Look on Round, heavy Lidded Eyeshapes: 00:09:00 •Correct Light Blemishes, Apply Foundation , Highlight & Contour Long Face Shape: 00:07:00 •Applying Bronzer & Blush: 00:02:00 •Creating the Perfect 3D Glow Effect: For lifted Cheekbones area: 00:02:00 •Shaping & Filling in Eyebrows with Gaps: 00:01:00 •Creating Nude Brown Ombre Lips & the Final Results: 00:03:00 •Intro Course Content: Focus of this Lesson L21: 00:01:00 •Foundation Matching on dark Complexions: Lets find the Correct shade (Mixing): 00:01:00 •Skin Prep & Prime for Combinational Skin (Oily/ Dehydrated): 00:01:00 •Day Eye Make Up Look on Small Upturned Eye Shape: 00:03:00 •Color Correcting Hyperpigmentation/ Spots on dark Skin Colors: 00:01:00 •Highlight & Contour: Oblong Face Shape with short Chin part: 00:02:00 •Apply Warmth, Color & Glow on dark Complexions: 00:01:00 •Make Big Lips appear Smaller & Final Results of Day Make Up Look: 00:01:00 •Transform Day to Night: Nightout Eye Make Up Look: 00:02:00 •Touch Ups: Another method to make Lips appear smaller & Final Results: 00:03:00 •Intro Course Content: Focus of this Lesson L22: 00:01:00 •Monolid & Close-Set Eyeshapes : How to Enhance them with Eyeshadow: 00:03:00 •Monolid Eyeshapes : Apply Eyeliner: 00:07:00 •Triangular Face Shape: Soft Highlight & Contour: 00:02:00 •Asian Nose: Creating a Prominent Nose Bridge: 00:02:00 •Touch Up & Final Results: 00:02:00 •Intro Course Content: Focus of this Lesson L23: 00:01:00 •Downturned Eyeshapes : Create bright & flattering Eyes: 00:05:00 •Color Correct Redness & Cover large-scale Freckles: 00:01:00 •Round Face Shape: Highlight & Contour: 00:03:00 •Filling in Brows with Brow Pomade & applying Cherry Red Lipstick & Final Results: 00:02:00 •Intro Course Content: Focus of this Lesson L24: 00:01:00 •Foundation Mixing & Matching on Medium Dark Skin Colors: 00:01:00 •Skin Prep & Prime: Dry Skin: 00:02:00 •Round Upturned Eyeshapes Makeup Application: 00:07:00 •Round Upturned Eyeshapes : Apply Eyeliner & Lashes: 00:03:00 •Color Correct on Medium dark Skin Tones: 00:01:00 •Square Face Shape: Highlight & Contour: 00:03:00 •How to Contour a Wide Nose: 00:01:00 •Apply Bronzer, Blush & Glow on medium dark Skin Colors: 00:02:00 •How to Correct Wide-apart & Thin Eyebrow Shapes: 00:03:00 •Perfect Pumpkin Nude Shade for Medium dark Skin Tones: 00:01:00 •Setting Spray & Final Results: 00:01:00 •Intro Course Content : Focus of this Lesson L25: 00:01:00 •Foundation Matching on Neutral Warm (Tanned) Skin Tone: 00:01:00 •Skin Prep & Prime on Combinational/Oily Skintype: 00:01:00 •Soft Pink Eye Make Up Look for Daytime: 00:05:00 •Color Correct Dark Circles around the Eyes: 00:03:00 •Rectangle Face Shape: Highlight & Contour: 00:02:00 •How to apply Bushy Brows & Final Results of Daytime Look: 00:03:00 •The Night Out Eye Make Up Transformation: 00:05:00 •Final Touch Ups & Results for the Evening Make Up Look: 00:02:00 •Intro Course Content: Focus of this Lesson L26: 00:01:00 •Slightly Hooded Eyeshapes : How to apply Eyeliner correctly: 00:02:00 •Skin Prep & Prime: Very Dry Skintype: 00:01:00 •Brighten Up & Enhance the Eyes of Wearer of Glasses: 00:05:00 •How to Prevent Red Marks That Glasses Leave Behind & giving back Structure: 00:04:00 •Creating a dewy Look, Applying Brow Mascara & Lip Gloss & Final Results Day: 00:03:00 •Evening Make Up: Sparkly, Glittery Eye Make Up Look & smudgy Burgundy Eyeliner: 00:02:00 •Intro Course Content: Focus of this Lesson L27: 00:01:00 •Skin Prep & Prime on Acne Prone/Sensitive Skin: 00:01:00 •Deep-Set Eyeshapes: How to enhance them beautifully: 00:07:00 •Color Correcting & Evening out the Skin: 00:02:00 •Inverted Triangle Face Shape: Highlight & Contour: 00:03:00 •Applying Depth, Pop of Colour & Glow on problematic Skin: 00:01:00 •Tatooed Eyebrows: How to make the Eyebrow shade looking freshly pigmented again: 00:01:00 •Apply Matte Warm Pink Nude Lipstick: 00:01:00 •Set the Make Up & Final Results: 00:01:00 •Skin Prep & Prime on Combinational T-Zone to dry Cheek area: 00:03:00 •Application of Smokey Eye Makeup Look: 00:21:00 •Highlight & Contour Rectangle Face Shape: 00:03:00 •Last Touch Ups to Complete The Makeup: Setting, Bronzer, Blush,Highlighter etc.: 00:07:00 •Intro & Skincare Products Recommendations for Acne Prone+ Sensitive Skin Types: 00:02:00 •Roségold Eye Makeup Application: 00:14:00 •Individual Lashes Application: 00:04:00 •Color Correcting & Foundation Application on Acne Prone Skin: 00:08:00 •Slim Oval Face Shape : Contouring & Highlight: 00:05:00 •Eyebrow Application on Natural, full and well-shaped Brows: 00:01:00 •Overlining Lips naturally: 00:02:00 •Results & Ending: 00:02:00

Overview Do you have the skills of a life coach? Have you ever considered a successful career in life coaching and CBT therapy?This Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle course will provide you with a solid understanding of life coaching. It'll cover many practical exercises, enabling you to master tools, techniques and the skills required to start your own coaching practice, if this is your motivation. Moreover, this course is a perfect starting point for anyone who is interested in a therapy career or for those who want to use CBT as a self help model.Don't be late. Enroll today and help to change people's lives with a brand new rewarding career in life coaching and CBT therapy.Please Note: Occupational Therapists and Clinical Psychologists must be registered with the Health and Care Professions Council (HCPC), which is the statutory regulator of the professions. Please note, that completion of the course does not entitle a person to join the HCPC Register or use the protected titles of Occupational Therapist or Clinical Psychologist. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle. It is available to all students, of all academic backgrounds. Requirements Our Life Coaching and Cognitive Behavioural Therapy (CBT) Complete Bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 26 sections • 164 lectures • 10:11:00 total length •What You Will Learn: 00:06:00 •Get To Know Your Instructor: 00:02:00 •How To Get Your CPD Certificates: 00:01:00 •What Is Life Coaching: 00:05:00 •The Benefits Of Becoming A Life Coach: 00:04:00 •The Difference Between Coaching, Therapy, Mentoring & Training: 00:03:00 •The Responsibilities Of A Life Coach: 00:03:00 •Coaching Fundamentals Overview: 00:02:00 •Listening Introduction: 00:02:00 •The 3 Kinds Of Listening As A Coach: 00:05:00 •Your Listening Template: 00:11:00 •Questioning Introduction: 00:01:00 •Questioning & Coaching: 00:03:00 •How Coaching Questions Are Different From Normal Questions: 00:02:00 •The Different Types Of Coaching Questions: 00:12:00 •Questions Summary: 00:03:00 •Building Trust Introduction: 00:01:00 •The Trust Checklist Exercise: 00:03:00 •How To Build Trust As A Coach: 00:08:00 •More Trust Building Strategies: 00:05:00 •Understanding Personalities Overview: 00:03:00 •Big Five Personality Model: 00:02:00 •Myers Briggs Personality Model: 00:04:00 •Your Personality Model: 00:09:00 •How To Bring Out Your Strengths With This Model: 00:10:00 •Coaching Models Introduction: 00:02:00 •GROW Model Explained: 00:05:00 •STEPPPA Model Explained: 00:08:00 •FUEL Model Explained: 00:03:00 •CLEAR Model Explained: 00:04:00 •Why We Will Use The GROW Model: 00:01:00 •Step 1 Introduction: 00:03:00 •Why Defining Your Values Is Important: 00:03:00 •How To Define Your Personal Values: 00:06:00 •What Does Your Ideal Life Look Like?: 00:04:00 •The 4 Biggest Goal Setting Mistakes To Avoid: 00:06:00 •Stretch Goals Explained: 00:03:00 •Why You Should Start With Long Term Goals: 00:05:00 •Setting Your First Long Term Goal: 00:06:00 •Turning Long Term Goals Into Short Term Goals: 00:05:00 •Next Steps: 00:01:00 •Step 2 Introduction: 00:01:00 •Status Quo Explained: 00:06:00 •Wheel Of Life Excercise Explained: 00:06:00 •Big Rocks Exercise Explained: 00:05:00 •Coaching Example Step 2: 00:05:00 •Step 3 Introduction: 00:01:00 •How To Brainstorm With Your Client(s): 00:05:00 •How To Evaluate Your Brainstorming Ideas: 00:05:00 •'Spheres Of Influence' Excerise Explained: 00:03:00 •'Not To Do List' Exercise Explained: 00:04:00 •Coaching Example Step 3: 00:07:00 •Step 4 Introduction: 00:01:00 •The 80/20 Rule Applied To Coaching: 00:04:00 •How To Design An Action Plan: 00:03:00 •Coaching Example Step 4: 00:05:00 •GROW Model Recap: 00:03:00 •Structuring Your Sessions Introduction: 00:01:00 •How To Define Your Coaching Ground Rules: 00:03:00 •How Much Should You Charge: 00:05:00 •The Pre Coaching Call: 00:03:00 •Your First Coaching Session: 00:03:00 •Progress Evaluation Sessions: 00:05:00 •My Recommended Coaching Timeline: 00:03:00 •Client Coach Relationship Intro: 00:01:00 •What Clients Expect From Their Coaches: 00:04:00 •Why Clients Choose One Coach Over Another: 00:02:00 •Client Coach Boundaries: 00:03:00 •How To Retain Clients Long Term: 00:05:00 •Advanced Coaching Strategies Introduction: 00:01:00 •Reframing Explained: 00:07:00 •Managing Emotional States: 00:07:00 •Understanding Representational Systems: 00:08:00 •Personal SWOT Analysis: 00:06:00 •Johari Window - Developing Self Awareness: 00:05:00 •Giving Good Feedback As A Coach: 00:05:00 •Part 2 Introduction: 00:03:00 •What It Means To Be Healthy: 00:04:00 •What Does A Health Coach Do?: 00:03:00 •How Can You Combine Life Coaching & Health Coaching: 00:02:00 •Diet Introduction: 00:01:00 •Your Health & Diet: How They Are Linked: 00:04:00 •The Consequences Of Following A Bad Diet: 00:04:00 •How To Eat For Longevity: 00:02:00 •What Are Calories? Explained: 00:04:00 •The Relationship Between Bodyweight And Health: 00:05:00 •Calories & Bodyweight In A Healthy Diet: 00:02:00 •The Surprising Results Of The Twinkie Diet: 00:02:00 •The Relationship Between Weight Loss And Health: 00:03:00 •Figuring Out How Many Daily Calories You Need: 00:02:00 •Calculating Your Total Daily Calories: 00:03:00 •Healthy Weight Ranges: 00:02:00 •The Best Foods For A Healthier Life: 00:02:00 •Best Protein Foods: 00:01:00 •Best Carbohydrate Foods: 00:01:00 •Best Dietary Fat Foods: 00:01:00 •How Much Of Each (Protein, Carbs, Fat)?: 00:04:00 •What About The Remaining Calories: 00:01:00 •Client Assessment Introduction: 00:01:00 •Client Interview: 00:04:00 •How To Create A Diet Plan For Clients: 00:09:00 •Calculating BMI: 00:03:00 •Cardio Introduction: 00:01:00 •The Different Types Of Cardio: 00:02:00 •Creating A Cardio Workout For A Client: 00:04:00 •How To Monitor Your Heart Rate During A Workout: 00:02:00 •Cardio vs Weigh Training - Which Is Better For Weight Loss: 00:07:00 •Weight Training Introduction: 00:01:00 •Muscle Building Formula: 00:07:00 •The Science Behind Muscle Growth: 00:04:00 •Weight Training vs Bodyweight Training: 00:02:00 •How To Create A Beginner Workout Plan: 00:09:00 •5 Most Important Aspects Of Lifting Form: 00:03:00 •Progressive Overload: 00:03:00 •Hormones Introduction: 00:02:00 •The 3 Types Of Hormones: 00:03:00 •The Endocrine System Explained: 00:04:00 •Hormones & Heart Disease: 00:04:00 •Anabolic Steroids: Why They Are So Dangerous: 00:04:00 •Most Important Hormones Overview: 00:01:00 •Insulin: 00:04:00 •Glucagon: 00:02:00 •Adrenaline: 00:03:00 •Cortisol: 00:04:00 •Ghrelin: 00:02:00 •Leptin: 00:03:00 •Thyroid Hormones: 00:02:00 •Estrogen: 00:03:00 •Growth Hormone: 00:01:00 •Testosterone: 00:03:00 •How To Build Your Own Supplement Stack: 00:09:00 •Top 3 Beginner Supplements For Muscle Growth: 00:04:00 •The Best Supplements To Boost Immunity: 00:04:00 •The Best Supplements For Vegans & Vegetarians: 00:02:00 •The Best Supplements For Joint & Bone Health: 00:02:00 •The Best Supplements For Fat Loss: 00:04:00 •Apex Learning Motivation Introduction: 00:02:00 •How To Get Out Of A Workout Rut: 00:09:00 •What Is Nutrient Density: 00:04:00 •Is Brown Sugar Better Than White Sugar: 00:03:00 •What Should You Train On Your First Day At The Gym?: 00:07:00 •Are Microwaves Harmful?: 00:05:00 •Fresh vs Frozen Food: Which Is Healthier: 00:04:00 •Part 3 Introdudction: 00:02:00 •The Difference Between Stress & Anxiety: 00:03:00 •Short vs Long Term Stress: 00:02:00 •The Effects Of Stress & Anxiety On Your Body: 00:05:00 •Proven Stress Management Strategies & Techniques: 00:03:00 •The Benefits Of Calm Breathing: 00:03:00 •Breathing Exercise #1 - Three Part Breath: 00:02:00 •Breathing Exercise #2 - Bellows Breath: 00:02:00 •Progressive Muscle Relaxation: 00:03:00 •Complete PMR Routine: 00:07:00 •Sleeping For A Longer Life: 00:04:00 •Tips To Fall Asleep Faster: 00:03:00 •Supplements For Improved Sleep: 00:02:00 •What Is Emotional Self Care: 00:05:00 •How To Accept Yourself: 00:03:00 •Taming Your Inner Critic: 00:06:00 •Getting A Different Perspecitive: 00:04:00 •Acknowledging Your Qualities: 00:03:00 •Getting Rid Of Time Consuming Commitments: 00:06:00 •How To Say 'No' To Others: 00:05:00 •Resources - Life Coach Training - Guideline For The Startup: 00:00:00

If you're looking to become instantly hireable across HR, healthcare, education, compliance, and public service roles, the Equality: 8-in-1 Premium Online Courses Bundle was made for you. These 8 power-packed courses signal that you're the kind of candidate every employer wants: skilled, inclusive, and people-focused. This game-changing bundle includes: Autism Employment Law Difficult Workplace Conversations Proofreading Counselling Team Leader Compliance Mindfulness From managing people and policies to communicating with compassion, this bundle covers every corner of equality-focused roles. ⚠️ FOMO alert: The job market is rewarding those trained in autism, employment law, and compliance — don’t fall behind. 💰 Value-for-money alert: You’re getting eight industry-grade certifications for one unbeatable price. 🏆 Reputation alert: Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot. 📝 Description If you want to lead in today’s inclusive workforce, you need more than ambition — you need recognised, role-relevant credentials. Start with autism — it’s no longer optional to understand how to support individuals with autism in workplaces, schools, or healthcare. Having verified training in autism is now a must-have across public-facing sectors. Then there’s employment law — an absolute priority for HR professionals, managers, recruiters, and business owners. Training in employment law shows that you're legally aware and a strategic asset. Recruiters are always on the lookout for candidates with employment law on their CV. Difficult workplace conversations are part of every leadership role. Your ability to navigate difficult workplace conversations will help you stand out in job interviews and during promotion opportunities. People who excel at difficult workplace conversations are indispensable in every organisation. Next, precision matters. That’s where proofreading shines. In admin, publishing, HR, legal, and content roles, proofreading is vital. Being trained in proofreading means you can deliver flawless work — a trait employers crave. In support roles, counselling is key. Whether you're in education, HR, healthcare, or customer service, having counselling skills makes you more trusted, empathetic, and hireable. Candidates trained in counselling stand out. Moving to leadership, team leader potential is essential. Demonstrating team leader skills in your application immediately elevates you. Employers love candidates with proven team leader credentials. Meanwhile, compliance is a top priority across regulated sectors like finance, health, and education. Professionals with compliance training are always in demand — because they reduce organisational risk and show attention to detail. Finally, mindfulness isn’t just a buzzword. Training in mindfulness makes you a better communicator, manager, and professional. It signals emotional regulation and leadership potential. This bundle brings together autism, employment law, difficult workplace conversations, proofreading, counselling, team leader, compliance, and mindfulness into one powerful package. ❓FAQ Q: Who should take this? A: Anyone in HR, admin, support, leadership, or education roles — or anyone aspiring to get there. Q: Will this help me get hired faster? A: Absolutely. These are the kinds of practical, in-demand skills hiring managers prioritise. Q: Are the courses certified? A: Yes. They’re professionally structured and widely recognised. And yes — Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot.

Step into any room — virtual or physical — and be the person everyone wants to hire. The People Practice: 8-in-1 Premium Online Courses Bundle is a career-launching, job-winning powerhouse packed with everything today’s employers crave. Whether you're entering the workforce, switching careers, or aiming for promotion, this is your edge. This bundle is ideal for industries like human resources, customer service, operations, consulting, project delivery, management, and coaching. It’s designed to make you hireable across the board. And yes, it includes eight of the most essential skills: Negotiation Skills Problem Solving Team Leader Public Speaking Crisis Management Project Management Life Coaching Self Organisation ✅ FOMO alert: While others are waiting to be trained, you'll already be hireable. ✅ Value alert: 8 courses. 1 price. Unlimited professional power. And don’t just take our word for it — Compete High has 4.8 on 'Reviews.io' and 4.3 on Trustpilot. 📝 Description You can't fake confidence in the job market — but you can build it with the People Practice bundle. In every job role, negotiation skills matter. Whether you're discussing timelines, ideas, or salaries, having standout negotiation skills can make or break opportunities. Hiring managers are actively searching for candidates with real-world negotiation skills. Equally critical is problem solving — the ability to think fast, react smartly, and deliver results. Mastering problem solving makes you valuable in leadership, logistics, customer support, and team settings. Next comes team leader potential. Even if you’re not applying for a management position, showing team leader traits like initiative, direction, and support will always impress recruiters. A professional with team leader capabilities is someone every team needs. Public speaking isn't just for TED Talks. From interviews to meetings, having strong public speaking skills is a must. Practise your public speaking and you’ll command attention — not just request it. Now, let’s talk emergencies. Every workplace faces tough moments. Your ability to show strong crisis management will keep teams grounded. Crisis management is a leadership marker and a major hiring signal. Success hinges on delivery. That’s where project management shines. Employers across all industries want talent skilled in project management — from tech startups to NGOs. Coaching isn’t just for life coaches — it’s a leadership tool. With life coaching strategies, you gain insight into motivation, mentorship, and people dynamics. Life coaching makes you a stronger colleague and a visionary team member. Finally, self organisation is the engine behind every high performer. People who master self organisation hit deadlines, stay focused, and reduce stress — and employers notice. All 8 of these courses work together to shape a truly unstoppable candidate. From negotiation skills to problem solving, from team leader dynamics to self organisation, your CV will shine. ❓FAQ Q: Who is this bundle for? A: Anyone aiming to become instantly more hireable across people-focused industries — from HR to management, consulting to admin. Q: How long does it take to complete? A: Learn at your own pace. Fast-track your progress or take it slow — it's flexible. Q: Do I need prior experience? A: No experience needed. Just a desire to upskill with negotiation skills, problem solving, team leader training, public speaking, crisis management, project management, life coaching, and self organisation.

Town planning and transport industries are evolving faster than ever, and with it, the demand for multi-skilled professionals is skyrocketing. The Transport & Town Planning: 8-in-1 Premium Online Courses Bundle is built to make you more than just eligible for these roles—it's crafted to make you irresistible to recruiters. 🚧🚗📊 If you’ve ever dreamed of being at the core of public infrastructure, compliance operations, or logistics strategy, this bundle is your stepping stone. Whether it's mastering RIDDOR responsibilities, applying your Problem Solving skills, or keeping up with evolving Compliances, you're setting yourself up for success. But it doesn’t stop there. With a sharp focus on Change Management, Communication Skills, Quality Assurance, Logistics and Transportation, and even practical Car Maintenance, this bundle gives you the career superpowers needed in both private and public sectors. 🔎 From transport hubs to city councils, from civil projects to multinational logistics—you’ll be the candidate who doesn’t just tick boxes, you define the role. And don’t forget: Compete High boasts a 4.8 on Reviews.io and 4.3 on Trustpilot. That’s not just good. That’s gold. ⭐ 📚 Description Want to work in transportation systems, road design, municipal planning, or public infrastructure? This bundle has your back—every keyword aligns with exactly what employers are searching for. Whether you're dealing with real-world RIDDOR procedures, solving departmental bottlenecks with advanced Problem Solving techniques, or ensuring operations meet updated Compliances, each course adds direct value to your CV. Now let's talk Change Management—an increasingly sought-after skill in any city planning or transport initiative. Integrating Communication Skills across roles is also critical—this bundle helps you build that foundation. Pair that with Quality Assurance procedures, smart insights into Logistics and Transportation, and practical knowledge of Car Maintenance, and you’ve positioned yourself as a multidisciplinary hire that businesses dream about. 🔥 The transport and planning industry thrives on professionals who understand both strategy and operations. Your future career could be in: 🏙️ Urban Development & Town Planning 🚦 Highway & Transport Engineering 🚛 Logistics & Transportation Management 🔍 Quality Assurance & Safety Auditing 🧾 Compliance Monitoring & Governance Each keyword—from RIDDOR to Car Maintenance—has been naturally and repeatedly embedded across this copy to ensure you get SEO traction, ATS hits, and recruiter alerts faster than ever. 📈 ❓ FAQ Q: Who’s this bundle for? A: Anyone looking to move into urban planning, public sector jobs, transport logistics, or even private fleet management. The skills—Change Management, Quality Assurance, RIDDOR—apply across industries. Q: Will this make me job-ready? A: Absolutely. From Problem Solving to Compliances, we’ve packed this with employer-prioritised training. Q: Do I need prior experience? A: No experience necessary. You’ll develop your knowledge from the ground up. Q: How does this help with town planning roles? A: Employers want well-rounded professionals. With Communication Skills, Logistics and Transportation, and Change Management, you’ll stand out as someone who sees the big picture. 🛠️ Don’t wait for opportunities—build them. Enrol now and be the hire everyone’s looking for. 🌍🛣️

The healthcare sector doesn’t just need doctors—it needs organised, reliable professionals behind the scenes. The Medical Secretary Mini Bundle prepares you for in-demand roles across private practices, hospitals, and health clinics. Combining healthcare, administrative assistant, virtual assistant, data entry, and compliance, it offers a high-value, career-focused edge to those who want to become instantly hireable. If you're serious about stepping into the world of healthcare administration, don’t miss the opportunity to stand out—this bundle was built for employability. Description The Medical Secretary Mini Bundle is packed with job-aligned keywords that hiring managers actively search for when reviewing CVs in the healthcare industry. With direct emphasis on healthcare, administrative assistant, virtual assistant, data entry, and compliance, this bundle targets the skills most sought after in receptionist, records officer, and secretary roles across the medical field. Whether you want to assist GPs, work remotely as a virtual assistant, manage patient schedules, or handle records with data entry precision, this bundle sets the tone. Hospitals and clinics are prioritising staff who understand compliance, manage workflows as a competent administrative assistant, and can operate within demanding healthcare environments. Don’t just meet expectations—exceed them with this essential bundle. FAQ Q: Who should take this bundle? A: Anyone looking to enter medical administration, reception, or assistant roles—especially those who want to work in healthcare. Q: Is it suitable for remote positions? A: Yes. The virtual assistant and data entry focus makes it ideal for online or hybrid work. Q: How does this boost my CV? A: It shows direct experience in healthcare, compliance, and administrative assistant work—key for hiring managers. Q: What types of organisations value these skills? A: Clinics, private surgeries, public hospitals, and virtual health services. Q: Will this help with NHS job applications? A: Yes. NHS admin roles regularly require knowledge of compliance, data entry, and healthcare structure. Q: Should I wait to enrol? A: No. Opportunities in medical admin are growing—delay could mean a missed job offer.

Do you want to master the essential mathematical skills for data science and machine learning? Do you want to learn how to apply statistics and probability to real-world problems and scenarios? If yes, then this course is for you! In this course, you will learn the advanced concepts and techniques of statistics and probability that are widely used in data science and machine learning. You will learn how to describe and analyse data using descriptive statistics, distributions, and probability theory. You will also learn how to perform hypothesis testing, regressions, ANOVA, and machine learning algorithms to make predictions and inferences from data. You will gain hands-on experience with practical exercises and projects using Python and R. Learning Outcomes By the end of this course, you will be able to: Apply descriptive statistics, distributions, and probability theory to summarise and visualise data Perform hypothesis testing, regressions, ANOVA, and machine learning algorithms to make predictions and inferences from data Use Python and R to implement statistical and machine learning methods Interpret and communicate the results of your analysis using appropriate metrics and visualisations Solve real-world problems and scenarios using statistics and probability Why choose this Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 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 Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 course for? This course is for anyone who wants to learn the advanced concepts and techniques of statistics and probability for data science and machine learning. This course is suitable for: Data scientists, machine learning engineers, and analysts who want to enhance their skills and knowledge Students and researchers who want to learn the mathematical foundations of data science and machine learning Professionals and managers who want to understand and apply data-driven decision making Hobbyists and enthusiasts who want to explore and learn from data Anyone who loves statistics and probability and wants to challenge themselves Career path Data Scientist (£35,000 - £55,000) Machine Learning Engineer (£40,000 - £60,000) Statistician (£35,000 - £55,000) Data Analyst (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Data Analyst (£50,000 - £70,000) Prerequisites This Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £135 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Let's get started Welcome! 00:02:00 What will you learn in this course? 00:06:00 How can you get the most out of it? 00:06:00 Section 02: Descriptive statistics Intro 00:03:00 Mean 00:06:00 Median 00:05:00 Mode 00:04:00 Mean or Median? 00:08:00 Skewness 00:08:00 Practice: Skewness 00:01:00 Solution: Skewness 00:03:00 Range & IQR 00:10:00 Sample vs. Population 00:05:00 Variance & Standard deviation 00:11:00 Impact of Scaling & Shifting 00:19:00 Statistical moments 00:06:00 Section 03: Distributions What is a distribution? 00:10:00 Normal distribution 00:09:00 Z-Scores 00:13:00 Practice: Normal distribution 00:04:00 Solution: Normal distribution 00:07:00 Section 04: Probability theory Intro 00:01:00 Probability Basics 00:10:00 Calculating simple Probabilities 00:05:00 Practice: Simple Probabilities 00:01:00 Quick solution: Simple Probabilities 00:01:00 Detailed solution: Simple Probabilities 00:06:00 Rule of addition 00:13:00 Practice: Rule of addition 00:02:00 Quick solution: Rule of addition 00:01:00 Detailed solution: Rule of addition 00:07:00 Rule of multiplication 00:11:00 Practice: Rule of multiplication 00:01:00 Solution: Rule of multiplication 00:03:00 Bayes Theorem 00:10:00 Bayes Theorem - Practical example 00:07:00 Expected value 00:11:00 Practice: Expected value 00:01:00 Solution: Expected value 00:03:00 Law of Large Numbers 00:08:00 Central Limit Theorem - Theory 00:10:00 Central Limit Theorem - Intuition 00:08:00 Central Limit Theorem - Challenge 00:11:00 Central Limit Theorem - Exercise 00:02:00 Central Limit Theorem - Solution 00:14:00 Binomial distribution 00:16:00 Poisson distribution 00:17:00 Real life problems 00:15:00 Section 05: Hypothesis testing Intro 00:01:00 What is a hypothesis? 00:19:00 Significance level and p-value 00:06:00 Type I and Type II errors 00:05:00 Confidence intervals and margin of error 00:15:00 Excursion: Calculating sample size & power 00:11:00 Performing the hypothesis test 00:20:00 Practice: Hypothesis test 00:01:00 Solution: Hypothesis test 00:06:00 T-test and t-distribution 00:13:00 Proportion testing 00:10:00 Important p-z pairs 00:08:00 Section 06: Regressions Intro 00:02:00 Linear Regression 00:11:00 Correlation coefficient 00:10:00 Practice: Correlation 00:02:00 Solution: Correlation 00:08:00 Practice: Linear Regression 00:01:00 Solution: Linear Regression 00:07:00 Residual, MSE & MAE 00:08:00 Practice: MSE & MAE 00:01:00 Solution: MSE & MAE 00:03:00 Coefficient of determination 00:12:00 Root Mean Square Error 00:06:00 Practice: RMSE 00:01:00 Solution: RMSE 00:02:00 Section 07: Advanced regression & machine learning algorithms Multiple Linear Regression 00:16:00 Overfitting 00:05:00 Polynomial Regression 00:13:00 Logistic Regression 00:09:00 Decision Trees 00:21:00 Regression Trees 00:14:00 Random Forests 00:13:00 Dealing with missing data 00:10:00 Section 08: ANOVA (Analysis of Variance) ANOVA - Basics & Assumptions 00:06:00 One-way ANOVA 00:12:00 F-Distribution 00:10:00 Two-way ANOVA - Sum of Squares 00:16:00 Two-way ANOVA - F-ratio & conclusions 00:11:00 Section 09: Wrap up Wrap up 00:01:00 Assignment Assignment - Statistics & Probability for Data Science & Machine Learning 00:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 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