3784 Link courses

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about electrical machines Understand the core competencies and principles of electrical machines Explore the various areas of electrical machines Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert electrical engineer Electrical Machines Online Course for Electrical Engineers - Bundle Course Master the skills you need to propel your career forward in electrical machines. This course will equip you with the essential knowledge and skillset that will make you a confident electrical engineer and take your career to the next level. This comprehensive electrical machines course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this electrical machines course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective electrical machines practice and equip you with the essential skills, confidence and competence to assist you in the electrical machines industry. You'll gain a solid understanding of the core competencies required to drive a successful career in electrical machines. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for electrical engineer or for people who are aspiring to specialise in electrical machines. Enrol in this electrical machines course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive electrical machines course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this electrical machines can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This electrical machines course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This electrical machines course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This electrical machines course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Course Content Introduction to Electric Machines 00:03:00 Types of Electric Machines and Principle of Electricity Generation 00:09:00 DC Machines Importance and Construction of DC Machines 00:26:00 Armature Winding and EMF Equation 00:39:00 Solved Example 1 00:04:00 Solved Example 2 00:03:00 Solved Example 3 00:07:00 Solved Example 4 00:06:00 Separately Excited DC Machine 00:20:00 Shunt and Series DC Machines 00:25:00 Solved Example 1 on Separately Excited DC Machine 00:07:00 Solved Example 2 on Separately Excited DC Machine 00:07:00 Solved Example 3 on Shunt Generator 00:04:00 Solved Example 4 on Shunt Generator 00:06:00 Solved Example 5 on Series DC Generator 00:06:00 Types and Applications of Compound DC Motors 00:07:00 Torque-Speed Characteristics and Speed Control of Separately Excited DC Motor 00:33:00 Torque-Speed Characteristics of Series DC Motor 00:08:00 Solved Example 1 on Speed Control 00:08:00 Solved Example 2 on Speed Control 00:05:00 Starting of DC Machine 00:13:00 Armature Reaction in DC Machines 00:10:00 Losses in DC Machines 00:03:00 Construction of Transformer What is The Construction of Transformer, Importance and Iron Core 00:02:00 Magnetic Circuit Inside Transformer 00:04:00 Windings of Transformer 00:03:00 Why are Windings Made of Copper 00:01:00 Classification of Windings 00:04:00 Insulating Material and Transformer Oil 00:02:00 Conservator of Transformer 00:02:00 Breather of Transformer 00:03:00 Bushings of Transformer 00:04:00 Tap Changer of Transformer 00:03:00 Cooling Tubes of Transformer 00:01:00 Buchholz Relay of Transformer 00:02:00 Explosion Vent In Transformer 00:02:00 Methods of Cooling In Transformer 00:02:00 Types of Transformers 00:02:00 Power Transformer and Distribution Transformer 00:05:00 Single Phase Core Type Transformer 00:04:00 Single Phase Shell Type Transformer 00:04:00 Three Phase Core Type Transformer 00:01:00 Three Phase Shell Type Transformer 00:01:00 Comparison between Shell and Core CSA 00:01:00 Comparison between Shell and Core Type 00:01:00 Notes 00:03:00 Video Explaining The Components in 3D and Real Life 00:04:00 Fundamentals of Magnetic Circuits for Electrical Engineering Introduction to Magnetic Circuits 00:02:00 Induced Emf and Current 00:04:00 Ampere Right Hand Rule 00:04:00 Magnetic Circuit and Important Definitions 00:06:00 Linear and Non Linear Materials 00:02:00 Flux Linkage and Reluctance 00:03:00 Analogy between Electric and Magnetic Circuits 00:05:00 Fringing Effect 00:01:00 Example 1 Magnetic Circuits 00:06:00 Example 2 00:02:00 Example 3 00:05:00 Application on Magnetic Circuit - Transformers 00:03:00 Theoretical Part on Transformers Introduction to Transformers 00:02:00 Construction of Transformer 00:01:00 Theory of Operation 00:04:00 Ideal Transformer 00:04:00 Non Ideal Transformer 00:02:00 Effect of Loading on Transformer 00:03:00 Transformer Regulation 00:02:00 Transformer Losses 00:03:00 Transformer Efficiency 00:04:00 Transformer Rating 00:01:00 Question 1 00:01:00 Question 2 00:01:00 Question 3 00:01:00 Example 1 00:01:00 Voltage Relation of Transformer 00:04:00 Transformer Exact Equivalent Circuit 00:06:00 Concept of Refereeing 00:04:00 Approximate Equivalent Circuit 00:02:00 Synchronous Machines Construction and Principle of Operation of Synchronous Generator 00:29:00 Principle of Operation of Synchronous Motor 00:24:00 Equivalent Circuit and Phasor Diagram of Non Salient Synchronous Machine 00:29:00 Solved Example 1 on Non Salient Machine 00:04:00 Solved Example 2 on Non Salient Machine 00:10:00 Solved Example 3 on Non Salient Machine 00:07:00 Solved Example 4 on Non Salient Machine 00:04:00 Solved Example 5 on Non Salient Machine 00:07:00 Solved Example 6 on Non Salient Machine 00:03:00 Equivalent Circuit and Phasor Diagram of Salient Synchronous Machine 00:38:00 Solved Example 1 on Salient Machine 00:09:00 Solved Example 2 on Salient Machine 00:05:00 Solved Example 3 on Salient Machine 00:09:00 Parallel Operation of Two Generators 00:17:00 Synchronization of Machine with Grid 00:10:00 Induction Machines Construction and Theory of Operation of Induction Machines 00:27:00 Equivalent Circuit and Power Flow in Induction Motor 00:23:00 Torque-Speed Characteristics of Induction Motor 00:19:00 Solved Example 1 on Induction Motor 00:07:00 Solved Example 2 on Induction Motor 00:06:00 Solved Example 3 on Induction Motor 00:06:00 Solved Example 4 on Induction Motor 00:18:00 Solved Example 5 on Induction Motor 00:13:00 Methods of Speed Control of Induction Motor 00:27:00 Methods of Starting of Induction Motor 00:21:00 Solved Example on Motor Starter 00:14:00 Principle of Operation of Doubly Fed Induction Generator 00:11:00 Self Excited Induction Generator 00:08:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 5 hours 57 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about aromatherapy or massage therapy Understand the core competencies and principles of aromatherapy or massage therapy Explore the various areas of aromatherapy or massage therapy Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert aromatherapist or massage therapist Aromatherapy Essential Oils - Natural Beauty Course Master the skills you need to propel your career forward in aromatherapy or massage therapy. This course will equip you with the essential knowledge and skillset that will make you a confident aromatherapist or massage therapist and take your career to the next level. This comprehensive aromatherapy course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this aromatherapy course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective aromatherapy or massage therapy practice and equip you with the essential skills, confidence and competence to assist you in the aromatherapy or massage therapy industry. You'll gain a solid understanding of the core competencies required to drive a successful career in aromatherapy or massage therapy. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for aromatherapist or massage therapist or for people who are aspiring to specialise in aromatherapy or massage therapy. Enrol in this aromatherapy course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive aromatherapy course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this aromatherapy or massage therapy can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This aromatherapy course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This aromatherapy course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This aromatherapy course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:02:00 It Doesn't Get Any Easier Than This 00:04:00 Download The Resources 00:01:00 How This Course Is Structured 00:01:00 Make Sure You Download This PDF File For The Description Box Links 00:02:00 Join The FB Group 00:01:00 What Is Going On Back There? 00:01:00 A Closer Look at The Butter and Oils What Is This Section All About? 00:01:00 Coconut Oil 00:03:00 Allergic To Coconut Oil. Here Is A Great Alternative 00:02:00 We Have Virgin Coconut Oil And Olive Oil. So What Exactly Is Extra Virgin 00:03:00 Olive Oil 00:02:00 Sweet Almond Oil 00:02:00 Castor Oil 00:02:00 Jojoba 00:02:00 Avocado 00:02:00 Beeswax 00:02:00 Vegan Alternatives To Beeswax 00:02:00 Shea Butter 00:02:00 Cocoa Butter 00:02:00 Tamanu Oil 00:01:00 Palm kernel Oil 00:01:00 Rosehip Oil 00:03:00 Hemp Oil 00:01:00 What Do I Do If I Don't Have The Oil Or Butter You Recommend 00:02:00 Getting Started to Make Your Products The Double Boiler- You Can Make Your Own Easily Like I Do 00:01:00 What You Will And Will Not Need To Have 00:01:00 Sanitization For Longer Product Shelf Life 00:01:00 What Is The Comedogenic Scale And Should I Care 00:02:00 Why I Weigh Ingredients Throughout The Course. 00:05:00 How To Price Your Products If You Want To Sell Them 00:05:00 How To Label Your Products For Resale 00:06:00 The Shelf Life Of Your Products. 00:02:00 Make Sure That You Write Things Down 00:01:00 A Word About Using Essential Oils 00:03:00 The Photosensitive Essential Oils That You Need To Be Aware Of 00:04:00 Making Body Butters Introduction To Body Butters, Lip Balms And Hard Deodorants 00:03:00 Scar And Stretch Marks Butter 00:09:00 How To Remodel Scars With Your New Scare And Stretch Mark Butter 00:08:00 A Little Tip With Cleaning Up When Using Beeswax 00:01:00 Anti Inflammatory Pain Relieving Butter 00:09:00 It's Confession Time. 00:05:00 Decadent Skin Nourishing Butter 00:07:00 Whipped Shea Body Butter A.K.A Body Frappé 00:08:00 Orange And Lavender Whipped Stretch Marks And Scar Butter 00:06:00 The World Is Now your Whipped Body Butter Oyster 00:02:00 Frankincense Solid Body Lotion Hearts 00:04:00 Lip Balms and Glosses Disposable Pipettes 00:01:00 It's Time To Make These Awesome Lip Balms! 00:11:00 Lip Balms And Cuticle Balms- Time To Have Fun! 00:02:00 Lip Gloss 00:05:00 Infusing Your Oils With Herbs and Other Awesome Things Coffee Infused Oil- Mocha Anyone 00:05:00 Calendula Herb Infused Oils And Much More-Next Level Benefits. 00:10:00 Four Weeks Later, The Coffee Infused Oil Is Ready To Filter. 00:02:00 Vanilla Infused Jojoba Oil. Ohhhh, Yes Please. 00:02:00 Deodorants How To Make A Solid Deodorant 00:03:00 Foot and Body Scrubs Coconut And Honey Peppermint Foot Scrub 00:03:00 Coconut Foot Scrub Version 2 00:04:00 Orange And Lavender Body Scrub 00:04:00 Facial Cleansers And Masks Nature's Perfect All-In-One Moisturizing Cleanser 00:04:00 The Full Oil Cleansing Facial Sequence 00:08:00 Honey And Oat Kaolin Clay Mask 00:05:00 Yoghurt, Chamomile And Kaolin Clay Mask 00:05:00 Chamomile And Calendula Facial Cleansing Powder And Mask 00:14:00 Toners For your skin Facial Toners, Essential Oils And Solubol 00:04:00 Serums The Basics On How To Make Your Own Serum With Essential Oils For Your Skin Type 00:02:00 How To Make Serums For 3 Skin Types 00:08:00 The Ultimate Rejuvenating Anti-Aging Serum 00:05:00 Scar And Stretch Mark, Face Serum Oil-One Oil Does It All! 00:03:00 Making Your Own body oil Making Your Own Body Oil For Your Skin Type 00:02:00 Making Products for acne Prone Skin and oily Skin Treating Acne With Chemical Free Products 00:06:00 A Great, Simple But Effective 3 Step Product Approach To Treating Acne 00:04:00 Bath (and Shower) time! Exfoliating Coffee Melt And Pour Soap 00:08:00 The 3 Ingredient Shower Wash 00:04:00 Lavender Exfoliating And Moisturizing Shower Scrub Bars 00:06:00 What To Do And NOT To Do When Making Bath Salts 00:09:00 What Dispersants You Can And Can't Use In The Bath And Shower 00:05:00 The Course Wouldn't Be Complete Without Bath Bombs 00:11:00 Castile Soap And It's Many Wonders 00:02:00 Hair Treatments The Amazing Coconut Oil Pre Washing Hair Conditioner 00:08:00 Pre Shaving Oil 00:09:00 Your Natural Shampoo And Conditioners Made Easy 00:01:00 How To Apply Your Essential Oils To Your Shampoo And Conditioners 00:04:00 The Hydrosol Spritz For Dry And Damaged Hair. 00:01:00 Hair Conditioning Treatment. Great For Hair Loss! 00:02:00 Hand sanitizer How To Make Your Own Hand Sanitizer 00:04:00 Perfumes A Roll-On Perfume To Take Anywhere 00:02:00 Final Assessment Assessment - Aromatherapy Essential Oils - Natural Beauty 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Course overview Take a practical approach to enhance your Excel modelling skills with the Advanced Excel Models using Formulas, VBA & Power Query course. In this course, you will learn how to build robust Excel models using Formulas, VBA and Power Query. This Advanced Excel Models using Formulas, VBA & Power Query course offers a wide range of training modules to enhance your abilities to create better models. You will discover the advanced Excel formulas to prepare reports, forecast and perform mathematical calculations. We will introduce you to the three excel models and show the functions used to prepare these pro models. In addition, you will learn the Excel formulas for prepaid expenses and explore the steps to create dynamic dashboards based on Power Query and Pivot Table without any formula. Learning outcomes Familiarize yourself with the advanced Excel formulas Be able to manage prepaid expenses Deepen your understanding of the prepaid expense models Learn about the pro Excel models and formulas Strengthen your knowledge of Power Query and PowerPivot Learn how to create Power query and pivot table based dashboard without any formula Who Is This Course For? This Advanced Excel Models using Formulas, VBA & Power Query course is recommended to anyone interested in learning how to prepare robust Excel models using advanced formulas, Power Query and VBA. In addition, the skills gained from this training will provide excellent opportunities for career advancement. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over. Good understanding of English language, numeracy and ICT skills are required to take this course. Certification After you have successfully completed the course, you will obtain an Accredited Certificate of Achievement. And, you will also receive a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy for £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why Choose Us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos and materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; United Kingdom & internationally recognized accredited qualification; Access to course content on mobile, tablet and desktop from anywhere, anytime; Substantial career advancement opportunities; 24/7 student support via email. Career Path The Advanced Excel Models using Formulas, VBA & Power Query Course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as: Data Analyst System Support and Reporting Analyst 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 Thankyou 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 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Explore the role of a Risk and Compliance Manager in ensuring organizational integrity and regulatory adherence. Learn how these professionals navigate complex landscapes, mitigate risks, and implement effective compliance strategies to safeguard businesses. Discover key skills and responsibilities essential for success in this critical position.

