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

22935 Industry courses in Cardiff delivered On Demand

Pharmacy Assistant & Technician

5.0(3)

By School Of Health Care

Pharmacy Assistant & Technician Make an important contribution to the UK healthcare system by ensuring that your community can rely on you for support and excellent customer service. This Pharmacy Assistant & Technician course teaches you everything you need to know to become a Pharmacy Technician or Pharmacy Technician Assistant and provide support and stability to your team. This Pharmacy Assistant & Technician course provides all the knowledge and essential skills required for these critical roles, including the ability to counsel, advise, and dispense medicinal expertise. You will also learn basic medical practices and prescription techniques, as well as common pharmaceutical terminology and the responsibilities for stock control and patient confidentiality. Enrol in this Pharmacy Assistant & Technician course to get a head start on a career in healthcare. Why choose this Pharmacy Assistant & Technician course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Pharmacy Assistant & Technician Learning Outcomes After completing this Pharmacy Assistant & Technician course, the learner will be able to: Understand the requirements needed to be a Pharmacy Technician or Assistant. Know how to counsel or communicate with patients and customers. Become aware of your position in the UK Healthcare infrastructure. Gain the ability to prescribe and dispense medication swiftly. Know to control and manage a medical inventory. Gain a solid understanding of the Standard Operating Procedures in a medical environment. Gain the skills to perform a full medical assessment on a patient. Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Pharmacy Assistant & Technician course. Who is this course for? Pharmacy Assistant & Technician This Pharmacy Assistant & Technician course is suitable for becoming pharmacy technicians or working in the medical field. Requirements Pharmacy Assistant & Technician To enroll in this Pharmacy Assistant & Technician course, students must fulfill the following requirements: Good Command over English language Be energetic and self-motivated. Basic computer Skill You must be at least 15 years old. Career path Pharmacy Assistant & Technician This Pharmacy Assistant & Technician course will prepare you for many healthcare profession such as: Pharmacist’s Assistant Pharmacy Technician Hospital Clerk Pharmacist

Pharmacy Assistant & Technician
Delivered Online On Demand1 hour 12 minutes
£12

Diploma in Counselling & Psychology - CPD Certified

5.0(3)

By School Of Health Care

Counselling: Counselling Course Online This Counselling: Counselling Course and Psychology UK course aims to provide you with in-depth knowledge of Diploma in Counselling: Counselling Course. Learn how to help people deal with personal and professional difficulties. There are numerous opportunities to work in well-known institutions and companies. Enrol in our Counselling: Counselling Course today to become a human mind expert and take the first step toward a psychologist or counsellor career. Why choose this Counselling: Counselling Course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Counselling: Counselling Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the Counselling: Counselling Course. Main Course: Diploma in Counselling & Psychology Course Courses you will GET: Course 01: Clinical Psychology Diploma Course 02: Diploma in Mastering Psychology [ Note: Free PDF certificate will provide as soon as completing the Counselling: Counselling Course] Counselling: Counselling Course Online This Counselling: Counselling Course consists of 14 modules. Assessment Method of Counselling: Counselling Course After completing Counselling: Counselling Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Counselling: Counselling Course After completing the Counselling: Counselling Course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Counselling: Counselling Course Online This Counselling: Counselling Course is designed for anyone who wants to gain knowledge in counselling and psychology. Requirements Counselling: Counselling Course Online To enrol in this Counselling: Counselling Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Counselling: Counselling Course. Be energetic and self-motivated to complete our Counselling: Counselling Course. Basic computer Skill is required to complete our Counselling: Counselling Course. If you want to enrol in our Counselling: Counselling Course, you must be at least 15 years old. Career path Diploma in Counselling and Psychology After completing this Counselling: Counselling Course, candidates may pursue careers.

Diploma in Counselling & Psychology - CPD Certified
Delivered Online On Demand18 hours
£12

Diploma in Clinical Psychology Course

