Step into the vibrant world of web development with our 'jQuery Masterclass Course: JavaScript and AJAX Coding Bible.' This course is crafted to guide you through the intricate functionalities of jQuery, a powerful library that simplifies JavaScript programming. Starting with an introduction that sets the foundation, the course gradually unfolds the vast capabilities of jQuery, from simple selectors to complex AJAX operations. Each section is meticulously designed to build upon your skills, making the journey from novice to jQuery expert both engaging and informative. This course isn't just about learning to code; it's about empowering you to create interactive and dynamic web applications with ease and confidence. Progress through the curriculum to master various aspects of jQuery, including working with attributes and values, handling events, and manipulating HTML/CSS. You'll delve into traversing methods, learning to navigate and manipulate the Document Object Model (DOM) efficiently. The course also sheds light on creating visually appealing web pages with jQuery effects and animations. The comprehensive section on AJAX will equip you with the skills to make asynchronous requests, enhancing the user experience of your web applications. By the end of this course, you'll not only have a solid understanding of jQuery but also the practical know-how to implement it in real-world projects. Learning Outcomes Understand the core concepts and functionalities of jQuery. Master the use of selectors for manipulating DOM elements. Gain proficiency in handling events and working with HTML/CSS in jQuery. Learn to create dynamic web content and effects using jQuery. Develop skills in AJAX for asynchronous web programming. Why choose this jQuery Masterclass Course: JavaScript and AJAX Coding Bible? 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 jQuery Masterclass Course: JavaScript and AJAX Coding Bible for? Web developers seeking to enhance their JavaScript and jQuery skills. Front-end developers aiming to create more interactive web applications. IT students and enthusiasts exploring web development technologies. Professionals transitioning to web development and programming. Anyone interested in learning jQuery for personal or professional web projects. Career path Web Developer: £25,000 - £50,000 Front-End Developer: £28,000 - £55,000 JavaScript Developer: £30,000 - £60,000 UI/UX Designer: £27,000 - £50,000 Full Stack Developer: £35,000 - £70,000 Web Application Developer: £32,000 - £65,000 Prerequisites This jQuery Masterclass Course: JavaScript and AJAX Coding Bible does not require you to have any prior qualifications or experience. You can just enrol and start learning.This jQuery Masterclass Course: JavaScript and AJAX Coding Bible 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 To This Course 00:02:00 Setup on Windows 00:03:00 Setup on Mac OS X 00:03:00 Setup on Linux 00:05:00 Online Code IDE 00:02:00 Uncompressed vs Minified vs Slim vs Slim Minified 00:05:00 Document Ready 00:03:00 Section 02 : Selectors Elements 00:03:00 All Elements 00:02:00 This Keyword 00:03:00 ID 00:02:00 Class 00:02:00 Multiple Items 00:03:00 First Element 00:02:00 Odd/Even 00:06:00 Element and Class 00:02:00 Children 00:04:00 Attributes 00:03:00 Type 00:04:00 Contains 00:03:00 Section 03 : Attributes/Values Get Attribute 00:02:00 Set Attribute 00:03:00 Set Attribute With Callback Function 00:03:00 Set Multiple Attributes 00:03:00 Remove 00:02:00 Text Attribute 00:02:00 Data Attribute 00:03:00 Value 00:03:00 HTML Value 00:02:00 Class 00:09:00 Section 04 : Events Binding & Unbinding 00:07:00 Attributes 00:04:00 Propagation 00:05:00 Prevent Default Behaviour 00:05:00 Mouse Single Click 00:02:00 Mouse Double Click 00:02:00 Mouse Enter Element 00:04:00 Mouse Leave Element 00:04:00 Mouse Hover 00:04:00 Mouse Down 00:03:00 Mouse Up 00:02:00 Keyboard Down 00:03:00 Keyboard Press 00:01:00 Keyboard Up 00:01:00 Form Submit 00:03:00 Form Change 00:03:00 Form Focus 00:04:00 Form Blur 00:02:00 Document/Window Scroll 00:03:00 Document/Window Resize 00:02:00 Combining Multiple Events Using A Single Selector 00:05:00 Section 05 : HTML/CSS Get and Set CSS Property 00:03:00 Set Multiple CSS Properties 00:02:00 Add, Remove and Toggle CSS Classes 00:06:00 Get and Set Element Dimensions 00:12:00 Adding Elements Using Append, Prepend, After and Before 00:05:00 Removing Elements Using Remove and Empty 00:06:00 Section 06 : Traversing Elements By Index 00:03:00 Child Elements 00:03:00 Parent Element 00:03:00 Sibling Elements 00:03:00 Filtering Elements 00:06:00 Section 07 : Effects Show, Hide and Toggle 00:11:00 Fading Using FadeIn, FadeOut, FadeToggle and FadeTo 00:06:00 Sliding Using SlideDown, SlideUp and SlideToggle 00:06:00 Animate 00:09:00 Stop Effects and Animations 00:03:00 Function Callback 00:03:00 Action and Method Chaining 00:05:00 Section 08: AJAX Load 00:05:00 Get JSON 00:04:00 GET Data 00:04:00 POST Data 00:05:00 Section 09 : Utility Functions Trim String 00:03:00 Extend 00:03:00 Extend Function 00:07:00 In Array 00:04:00 Each 00:03:00 Data Function 00:05:00 Proxy Function 00:03:00 Is Window Function 00:01:00 Now/Epoch Time Method 00:02:00 Number Check (isNumeric) 00:02:00 Dequeue 00:03:00 Global Evaluation 00:02:00 Section 10 : Resource Resource 00:00:00 Assignment Assignment - jQuery: JavaScript and AJAX Coding Bible 00:00:00
Overview Introducing our meticulously designed 'Addiction Therapy Diploma' course. An illuminating pathway, commencing with the fundamental understanding of drugs and their effects, progressing to the intrinsic relationship between addictions and mental health, and culminating with integrative strategies. From this course, you will gain invaluable insights into neurophysiology, the pivotal role of trauma in addiction, and the crucial tripod of support, ensuring a comprehensive grasp of this pivotal discipline. With our compelling modules, one learns not only the science but also the art of aiding those entrapped in the challenging cycle of addiction. Through our focused curriculum, ranging from the minutiae of the brain works to the broader aspects of harm minimisation, you'll be equipped to make meaningful differences in people's lives. Not only will you be enriched with knowledge, but the structured guidance of our course will also instil the confidence to navigate this complex terrain of therapy. As addiction continues to be a significant challenge globally, there's an ever-growing demand for professionals adept in this sphere. This diploma serves as both an enlightening educational experience and a stepping stone towards a fulfilling career, cementing your position in a field that necessitates compassion, understanding, and expertise. Learning Outcomes Understand the varied effects of drugs and their impact on human physiology. Identify the correlation between addictions and underlying mental health issues. Develop strategies for harm minimisation and promotion of optimal health. Acquire knowledge on the neurophysiological workings of the brain in addiction scenarios. Comprehend the trauma model and its significance in treatment methodologies. Implement brief interventions, early strategies, and comprehend the integral tripod of support. Gain an in-depth perspective on the dual diagnosis of addiction and mental health. Why buy this Addiction Therapy Diploma? 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 Addiction Therapy Diploma 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 Addiction Therapy Diploma course for? This course is ideal for Individuals aspiring to delve into the realm of addiction therapy. Health professionals aiming to expand their therapeutic toolkit. Counsellors and therapists focusing on enhancing their proficiency in addiction. Graduates in psychology or related fields exploring specialised avenues. Anyone passionate about understanding addiction and providing holistic care. Prerequisites This Addiction Therapy Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Addiction Therapy Diploma 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 Addiction Therapy Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Promotional Video Promotional 5 minute video 00:06:00 SAMHI Dual Diagnosis Intro video SAMHI Dual Diagnosis Intro video and downloadable worksheet PowerPoint slides 00:04:00 Module 1 - Drugs and Effects Module 1 - Drugs and Effects: VIDEO PART 1 (content part 1 - 4) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 2 (content part 5 - 6) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 3 (content part 7 - 8) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 4 (content part 9) 00:16:00 Module 1 - Drugs and Effects: VIDEO PART 5 (content part 10) 00:10:00 Module 1 - Drugs and Effects: VIDEO PART 6 (content 10 - 12) 00:18:00 Module 1 - Drugs and Effects: VIDEO PART 7 (content part 13) 00:13:00 Module 1 - Drugs and Effects: VIDEO PART 8 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 9 (content part 14) 00:20:00 Module 1 - Drugs and Effects: VIDEO PART 10 (content part 15 - 18) 00:19:00 Module 2 - Addictions & Mental Health Module 2 Addictions & Mental Health: VIDEO PART 1 content part 1 - 2 00:16:00 Module 2 Addictions & Mental Health: VIDEO PART 2 content part 3 - 5 00:19:00 Module 2 Addictions & Mental Health: VIDEO PART 3 content part 6 - 7 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 4 content part 00:17:00 Module 2 Addictions & Mental Health: VIDEO PART 5 content part 00:18:00 Module 2 Addictions & Mental Health: VIDEO PART 6 content part 00:20:00 Module 2 Addictions & Mental Health: VIDEO PART 7 content part 00:14:00 Module 2 Addictions & Mental Health: VIDEO PART 8 content part 00:12:00 Module 2 Addictions & Mental Health: VIDEO PART 9 content part 00:20:00 Module 3 - Harm Minimisation & Optimal Health Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 00:23:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 2 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 3 content part 00:09:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 4 content part 00:18:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 5 content part 00:17:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 1 content part 6 00:11:00 Module 3 Harm Minimisation & Optimal Health VIDEO PART 7 content part 7 00:12:00 Module 4 - Brain Works - Neurophysiology Module 4 Brain Works - Neurophysiology 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 1 content part 00:10:00 Module 4 Brain Works - Neurophysiology VIDEO PART 2 content part 00:17:00 Module 4 Brain Works - Neurophysiology VIDEO PART 3 content part 00:19:00 Module 4 Brain Works - Neurophysiology VIDEO PART 4 content part 00:16:00 Module 4 Brain Works - Neurophysiology VIDEO PART 5 content part 00:11:00 Module 5 - Trauma Model & Keys to Treatment Module 5 Trauma Model & Keys to Treatment VIDEO PART 1 content part 1 - 2a - 2f 00:20:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 2 content part 2g 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 3 content part 2h - 2i 00:15:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 4 content part 3 00:13:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 5 content part 4 00:12:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 6 content part 5 - 7 00:18:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content part 8 00:17:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 7 content partVIDEO PART 8 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 9 content part 11 00:16:00 Module 5 Trauma Model & Keys to Treatment VIDEO PART 10 content part 12 00:19:00 Module 6 - Brief & Early Intervention and Tripod of Support Module 6 Brief & Early Intervention and Tripod of Support VIDEO 1 content part 1 00:18:00 Module 6 Brief & Early Intervention and Tripod of Support VIDEO 2 content part 2 00:20:00 Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs Resources - Addiction & Mental Health (Dual Diagnosis) Integrative 12hrs 00:00:00 Assignment Assignment - Addiction Therapy Diploma 00:00:00
Embarking on a journey into the world of feline fascination? The 'Cat Care and Dog Training Course' is an all-encompassing curriculum that is crafted under the supervision of industry experts and delves deep into the unique behavioural intricacies of cats, as well as touching upon the pivotal issues related to cat health care. Whether it's understanding the complexities of inter-cat aggression or the factors contributing to feline obesity, this course brings a treasure trove of knowledge right to your fingertips. But that's not all! For those dog lovers, finding the right 'dog training near me' has never been easier. This course seamlessly integrates vital components of dog training, ensuring you are well-equipped to foster harmonious relationships with both cats and dogs alike. Learning Outcomes Analyse and address various cat behavioural issues, from scratching behaviours to excessive vocalisation. Implement strategies to combat specific cat health challenges, including diabetes and dental diseases. Employ techniques to mitigate complex cat behavioural challenges such as obsessive compulsive disorder and redirected aggression. Understand and manage health concerns such as feline cognitive dysfunction and urinary incontinence. Implement preventive health measures for cats, including understanding vaccinations like rabies and feline distemper. Discover ways to enhance the immunity of your cat for optimum health and well-being. Gain insights into foundational dog training methodologies for harmonious pet integration. Why buy this Cat Care and Dog Training 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 Cat Care and Dog Training Course you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Cat Care and Dog Training Course course for? This course is ideal for: Pet lovers aiming to gain deeper insights into cat behaviours and health issues. Individuals seeking a comprehensive understanding of both feline care and dog training. Aspiring pet trainers or carers wanting to broaden their expertise. Cat owners looking for practical solutions to common behavioural and health problems. Dog enthusiasts wanting to integrate foundational dog training knowledge into their skill set. Prerequisites This Cat Care and Dog Training 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 Feline Behavioural Specialist: £30,000 - £45,000 annually Veterinary Nurse Specialising in Cats: £21,000 - £30,000 annually Animal Welfare Officer: £20,000 - £28,000 annually Professional Dog Trainer: £25,000 - £40,000 annually Pet Care Business Owner: £30,000 - £60,000 (depending on the size and location of business) Animal Shelter Manager: £28,000 - £40,000 annually. Course Curriculum Introduction Cat Behavior Issue 1: Scratching Behavior Scratching Behavior 00:07:00 Cat Behavior Issue 2: Intercat Aggression Intercat Aggression 00:05:00 Cat Behavior Issue 3: Attention Seeking Behavior Attention Seeking Behavior 00:08:00 Cat Behavior Issue 4: Petting Induced Aggression Petting Induced Aggression 00:05:00 Cat Behavior Issue 5: Redirected Aggression Redirected Aggression 00:07:00 Cat Behavior Issue 6: Separation Anxiety Separation Anxiety 00:08:00 Cat Behavior Issue 7: Obsessive Compulsive Disorder (OCD) Obsessive Compulsive Disorder (OCD) 00:05:00 Cat Behavior Issue 8: Urine Marking Urine Marking 00:09:00 Cat Behavior Issue 9: Excessive Vocalisation Excessive Vocalisation 00:08:00 Cat Behavior Issue 10: Spilling Water Spilling Water 00:04:00 Cat Behavior Issue 11: Destructive Chewing Destructive Chewing 00:05:00 Cat Behavior Issue 12: Fear in Cats Fear in Cats 00:09:00 Cat Behavior Issue 13: Play Aggression Play Aggression 00:07:00 Cat Health Problem 1: Seizures 1.1 Seizures: Ways to Identify 00:02:00 1.2 Seizures: Causes 00:02:00 1.3 Seizures: Ways to Manage 00:02:00 1.4 Seizures: Preventive Measures 00:01:00 Cat Health Problem 2: Obesity 2.1 Obesity: Ways to Identify 00:02:00 2.2 Obesity: Health Consequences 00:01:00 2.3 Obesity: Causes 00:01:00 2.4 Obesity: Ways to Manage 00:02:00 Cat Health Problem 3: Hearing Loss 3.1 Hearing Loss: Ways to Identify 00:02:00 3.2 Hearing Loss: Causes 00:02:00 3.3 Hearing Loss: Ways to Manage 00:03:00 3.4 Hearing Loss: Preventive Measures 00:01:00 Cat Health Problem 4: Feline Cognitive Dysfunction (FCD) / Memory Loss 4.1 FCD / Memory Loss: Ways to Identify 00:05:00 4.2 FCD / Memory Loss: Causes 00:01:00 4.3 FCD / Memory Loss: Ways to Manage 00:04:00 Cat Health Problem 5: Urinary Incontinence 5.1 Urinary Incontinence: Ways to Identify 00:01:00 5.2 Urinary Incontinence: Causes 00:01:00 5.3 Urinary Incontinence: Ways to Manage 00:03:00 Cat Health Problem 6: Arthritis / Joint Pain 6.1 Arthritis / Joint Pain: Ways to Identify 00:03:00 6.2 Arthritis/ Joint Pain: Causes 00:01:00 6.3 Arthritis: Ways to Manage 00:04:00 Cat Health Problem 7: Vision Loss 7.1 Vision Loss: Ways to Identify 00:05:00 7.2 Vision Loss: Causes 00:01:00 7.3 Vision Loss: Ways to Manage 00:03:00 7.4 Vision Loss: Preventive Measures 00:01:00 Cat Health Problem 8: Diabetes 8.1 Diabetes: Ways to Identify 00:03:00 8.2 Diabetes: Ways to Manage 00:02:00 Cat Health Problem 9: Cancer 9.1 Cancer: Ways to Identify 00:02:00 9.2 Cancer: Causes 00:03:00 9.3 Cancer: Preventive Measures 00:02:00 Cat Health Problem 10: Dental Diseases 10.1 Dental Diseases: Ways to Identify 00:03:00 10.2 Dental Diseases: Preventive Measures 00:02:00 Cat Health Problem 11: Fatty Liver Disease 11.1 Fatty Liver Disease: Ways to Identify 00:02:00 11.2 Fatty Liver Disease: Causes 00:02:00 11.3 Fatty Liver Disease: Ways to Manage 00:01:00 11.4 Fatty Liver Disease: Preventive Measures 00:02:00 Cat Health Problem 12: Heart Diseases 12.1 Heart Diseases: Ways to Identify 00:02:00 12.2 Heart Diseases: Causes 00:02:00 12.3 Heart Diseases: Preventive Measures 00:01:00 Cat Health Problem 13: Hyperthyroidism 13.1 Hyperthyroidism: Ways to Identify 00:03:00 13.2 Hyperthyroidism: Causes 00:01:00 13.3 Hyperthyroidism: Ways to Manage 00:01:00 Cat Health Problem 14: Kidney Diseases 14.1 Kidney Diseases: Ways to Identify 00:02:00 14.2 Kidney Diseases: Health Consequences 00:02:00 14.3 Kidney Diseases: Causes 00:01:00 14.4 Kidney Diseases: Ways to Manage 00:02:00 Cat Health Problem 15: Lactose Intolerance 15.1 Lactose Intolerance: Ways to Identify and Causes 00:02:00 15.2 Lactose Intolerance: Ways to Manage 00:03:00 Cat Health Problem 16: Feline Distemper Disease (Vaccination) 16.1 Feline Distemper Disease: Causes 00:02:00 16.2 Feline Distemper Disease: Health Consequences 00:01:00 16.3 Feline Distemper Disease: Ways to Manage 00:01:00 16.4 Feline Distemper Disease: Preventive Measures 00:02:00 Cat Health Problem 17: Rabies 17.1 Rabies: Ways to Identify 00:03:00 17.2 Rabies: Management & Prevention 00:04:00 Conclusion: Ways to Boost Immunity of your Cat Ways to Boost Immunity of your Cat 00:03:00
Dive into the world of sustainable architecture and environmental design with the 'LEED V4 - Diploma in Building Design and Construction at QLS Level 4.' This comprehensive course, meticulously structured over eleven units, offers a deep exploration of green building principles and practices. Starting with an introductory unit that sets the stage for a transformative learning journey, the course progresses through a series of meticulously crafted modules. Each unit, from the integrative process to regional priority considerations, is designed to enhance understanding and skills in creating environmentally responsible and resource-efficient buildings. The curriculum culminates with a completion unit, ensuring learners emerge with a holistic grasp of the subject matter. The diploma not only educates but inspires, focusing on critical areas such as location and transportation, sustainable site development, water efficiency strategies, energy and atmosphere considerations, and the use of sustainable materials and resources. It also delves into the nuances of indoor environmental quality and innovative approaches to building design and construction. This course is an invaluable resource for those aspiring to make a significant impact in the building and construction industry, equipping them with the knowledge to design and construct buildings that align with the advanced standards of LEED V4. Learning Outcomes Acquire comprehensive knowledge of sustainable building practices and principles. Develop expertise in optimizing water usage and energy efficiency in construction. Gain skills in selecting and utilizing sustainable materials and resources. Understand the significance of indoor environmental quality in building design. Master innovative strategies for building design and construction with a focus on regional priorities. Why choose this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this LEED V4 - Diploma in Building Design and Construction at QLS Level 4 course for? Aspiring architects and designers keen on specializing in sustainable construction. Professionals in the construction industry aiming to enhance their eco-friendly building skills. Environmental consultants seeking to deepen their knowledge of green building practices. Urban planners interested in incorporating sustainable strategies in city designs. Project managers in the construction sector aiming to adopt LEED V4 standards. Career path Sustainable Architect: £30,000 - £50,000 Green Building Consultant: £35,000 - £55,000 Environmental Design Coordinator: £32,000 - £48,000 Urban Sustainability Planner: £28,000 - £45,000 Resource Efficiency Manager: £34,000 - £52,000 Eco-friendly Construction Project Manager: £36,000 - £60,000 Prerequisites This LEED V4 - Diploma in Building Design and Construction at QLS Level 4 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. 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 £95 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 Unit 01: Introduction Introduction 00:01:00 Getting Started 00:04:00 Minimum Program Requirements 00:07:00 Rating System Selection 00:07:00 Unit 02: Integrative Process Integrative Process 00:04:00 Integrative Project Planning and Design 00:02:00 Unit 03: Location & Transportation Overview 00:03:00 Neigbourhoud Development 00:03:00 Sensitive Land 00:02:00 Surrounding Density & Diverse Uses 00:07:00 High Priority Site 00:02:00 Access to Quality Transit 00:06:00 Bicycle Facilities 00:06:00 Reduced Parking Footprint 00:04:00 Green Vehicles 00:04:00 Unit 04: Sustainable Sites Overview 00:02:00 Construction Activity Pollution Prevention 00:03:00 Environmental Site Assessment 00:03:00 Restore or Protect Habitat 00:04:00 Open Space 00:03:00 Rainwater Management 00:03:00 Heat Island Reduction 00:04:00 Light Pollution Reduction 00:05:00 Site Master Plan 00:02:00 Tenant Design and Construction Guidelines 00:02:00 Places of Respite 00:03:00 Direct Exterior Access 00:02:00 Joint Use Facilities 00:03:00 Unit 05: Water Efficiency Overview 00:01:00 Prereq Outdoor Water Use 00:03:00 Prereq Indoor Water Use 00:04:00 Prereq Building Water Metering 00:02:00 Credit Outdoor Water Use 00:02:00 Credit Indoor Water Use 00:03:00 Cooling Tower Water use 00:03:00 Building Water Metering Credit 00:02:00 Unit 06: Energy & Atmosphere Overview 00:02:00 Fundamental Commissioning & Verification 00:04:00 Minimum Energy Performance 00:05:00 Prereq Building Level Energy Metering 00:02:00 Fundamental Refrigerant Management 00:02:00 Enhanced Commissioning 00:05:00 Minimum Energy Performance 00:04:00 Advanced Energy Metering 00:02:00 Demand Response 00:03:00 Renewable Energy Production 00:02:00 Enhanced Refrigerant Management 00:03:00 Green Powerand Carbon Offsets 00:02:00 Unit 07: Materials & Resources Overview 00:02:00 Storage and Collection of Recyclables 00:03:00 Construction and Demolition Waste Management Planning 00:02:00 Preq PBT Source Reduction - Mercury 00:03:00 Building Life Cycle Impact Reduction 00:05:00 BPDO Environmental Product Declaration 00:04:00 BPDO Sourcing of Raw Materials (2020 Update Web) 00:03:00 BPDO Material Ingredients 00:05:00 PBT Source Reduction - Mercury Credit 00:02:00 PBT Source Reduction - Lead Cadmium Copper 00:03:00 Furniture and Medical Furnishings 00:04:00 Design for Flexibilty 00:02:00 Construction and Demolition Waste Management 00:03:00 Unit 08: Indoor Environment Quality Overview 00:01:00 Min Indoor Air Quality Performance 00:06:00 Environmental Tobacco Smoke Control 00:03:00 Minimum Accoustic Performance 00:03:00 Enhanced Indoor Air Quality Strategies 00:02:00 Low Emitting Materials 00:03:00 Construction Indoor Air Quality Management Plan 00:04:00 Indoor Air Quality Assessment 00:03:00 Thermal Comfort 00:04:00 Interior Lighting 00:06:00 Daylight 00:06:00 Quality Views 00:03:00 Accoustic Performance 00:03:00 Unit 09: Innovation Innovation Credit 00:03:00 Innovation LEED AP 00:01:00 Unit 10: Regional Priority Regional Priority Overview 00:01:00 Regional Priority Credit 00:02:00 Unit 11: Completion Completion 00:01:00 Assignment Assignment - LEED V4 - Diploma in Building Design and Construction at QLS Level 4 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00
Imagine entering a realm where English prose and mathematical formulas dance together in perfect harmony, creating a tapestry of information that nourishes your mind and soul. This is what our Functional Skills Level 2 - Maths and English course promises - a symbiotic blend of numerical precision and linguistic elegance that empowers you to unlock your full potential. As you delve into the intricacies of multiplication, decimals, and grammar, you'll find yourself armed with the tools to conquer academic and professional challenges with ease. Each lesson is a stepping stone towards mastery, with expertly crafted content that makes learning feel like a thrilling adventure. The interactive lectures and practical exercises are your companions on this journey, guiding you towards a realm of clarity and confidence. No longer will you feel daunted by complex word problems or perplexed by the intricacies of sentence structure. Instead, you'll embrace them as opportunities to showcase your newfound prowess. As you emerge from this transformative experience, you'll find yourself not just proficient, but fluent in the language of Maths and English. Your enhanced skills will open doors to new opportunities, enabling you to communicate more effectively, solve problems with precision, and excel in your academic and professional pursuits. Learning Outcomes Apply multiplication techniques for digit numbers 11, 22, 33. Understand and utilise decimal and fraction conversions. Solve word problems involving ratios and proportions. Gain proficiency in basic grammar and sentence structure. Develop skills for accurate spelling and punctuation use. Understand operations on integers and rational numbers. Solve complex problems using BODMAS rules. Why Choose This 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 course for? Students aiming to enhance their Maths and English skills. Professionals seeking to improve their linguistic abilities. Individuals preparing for competitive exams. Anyone interested in expanding their academic knowledge. Individuals seeking to develop critical thinking skills. Career Path Increased eligibility for jobs requiring strong Maths and English skills. Writer or Editor Communications Specialist Data Analyst Teacher or Tutor in Maths or English Administrative or Office Professional. Salary range in the UK: £20,000 - £40,000, depending on the field and position. Certification Upon completion of the Functional Skills Level 2 - Maths and English course materials, you are eligible to take a written assignment test either during or post-course. Successfully passing the test allows you to obtain the PDF certificate for £5.99. Additionally, you may order an original hard copy certificate at an extra cost of £9.60. Prerequisites There are no prerequisites or prior qualifications required to enrol in the Functional Skills Level 2 - Maths and English course. This programme has been professionally developed to be compatible with all PCs, Macs, tablets, and smartphones. Conveniently access the course content from any location at any time, provided you have a reliable internet connection. Course Curriculum Functional Maths Training Course Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Functional skills English Introduction to the Course 00:13:00 Basics of Grammar 00:16:00 The Basics of Sentence 00:11:00 Structure of Sentence 00:19:00 Question 00:13:00 Punctuation & Capitalisation 00:24:00 Spelling 00:27:00 Common Mistakes and Ways to Improve 00:21:00
Discover the world of feline behaviour and health in our 'Cat Care' course. Gain valuable insights into common cat behaviour issues, from scratching to OCD, and learn to create a harmonious environment for your furry friend. In the second part, explore cat health problems, from seizures to kidney diseases, and master preventive care for a happy and healthy cat. Equip yourself to be a responsible cat owner and ensure your feline companion thrives. Join us on this enriching journey into the world of cat care. Learning Outcomes of Cat Care Course: Understand various cat behaviour issues and their underlying causes. Develop effective strategies to manage and modify cat behaviour problems. Recognize common cat health problems and their symptoms. Learn preventive measures to promote your cat's long-term health. Gain practical knowledge on ways to boost your cat's immunity and overall well-being. Why buy this Cat Care Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Cat Care 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. Who is this Cat Care course for? Aspiring cat owners looking to prepare for the responsibilities of cat ownership. Current cat owners seeking to better understand and manage their cat's behavior and health. Animal enthusiasts interested in expanding their knowledge of feline care. Veterinary assistants or pet caregivers aiming to enhance their skills in cat care. Anyone looking to provide the best possible care for their beloved feline companions. People already working in the relevant fields and want to polish their knowledge and skill. Career path Veterinary Technician: £18,000 - £30,000 per year Pet Behaviorist: £20,000 - £45,000 per year Animal Welfare Officer: £18,000 - £30,000 per year Pet Care Specialist: £16,000 - £25,000 per year Veterinary Nurse: £18,000 - £30,000 per year Animal Shelter Manager: £22,000 - £40,000 per year Prerequisites This Cat Care course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Cat Care 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 Introduction Course Introduction 00:02:00 Cat Behavior Issue 1: Scratching Behavior Scratching Behavior 00:07:00 Cat Behavior Issue 2: Intercat Aggression Intercat Aggression 00:05:00 Cat Behavior Issue 3: Attention Seeking Behavior Attention Seeking Behavior 00:08:00 Cat Behavior Issue 4: Petting Induced Aggression Petting Induced Aggression 00:05:00 Cat Behavior Issue 5: Redirected Aggression Redirected Aggression 00:07:00 Cat Behavior Issue 6: Separation Anxiety Separation Anxiety 00:08:00 Cat Behavior Issue 7: Obsessive Compulsive Disorder (OCD) Obsessive Compulsive Disorder (OCD) 00:05:00 Cat Behavior Issue 8: Urine Marking Urine Marking 00:09:00 Cat Behavior Issue 9: Excessive Vocalisation Excessive Vocalisation 00:08:00 Cat Behavior Issue 10: Spilling Water Spilling Water 00:04:00 Cat Behavior Issue 11: Destructive Chewing Destructive Chewing 00:05:00 Cat Behavior Issue 12: Fear in Cats Fear in Cats 00:09:00 Cat Behavior Issue 13: Play Aggression Play Aggression 00:07:00 Cat Health Problem 1: Seizures 1.1 Seizures: Ways to Identify 00:02:00 1.2 Seizures: Causes 00:02:00 1.3 Seizures: Ways to Manage 00:02:00 1.4 Seizures: Preventive Measures 00:01:00 Cat Health Problem 2: Obesity 2.1 Obesity: Ways to Identify 00:02:00 2.2 Obesity: Health Consequences 00:01:00 2.3 Obesity: Causes 00:01:00 2.4 Obesity: Ways to Manage 00:02:00 Cat Health Problem 3: Hearing Loss 3.1 Hearing Loss: Ways to Identify 00:02:00 3.2 Hearing Loss: Causes 00:02:00 3.3 Hearing Loss: Ways to Manage 00:03:00 3.4 Hearing Loss: Preventive Measures 00:01:00 Cat Health Problem 4: Feline Cognitive Dysfunction (FCD) / Memory Loss 4.1 FCD / Memory Loss: Ways to Identify 00:05:00 4.2 FCD / Memory Loss: Causes 00:01:00 4.3 FCD / Memory Loss: Ways to Manage 00:04:00 Cat Health Problem 5: Urinary Incontinence 5.1 Urinary Incontinence: Ways to Identify 00:01:00 5.2 Urinary Incontinence: Causes 00:01:00 5.3 Urinary Incontinence: Ways to Manage 00:03:00 Cat Health Problem 6: Arthritis / Joint Pain 6.1 Arthritis / Joint Pain: Ways to Identify 00:03:00 6.2 Arthritis/ Joint Pain: Causes 00:01:00 6.3 Arthritis: Ways to Manage 00:04:00 Cat Health Problem 7: Vision Loss 7.1 Vision Loss: Ways to Identify 00:05:00 7.2 Vision Loss: Causes 00:01:00 7.3 Vision Loss: Ways to Manage 00:03:00 7.4 Vision Loss: Preventive Measures 00:01:00 Cat Health Problem 8: Diabetes 8.1 Diabetes: Ways to Identify 00:03:00 8.2 Diabetes: Ways to Manage 00:02:00 Cat Health Problem 9: Cancer 9.1 Cancer: Ways to Identify 00:03:00 9.2 Cancer: Causes 00:03:00 9.3 Cancer: Preventive Measures 00:02:00 Cat Health Problem 10: Dental Diseases 10.1 Dental Diseases: Ways to Identify 00:03:00 10.2 Dental Diseases: Preventive Measures 00:02:00 Cat Health Problem 11: Fatty Liver Disease 11.1 Fatty Liver Disease: Ways to Identify 00:02:00 11.2 Fatty Liver Disease: Causes 00:02:00 11.3 Fatty Liver Disease: Ways to Manage 00:02:00 11.4 Fatty Liver Disease: Preventive Measures 00:02:00 Cat Health Problem 12: Heart Diseases 12.1 Heart Diseases: Ways to Identify 00:02:00 12.2 Heart Diseases: Causes 00:02:00 12.3 Heart Diseases: Preventive Measures 00:01:00 Cat Health Problem 13: Hyperthyroidism 13.1 Hyperthyroidism: Ways to Identify 00:03:00 13.2 Hyperthyroidism: Causes 00:01:00 13.3 Hyperthyroidism: Ways to Manage 00:01:00 Cat Health Problem 14: Kidney Diseases 14.1 Kidney Diseases: Ways to Identify 00:02:00 14.2 Kidney Diseases: Health Consequences 00:02:00 14.3 Kidney Diseases: Causes 00:01:00 14.4 Kidney Diseases: Ways to Manage 00:02:00 Cat Health Problem 15: Lactose Intolerance 15.1 Lactose Intolerance: Ways to Identify and Causes 00:02:00 15.2 Lactose Intolerance: Ways to Manage 00:03:00 Cat Health Problem 16: Feline Distemper Disease (Vaccination) 16.1 Feline Distemper Disease: Causes 00:02:00 16.3 Feline Distemper Disease: Ways to Manage 00:01:00 16.4 Feline Distemper Disease: Preventive Measures 00:02:00 Cat Health Problem 17: Rabies 17.1 Rabies: Ways to Identify 00:03:00 17.2 Rabies: Management & Prevention 00:04:00 Conclusion: Ways to Boost Immunity of your Cat Ways to Boost Immunity of your Cat 00:03:00 Assignment Assignment - Cat Care 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 Healthy Fitness 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 Healthy Fitness Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Healthy Fitness 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 Healthy Fitness 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 Healthy Fitness? 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 Healthy Fitness 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 Healthy Fitness 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 Healthy Fitness does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Healthy Fitness 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 Healthy Fitness is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: 7 Day Work Program Day 01 -Leg Blast 00:10:00 Day 02 -Upper Body 00:11:00 Day 03 -Cardio Blast 00:10:00 Day 04 -Dynamic Upper Body 00:10:00 Day 05 -Dynamic Lower Body 00:12:00 Day 06 -Core 00:09:00 Day 07 -Stretching and Isometrics 00:16:00 Section 02: Bodybuilding Tips Science of Body building 00:04:00 Debunking Myths Of Lifting 00:04:00 The Most Important Thing In Training 00:04:00 Section 03: HIT Beginning High Intensity Training 00:04:00 Foundations of HIT 00:03:00 HIT Recovery 00:04:00 HIT Workout Day One 00:04:00 HIT Diet 00:04:00 HIT Workout Day Two 00:04:00 Section 04: Hypertrophy Not All Strength is Created Equal 00:06:00 Body Weight Training 00:04:00 Gym Based Training 00:07:00 A Simple Workout You Can Do Anywhere 00:07:00 Crossfit: is it for you? 00:05:00 Stretching: Why It's So Important 00:07:00 HIIT and TABATA Explained 00:05:00 How to Hire A Personal Trainer 00:10:00 Paleo Diet Explained 00:05:00 Creating Your Own Training Program 00:06:00 Section 05: Joint Health 101 Introduction 00:01:00 The Importance Of Joint Health 00:07:00 A Look At Common Joint Problems 00:07:00 Exercise Your Joints 00:08:00 Balance Your Diet 00:08:00 Watch Your Weight 00:06:00 Home Remedies For Easing Joint Pains 00:07:00 Best Supplements For Joint Health 00:10:00 Other Options To Treat Joint Pains 00:07:00 Conclusion 00:01:00 Section 06: Workout Clips Home Fitness Man 00:02:00 Workout Aid your Recovery 00:01:00 Workout Aim past your goal 00:01:00 Workout Air Your Dirty Laundry 00:01:00 Workout Avoid Tendinitis 00:01:00 Workout Back Flys 00:01:00 Workout Back to Comfort 00:01:00 Workout Be a Lightweight 00:01:00 Workout Be an Early Bird 00:01:00 Workout Be an Energizer Bunny 00:01:00 Workout Become a Better Runner 00:01:00 Workout Bike more Efficiently 00:01:00 Workout Bike Uphill Better 00:01:00 Workout Biking 00:01:00 Workout Break out the Cash 00:01:00 Workout Breathe as You Rise 00:01:00 Workout Build Your Back 00:01:00 Workout Catch Baseballs Better 00:01:00 Workout Catch the Spiral 00:01:00 Workout Chin-Ups 00:01:00 Workout Close Grip Bench 00:01:00 Workout Close Grip Lat Pull-Down 00:01:00 Workout Count Backwards from 100 00:01:00 Workout Create Constructive Sleep Habits 00:01:00 Workout Crumple and Crush 00:01:00 Workout Crunches 00:01:00 Workout Deadlift 00:01:00 Workout Dips 00:01:00 Workout Diversify for Ultimate Success 00:01:00 Workout Do it in Parts 00:01:00 Workout Elliptical 00:01:00 Workout Exercise Bike 00:01:00 Workout Incline Dumbbell Press 00:01:00 Workout Incline Reverse Flys 00:01:00 Workout Jump Rope 00:01:00 Workout Jumping Jacks 00:01:00 Workout Knee Push-Ups 00:01:00 Workout Leg Curls 00:01:00 Workout Leg Extensions 00:01:00 Workout Leg Press 00:01:00 Workout Leg Raises 00:01:00 Workout Lower Back Raises 00:01:00 Workout Lunges 00:01:00 Workout Military Press 00:01:00 Workout Oblique Crunches 00:01:00 Workout Oblique Sit-Ups 00:01:00 Workout Overhead Triceps Extension 00:01:00 Workout Preacher Curl 00:01:00 Workout Pull-Ups 00:01:00 Workout Push-Ups 00:01:00 Workout Runner 00:01:00 Workout Running Treadmill 00:01:00 Workout Seated Row 00:01:00 Workout Shoulder Press 00:01:00 Workout Side Dumbbell Raise 00:01:00 Workout Single Arm Curl 00:01:00 Workout Sit-ups 00:01:00 Workout Squats 00:01:00 Workout Triceps Kickback 00:01:00 Workout Upright Barbell Rows 00:01:00 Workout Walking 00:01:00 Workout Wide Grip Pull-Down 00:01:00 Assignment Assignment -Healthy Fitness 2 weeks, 1 day
This ChatGPT for Marketing and Productivity with AI Tools course is your guide to using AI to boost your marketing results. Boost your marketing skills and productivity to the next level with our comprehensive ChatGPT for Marketing and Productivity with AI Tools course. Dive deep into the world of Artificial Intelligence (AI), its applications, and how it can revolutionise the way you work. This course is meticulously designed to empower marketing professionals, content creators, entrepreneurs, and anyone intrigued by the power of AI. It's a blend of theoretical understanding, practical exposure, and foresight into the future of AI, particularly in the field of marketing and productivity. In Section 01, we unpack the 'AI Marketing Playbook'. Starting with an introduction to OpenAI's ChatGPT, its possibilities, and its limitations, you'll gain a fundamental understanding of AI capabilities. Following this, delve into practical aspects of using ChatGPT, from generating innovative ideas and content to cross-posting queries and simplifying complex information. Our experts will also guide you on how to leverage AI for business problem-solving and developing methodologies, wrapping up with insights on the future of ChatGPT. In Section 02 get teaching on how to use ChatGPT and other AI tools for effective marketing. Learn to work with Autonomous AI Agents and a variety of AI tools such as Durable, Eightify, Genei, and Ellicit, to name a few. By the end of this section, you'll be equipped with the skills to carry out high-quality research, build AI-based websites, determine research credibility, and clone voices. You'll also get an interesting perspective on the future of AI. Finally, Section 03 is all about enhancing your productivity with ChatGPT and AI tools. From meta-search sites to speech-to-text services, AI design tools, content improvement techniques, and more, this section aims to streamline your work processes. Learn to use tools like Microsoft Bing Search, Google Bard, Speechify, and Adobe for audio enhancements. Wrap up this course with an exploration of generative AI and a glance into the future of this exciting field. Whether you're a beginner or an experienced professional, this course promises to expand your horizons and make you proficient in harnessing AI's power for marketing and productivity. Unleash the potential of AI and transform your work efficiency with this ChatGPT for Marketing and Productivity with AI Tools course. Enrol today and start your AI journey with us! Learning Outcomes Upon completion of the ChatGPT for Marketing course, you will be able to: Understand the fundamentals of OpenAI's ChatGPT and its capabilities. Generate and qualify ideas effectively using ChatGPT. Learn to apply ChatGPT for solving specific business problems. Develop skills to connect with various Autonomous AI Agents. Learn to use AI tools for enhanced research and content creation. Understand how to determine research credibility using AI. Gain proficiency in utilising AI for website creation and voice cloning. Develop skills to leverage AI tools for improved productivity. Understand the future scope of generative AI in marketing. Master the use of various AI design and content improvement tools. Who is this course for? This ChatGPT for Marketing course is ideal for: Marketing professionals seeking to leverage AI in their strategies. Content creators interested in AI-powered idea generation and curation. Business owners looking to integrate AI into their operational processes. Individuals interested in exploring AI applications in marketing and productivity. Any tech enthusiast keen on understanding and applying AI tools. Career Path Our ChatGPT for Marketing course will help you to pursue a range of career paths, such as: AI Marketing Specialist: £45,000 - £70,000 Content Strategist: £35,000 - £55,000 Business Intelligence Analyst: £40,000 - £65,000 Productivity Consultant: £45,000 - £75,000 AI Research Analyst: £50,000 - £80,000 AI Application Developer: £55,000 - £90,000 Digital Transformation Consultant: £60,000 - £100,000 AI Solutions Architect: £65,000 - £110,000 Prerequisites This Photoshop Training for Beginners does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Photoshop Training for Beginners 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 of the Photoshop Training for Beginners 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. Course Curriculum Section 01: The AI Marketing Playbook Unit 01: Start an Account with ChatGPT 00:02:00 Unit 02: What the Company OpenAI Say About Itself 00:02:00 Unit 03: What OpenAI Say About The Limitations of the Chatbot 00:02:00 Unit 04: Chatbot Prompt Examples Given By Open AI 00:02:00 Unit 05: Will Chat GPT Be a Paid Application 00:01:00 Unit 06: Chat GPT Idea Generation 00:02:00 Unit 07: Chat GPT - Idea Qualification and Accuracy 00:03:00 Unit 08: ChatGPT - Accuracy and Citations 00:02:00 Unit 09: Chat GPT - Creating HTML Instances 00:01:00 Unit 10: Chat GPT - How to Solve Specific Business Problems 00:02:00 Unit 11: Chat GPT - Statistical Verification of Information 00:01:00 Unit 12: Chat GPT - Rewrite Content for Different Contexts 00:02:00 Unit 13: ChatGPT - Content Checked With AI 00:02:00 Unit 14: ChatGPT - Simplifying Information 00:01:00 Unit 15: ChatGPT - How to Ask the Chatbot about Context 00:01:00 Unit 16: ChatGPT - How to Cross-Post Queries 00:01:00 Unit 17: ChatGPT - How to Narrow Down the Context of Your Query 00:02:00 Unit 18: ChatGPT - How to Solve a Business Process 00:02:00 Unit 19: ChatGPT - Developing a Methodology From Experts 00:01:00 Unit 20: The Future of ChatGPT 00:01:00 Section 02: How to Use ChatGPT and AI for Marketing Unit 01: Autonous AI Agents 00:01:00 Unit 02: Connecting to Open AI 00:01:00 Unit 03: Getting an OpenAI Key 00:01:00 Unit 04: Agent GPT - Autonomous AI 00:02:00 Unit 05: GoalGPT - Autonomous Agents 00:01:00 Unit 06: Cognosis - Autonomous AI 00:02:00 Unit 07: Aomni - Autonomous Agent 00:01:00 Unit 08: Durable - Build a Website with AI 00:01:00 Unit 09: Eightify Summaries 00:02:00 Unit 10: Genei - Do Higher Quality Research with AI 00:01:00 Unit 11: Ellicit - Do Higher Quality Research with AI 00:01:00 Unit 12: Inciteful - Do Higher Quality Research with AI 00:02:00 Unit 13: SciteAI Determine the Credibility of Your Research 00:01:00 Unit 14: Eleven Labs - Voice Cloning 00:02:00 Unit 15: AgentGPT - Wrap Up and Return 00:01:00 Unit 16: Cognosys - Wrap Up and Return 00:01:00 Unit 17: Aomni - Wrap Up and Return 00:01:00 Unit 18: Goal GPT - Wrap Up and Return 00:01:00 Unit 19: Uploading Research Reports to Summarization Applications 00:01:00 Unit 20: Perspective on The Future of AI 00:01:00 Section 03: Productivity with AI Tools Unit 01: Meta Search Sites 00:02:00 Unit 02: SMMRY for Summarzing 00:01:00 Unit 03: ChatGPT Plugins Waitlist 00:01:00 Unit 04: Using Microsoft Bing Search 00:02:00 Unit 05: Using Google Bard 00:01:00 Unit 06: Microsoft Word Speech To Text 00:01:00 Unit 07: Transcribe Audio in Microsoft Word 00:02:00 Unit 08: Speechify 00:02:00 Unit 09: Exact Image Creation 00:01:00 Unit 10: AI Design Tools 00:02:00 Unit 11: Learn How to Prompt 00:01:00 Unit 12: Content Improvement 00:01:00 Unit 13: Idea Generation 00:01:00 Unit 14: Audio Enhancement with Adobe 00:02:00 Unit 15: Clean up Audio With Cleaanvoice 00:01:00 Unit 16: Notion-AI 00:01:00 Unit 17: Pictory 00:01:00 Unit 18: Lex 00:01:00 Unit 19: ChatPDF 00:01:00 Unit 20: Conclusion and the Future of Generatie AI - Searchie 00:01:00
Gain full proficiency in Microsoft Office and add a brand new qualification to your CV! The Microsoft Office course is the ultimate training bundle package for Microsoft Office, taking you from beginner to expert in no time. You will learn how to perform a wide range of administrative tasks which will equip you with the most in-demand skills needed to work in an office-based role. This course is a step-by-step instructor-guided course, taking you through key procedures, best practices and shortcuts. Master Microsoft Office in only one week and take your career to the next level! Learning Outcomes Attain mastery in navigating and utilising Excel 2016 for computations, formatting, and workbook management. Develop advanced word processing abilities in Word 2016, from basic formatting to publishing. Craft engaging presentations in PowerPoint 2016, integrating various media and graphics. Gain expertise in data management through Access 2016, including data modification and report generation. Enhance overall productivity by understanding and implementing Microsoft Office's efficient features. Why choose this Microsoft Office course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Microsoft Office course 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. Who is this Microsoft Office course for? Individuals aiming to bolster their digital productivity skills. Professionals looking to advance their documentation and presentation prowess. Data enthusiasts wanting to harness Excel's computational capabilities. Students seeking comprehensive knowledge in Microsoft tools. Administrative staff aiming for streamlined data management. Career path Data Analyst: £25,000 - £40,000 Administrative Assistant: £18,000 - £28,000 Presentation Designer: £23,000 - £35,000 Document Controller: £22,000 - £38,000 Office Manager: £25,000 - £45,000 Database Administrator: £30,000 - £50,000 Prerequisites This Microsoft Office course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Office 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 Excel 2016 Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interfact 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:07:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Word 2016 Getting Started with Word Navigate in Microsoft Word 00:12:00 Create and Save Word Documents 00:24:00 Manage Your Workspace 00:06:00 Edit Documents 00:16:00 Preview and Print Documents 00:04:00 Customize the Word Environment 00:08:00 Formatting Text and Paragraphs Apply Character Formatting 00:17:00 Control Paragraph Layout 00:19:00 Align Text Using Tabs 00:07:00 Display Text in Bulleted or Numbered Lists 00:03:00 Apply Borders and Shading 00:05:00 Working More Efficiently Make Repetitive Edits 00:06:00 Apply Repetitive Formatting 00:10:00 Use Styles to Streamline Repetitive Formatting Tasks 00:14:00 Managing Lists Sort a List 00:05:00 Format a List 00:06:00 Adding Tables Insert a Table 00:07:00 Modify a Table 00:06:00 Format a Table 00:03:00 Convert Text to a Table 00:04:00 Inserting Graphic Objects Insert Symbols and Special Characters 00:04:00 Add Images to a Document 00:11:00 Controlling Page Appearance Apply a Page Border and Color 00:03:00 Add Headers and Footers 00:06:00 Control Page Layout 00:05:00 Add a Watermark 00:04:00 Preparing to Publish a Document Check Spelling Grammar and Readability 00:07:00 Use Research Tools 00:06:00 Check Accessibility 00:03:00 Save a Document to Other Formats 00:04:00 Workbooks - Microsoft Word 2016 (Beginner) Workbooks - Microsoft Word 2016 (Beginner) 00:00:00 PowerPoint 2016 PowerPoint Interface Navigate the PowerPoint Environment 00:28:00 View and Navigate a Presentation 00:15:00 Create and Save a PowerPoint Presentation 00:13:00 Use PowerPoint Help 00:10:00 Presentation Basics Select a Presentation Type 00:08:00 Edit Text 00:13:00 Build a Presentation 00:27:00 Formatting Format Characters 00:11:00 Format Paragraphs 00:16:00 Format Text Boxes 00:09:00 Inserting Options Insert Images 00:10:00 Insert Shapes 00:15:00 Working with Objects Edit Objects 00:16:00 Format Objects 00:06:00 Group Objects 00:04:00 Arrange Objects 00:07:00 Animate Objects 00:07:00 Table Create a Table 00:09:00 Create a Table 00:09:00 Insert a Table from Other Microsoft Office Applications 00:06:00 Charts Create a Chart 00:10:00 Format a Chart 00:10:00 Insert a Chart from Microsoft Excel 00:05:00 Review and Presentatin Review Your Presentation 00:11:00 Apply Transitions 00:05:00 Print Your Presentation 00:05:00 Deliver Your Presentation 00:08:00 Access 2016 Introduction to Access Orientation to Microsoft Access1 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Data Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Working with Queries Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Access Forms Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Working with Reports Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12: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