Elevate your career in animal care with our Advanced Diploma in Veterinary Care Assistant - Level 3. Gain comprehensive knowledge and practical skills in veterinary science, patient care, and medical procedures. This accredited program equips you with the expertise to excel as a Veterinary Care Assistant, making a positive impact in the health and well-being of animals. Enroll now for a rewarding journey in the field of veterinary care

Criminal Intelligence and Crime Analysis: Explore the dynamic field where data-driven insights intersect with law enforcement. Uncover the latest techniques and technologies used to analyze criminal behavior, enhance investigative strategies, and foster safer communities. Gain a deep understanding of intelligence gathering, risk assessment, and proactive crime prevention. Elevate your skills in the pursuit of justice with our comprehensive resources and expertise in Criminal Intelligence and Crime Analysis.

Unlock the power of Strategic Planning and Analysis for Marketing success with our comprehensive guide. Learn how to formulate data-driven strategies, analyze market trends, and optimize your marketing efforts for maximum impact. Elevate your business game with proven techniques and expert insights to stay ahead in today's dynamic market landscape. Discover the key to strategic marketing excellence and drive results that resonate with your target audience. Explore our resource now and transform your marketing approach into a strategic powerhouse.

Transform lives as a Home-Start Volunteer! Join our dedicated team to make a positive impact on families in need. Support and empower parents, offering a helping hand through challenging times. Become a beacon of hope as a Home-Start Volunteer today.

Unlock a world of scientific discovery with our Laboratory Technician Diploma. Gain hands-on experience and essential skills in laboratory procedures, analytical techniques, and scientific instrumentation. Prepare for a rewarding career in the exciting field of laboratory science. Enroll now for comprehensive training and a pathway to becoming a proficient laboratory technician.

Explore essential child care skills with our comprehensive course on Safeguarding & Child Protection. Gain insights into crucial protocols, best practices, and legal frameworks to ensure the safety and well-being of children in various care settings. Enroll now for expert guidance and certification.