5.0(3)

By School Of Health Care

Diploma in Clinical Psychology Course Online The Diploma in Clinical Psychology course covers a wide range of mental health disorders and provides practical and theoretical knowledge on various forms of psychology and their approaches and applications. It examines the main characteristics of good mental health and then introduces some key statistics about mental health in the United Kingdom. Our comprehensive Diploma in Clinical Psychology course is the perfect way to kickstart your career in the field of psychology. The Diploma in Clinical Psychology course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. Main Course: Diploma in Clinical Psychology Free Courses Course 01: Psychological Wellbeing Practitioner Course 02: Diploma in Counselling and Psychology Course 03: Diploma in Mastering Psychology [ Note: Free PDF certificate as soon as completing the Diploma in Clinical Psychology course] Diploma in Clinical Psychology Course Online Industry Specialists developed this Diploma in Clinical Psychology Course into 12 user-friendly modules/ lectures. Assessment Method of Diploma in Clinical Psychology Course After completing Diploma in Clinical Psychology Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Diploma in Clinical Psychology Course After completing the Diploma in Clinical Psychology course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Diploma in Clinical Psychology Course Online This Diploma in Clinical Psychology course is ideal for anyone looking to start a career in the field of psychology or counselling. Requirements Diploma in Clinical Psychology Course Online To enrol in this Diploma in Clinical Psychology Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Diploma in Clinical Psychology Course. Be energetic and self-motivated to complete our Diploma in Clinical Psychology Course. Basic computer Skill is required to complete our Diploma in Clinical Psychology Course. If you want to enrol in our Diploma in Clinical Psychology Course, you must be at least 15 years old. Career path Diploma in Clinical Psychology Course Online This Diploma in Clinical Psychology course will prepare you for a variety of career paths.

Diploma in Clinical Psychology Course
Delivered Online On Demand40 hours
£12

Building Surveying Course - CPD Certified

5.0(3)

By School Of Health Care

Building Surveying Training: Building Surveying Course Online Would you like to begin acquiring valuable knowledge that will help you differentiate yourself from your rivals? If so, then our special building surveying course could be your perfect choice! This building surveying course covers construction technology, building pathology, regulations, and inspection. Also, the building surveying course includes maintenance, heritage conservation, BIM, and health and safety. Moreover, the building surveying course describes professional ethics, project management, sustainability, and communication. Students in this building surveying course gain skills in defect recognition, risk evaluation, maintenance planning, and client communication. What are you waiting for, then? Enrol in this building surveying course on building surveys right away. Special Offers of this Building Surveying: Building Surveying Course: This Building Surveying: Building Surveying Course includes a FREE PDF Certificate. Lifetime access to this Building Surveying: Building Surveying Course Instant access to this Building Surveying: Building Surveying Course 24/7 Support Available to this Building Surveying: Building Surveying Course Main Course: Building Surveying Course [ Note: Free PDF certificate as soon as completing Building Surveying Training: Building Surveying Course] Building Surveying Training: Building Surveying Course Online This Building Surveying Training: Building Surveying Course consists of 09 modules. Unlock your potential with our Building Surveying course! Dive deep into Building Surveying principles, practices, and techniques. Master Building Surveying skills that set you apart in the industry. Our Building Surveying course offers hands-on experience and expert guidance in Building Surveying, preparing you for a successful career in Building Surveying. Enroll today! Who is this course for? Building Surveying Training: Building Surveying Course Online Anyone interested in earning a diploma in this field can take this building surveying course. Requirements Building Surveying Training: Building Surveying Course Online To enrol in this Building Surveying Training: Building Surveying Course, students must fulfil the following requirements: Building Surveying: Good Command over English language is mandatory to enrol in our Building Surveying Course. Building Surveying: Be energetic and self-motivated to complete our Building Surveying Course. Building Surveying: Basic computer Skill is required to complete our Building Surveying Course. Building Surveying: If you want to enrol in our Building Surveying Course, you must be at least 15 years old. Career path Building Surveying Training: Building Surveying Course Online This building surveying course provides an exceptional chance to grow professionally and acquire useful skills.

