32173 Courses in Cardiff delivered Online

Master Microsoft Excel with the Microsoft Office Specialist (MOS) certification. Excel at data analysis, visualization, and productivity with expert-level skills. Excel your career with MOS - Microsoft Excel certification today.

Follow your dreams by enrolling on the Receptionist and Organisational Skills course today and develop the experience, skills and knowledge you need to enhance your professional development. Receptionist and Organisational Skills will help you arm yourself with the qualities you need to work towards your dream job. Study the Receptionist and Organisational Skills training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Receptionist and Organisational Skills course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Receptionist and Organisational Skills course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Receptionist and Organisational Skills course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Receptionist and Organisational Skills course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Receptionist and Organisational Skills course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Receptionist and Organisational Skills course. The Receptionist and Organisational Skills course is designed by industry experts and is tailored to help you learn new skills with ease.  The Receptionist and Organisational Skills is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Receptionist and Organisational Skills when it suits you. Access the Receptionist and Organisational Skills course modules from any internet-enabled device, including computers, tablets, and smartphones. The Receptionist and Organisational Skills course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Receptionist and Organisational Skills now and start learning instantly! What You Get Out Of Studying Receptionist and Organisational Skills With Janets: Receive a digital Certificate upon successful completion of the Receptionist and Organisational Skills course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) DescriptionThe Receptionist and Organisational Skills training course is delivered through Janets' online learning platform. Access the Receptionist and Organisational Skills content from any internet-enabled device whenever or wherever you want to. The Receptionist and Organisational Skills course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Receptionist and Organisational Skills course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Receptionist and Organisational Skills course. After successfully passing the Receptionist and Organisational Skills course exam, you will be able to apply for a CPD-accredited certificate as proof of your Receptionist and Organisational Skills qualification. Certification All students who successfully complete the Receptionist and Organisational Skills course can instantly download their digital certificate. You can also purchase a hard copy of the Receptionist and Organisational Skills course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Receptionist and Organisational Skills is ideal for those who already work in this sector or are an aspiring professional. This Receptionist and Organisational Skills course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Receptionist and Organisational Skills is open to all students and has no formal entry requirements. To study the Receptionist and Organisational Skills course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Receptionist and Organisational Skills is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Receptionist and Organisational Skills and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Module One – Getting Started Module Two – Remove the Clutter Module Three – Prioritize Module Four – Scheduling Your Time  Module Five – To Do Lists Module Six – Paper and Paperless Storage Module Seven – Organization in Your Work Area Module Eight – Tools to Fight Procrastination Module Nine – Organizing Your Inbox Module Ten – Avoid the Causes of Disorganization Module Eleven – Discipline is the Key to Stay Organized Module Twelve – Wrapping Up

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Superfood Nutrition: 60+ Foods For Health & Fitness Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Superfood Nutrition: 60+ Foods For Health & Fitness Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Superfood Nutrition: 60+ Foods For Health & Fitness Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Superfood Nutrition: 60+ Foods For Health & Fitness Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Superfood Nutrition: 60+ Foods For Health & Fitness? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Superfood Nutrition: 60+ Foods For Health & Fitness there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Superfood Nutrition: 60+ Foods For Health & Fitness course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Superfood Nutrition: 60+ Foods For Health & Fitness does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Superfood Nutrition: 60+ Foods For Health & Fitness was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Superfood Nutrition: 60+ Foods For Health & Fitness is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction & What You Will Learn In The Course 00:02:00 Get To Know Your Instructor 00:02:00 Superfoods Introduction 00:02:00 The Basics Of A Healthy Diet The True Dieting Pyramid 00:04:00 Bodyweight And Health 00:05:00 Calories & Bodyweight In A Healthy Diet 00:02:00 The Twinkie Diet 00:02:00 How Many Calories Do You Need Daily 00:02:00 Food Composition Explained 00:03:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Food Composition Recommendations 00:03:00 Macronutrients Introduction 00:01:00 How Much Protein Should You Eat 00:02:00 How Much Fat Should You Eat 00:04:00 How Much Carbs Should You Eat Per Day 00:01:00 Macronutrient Recommendations 00:03:00 Nutrient Timing Introduction 00:02:00 Nutrient Timing Facts 00:04:00 Nutrient Timing Recommendations 00:02:00 Supplements Introduction 00:04:00 Superfood Vegetables The Benefits Of Vegetables 00:03:00 Artichokes 00:02:00 Lettuce 00:02:00 Broccoli 00:02:00 Brussels Sprouts 00:01:00 Carrots 00:01:00 Cauliflower 00:01:00 Mushrooms 00:02:00 Onions 00:02:00 Peppers 00:01:00 Spinach 00:01:00 Sweet Potatoes 00:02:00 Tomatoes 00:02:00 Superfood Grains The Benefits Of Whole Grains 00:03:00 Brown Rice 00:01:00 Oats 00:01:00 Quinoa 00:01:00 Superfood Beans & Legumes The Benefits Of Beans & Legumes 00:02:00 Beans 00:01:00 Chickpeas 00:02:00 Lentils 00:01:00 Peas 00:01:00 Superfood Fruits The Benefits Of Fruits 00:02:00 Apples 00:01:00 Apricots 00:02:00 Avocados 00:02:00 Bananas 00:01:00 Cherries 00:01:00 Dates 00:01:00 Figs 00:01:00 Grapefruits 00:02:00 Grapes 00:01:00 Lemons & Limes 00:01:00 Oranges 00:01:00 Papayas 00:01:00 Pineapples 00:01:00 Superfood Berries The Benefits Of Berries 00:02:00 Blueberries 00:01:00 Cranberries 00:01:00 Raspberries 00:01:00 Strawberries 00:02:00 Superfood Nuts & Seeds The Benefits Of Nuts & Seeds 00:02:00 Almonds 00:02:00 Brazil Nuts 00:01:00 Cashews 00:01:00 Coconuts 00:01:00 Hazelnuts 00:01:00 Macadamias 00:01:00 Peanuts 00:01:00 Pecans 00:01:00 Pumpkin Seeds 00:01:00 Sunflower Seeds 00:01:00 Walnuts 00:01:00 Superfood Meat, Poultry & Eggs The Benefits Of Meat, Poultry & Eggs 00:03:00 Eggs 00:01:00 Free Range Poultry 00:01:00 Grass Fed Beef 00:01:00 Lamb 00:01:00 Liver 00:01:00 Superfood Fish & Seafood The Benefits Of Fish & Seafood 00:02:00 Clams 00:01:00 Lobster 00:01:00 Salmon 00:01:00 Shrimp 00:01:00 Tuna 00:01:00 Miscellaneous Dark Chocolate 00:01:00 Olive & Olive Oil 00:01:00 The Right Foods For Specific Health Goals Should Women And Men Eat Differently 00:03:00 The Right Foods For Preventing Cancer 00:04:00 The Right Foods To Boost Your Metabolism 00:04:00 The Right Foods For More Energy 00:03:00 The Right Foods For Healthy Bones & Ligaments 00:02:00 The Right Foods For Preventing Heart Disease 00:03:00 The Right Foods For Muscle Gains 00:02:00 The Right Foods For Good Skin & Hair 00:04:00 The Right Foods For Fighting Stress & Depression 00:03:00 Superfoods For Special Diets The Right Foods For A High Calcium Diet 00:01:00 The Right Foods For A High Fat Diet 00:05:00 The Right Foods For A High Fiber Diet 00:03:00 The Right Foods For A High Protein Diet 00:02:00 Extra Section 0 Course Promo 00:02:00 6 Calories Explained copy 00:04:00 10 weight loss and health copy 00:03:00 12 How To Determin Your Optimal Calorie Intake copy 00:03:00 13 healthy weight ranges copy 00:02:00 20 Protein Explained copy 00:02:00 foods to boost testoerone 00:04:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Flutter & Dart Development Course Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Flutter & Dart Development Course Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Flutter & Dart Development Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Flutter & Dart Development Course Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Flutter & Dart Development Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Flutter & Dart Development Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Flutter & Dart Development Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Flutter & Dart Development Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Flutter & Dart Development Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Flutter & Dart Development Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Setup On Windows 00:16:00 Setup On Linux 00:14:00 Setup On Mac iOS 00:14:00 Setup On Mac Android 00:12:00 App Base Code 00:03:00 Section 02: Widgets Text 00:04:00 Container 00:04:00 Row 00:05:00 Column 00:02:00 Stack 00:02:00 Image 00:06:00 Center 00:02:00 Padding 00:03:00 Align 00:02:00 Constrained Box 00:03:00 Baseline Class 00:03:00 Aspect Ratio 00:03:00 Sized Box 00:02:00 Transform 00:03:00 Section 03: Gestures Pointers 00:06:00 Tap 00:02:00 Double Tap 00:02:00 Long Press 00:03:00 Vertical Drag 00:04:00 Horizontal Drag 00:04:00 Pan 00:04:00 Section 04: Navigation Components Scaffold 00:06:00 App bar 00:05:00 Bottom Navigation Bar 00:08:00 TabBar View 00:07:00 Drawer 00:05:00 SliverApp Bar 00:07:00 Section 05: Input/Selection Components FlatButton 00:04:00 RaisedButton 00:03:00 DropdownButton 00:09:00 TextField 00:04:00 CheckBox 00:06:00 Radio Button 00:04:00 PopupMenuButton 00:07:00 IconButton 00:04:00 ButtonBar 00:03:00 Floating Action Button 00:04:00 Switch 00:04:00 Slider 00:05:00 Date Picker 00:05:00 Time Picker 00:07:00 SimpleDialog 00:08:00 AlertDialog 00:06:00 BottomSheet 00:06:00 Expansion Panel List and Expansion Panel 00:07:00 SnackBar 00:07:00 Cupertino Setup 00:02:00 Cupertino Action Sheet 00:06:00 Cupertino Activity Indicator 00:01:00 Cupertino Alert Dialog 00:04:00 Cupertino Button 00:03:00 CupertinoPageScaffold 00:04:00 CupertinoPicker 00:04:00 CupertinoPopupSurface 00:04:00 CupertinoSegmentedControl 00:04:00 CupertinoSlider 00:04:00 CupertinoSwitch 00:03:00 CupertinoNavigationBar 00:04:00 CupertinoTabBar 00:05:00 CupertinoTabScaffold 00:04:00 CupertinoTextField 00:04:00 Section 06: Information Displays Icons 00:04:00 Chip 00:03:00 Tooltip 00:02:00 DataTable 00:09:00 Card 00:06:00 Linear Progress Indicator 00:03:00 Circular Progress Indicator 00:04:00 Section 07: Layout GridView 00:03:00 ListView & ListTile 00:04:00 Stepper & Step 00:07:00 Divider & divideTiles 00:05:00 Aligning Widgets 00:03:00 Sizing Widgets 00:03:00 Sizing Widgets 00:03:00 Add, Update and Delete Widgets 00:06:00 Section 08: Navigation & Routing Navigate To A New Screen and Back 00:06:00 Multiple Files For Each Screen 00:03:00 Send Data To A New Screen 00:05:00 Return Data From A Screen 00:05:00 Navigate With Named Routes 00:03:00 Animating A Widget Across Screens 00:02:00 Stateless vs Stateful Widgets 00:08:00 Section 09: Animation Tween Animation 00:07:00 Staggered Animation 00:04:00 Reverse and Stop Animations 00:02:00 Section 10: Platform Specific Code Call Android Java Code 00:08:00 Send Parameters To Android Java Code 00:07:00 Call Android Kotlin Code 00:08:00 Send Parameters To Android Kotlin Code 00:05:00 Call iOS Objective-C Code 00:10:00 Send Parameters To iOS Objective-C Code 00:05:00 Call iOS Swift Code 00:08:00 Send Parameters To iOS Swift Code 00:05:00 Section 11: Building & Releasing Remove Debug Badge 00:01:00 Build & Release For Android 00:04:00 Build & Release For iOS 00:06:00 Section 12: Networking Fetch Data From The Internet 00:13:00 Making authenticated requests using HTTP Headers 00:03:00 Parsing JSON In The Background 00:17:00 Working With WebSockets 00:10:00 Section 13: Data Persistence Reading & Writing Files On The Server Using SQL Injection Vulnerability 00:06:00 Storing Key-Value Data On Disk 00:03:00 Data Persistence Using SQLite 00:04:00 Section 14: Creating An App Calculator Part 1 - TabBar Creation 00:12:00 Calculator Part 2 - Implementing The Tabs 00:05:00 Calculator Part 3 - Tab Persistence 00:03:00 Changing Android App Icon 00:05:00 Changing iOS App Icon 00:01:00 Change App Display Name 00:05:00 Assignment Assignment - Flutter & Dart Development Course 00:00:00

