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

2283 Courses in Cardiff delivered Online

Functional Skills Level 2 - Maths and English

4.5(3)

By Studyhub UK

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

Functional Skills Level 2 - Maths and English
Delivered Online On Demand9 hours 20 minutes
£10.99

Complete AutoLISP Programming

4.5(3)

By Studyhub UK

Embark on a transformative journey into the realm of AutoLISP programming with our comprehensive course titled 'Complete AutoLISP Programming.' Crafted with precision and expertise, this course is not just a curriculum; it's a key to unlocking a world of possibilities within AutoCAD customization. Imagine seamlessly creating macros for essential commands, mastering AutoLISP rules, variables, math functions, list functions, user input functions, object handling functions, selection sets, conditionals, and delving into the intricacies of AutoCAD objects and data models. Authored by industry experts, this course goes beyond the basics, providing a Quick Win Demo and hands-on projects that reinforce your newfound skills. Learning Outcomes Develop a deep understanding of AutoLISP programming rules, enabling you to create efficient and customized AutoCAD commands. Master the application of AutoLISP variables in real-world programming scenarios, honing your skills through practical exercises. Acquire proficiency in AutoLISP math functions, empowering you to perform complex mathematical operations seamlessly within AutoCAD. Unlock the potential of AutoLISP's list functions, gaining the ability to manipulate lists for enhanced program functionality. Explore AutoLISP's user input functions, object handling functions, and delve into the intricacies of conditionals and equality functions. Why choose this Complete AutoLISP Programming 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 The Complete AutoLISP Programming course for? CAD enthusiasts and draftsmen seeking to elevate their AutoCAD customization skills. Architects aiming to streamline and enhance their design processes. Engineers looking to automate repetitive tasks and boost productivity. Students and professionals in the fields of architecture, engineering, and design. Anyone with a passion for programming and a desire to delve into the world of AutoCAD customization. Career path AutoCAD Programmer: £35,000 - £45,000 CAD Automation Specialist: £40,000 - £50,000 Architectural Technologist: £30,000 - £40,000 Engineering Design Consultant: £35,000 - £45,000 BIM Specialist: £40,000 - £50,000 Project Manager (CAD): £45,000 - £55,000 Prerequisites This Complete AutoLISP Programming does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Complete AutoLISP Programming 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 Unit 01: Introduction Module 01: Introduction 00:01:00 Module 02: Course Outline 00:05:00 Module 03: Introduction to AutoLISP 00:02:00 Module 04: Who is this Course for? 00:02:00 Module 05: What will I Learn? 00:01:00 Module 06: About the Author 00:02:00 Module 07: Why Learn AutoLISP? 00:02:00 Module 08: Tools 00:04:00 Unit 02: Quick Win Demo Module 01: Create Zoom Command Macros 00:13:00 Module 02: Create Layer Command Macros 00:10:00 Module 03: Create Insert Command Macros 00:07:00 Module 04: Create Audit Commands 00:06:00 Unit 03: AutoLISP Rules Module 01: AutoLISP Rules 00:05:00 Unit 04: AutoLISP Variables Module 01: Understanding AutoLISP Variables 00:05:00 Module 02: Using Variables in a Real World Program - Part 1 00:08:00 Module 03: Using Variables in a Real World Program - Part 2 00:08:00 Module 04: Using Variables in a Real World Program - Part 3 00:05:00 Module 05: Using Variables in a Real World Program - Part 4 00:07:00 Unit 05: AutoLISP Math Functions Module 01: Math Functions in Theory 00:06:00 Module 02: Math Functions by Example 00:15:00 Unit 06: AutoLISP's List Functions Module 01: List Functions Theory - Part 1 00:06:00 Module 02: CAR Function - Demo 00:02:00 Module 03: CDR Function - Demo 00:02:00 Module 04: CADR Function - Demo 00:02:00 Module 05: CADDR Function - Demo 00:02:00 Module 06: CAAR Function - Demo 00:02:00 Module 07: CDDR Function - Demo 00:01:00 Module 08: List Functions Theory - Part 2 00:05:00 Module 09: list Function - Demo 00:01:00 Module 10: cons Function - Demo 00:02:00 Module 11: nth Function - Demo 00:01:00 Module 12: Foreach Function - Demo 00:04:00 Module 13: List Functions Theory - Part 3 00:05:00 Module 14: Assoc Function - Demo 00:04:00 Module 15: Subst Function - Demo 00:06:00 Module 16: Last Function - Demo 00:02:00 Module 17: Reverse Function - Demo 00:02:00 Unit 07: AutoLISP's User Input Functions Module 01: User Input Functions Theory - Part 1 00:05:00 Module 02: User Input Functions Theory - Part 2 00:04:00 Module 03: GetPoint Function - Demo 00:02:00 Module 04: GetInt Function - Demo 00:03:00 Module 05: GetString Function - Demo 00:04:00 Module 06: GetReal Function - Demo 00:02:00 Module 07: GetDist Function - Demo 00:04:00 Module 08: GetCorner Function - Demo 00:04:00 Module 09: GetAngle Function - Demo 00:10:00 Module 10: GetKword Function - Demo 00:05:00 Unit 08: Object Handling Functions Module 01: Object Handling Functions - Theory 00:04:00 Module 02: Entsel Function - Demo 00:03:00 Module 03: Entnext Function - Demo 00:03:00 Module 04: Entlast Function - Demo 00:02:00 Module 05: Entget Function - Demo 00:04:00 Module 06: Object Handling Functions - Exercises 00:02:00 Module 07: Object Handling Functions - Solutions to Exercises 00:06:00 Unit 09: AutoLISP's Selection Sets Module 01: Selection Sets - Theory 00:08:00 Module 02: Ssget Function - Demo 00:11:00 Module 03: Ssadd Function - Demo 00:05:00 Module 04: Ssdel Function - Demo 00:03:00 Module 05: Ssmemb Function - Demo 00:03:00 Module 06: Ssname Function - Demo 00:03:00 Module 07: Sslength Function - Demo 00:05:00 Module 08: Selection Sets - Exercises 00:04:00 Module 09: Selection Sets - Solutions to Exercises 00:13:00 Unit 10: Conditionals And Equality Functions Module 01: Using If and Progn Statements 00:05:00 Module 02: Using While and EQ Functions 00:05:00 Module 03: Using Cond and And Functions 00:04:00 Unit 11: AutoCAD Objects - Data Model Module 01: AutoCAD Objects: Re-examined (Part 1) 00:04:00 Module 02: AutoCAD Objects: Re-examined (Part 2) 00:05:00 Module 03: Line Object: Re-examined (Demo) 00:05:00 Module 04: Circle Object: Re-examined (Demo) 00:04:00 Module 05: Text Object: Re-examined (Demo) 00:08:00 Module 06: Dimension Object: Re-examined (Demo) 00:11:00 Module 07: Block/Attribute Object: Re-examined (Demo) 00:28:00 Unit 12: Symbol Table And Dictionary Handling Functions Module 01: Symbol Table and Dictionary-Handling Functions - Theory 00:05:00 Module 02: Tblsearch - Demo 00:13:00 Module 03: Tblnext - Demo 00:09:00 Unit 13: Hands-On Projects Module 01: CDIM - Project 00:12:00 Module 02: CHSTYLE - Project 00:16:00 Module 03: EXTATTR - Hands-On Project 00:26:00 Unit 14: Conclusion Module 01: Conclusion Message and Thank you! 00:01:00