Building Surveying Course - CPD Certified
Delivered Online On Demand1 hour 24 minutes
£12

Freelance Writing Course

By iStudy UK

Course Description Freelance writing is the practice of writing for money, in its simplest state. Freelance writers produce whatever written text is needed by their clientele, generally at home in their own office, for money. If you want to be freelance writer or want to get the success keys, you are welcome to join Freelance Writing Course. You will gain the skills necessary to thrive in the freelance writing world. Learn the secret self-promotion tactics of a seasoned freelancer quickly. Feel motivated and full of self-belief in a new home based career. You will learn everything you need to know about magazine article and travel writing, ghost writing, genre fiction writing, nonfiction book writing, children's book writing, to effective copy writing, and much more. What's In the Course? Discover why I am the right teacher for you. Indeed, I may be the ONLY writing teacher out there who has actually made a good living from writing. Most teachers either live in dusty classrooms teaching theory, or are so called 'gurus' who have no real world experience and yet spout even more theory from behind a blog or a flashy website. Not me, I'm the real deal. I've been making a living from freelance writing for over 25 years, online and offline - so I know how it's done, how it works, and how to make a shed-load of money doing it. Let me show you the best attributes to develop to make your new career a certainty. Talk to me about your problems within the course and let me help you gain the right mindset, attitude, and motivation. I'll be candid and assist you as much as is humanly possible. Plus, I'll be upfront about the money you can make, which is sometimes a lot more than you'd think! The key to making freelance writing work is to create multiple streams of income, so that you're getting a constant flow of money coming in from all kinds of writing work: magazine articles, travel writing, ghosting writing, editing jobs, writing fiction and nonfiction, getting published by the trade AND/OR self publishing certain things. The trick is to diversify and not rely totally on just one form of income. I'll explain fully how that is done effectively at the beginning of the course. Many new writers don't fully appreciate how to run a lucrative business. Basically writing for a living is a business too - and you need to approach it like one. In one crucial set of videos I explain how to plan and strategize your success and use priorities and measurement of your activities to maximize your earning potential. Plus tips on how to reduce your taxes and properly manage your finances. Writing success is about managing your activities - daily - and responding to feedback. My course ensures you don't get caught in a rut and that you respond quickly to the demands that writing for a living will engender. Included are downloadable activity sheets that will help you identify the best paying jobs. More than any other freelance business, you are a product of your own destiny when it comes to writing. You decide on what you want. You decide what you want to do with your time. You are the master of your universe - and you reap the rewards of true independence. During the course I explain how your mindset is your best friend, your best asset, and your key to true success. It's what is in your heart that matters - and I explain why. After this master class in self management I then go on introduce the concept of Practical Cash Creation. This detailed module explains the reality of writing for a living and what it means, how it can impact your life and those around you, how making money changes your life - and your partner's - all for the good. There are more downloadable income to activity schedules and spreadsheets in these modules to help you chart your progress and track your journey to success. Finally we reach the actual meat and potatoes of the course - actual money making activities explained in detail: how actual cash is generated from a myriad of sources. The information in these videos will literally blow you away. Never in one place have so many secrets been laid bare, especially about an industry normally shrouded in secrecy. Now it's no longer necessary for you to learn the hard way - all by yourself and over a long period of time (years!) because I have done all that FOR YOU. All the information you need is here. All the right tips and tactics that work are ALL HERE. Just for you. Writing for Magazines is traditionally seen as the freelancers main income source and the subject receives its full attention from me. The fact is, magazine articles may only make up a small part of your overall income but everything you learn about pitching for work will help sharpen your freelance writing skills. In this series of lectures I help you with Sample Query letters, assistance choosing topics that can't fail to have an editor salivating and a market listing to die for. Non Fiction Writing is covered in a series of SEVEN videos that show you how to construct sure-fire submissions to publishers on all kinds of books: science, fashion, history, whatever you like. You see the thing is that you don't have to write entire books to get paid to write them. Better to pitch nonfiction ideas to publishers FIRST and then let them commission you to write them. This is how true professionals work - and I show you the exact method by which you can compete and win with ease. Again I include an up to the minute listing of nonfiction publishers who are desperate for new book ideas from you. Writing Genre Fiction for big money is the dream of almost all new authors. But how is this achieved? Look no further. Over EIGHT info packed videos and FOUR full-length e-books, I explain how to write effective romance, thrillers, fantasy, horror, science fiction and cross-genre fiction for the modern marketplace, whether you're targeting traditional publishers or you want to self publish on Amazon. This module alone is worth far more than the super low price I'm asking for this extraordinary course. You won't believe what you get! Writing for Children is another favorite choice among new authors who sense there is much money to be made from spinning short tales for kids. It is true that the children's market is huge and lucrative but, do you really have what it takes to be a winner in this field? This special SEVEN part lecture series will put you on the right track. Compiled with the help of a multi-published children's author, this section alone is super valuable to any writer's career. Includes great instruction on technique and comprehensive market listing of children's book publishers Writing for the Corporate World has always been a great fallback for me. If ever there's a market that's always hungry, it's the business world. But many people misunderstand how most companies go about attracting freelance writers... because mostly they don't. We writers often have to make the first move. This section gives you the foolproof strategy I have always used to get business work. It's quick, easy, and costs nothing - but the pay is out of this world! Learn the one trick I present in this eye-popping SIX part section and you'll always be wealthy! Travel Writing - the dream ticket. What could be more exotic and glamorous? Writing travel articles is a bit like being James Bond without the gun! But what do travel magazines really want? What do travel book publishers need? In this wonderful new section I give you the facts. Everything you need to know about writing compelling articles, plus advice on how to get holiday gigs, and how best to do research on location and take photos that will become your way into the big time! Includes a complete list of travel writing publishers and high paying magazine markets. Becoming a Ghost Writer is about getting it all: money without the hassle of being a touring author. Honestly, if you're looking for sure-fire income, there is never a shortage of people looking for ghost writers. And it's incredibly well paid. Your biggest hurdle is finding the right kind of clients, by which I mean the PAYING ones. Only one in ten ghost writing clients want to pay you - even though they will lie and tell you they'll pay you later, which they often won't. This section is all about using business skills to attract paying clients, how to construct ghost writing contracts and how to do a great job quickly AND get paid UPFRONT. Getting Rich as a Copywriter is an ambition like no other. As we speak it is possible to spend up to $2000 on a copywriting course ALONE. But here, within Secrets of a Freelance Writer, over EIGHT packed lectures, you get every piece of information on copywriting you'll ever need. Don't waste your money on hack copywriters who have to sell their overpriced courses to make their mortgage payments. Find out everything you need to know from me, a freelancer - and a nice guy - who has used advanced copywriting skills to build a million dollar empire over the last decade and a half. Get in the know - and quickly! Self Publishing Online is now a necessary skill for all new writers. You simply can't survive as a credible author these days without having an online presence and a means by which to sell you own books. Many traditional authors are making the switch to digital author simply because the royalties publishers pay are too low. Amazon pays 70% to 90%. Traditional publisher pay 10%. It's easy to see why the majority of new authors now CHOOSE self publishing over the long and often disappointing slog of getting an agent then a literary deal where you'll end up barely able to pay the rent and bills. Learn how to self publish online like a professional and watch the money come rolling in! What are you waiting for? Offline Self-Publishing too is still a valid way of making cash quickly - if you know how to do it properly. There are many pitfalls to vanity publishing and you don't want to do that. But if you're a teacher, a coach, or a speaker then publishing your own book in a limited POD run to can be earning money you would normally be leaving on the table. In this four part section, let me show you the best advice for self publishing offline in this digital age. Includes downloadable resources. Grants and Funding for Writers. Did you know there are individuals, government departments, and corporations who regularly give money to authors, writers and poets? Getting grants and funding can be a useful tool to helping your bank balance and your kudos rating but many artists struggle over where and how to begin with this minefield of possibilities. This special section takes the mystery out of getting grants and applying for art funding. Helping Other Writers is one major key to getting wealthy as an author. As the number of wordsmiths taking themselves seriously these days, the larger the market grows for people who need help, help only YOU can give. You may not have considered this as a market before. You may not have thought yourself good enough. No matter. This unique look at cash creation shows you, over TEN fact filled lectures exactly how to make a great living simply helping other writers to succeed. And it's easy to attract the work and keep getting gigs for as long as you like! Self Promotion is necessary but need not be hard. Many writers don't want to promote themselves and then are overwhelmed by all the possibilities, many of which are a waste of time. Let me show you the best ways to promote yourself - the ones that work - so you can save time and get on with what really matters: the writing. Over this extraordinary FIVE part section - the likes of which you've never seen - I'll give you the lowdown on promotion tactics that make money and make sure you benefit from your new career. In the Conclusion, we look at maintaining a freelance career, which is all about combining self belief and proper business practice with writing. The fact is you don't need to be the best writer in the world to make a living as an author, a copywriter, a ghost writer or even a magazine article writer. Your enthusiasm and your dedication will take you a lot further than your talent. Freelance Writing is a dream job where you are rich, independent and FREE. Come join me. Let me show you how it's done! As well as giving all the information about writing for a living you could ever need, this unique course presents a step-by-step, motivational program for personal writing success, whatever your level of expertise. All you need is your enthusiasm and a willingness to learn and you will begin a new life of independence and freedom within days of taking this fun and insightful study aid. GO FOR IT! Join me now. Introduction to Freelance Writing Am I The Right Teacher For You? You Betcha! FREE 00:01:00 What You Need To Succeed FREE 00:02:00 Your Key is Your Attitude FREE 00:02:00 How Much Money Are We Talking Here? FREE 00:01:00 Creating Multiple Streams of Income The Main Point of This Course 00:02:00 Strategy and Measurement 00:02:00 Setting Your Priorities 00:02:00 Mindset of the Freelancer Mindset 00:02:00 Heart of Gold, Pot of Gold 00:02:00 Acquiring The Very Best Attitude 00:02:00 Practical Cash Creation Practical Cash Creation 00:01:00 The Reality of Writing for a Living 00:02:00 Activity To Income Schedule 00:00:00 Your Daily Writing Activities 00:00:00 Tracking Your income Tracking Your Income ONE 00:02:00 Tracking Your Income TWO 00:01:00 Income Tracking Sheet 00:00:00 Freelancer Spreadsheet Template 00:00:00 Writing For Magazines Writing For Magazines 00:02:00 Choosing Topics For Magazine Articles 00:01:00 Markets for Nonfiction Articles 00:00:00 Sample Magazine Query Letter 00:00:00 Writing Non Fiction For Publication and Sale Writing Non Fiction for Profit ONE 00:02:00 Writing Non Fiction For Profit TWO 00:02:00 Writing Non Fiction For Profit THREE 00:01:00 Writing Non Fiction For Profit FOUR 00:02:00 Writing Non Fiction For Profit FIVE 00:02:00 Writing Non Fiction For Profit SIX 00:02:00 Writing Non Fiction For Profit SEVEN 00:02:00 Writing Genre Fiction For Money and Kudos Introduction to Writing Genre Fiction 00:02:00 Writing Genre Fiction TWO 00:02:00 Writing Genre Fiction THREE - Romance 00:03:00 Writing Genre Fiction FOUR - Thrillers 00:01:00 Writing Genre Fiction FIVE - Science Fiction 00:01:00 Writing Genre Fiction SIX - Horror 00:02:00 Writing Genre Fiction SEVEN - Fantasy 00:01:00 Writing Genre Fiction EIGHT - Cross Genre 00:01:00 Writing For Children Writing for Children ONE 00:01:00 Writing for Children TWO 00:02:00 Writing for Children THREE 00:02:00 Writing for Children FOUR 00:02:00 Writing for Children FIVE 00:02:00 Writing for Children SIX 00:02:00 Writing for Children SEVEN 00:02:00 Marketing Listing of Children Book Publishers 00:00:00 Writing for Corporate Companies Writing for Business ONE 00:01:00 Writing for Business TWO 00:02:00 Writing for Business THREE 00:02:00 Writing for Business FOUR 00:02:00 Writing for Business FIVE 00:02:00 Writing for Business SIX 00:02:00 Travel Writing Travel Writing ONE 00:02:00 Travel Writing TWO 00:02:00 Travel Writing THREE 00:02:00 Travel Writing FOUR 00:02:00 Travel Writing FIVE 00:01:00 Travel Writing SIX 00:01:00 Travel Writing Publishers 00:00:00 Ghost Writing Ghost Writing ONE 00:02:00 Ghost Writing TWO 00:02:00 Ghost Writing THREE 00:02:00 Ghost Writing FOUR 00:01:00 Ghost Writing FIVE 00:02:00 Ghost Writing Resources 00:00:00 The Art of Writing Ad Copy The Art of Writing Copy ONE 00:02:00 The Art of Writing Copy TWO 00:02:00 The Art of Writing Copy THREE 00:02:00 The Art of Writing Copy FOUR 00:02:00 The Art of Writing Copy FIVE 00:02:00 The Art of Writing Copy SIX 00:02:00 The Art of Writing Copy SEVEN 00:02:00 The Art of Writing Copy EIGHT 00:02:00 Self Publishing Online Self Publishing Online ONE 00:02:00 Self Publishing Online TWO 00:02:00 Self Publishing Online THREE 00:01:00 Self Publishing Online FOUR 00:02:00 Self Publishing Online FIVE 00:02:00 Self Publishing Online SIX 00:02:00 Self Publishing Online SEVEN 00:01:00 Self Publishing Offline Offline Publishing Advice ONE 00:02:00 Offline Publishing Advice TWO 00:02:00 Offline Publishing Advice THREE 00:02:00 Offline Publishing Advice FOUR 00:02:00 Offline Publishing Resources 00:00:00 Grants and Funding for Writers Grants and Funding ONE 00:02:00 Grants and Funding TWO 00:01:00 Grants and Funding THREE 00:02:00 Grants Currently Available to Writers 00:00:00 Getting Wealthy by Helping Other Writers Helping Other Writers ONE 00:01:00 Helping Other Writers TWO 00:02:00 Helping Other Writers THREE 00:02:00 Helping Other Writers FOUR 00:02:00 Helping Other Writers FIVE 00:02:00 Helping Other Writers Six 00:01:00 Helping Other Writers SEVEN 00:01:00 Helping Other Writers EIGHT 00:02:00 Helping Other Writers NINE 00:01:00 Helping Other Writers TEN 00:00:00 Self Promotion Self Promotion Advice ONE 00:02:00 Self Promotion Advice TWO 00:01:00 Self Promotion Advice THREE 00:02:00 Self Promotion Advice FOUR 00:01:00 Self Promotion Advice FIVE 00:02:00 Self Belief and Your Career The End of the Course 00:01:00 Self Publishing - AGAIN 00:02:00 Maintaining a Freelance Career 00:02:00 Self Belief 00:02:00 Useful Websites for Self Publishing 00:00:00