Register on the Stock Trading today and build the experience, skills and knowledge you need to enhance your expert development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Stock Trading course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get Out Of Studying Stock Trading With Janets Receive a e-certificate upon successful completion of the course Get taught by experienced, expert instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The 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 Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets 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. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who Is This Course For The Stock Trading is ideal for those who already work in this sector or are an aspiring expert. This Stock Trading course is designed to enhance your expertise and boost your CV. Learn key skills and gain a expert lesson to prove your newly-acquired knowledge. Requirements The Stock Trading is open to all students and has no formal entry requirements. To study the Stock Trading course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path The Stock Trading is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Stock Trading and gain an industry-acknowledged lesson that will help you excel in finding your ideal job.

Learn Yoga and start practising yoga with the video course entitled Yoga Training Diploma. Yoga helps you to improve your physical, mental, and spiritual condition. The course covers the powerful Pranashama Yoga techniques, sequences along with the concepts and techniques of Chakra balancing, meditation, nutrition, Acro or partner Yoga and Thai massage healing. The course is helpful for both Yoga trainers and individuals who want to learn Yoga. Apart from the Yoga exercise, the course also presents the recipes of Yoga Detox diet, juicing, and making smoothies. You will also know some of the short yoga practices and specific poses such as Donkey kicks, mermaid pose, vibrator technique, yoga abs and more. Finally, the course includes some training manuals and ebooks that can work as your guide for a long time. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Yoga Training Diploma is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Career path The Yoga Training Diploma will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Pranashama Philosophy Pranashama Philosophy 00:48:00 Guided Meditations Meditation for Beginners 00:06:00 Chakra Balancing Meditation 00:09:00 Guided Mediation Love and Yoga Nidra 00:12:00 Empowering Relaxation Guided Meditation 00:20:00 The Prasha Method System of Healing Yoga to Get Grounded 00:19:00 Grounding Yoga 00:55:00 Qi Yoga Flow to Balance Emotions 00:13:00 Fire Practice to Transform & Tone 01:21:00 Journey into the Heart - Upper Back & Shoulders 00:53:00 Yoga Inversions Series 00:34:00 Yoga Inversion Series 2 00:09:00 Yoga Inversion Headstands 00:17:00 Mantra Vinyasa Yoga 00:50:00 Mantra Vinyasa Florida 00:50:00 Eyes Closed Vinyasa 6th Chakra Practice 00:13:00 Mantra Vinyasa Workshop Part 1 00:12:00 Mantra Vinyasa Workshop Part 2 00:12:00 Mantra Vinyasa Part 33 00:04:00 Heart Chakra Practice Part 16 00:13:00 Heart Chakra Practice Part 26 00:13:00 Heart Chakra Practice Part 36 00:13:00 Heart Chakra Practice Part 46 00:13:00 Heart Chakra Practice Part 56 00:01:00 Heart Chakra Practice Part 66 00:12:00 Detox Yoga 00:33:00 Yoga Detox Diet, Juicing & Smoothie Recipe Videos Energy Diet Seminar 00:39:00 Red Smoothie Recipe 00:03:00 Detox Green Juice 00:06:00 Chocolate Chai Spice Smoothie Recipe 00:10:00 Cabbage Wraps Recipe 00:18:00 Partner / Acro Yoga Workshops Thai Yoga Massage - Partner Healing & Love 00:32:00 Acro Yoga Double Wheel Pose 00:01:00 Acro Partner Yoga Triple Plank 00:01:00 Pranashama Yoga Full Classes Transform Your Life with Yoga DVD - full length 01:04:00 Pranashama Yoga Flow - All Levels 00:55:00 30 Minute Core Strengthening and Spinal Balancing Sequence 00:31:00 Adjustments, Anatomy and Alignment Workshops Anatomy & Alignment Staff Pose 00:07:00 Yoga for Back Pain Special Needs Yoga Workshop 00:10:00 Anatomy & Alignment Workshop Fish 00:06:00 Anatomy and Alignment Poses for Very Tight Hips 00:20:00 Adjustments Workshop tight or injured shoulders 00:17:00 Adjustments Workshop Sun Salutation Series 00:25:00 Adjustments Workshop Knee Injury or Pain 00:11:00 Adjustments Workshop Back Pain or Injury 00:10:00 Adjustments Workshop Shoulder Pain or Injury 00:10:00 Adjustments Workshop Legs 00:07:00 Adjustments Workshop Lower Back 00:05:00 45 minute Workshop Yoga for Lower Back and Sciatica Pain Relief 00:45:00 Short Yoga Tutorials and Specifics Poses Running Man Yoga Tutorial 00:04:00 Donkey Kicks Yoga Tutorial 00:04:00 Wild Thing - How to 00:04:00 Yoga Abs 00:04:00 Mermaid Pose Yoga Tutorial 00:08:00 Vibrator Technique - How to 00:05:00 Resources Resources - Yoga Training Diploma 00:00:00 Order Your Certificate