Complete AutoLISP Programming
Delivered Online On Demand7 hours 26 minutes
£10.99

Life Coaching Course Online

By Lead Academy

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This life coaching course will help you to learn powerful coaching techniques, effective communication skills and transformative strategies to help people thrive in all aspects of life. With this course, you will become a certified life coach, equipped to make a positive impact on the lives of others. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand Life coaching fundamentals such as listening template, questioning, trust checklist, and more Learn various coaching models such as GROW Model, STEPPA Model etc. Understand different coaching steps such as goal setting, reality, options and obstacles, Will and Action Planning Learn how to structure your coaching sessions Discover the relationship between the client and the coach Know advanced coaching strategies such as managing emotional states or personal SWOT analysis Get acquainted with diet and nutrition fundamentals Understand exercise coaching such as cardio or resistance training Why Life Coaching Course right for you? The life coaching course online will give you a basic overview of coaching fundamentals, a listening introduction, three kinds of listening as a coach, and your listening template. You will learn the difference between coaching and standard questions and types of coaching questions. This extensive course will teach you advanced coaching strategies and introduce the concept of trust. You will explore different personality models such as the Big Five personality model, Myers Briggs personality model and steps to identify your personality model. By the end of the course, you will gain life coaching skills and theoretical knowledge on coaching fundamentals, models, personality models, and methods to structure your coaching sessions. Life Coaching Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction What You Will Learn Get To Know Your Instructor Part 1 : Life Coaching Certification What Is Life Coaching The Benefits Of Becoming A Life Coach The Difference Between Coaching, Therapy, Mentoring & Training The Responsibilities Of A Life Coach Coaching Fundamentals Coaching Fundamentals Overview Listening Introduction The 3 Kinds Of Listening As A Coach Your Listening Template Questioning Introduction Questioning & Coaching How Coaching Questions Are Different From Normal Questions The Different Types Of Coaching Questions Questions Summary Building Trust Introduction The Trust Checklist Exercise How To Build Trust As A Coach More Trust Building Strategies Understanding Personalities Understanding Personalities Overview Big Five Personality Model Myers Briggs Personality Model Your Personality Model How To Bring Out Your Strengths With This Model. Coaching Models Explained Coaching Models Introduction GROW Model Explained STEPPPA Model Explained FUEL Model Explained CLEAR Model Explained Why We Will Use The GROW Model Coaching Step 1: Goal Setting Step 1 Introduction Why Defining Your Values Is Important. How To Define Your Personal Values. What Does Your Ideal Life Look Like. The 4 Biggest Goal Setting Mistakes To Avoid Stretch Goals Explained Why You Should Start With Long Term Goals. Setting Your First Long Term Goal Turning Long Term Goals Into Short Term Goals Next Steps Coaching Step 2: Reality Step 2 Introduction Status Quo Explained Wheel Of Life Excercise Explained Big Rocks Exercise Explained Coaching Example Step 2 Coaching Step 3: Option & Obstacles Step 3 Introduction How To Brainstorm With Your Client(s). How To Evaluate Your Brainstorming Ideas. 'Spheres Of Influence' Excerise Explained 'Not To Do List' Exercise Explained Coaching Example Step 3 Coaching Step 4: Will & Action Planning Step 4 Introduction The 80/20 Rule Applied To Coaching How To Design An Action Plan Coaching Example Step 4 GROW Model Recap How To Structure Your Coaching Sessions. Structuring Your Sessions Introduction How To Define Your Coaching Ground Rules. How Much Should You Charge. The Pre Coaching Call Your First Coaching Session Progress Evaluation Sessions My Recommended Coaching Timeline Clint Coach Relationship Client Coach Relationship Intro What Clients Expect From Their Coaches. Why Clients Choose One Coach Over Another. Client Coach Boundaries How To Retain Clients Long Term. Advanced Coaching Strategies Advanced Coaching Strategies Introduction Reframing Explained Managing Emotional States Understanding Representational Systems Personal SWOT Analysis Johari Window - Developing Self Awareness Giving Good Feedback As A Coach Part 2: Holistic Health Coaching Certification Part 2 Introduction What It Means To Be Healthy What Does A Health Coach Do. How Can You Combine Life Coaching & Health Coaching. Diet & Nutrition Fundamentals Diet Introduction Your Health & Diet: How They Are Linked The Consequences Of Following A Bad Diet How To Eat For Longevity What Are Calories? Explained The Relationship Between Bodyweight And Health Calories & Bodyweight In A Healthy Diet The Surprising Results Of The Twinkie Diet The Relationship Between Weight Loss And Health Calculating Your Total Daily Calories Healthy Weight Ranges The Best Foods For A Healthier Life Best Protein Foods Best Carbohydrate Foods Best Dietary Fat Foods How Much Of Each (Protein, Carbs, Fat). Diet & Nutrition Coaching Client Assessment Introduction Client Interview How To Create A Diet Plan For Clients. Calculating BMI Exercise Coaching: Cardio Cardio Introduction The Different Types Of Cardio How To Monitor Your Heart Rate During A Workout. Cardio vs Weigh Training - Which Is Better For Weight Loss Exercise Coaching: Resistance Training Weight Training Introduction Muscle Building Formula The Science Behind Muscle Growth Weight Training vs Bodyweight Training How To Create A Beginner Workout Plan 5 Most Important Aspects Of Lifting Form Progressive Overload Hormone Health Explained Hormones Introduction The 3 Types Of Hormones The Endocrine System Explained Hormones & Heart Disease Anabolic Steroids: Why They Are So Dangerous Most Important Hormones Overview Insulin Glucagon Adrenaline Cortisol Ghrelin Leptin Thyroid Hormones Estrogen Growth Hormone Testosterone Supplements How To Build Your Own Supplement Stack Top 3 Beginner Supplements For Muscle Growth The Best Supplements To Boost Immunity The Best Supplements For Vegans & Vegetarians The Best Supplements For Joint & Bone Health The Best Supplements For Fat Loss Health & Fitness Motivation Health & Fitness Motivation Introduction The Role Of Stress In Motivation The Motivation Problem How To Build Willpower 8 Steps To Building Fitness Discipline How To Get Out Of A Workout Rut. More Tips To Stay Motivated Health & Fitness FAQ Answered What Is Nutrient Density. Is Brown Sugar Better Than White Sugar. What Should You Train On Your First Day At The Gym. Fresh vs Frozen Food: Which Is Healthier Part 3: Wellness Coaching Certification Part 3 Introduction Steers Management The Difference Between Stress & Anxiety Short vs Long Term Stress The Effects Of Stress & Anxiety On Your Body Proven Stress Management Strategies & Techniques The Benefits Of Calm Breathing Breathing Exercise #1 - Three Part Breath Breathing Exercise #2 - Bellows Breath Progressive Muscle Relaxation Complete PMR Routine Sleep Sleeping For A Longer Life Tips To Fall Asleep Faster Supplements For Improved Sleep Emotional Self Care What Is Emotional Self Care How To Accept Yourself. Taming Your Inner Critic Getting A Different Perspective Acknowledging Your Qualities Getting Rid Of Time-Consuming Commitments How To Say 'No' To Others. Who should take this course? This online course is suitable for those who want to pursue a career in life coaching or anyone interested in learning life coaching and various coaching models in general. Entry Requirements There are no academic entry requirements for this Life Coaching course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This life coaching online course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Life Coaching Course Online
Delivered Online On Demand
£25