Freelance Writing Course
Delivered Online On Demand2 hours 46 minutes
£25

Carpentry Training: Floor Systems and Roof Framing

4.7(160)

By Janets

Initiating with a a comprehensive overview of carpentry, this course will take you to the overview of roof framing and sliding. It also sheds light on the wall framing, exterior framing of doors and windows and more. Take this course to achieve amazing carpentry skills and grow faster. Start learning Carpentry Training: Floor Systems and Roof Framing that will give you enough knowledge and skills to build your dream career. About this course This Carpentry Training: Floor Systems and Roof Framing helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Carpentry Training: Floor Systems and Roof Framing is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Carpentry Training: Floor Systems and Roof Framing is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Carpentry Training: Floor Systems and Roof Framing related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: An Overview of Carpentry Module 2: Introduction to Floor Systems Module 3: An Overview of Wall Framing Module 4: Exterior Doors and Windows Module 5: An Overview of Roof Framing and Siding Course Content Course Name: Carpentry: Floor Systems and Roof Framing Module 1: An Overview of Carpentry 00:09:00 Module 3: An Overview of Wall Framing 00:08:00 Module 4: Exterior Doors and Windows 00:12:00 Module 5: An Overview of Roof Framing and Siding 00:11:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Carpentry Training: Floor Systems and Roof Framing
Delivered Online On Demand40 minutes
£5.99