Overview This comprehensive course on Pure Mathematics Fundamentals will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Pure Mathematics Fundamentals comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Pure Mathematics Fundamentals. It is available to all students, of all academic backgrounds. Requirements Our Pure Mathematics Fundamentals is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 193 lectures • 03:43:00 total length •About Course: 00:02:00 •Quick Guide: 00:01:00 •Topics of Essential Revision - 1: 00:00:00 •Negative numbers and operations on Integers: 00:14:00 •The rules of Indices in Algebra: 00:11:00 •Working with indices Part 1: 00:10:00 •Working with indices Part 2: 00:08:00 •Fractional Indices: 00:12:00 •What are Polynomials?: 00:07:00 •Writing statements in Algebraic Form: 00:06:00 •Simplification using BODMAS: 00:08:00 •Distributive Property: 00:07:00 •Addition of Algebraic expressions: 00:13:00 •Subtraction of Algebraic expressions: 00:12:00 •Multiplication of Algebraic Expressions Part 1: 00:05:00 •Multiplication of Algebraic Expressions Part 2: 00:05:00 •Multiplication of Algebraic Expressions Part 3: 00:06:00 •Division of algebraic expressions Part 1: 00:11:00 •Division of algebraic expressions Part 2: 00:10:00 •Division of algebraic expressions Part 3: 00:07:00 •Topics of Essential Revision - 2: 00:00:00 •Factorization by method of common factor: 00:13:00 •Factorization by regrouping the terms: 00:10:00 •Factorization by difference of two squares: 00:11:00 •Factorization using identity (a + b) ² and (a - b) ²: 00:10:00 •Factorization using identity (a + b + c) ²: 00:05:00 •Factorization by middle term split Part 1: 00:12:00 •Factorization by middle term split Part 2: 00:09:00 •Simultaneous Linear Equations: 00:07:00 •Graphical Method: 00:06:00 •Graphical method Continued: 00:11:00 •Elimination by substitution Method: 00:09:00 •Equating the coefficients Method: 00:11:00 •Cross Multiplication: 00:10:00 •Equations Reducible to Linear Equations-1: 00:08:00 •Equations Reducible to Linear Equations-2: 00:14:00 •Introduction to Quadratic Equations: 00:05:00 •Solving Quadratic Equations by Factorization method: 00:09:00 •Writing in completed square form: 00:07:00 •Solving by completed square method: 00:08:00 •Sketching of Quadratic Graphs: 00:12:00 •Quadratic graphs using Transformations: 00:06:00 •Quadratic inequalities: 00:11:00 •Deriving Quadratic formula: 00:05:00 •Solving problems using Quadratic Formula: 00:06:00 •Nature of Roots Part - 1: 00:05:00 •Nature of roots Part - 2: 00:12:00 •Downloadable Resources: 00:00:00 •Distance formula: 00:18:00 •Mid point formula: 00:05:00 •Gradient of a line: 00:11:00 •Graphing using gradient and y intercept: 00:03:00 •Some standard lines: 00:05:00 •Slope intercept form y = m x +c: 00:06:00 •Point slope form and two point form: 00:11:00 •Intersection of line and parabola: 00:10:00 •Past Papers Problems Part 1: 00:09:00 •Past Papers Problems Part 2: 00:11:00 •Past Papers Problems Part 3: 00:09:00 •Past Papers Problems Part 4: 00:12:00 •Past Papers Problems Part 5: 00:12:00 •Downloadable Resources: 00:00:00 •Sequence and series ( video): 00:08:00 •Arithmetic Sequence: 00:10:00 •General term of an A.P.: 00:07:00 •Finding given term is which term: 00:05:00 •Writing sequence when two terms are known: 00:08:00 •Condition for three terms to be in A.P.: 00:05:00 •Sum to n terms of A.P.: 00:06:00 •Practice Problems 1 (A.P.): 00:09:00 •Practice problems 2 (A.P.): 00:07:00 •Practice problems 3 (A.P.): 00:07:00 •Practice problems 4 (A.P.): 00:11:00 •Geometric Progressions: 00:12:00 •Sum to n terms in G.P.: 00:14:00 •Sum to infinite Terms in G.P.: 00:13:00 •Practice Problems 1 (GP): 00:15:00 •Practice Problems 2 (GP): 00:12:00 •Practice Problems 3 (GP): 00:07:00 •Practice Problems based on AP and GP both: 00:15:00 •Past papers problems 1: 00:17:00 •Past papers problems 2: 00:10:00 •Past papers problems 3: 00:11:00 •Downloadable Resources: 00:00:00 •Geometric Progressions - Resources: 00:00:00 •What is Factorial?: 00:07:00 •n-choose -r problems: 00:07:00 •Properties of n - choose -r: 00:05:00 •Binomial Theorem for positive index: 00:20:00 •Expanding using Binomial Theorem: 00:11:00 •Finding the indicated term in the Binomial expansion: 00:11:00 •Finding the indicated term from end: 00:09:00 •Finding the coefficient for given exponent (index) of the variable: 00:09:00 •Finding the term independent of variable: 00:05:00 •Expanding in increasing and decreasing powers of x: 00:09:00 •Practice problems 1: 00:12:00 •Practice Problems 2: 00:09:00 •Practice problems 3: 00:10:00 •Past papers problems 1: 00:15:00 •Past Paper problems 2: 00:13:00 •Past Paper problems 3: 00:09:00 •Downloadable Resources: 00:00:00 •What is Function?: 00:08:00 •Vertical Line Test: 00:04:00 •Value of a Function Graphically: 00:08:00 •Domain Range of a function Algebraically: 00:14:00 •Domain Range of a function Graphically: 00:07:00 •Even & Odd Functions: 00:07:00 •One to one Function: 00:05:00 •Composite Functions: 00:09:00 •How to draw Rational Functions- 1: 00:05:00 •How to draw Rational Functions- 2: 00:10:00 •Inverse of a function Algebraically: 00:05:00 •Inverse of a function Graphically: 00:09:00 •Practice Problems 1: 00:16:00 •Practice Problems 2: 00:11:00 •Downloadable Resources: 00:00:00 •What is Derivative?: 00:08:00 •Derivation of formula for Derivative: 00:06:00 •Differentiation by definition or First Principle: 00:07:00 •Power Rule: 00:22:00 •Practice Problems on Power Rule 1: 00:07:00 •Practice Problems on Power Rule 2: 00:07:00 •Practice Problems on Power Rule 3: 00:05:00 •Practice Problems on Power Rule 4: 00:13:00 •Practice Problems on Power Rule 5: 00:08:00 •Downloadable Resources: 00:00:00 •Tangents and Normals- Basics: 00:13:00 •Practice- Tangents and Normals Part 1: 00:16:00 •Practice- Tangents and Normals Part 2: 00:13:00 •Practice- Tangents and Normals Part 3: 00:11:00 •Practice- Tangents and Normals Part 4: 00:14:00 •Downloadable Resources: 00:00:00 •Stationary Points - Basics: 00:13:00 •Practice- Increasing Decreasing & Maxima Minima part 1: 00:11:00 •Practice- Increasing Decreasing & Maxima Minima part 2: 00:12:00 •Practice- Increasing Decreasing & Maxima Minima part 3: 00:10:00 •Downloadable Resources: 00:00:00 •Concavity-Basics: 00:02:00 •Concavity & Second Derivative: 00:08:00 •Second Derivative Test: 00:09:00 •Practice Problems on second derivative: 00:04:00 •Practice Problem of Maxima Minima using second derivative test Part 1: 00:17:00 •Practice Problem of Maxima Minima using second derivative test Part 2: 00:10:00 •Practice Problem of Maxima Minima using second derivative test Part 3: 00:07:00 •Practice Problem of Maxima Minima using second derivative test Part 4: 00:07:00 •Applications of Maxima and Minima Part 1: 00:09:00 •Applications of Maxima and Minima Part 2: 00:07:00 •Applications of Maxima and Minima Part 3: 00:10:00 •Applications of Maxima and Minima Part 4: 00:09:00 •Applications of Maxima and Minima Part 5: 00:10:00 •Applications of Maxima and Minima Part 6: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 1: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 2: 00:09:00 •Past Paper Problems on applications of maxima and minima Part 3: 00:08:00 •Past Paper Problems on applications of maxima and minima Part 4: 00:07:00 •Chain Rule: 00:12:00 •Rate of change part 1: 00:05:00 •Rate of change part 2: 00:10:00 •Rate of change part 3: 00:07:00 •Past Paper Problems using chain rule -1: 00:06:00 •Past Paper Problems using chain rule -2: 00:07:00 •Past Paper Problems using chain rule - 3: 00:07:00 •Past Paper Problems using chain rule - 4: 00:04:00 •Downloadable Resources: 00:00:00 •What is Integration?: 00:12:00 •Practice Questions 1: 00:06:00 •Practice Questions 2: 00:09:00 •Practice Questions 3: 00:09:00 •Fundamental Theorem of Calculus: 00:09:00 •What is Definite Integration?: 00:10:00 •Finding Definite Integration: 00:09:00 •Practice Questions on Definite Integration 1: 00:10:00 •Practice Questions on Definite Integration 2: 00:10:00 •Practice Questions on Definite Integration 3: 00:15:00 •Area below x-axis: 00:12:00 •Practice Problems on Area below x-axis 1: 00:11:00 •Practice Problems on Area below x-axis 2: 00:13:00 •Practice Problems on Area below x-axis 3: 00:09:00 •Practice Problems on Area below x-axis 4: 00:07:00 •Area between two curves (Basics): 00:15:00 •Practice Problems on Area between two curves 1: 00:06:00 •Practice Problems on Area between two curves 2: 00:13:00 •Practice Problems on Area between two curves 3: 00:12:00 •Practice Problems on Area between two curves 4: 00:10:00 •Practice Problems on Area between two curves 5: 00:13:00 •The Reverse Chain Rule- Indefinite Integration: 00:06:00 •The Reverse Chain Rule- Definite Integration: 00:05:00 •Practice Problems on The Reverse Chain Rule: 00:09:00 •Improper Integrals: 00:06:00 •Volumes by Integration: 00:08:00 •Practice Problems on Volumes by Integration-1: 00:04:00 •Practice Problems on Volumes by Integration-2: 00:04:00

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