Real Estate Agent

4.5(3)

By Studyhub UK

Guarantee a successful career in real estate with the Real Estate Agent course training programme! Through this course, you will learn how the real estate industry works and will gain the most up-to-date skills to start building your property portfolio. Not only that, but you will gain the interpersonal skills and business skills needed to launch your career successfully and stand out from the competition. Gain an industry-recognised qualification to fast track your career and learn best practises from this best-selling bundle training program. This course is the perfect stepping stone to a successful career as an Estate Agent. Learning Outcomes Navigate the roles and responsibilities of estate agents across various sectors. Cultivate a robust method for listing and valuing properties effectively. Enhance negotiation techniques to become a formidable advocate for clients. Implement strategic time management and productivity amplifying methods. Invest in property with acumen and build a diverse, profitable portfolio. Why choose this Real Estate Agent 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 Real Estate Agent course for? Novices with aspirations to penetrate the real estate industry. Seasoned professionals aiming to refresh and expand their expertise. Investors looking to enrich their knowledge of real estate transactions. Individuals pursuing skills in property portfolio expansion. Professionals desiring to elevate their persuasive communication abilities. Career path Estate Agent: £18,000 - £30,000 Property Manager: £20,000 - £35,000 Real Estate Investment Analyst: £25,000 - £55,000 Portfolio Manager: £40,000 - £70,000 Lettings Negotiator: £15,000 - £25,000 Real Estate Developer: £30,000 - £70,000+ Prerequisites This Real Estate Agent does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Real Estate Agent 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 ***Estate Agent Diploma*** Introduction to the Course Introduction to the Course - Estate Agent 00:03:00 Module 01 - Estate Agent: An Introduction Estate Agent: An Introduction 00:24:00 Module 02 - Different Types of Estate Agents Different Types of Estate Agents 00:18:00 Module 03 - Getting Started on the Job Getting Started on the Job 00:19:00 Module 04 - Listing Property: Finding the Sellers Listing Property: Finding the Sellers 00:27:00 Module 05 - Valuation Process Valuation Process 00:24:00 Module 06 - Negotiating as Estate Agent Negotiating as Estate Agent 00:15:00 Module 07 - Selling Property: Finding the Buyers Selling Property: Finding the Buyers 00:26:00 Module 08 - Letting Property Letting Property 00:34:00 Module 09 - Technology for Estate Agents Technology for Estate Agents 00:24:00 Module 10 - Regulation of Estate Agents Regulation of Estate Agents 00:16:00 Final Recap Final Recap to the Course 00:00:00 ***Time Management & Productivity Training in Real Estate*** Introduction Meet Your Instructor 00:02:00 Why Shawn as Your Instructor? - Personal Success Story 00:04:00 Roadmap to Do More Deals in Less Time 00:01:00 Time Management Trough Tempo Methodology What is Tempo Methodology? 00:02:00 The First Step to BOOSTING Productivity 00:08:00 Personal Strategy Assessment Time! 00:08:00 How to Make the Necessary Changes 00:05:00 Developing a SUCCESSFUL Game-plan 00:05:00 It's Go Time.. 00:02:00 The Tempo Methodology Machine 00:03:00 Productivity Killers - How to MINIMIZE Avoiding Your Email Inbox Nightmare 00:06:00 SILENT but DEADLY Productivity Killers 00:06:00 What are Electives? How Do We Stop Them 00:04:00 Mind Blowing Social Media Trends 00:04:00 Productivity Boosters - How to MAXIMIZE Step 1 is Always NUKE IT 00:04:00 Mastering the Art of Goal Setting 00:07:00 Prioritize - Prioritize - PRIORITIZE 00:05:00 Mini Strategies for Success! 00:04:00 Return on Time Invested (ROTI) 00:04:00 Exponentially AMPLIFY Your Time How to Manage 1,000 Clients w/ 1 Click 00:08:00 Simple Tip for Staying Focused 00:06:00 How to Wake Up Every Day Ready to Succeed 00:07:00 Simple Technique to Sleep FASTER & Feel BETTER 00:05:00 How to Increase Efficiency by 300% 00:08:00 Conclusion My Thanks to You 00:03:00 Bonus What's Next? (BONUS) 00:02:00 ***Real Estate Investment Training*** Introduction Introduction Super Real Estate Investing 00:11:00 Why Real Estate Continues to Be the Best Investment for Most People 00:13:00 Getting Amazing Deals on Properties How to buy houses for super cheap 00:21:00 How to use direct marketing to reach motivated sellers 00:16:00 How to Finance Real Estate Deals Secrets to financing all kinds of deals 00:17:00 Understanding Hard Money 00:07:00 More Hard Money Examples 00:11:00 How to Execute Effective Exit Strategies The best exit strategies in real estate 00:14:00 Secrets to wholesaling properties to other investors 00:14:00 Secrets to rehabbing the property and maximizing profit 00:07:00 Making Money with Tax Lien Certificates and Deeds Secrets to buying tax lien certificates and tax deeds 00:09:00 Building Wealth and Passive Income Through Rental Properties Buying and renting for maximum passive income 00:16:00 REI Secrets, Tips, and Tricks 00:13:00 More REI Secrets, Tips, and Tricks 00:11:00 Even more REI Secrets, Tips, and Tricks 00:09:00 Conclusion Conclusion Super Real Estate 00:06:00 ***Portfolio Building for Property*** Module: 01 Introduction 00:07:00 The answer is Property 00:05:00 Mortgage Types 00:06:00 Negative Mind Chatter 00:08:00 Module: 02 Steps in the Plan 00:06:00 Property Types 00:02:00 Set it up and Forget about it 00:07:00 Raising the Capital 00:16:00 Watch Your Cashflow 00:08:00 Look at the costs 00:09:00 Module: 03 Portfolio building strategy 00:13:00 Historic Property Cycles 00:07:00 Make your portfolio grow faster 00:08:00 Ways to Create Income 00:02:00 Understanding Inflation 00:03:00 ***Persuasion and Influencing Skills*** What Is Influence & Why is It Important! 00:06:00 The Power To influence - Beginning Concepts 00:13:00 The 6 Master Principles Of Persuasion - Part 1 00:15:00 The 6 Master Principles Of Persuasion - Part 2 00:16:00 The MUST Have Persuasion Tool! 00:09:00 Emotional Reasoning 00:06:00 MORE Powerful Tools Of Persuasion 00:17:00 Rapport Building & Reputation - Part 1 00:11:00 Rapport Building & Reputation - Part 2 00:16:00 Powerful Tools Of Persuasion - Part 1 00:13:00 Powerful Tools Of Persuasion - Part 2 00:12:00 Powerful Tools Of Persuasion - Part 3 00:15:00 Mock Exam Mock Exam - Real Estate Agent 00:20:00 Final Exam Final Exam - Real Estate Agent 00:20:00