Post COVID Mental Aid Course

4.7(160)

By Janets

Start learning Post COVID Mental Aid Course that will give you enough knowledge and skills to build your dream career. About this course This Post COVID Mental Aid Course helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Post COVID Mental Aid Course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Post COVID Mental Aid Course is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Post COVID Mental Aid Course related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 01: An Overview of COVID-19 Module 02: COVID-19 Impacts on Mental Health for Children Module 03: COVID-19's Effects on the Mental Health of the Young Generation Module 04: COVID-19's Effects on the Mental Health of the Old Generations Module 05: WHO's Psychological Aid Guidelines for Dealing with Mental Health Issues Caused by the Pandemic Course Content Covid 19: Mental Health Module 01: An Overview of COVID-19 00:19:00 Module 02: COVID-19 Impacts on Mental Health for Children 00:17:00 Module 03: COVID-19's Effects on the Mental Health of the Young Generation 00:07:00 Module 04: COVID-19's Effects on the Mental Health of the Old Generations 00:11:00 Module 05: WHO's Psychological Aid Guidelines for Dealing with Mental Health Issues Caused by the Pandemic 00:16:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Post COVID Mental Aid Course
Delivered Online On Demand1 hour 10 minutes
£5.99

Online Social Work Course

4.7(160)

By Janets

Doing online social work is a new form of contributing to social welfare in the digital age. This Online Social Work Course has been designed to educate you to contribute more dynamically and effectively teaching you essential guidelines and theories. It will teach you the framework of teamwork and casework procedure. Start learning Online Social Work Course that will give you enough knowledge and skills to build your dream career. About this course This Online Social Work Course helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. Why choose this course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Online Social Work Course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Who Is This Course For:​ This Online Social Work Course is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Online Social Work Course related skills to aid his/her career path. No formal entry prerequisites are required Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Course Content Module 1: An Overview of Social Work Basics Module 2: Social Work Dimensions and Intervention Models I Module 3: The Role of a Social Worker and Guidelines for Social Worker Module 4: Social Working and Sociology Theories Module 5: Teamwork and Casework Procedure Course Content Social Work Basics Module 1: An Overview of Social Work Basics 00:14:00 Module 2: Social Work Dimensions and Intervention Models I 00:34:00 Module 3: The Role of a Social Worker and Guidelines for Social Worker 00:15:00 Module 4: Social Working and Sociology Theories 00:24:00 Module 5: Teamwork and Casework Procedure 00:22:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Online Social Work Course
Delivered Online On Demand1 hour 49 minutes
£5.99

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