Ascend to the next level of Excel proficiency with our comprehensive Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course. This in-depth training will equip you with the skills to create sophisticated dashboards using advanced Excel formulas, VBA, and Power Query, empowering you to transform raw data into actionable insights. Master the art of financial modeling with our prepaid expenses models, learning how to calculate amortization schedules and create detailed summaries using Excel formulas. Delve into the power of Power Query to effortlessly manipulate and analyze large datasets, building dynamic dashboards without the limitations of formulas. Learning Outcomes Gain proficiency in creating automated dashboards using advanced Excel formulas, VBA, and Power Query Develop expertise in financial modeling using prepaid expenses models Master the calculation of amortization schedules and prepaid expenses summaries Implement Power Query to manipulate and analyze large datasets Create dynamic dashboards without the limitations of formulas Enhance your Excel skills and data analysis capabilities Why choose this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query course for? Accounting and finance professionals seeking to enhance their Excel skills for financial modeling and dashboard creation Business analysts and data analysts aiming to expand their expertise in data manipulation and visualization Excel enthusiasts interested in mastering advanced Excel formulas, VBA, and Power Query Individuals seeking to create interactive and insightful dashboards for data-driven decision-making Anyone seeking to elevate their Excel skills and become a proficient data analyst Career path Financial Analyst (£35,000 - £55,000) Business Analyst (£40,000 - £60,000) Data Analyst (£45,000 - £65,000) Management Accountant (£40,000 - £60,000) Business Intelligence Analyst (£45,000 - £65,000) Senior Financial Analyst (£50,000 - £70,000) Prerequisites This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Course Outline and Introduction 00:04:00 Minimum Requirements for the Course 00:01:00 Prepayments Introduction 00:01:00 Prepaid Expenses Models: Resources Download Month End Date Prepaid Expenses Amortization Calculation 00:00:00 Exact Prepaid Expenses Payment Date Calculation 00:00:00 Accounting for Prepaid Expenses Prepaid Expenses Accounting Definition: Prepayments 00:03:00 Prepaid Expense Example: How Accounting works for Prepayments 00:03:00 Advantages and Disadvantages of Prepaid Expenses 00:03:00 Excel Formulas Detailed: Introduction to three Excel Models Introduction to PRO Excel Models and Formulas 00:06:00 Date Function 00:05:00 EOMONTH Function 00:04:00 DATEVALUE function 00:03:00 IF Function 00:08:00 IFS Function (Office 365 Only) 00:07:00 VLOOKUP Function 00:07:00 MATCH Function 00:05:00 INDIRECT Function 00:02:00 NAMED Ranges: Name Manager 00:03:00 Advanced Version of VLOOKUP Function 00:07:00 Formula Based Prepaid Expenses Model Introduction to Model and Control Panel Tab (Important Sheet Tab) 00:08:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 1) 00:05:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 2) 00:06:00 Formula Based Prepaid Expenses Model - Deep Dive (Part 3) 00:06:00 IFS Function - Month End date Prepayment calculation 00:04:00 Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary) 00:09:00 Protecting Formulas Cells and Fields in the Model 00:04:00 Calculate Prepaid Expenses Amortisation from Exact Start Date Exact Date Prepaid Amortisation calculation Intro 00:03:00 Formulas update and Model Changes for Exact Prepaid Exps Calculation 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1) 00:04:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2) 00:03:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3) 00:02:00 Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4) 00:07:00 IFS Function - Exact Date Prepayments Amortisation 00:04:00 Data Validation Controls (Enhancing Data Input Controls with Protection) 00:10:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 1) 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (Part 2) 00:09:00 Additional Material: Resources 00:00:00 Prepaid Expenses Summary with Power Query and Pivot Table Power Query and Pivot Table Prepayment Summary Table Intro 00:06:00 What is Power Query and Some Awesome Resources for Power Query learning 00:07:00 Power Query and Pivot Table Summary - Deep Dive (Part 1) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 2) 00:04:00 Power Query and Pivot Table Summary - Deep Dive (Part 3) 00:05:00 Power Query and Pivot Table Summary - Deep Dive (Part 4) 00:09:00 Using Array Formulas to Add Formula Protection 00:04:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1 00:02:00 Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2 00:08:00 Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version) 00:13:00 Advanced VBA Prepaid Expenses Amortisation Model Changing Macros Security in Excel 00:05:00 Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model 00:06:00 Bonus : New Version - Excel VBA Model for Prepayment Expenditure 00:08:00 BONUS: Dynamic Dashboard for Divisional Profit and Loss statements: Easy Way Dynamic Dashboard Overview 00:07:00 Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets 00:08:00 Creating Dynamic Data Validation 00:02:00 Creating Named Ranges for Dynamic Table Arrays 00:03:00 Dynamic Date Column Headings for each Divisional PL Table 00:02:00 Dynamic Month and YTD Dashboard tables headings (PRO TIP) 00:03:00 Dynamic VLOOKUP Formula - Preparing First section of the Dashboard 00:04:00 Creating Rolling Dashboard with Dynamic VLOOKUP Function 00:08:00 IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP) 00:03:00 Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function) 00:05:00 Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit 00:05:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1) 00:03:00 Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2) 00:06:00 Power Query & Pivot Tables based Dashboard without any Formulas, Fully Dynamic Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed 00:05:00 Understanding the data files before building dashboard 00:02:00 Consolidating Reports with Power Query (Get & Transform) , How to install PQ 00:08:00 Dynamic File Path Trick in Power Query with Parameters (Amazing trick) 00:06:00 Conditional Cumulative totals with SUMIFS Function 00:04:00 Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code) 00:06:00 Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise 00:06:00 Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast) 00:08:00 Dashboard Creation - Line Charts 00:08:00 Update Dashboard with Additional Divisional Data with Few Click (Magical) 00:03:00 Thank you Thank you 00:02:00 Ultimate Prepaid Expenditure Model (Super Bonus) 00:02:00 Resources Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 00:00:00 Assignment Assignment - Microsoft Excel: Automated Dashboard Using Advanced Formula VBA Power Query 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Italian Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Italian Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Italian Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Italian Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Italian? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Italian there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Italian course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Italian does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Italian was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Italian is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum ***Complete Italian Course - Beginner*** Learn ltalian : ltalian Course for Beginners (A1 A2 A2+) Learn Italian- Find out all about this course in less than two minutes 00:02:00 Learn Italian - The Alphabet. The Definite Article Learn Italian - The Alphabet. The Definite Article - Part 1 00:14:00 Dictation- Italian Language- Exercise 00:18:00 Learn Italian - The Indefinite Article. The numbers from 0 to 100 Learn Italian - The Indefinite Article. The numbers from 0 to 100 00:19:00 Learn Italian - Present Simple for regular verbs Learn Italian - Present Simple for regular verbs 00:17:00 Learn Italian - Present Simple for irregular verbs. Learn Italian - Present Simple for irregular verbs. 00:17:00 Learn Italian - Present Simple for irregular verbs(II) 00:14:00 Exercises - Dictation 2 00:09:00 Learn Italian - The verb ''to be''-reflexive Learn Italian - The verb 'to be'-reflexive 00:11:00 Learn Italian - Reflexive verbs. Adverbs of frequency Learn Italian - Reflexive verbs. Adverbs of frequency 00:16:00 Learn Italian - At the supermarket. The food Learn Italian - At the supermarket. The food 00:10:00 Learn Italian - Modal verbs Learn Italian - Modal verbs 00:09:00 Learn Italian - Prepositions. Learn Italian - Prepositions. Part 1 00:11:00 Learn Italian - Prepositions. Part 2 00:09:00 Learn Italian - The Adjectives. The numbers Learn Italian - The Adjectives. The numbers11 00:14:00 Learn Italian - Clothes Learn Italian - Clothes 00:10:00 Learn Italian - After and before. Masculine nouns which end in '-ma' Learn Italian - After and before. Masculine nouns which end in '-ma' 00:08:00 Learn Italian - Place adverbs Learn Italian - Possessive pronouns and adjectives. The family 00:10:00 Learn Italian - Place adverbs 00:10:00 Learn Italian - Dialogue: On the phone Learn Italian - Dialogue- On the phone 00:08:00 Learn Italian - Present Perfect. The animals Learn Italian - Present Perfect. The animals 00:13:00 Exercises - Dictation 3 00:12:00 VideoLearn Italian - Present Perfect(II) 00:19:00 Learn Italian - Past Participle. Irregular Verbs. Learn Italian - Past Participle. Irregular Verbs(II) 00:08:00 Learn Italian - Greetings 00:05:00 Learn Italian - Past Participle. Irregular Verbs(II)111 00:08:00 Learn Italian - Past participle. Irregular Verbs(III). Prepositions and 00:11:00 Learn Italian - The weather Learn Italian - The weather 00:09:00 Learn Italian - Parts of the body. At the pharmacy Learn Italian - Parts of the body. At the pharmacy 00:11:00 The adverbs with Present Perfect. The auxiliary verbs ''to be'' and ''to have'' The adverbs with Present Perfect. The auxiliary verbs 'to be' and ' 00:11:00 Learn Italian - Conjunctions Learn Italian - Conjunctions 00:09:00 Learn Italian - Vocabulary: New verbs Learn Italian - Vocabulary- New verbs 00:10:00 Learn Italian - Vocabulary- New verbs(II). The expression 'ce l'ho' 00:10:00 Learn Italian - Dialogue: How did you spend your weekend? Learn Italian - Dialogue- How did you spend your weekend- 00:09:00 Learn Italian - Future Simple Learn Italian - Future Simple 00:12:00 Learn Italian - Future Simple. Irregular Verbs 00:11:00 Learn Italian - The use of Future Simple 00:08:00 Exercises - Dictation 4 00:10:00 Learn Italian - Metterci and volerci Learn Italian - Metterci and volerci 00:11:00 Learn Italian - Recap Learn Italian - Recap 00:17:00 Exercises - Dictation 5 00:08:00 ***Complete Italian Course - Intermediate*** Module : 01 Italian Course For Intermediate - I pronomi diretti oggetto 00:16:00 Italian Course For Intermediate - Utensili 00:06:00 Italian Course For Intermediate - I pronomi indiretti 00:15:00 Italian Course For Intermediate - Esercizi. I mestieri 00:07:00 Italian Course For Intermediate - Il pronome partitivo ne 00:09:00 Italian Course For Intermediate - Dettato 00:08:00 Italian Course For Intermediate - I pronomi diretti e indiretti con verbi modali 00:09:00 Module : 02 Italian Course For Intermediate - La formazione di verbi a partire da aggettivi 00:07:00 Italian For Intermediate - I pronomi diretti e indiretti con il passato prossimo 00:16:00 Italian Course For Intermediate - Altri usi della particella ne 00:05:00 Italian Course For Intermediate - Gli usi di ci 00:08:00 Italian Course For Intermediate - Ce n'è/ce ne sono 00:06:00 Italian Course For Intermediate - Il futuro composto 00:09:00 talian Course For Intermediate - Dettato 2 00:08:00 Module : 03 Italian Course For Intermediate - Gradi di comparazione dell'aggett 00:11:00 Italian Course For Intermediate - L'imperfetto 00:09:00 Italian Course For Intermediate - Ripasso imperfetto e passato prossimo 00:07:00 Italian Course For Intermediate - Il trapassato prossimo 00:06:00 Italian Course For Intermediate - La struttura stare + gerundio 00:06:00 Italian Course For Intermediate - Dettato 3 00:08:00 Italian Course For Intermediate - Gli aggettivi bello e quello 00:07:00 Module : 04 Italian Course For Intermediate - Il pronome relativo cui 00:12:00 Italian Course For Intermediate - Alcuni verbi pronominali 00:06:00 Italian Course For Intermediate - Dialogo. Gli avverbi di modo 00:06:00 Italian Course For Intermediate - Il condizionale semplice 1 00:12:00 Italian Course For Intermediate - Il condizionale semplice 2 00:12:00 Italian Course For Intermediate - Il condizionale composto 1 00:08:00 Italian Course For Intermediate - Il condizionale composto 2 00:11:00 Module : 05 Italian Course For Intermediate - Computer e internet. Vocabolario di base 00:05:00 Italian Course For Intermediate - Dettato 4 00:09:00 Italian Course For Intermediate - L'imperativo 1 00:14:00 Italian Course For Intermediate - L'imperativo 2 00:12:00 Italian Course For Intermediate - Dialogo 00:04:00 Italian Course For Intermediate - Dettato 5 00:09:00 Italian Course For Intermediate - Ripasso 00:30:00