Real Estate Agent
Delivered Online On Demand14 hours 4 minutes
£10.99

Award in Functional Skills Maths at QLS Level 2

4.5(3)

By Studyhub UK

Step into the captivating world of Functional Skills Maths Level 2, a course that transcends mere numbers. It's not just about equations; it's about empowering you to conquer challenges and infuse confidence into your every step. Imagine a world where percentages aren't daunting but doors opening to financial empowerment.    Functional Skills Maths Level 2 equips learners with essential mathematical competencies. This course addresses real-world challenges, empowering individuals to navigate daily life, business, and further education with confidence. Proficiency in BODMAS, decimals, ratios, and more provides tangible benefits, fostering problem-solving and decision-making skills. Students gain a competitive edge in personal and professional spheres, improving their prospects and contributing to a numerically literate society.   By mastering concepts like percentages and unitary methods, learners enhance their financial acumen, crucial for managing personal finances or pursuing business ventures. This course is a gateway to unlocking opportunities, and fostering a deeper understanding of mathematical applications in diverse contexts. The practical skills acquired are invaluable for achieving academic success, career advancement, and overall personal development.   Learning Outcomes Apply rules of BODMAS for accurate mathematical simplification. Demonstrate proficiency in working with integers and directed numbers. Master calculations involving decimals, percentages, and scientific notation. Analyse and solve problems related to profit, loss, discount, and tax. Utilise unitary methods in practical applications and problem-solving scenarios. Understand and apply concepts of ratio, proportion, and fractions effectively. Successfully estimate and approximate numerical values in real-world situations. Comprehend the principles of factors, multiples, and their mathematical relationships. Apply mathematical skills to solve mock and final exam questions effectively.   Who is this Award in Functional Skills Maths at QLS Level 2 Course For? Individuals seeking practical math skills for daily life. Students aiming for academic success and confidence in mathematics. Professionals looking to enhance their financial literacy. Entrepreneurs and business enthusiasts want sound mathematical foundations. Anyone wanting to improve problem-solving abilities through practical math.   Why Choose This Award in Functional Skills Maths at QLS Level 2 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.   Career Path Administrative roles: Administrative Assistant (£18,000 - £25,000 per year) Retail positions: Retail Manager (£20,000 - £45,000 per year) Finance sector: Junior Accountant (£20,000 - £30,000 per year) Business ownership: Small Business Owner (Earnings vary widely) Further studies: Access to higher-level math courses for specialised careers.   Prerequisites This Functional Skills Maths - Level 2 is open to all, irrespective of prior qualifications. Enrolling is simple, and the course, created by experts, functions seamlessly on PCs, Macs, tablets, and smartphones. With accessibility from any location with a reliable internet connection, this course provides convenient learning options.   Certification After finishing the course content, you'll encounter a written assignment test. Upon successful completion, you can acquire a PDF certificate for a fee of £4.99. If you prefer a physical copy, you can order an original hard copy for an extra £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 £75 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 Integers ( Directed Numbers) 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 Factors and Multiples 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 Fractions 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 Simplification Rule : BODMAS 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 Decimal numbers 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 Rational Numbers 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 Approximation 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 1 00:05:00 Estimation and Scientific Notation or Standard form 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 Percentage 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 Ratio and Proportion 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 51 To 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 Unitary Method and its Applications 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 Profit , Loss, discount and Tax 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 Mock Exam Mock Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Final Exam Final Exam - Award in Functional Skills Maths at QLS Level 2 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Award in Functional Skills Maths at QLS Level 2
Delivered Online On Demand7 hours 36 minutes
£10.99

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16

By Packt

Do you want to create outstanding apps with SwiftUI? Moreover, are you eager to build up your professional portfolio and show up in your next job interview with confidence? This complete iOS application development course is designed to teach you how to become an advanced multiplatform app developer using Apple's native user interface framework: SwiftUI.

SwiftUI and Node.js Full Stack - Build Twitter - iOS 16
Delivered Online On Demand21 hours 13 minutes
£59.99

Newspaper Journalism

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now With a single payment you will gain access to Newspaper Journalism including 10 additional premium courses, original hard copy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. Courses are included with this Newspaper Journalism Complete Bundle: Course 01: Newspaper Journalism Course 02: Level 2 Microsoft Office Essentials Course 03: Microsoft Teams Course 04: Report Writing Course 05: Working from Home Essentials Course 06: Mental Health and Working from Home Course 07: Online Meeting Management Course 08: Effective Communication Skills Course 09: Time Management Course 10: Leadership & Management Diploma Course 11: Emotional Intelligence and Human Behaviour If you want to gain a solid understanding of Newspaper Journalism and fast track your dream career, then take a step in the right direction with this industry-standard, comprehensive Newspaper Journalism course designed by expert instructors. The Newspaper Journalism will cover a comprehensive range of 13, you'll have 24/7 online access to the study materials, introductory videos, assessment tests, study resources and tutor support for a lifetime. The Newspaper Journalism will help you to develop your skills, confidence and knowledge of this sector, helping to add real value to your CV and personal development. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Newspaper Journalism has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Newspaper Journalism is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Whether you are looking to brighten up your CV, just starting out in the industry, looking for a career change or just fancy learning something new, this online Newspaper Journalism course is perfect! Benefits you'll get choosing Apex Learning for this Newspaper Journalism: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum: Module 01: Introduction and Principles Journalism: An Introduction Introduction Forms of Journalism Influences on Journalism Principles Summary Module 02: History and Development The Print Medium Newspapers in the Digital Age Why Newspapers Remain So Powerful Journalism on the Internet The UK National Press Today Common Threads in the History of UK Journalism Summary Module 03: Interviewing for Newspaper Journalism Interviewing The Face-To-Face InterviewThe Telephone Interviews Copy Presentation Hard NewsSofter NewsFeatures Summary Module 04: News Writing Introduction to News Writing SlugsThe Split PagePunctuationRewriting Wire CopyConversational StyleReading Your Copy AloudAvoiding Information Overload News Writing Style Names and TitlesNumbers, Capital Numbers, Punctuation Marks, and Web SitesLanguage Summary Module 05: News Production Effective News Gathering Methods InterviewingThe Deductive and Investigative MethodsIntelligent DeductionGetting Facts Sources of Information Direct ObservationSecondary Sources InterviewsPress ConferencesPress NotesDocuments Producing Quality News Summary Module 06: News Reporting Reporting the News Equipment Reporting Video Shooting TechniquesSequences Reporting Audio Summary Module 07: Writing Skills for Newspaper Journalists Getting Down to It Make A Plan Before You StartWrite Straight onto The KeyboardWrite Notes to Get StartedRevise Your WritingMaster the Basics Writing News Writing Reviews Glossary of Terms Used in Journalism Summary Module 08: Newspaper Journalism law Introduction and Background Types of Law Divisions of the Law Defamation Defamation Act 2013Defamation and Human Rights Reporting Restrictions in Legal Cases Court Reporting RestrictionsReporting Restrictions on Cases Involving Children and Young PeopleRestrictions on Reporting Sexual OffencesOther Main Reporting Restrictions Divorce Election law Summary Module 09: Court Reporting Going to Court Reporting Court Cases Contempt of Court Writing Your Court Report Summary Module 10: Journalism Ethics What Are Ethics? What Makes a Good Journalist? Morality and TruthThe Right to Respect for PrivacyFreedom of Speech Copyright Summary Module 11: Niche Journalism What Is Niche Journalism? Importance of Niche Journalism Introduction to Sports Journalism Sports Journalism in the 21st CenturySports Journalism in a Changing Newspaper Market Broadcasting, Sports Journalism and Entertainment Television and Sports JournalismSports News in The Digital Age Travel Journalism Travel Journalism and the Lifestyle Fashion Journalism Writing Fashion News and Features Writing Fashion News Summary Module 12: Tips on Writing a Good Feature Story What Is Feature Writing? The Role of The FeatureWho Is the Feature Writer? Different Types of Features Descriptive and Colour WritingPersonality-Celebrity FeaturesSeasonal FeaturesEntertainment Features and Critical WritingWriting Product Reviews for ConsumersOther Forms of Reviews and Criticism Key Skills of a Feature Writer How to Get Quotes Dealing with Quotes Summary Module 13: Health and Safety for Journalists Introduction to Health and Safety Health and Safety at Work The Main Elements of Health and Safety Law Reporting in Hostile Environments Reporting Sports Events Working As a Freelance A Summary of Additional Regulations Summary How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery inside the U.K. is Free. International students have to pay a £3.99 postal charge. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous certifications required for enrolment on this course. It is available to all students, of all academic backgrounds. Requirements Our Newspaper Journalism 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 certifications 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. Certificates Certificate of completion Digital certificate - Included

Newspaper Journalism
Delivered Online On Demand
£53

Life Coach Training - Guideline For The Startup

4.9(27)

By Apex Learning

Overview This comprehensive course on Life Coach Training - Guideline For The Startup will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Life Coach Training - Guideline For The Startup comes with accredited certification, 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 Life Coach Training - Guideline For The Startup. It is available to all students, of all academic backgrounds. Requirements Our Life Coach Training - Guideline For The Startup 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 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 27 sections • 165 lectures • 10:06: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 •: 00:00:00 •: 00:00: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 •Assignment - Life Coach Training - Guideline For The Startup: 00:00:00

Life Coach Training - Guideline For The Startup
Delivered Online On Demand10 hours 6 minutes
£12

Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7

4.5(3)

By Studyhub UK

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

Advanced Diploma in Statistics & Probability for Data Science & Machine Learning at QLS Level 7
Delivered Online On Demand11 hours 27 minutes
£10.99

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query

4.5(3)

By Studyhub UK

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

Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Delivered Online On Demand6 hours 8 minutes
£10.99