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

7374 Power courses in Cardiff delivered Online

HVAC, Electrical and Fire Safety

4.9(27)

By Apex Learning

Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Give a compliment to your career and take it to the next level. This HVAC, Electrical and Fire Safety bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this HVAC, Electrical and Fire Safety bundle will help you stay ahead of the pack. Throughout the HVAC, Electrical and Fire Safety programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Bundle Consists of the following Premium courses: Course 01: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Course 02: Electricity & Circuit Analysis Level 3 Course 03: PAT Level 4 Course 04: Electric Power Metering for Single and Three Phase Systems Course 05: Energy Saving in Electric Motors Course 06: Electrical and Fire Safety Training - Level 2 Course 07: Digital Electric Circuits & Intelligent Electrical Devices Course 08: Fall Prevention During Working at Height Course 09: Manual Handling Level 2 Course 10: Emergency First Aid and Incident Management at Work Course 11: Time Management As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the HVAC, Electrical and Fire Safety to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Benefits you'll get choosing Apex Learning for this HVAC, Electrical and Fire Safety: One payment, but lifetime access to 11 CPD courses Certificate, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught by expert instructors Get 24/7 help or advice from our email and live chat teams Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificates: Free (Previously it was £10*11= £110) Hard Copy Certificates: Free (Previously it was £20*11= £220) Curriculum of the Bundle Course 01: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician Module 01: Introduction Module 02: Heating Fundamentals and Psychrometrics Module 03: HVAC Systems Module 04: Heating and Ventilation Module 05: Air Conditioning Systems for HVAC Technicians Module 06: Compressors, Water Chillers, and Fans Module 07: Piping for HVAC Technician Module 08: Duct System in HVAC Module 09: Refrigeration and Refrigerants Module 10: Special Applications Module 11: HVAC System Selection Module 12: Safety in the HVAC Industry Course 02: Electricity & Circuit Analysis Level 3 Ch - 00 Intro Basic Electricity Ch - 01 The Nature of Electricity Ch - 02 Conductors & Insulators Ch - 03 Current and Electric Circuits Ch - 04 Ohm's Law Ch - 05 Electric Power Ch - 06 Series & Parallel Circuits Ch - 07 Circuit Theorems Ch - 08 Electric Fields and Capacitance Ch - 09 Magnetism and Inductance Ch - 10 Transient Response Capacitors & Inductors Course 03: PAT Level 4 Module 01: Introduction to PAT Module 02: Relevant Statutory Provisions for PAT Module 03: Risk Assessment Module 04: Reducing and Controlling Risks Module 05: Electrical Units and Appliance Classification Module 06: Initial Visual Examination Module 07: Instruments for Testing and Equipment Inspection Module 08: Electrical Installation Testing Module 09: Safety Precautions in Electrical Testing Module 10: Reporting and Record-keeping Course 04: Electric Power Metering for Single and Three Phase Systems Module 01: Basic Metering Introduction Module 02: Power & Energy Module 03: AC Power Module 04: Instrumentation Module 05: Single Phase Metering Module 06: Instrument Transformers Module 07: Three Phase Metering Module 08: Cross Wattmeter Verification Course 05: Energy Saving in Electric Motors Module 01: Introduction Module 02: Classification Module 03: Terminologies Module 04: Losses Module 05: Energy saving in motors part I Module 06: Energy saving in motors part II Module 07: Energy saving in motors Part III Module 08: Energy saving in motors part IV Module 09: Energy saving in motors part V Module 10: Energy Efficient Motor Course 06: Electrical and Fire Safety Training - Level 2 Module 01: Introduction and Basics Module 02: Introduction to Fire Safety Module 03: Voltage and Resistance Module 04: Capacitance and Capacitors Module 05: Safety Precautions Module 06: Fire Safety Legislation Module 07: Measures of Fire Safety Module 08: Fire Emergency: Evacuation Procedures Course 07: Digital Electric Circuits & Intelligent Electrical Devices Module 01: Introduction Module 02: Numbering Systems Module 03: Binary Arithmetic Module 04: Logic Gates Module 05: Flip-Flops Module 06: Counters & Shift Registers Module 07: Adders Course 08: Fall Prevention During Working at Height Fall Prevention During Working at Height Module 01: Introduction, Regulations and Duties Module 02: Risk Assessment and Prevention Module 03: Work at Height Equipment Course 09: Manual Handling Level 2 Introduction, Legislation and Guidance Manual Handling Hazards and Injuries Manual Handling Risk Assessments Controlling and Reducing the Risks Safe Lifting Techniques Course 10: Emergency First Aid and Incident Management at Work Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 11: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this HVAC, Electrical and Fire Safety bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our HVAC, Electrical and Fire Safety is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various expertise will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

HVAC, Electrical and Fire Safety
Delivered Online On Demand
£53

Electrician: Electricity & Circuit Analysis Course

5.0(2)

By Training Express

The Electrician: Electricity & Circuit Analysis Course is designed to provide an in-depth understanding of electrical systems and circuit analysis. This course delves into the fundamental principles of electricity, exploring concepts such as voltage, current, resistance, and Ohm’s Law. Students will gain a thorough grounding in electrical theory, circuit design, and analysis, enabling them to make sense of complex electrical circuits and systems. Whether you’re starting from scratch or looking to enhance your knowledge, this course offers a structured approach to mastering the key concepts that form the foundation of electrical work. Throughout the course, learners will become well-versed in various analytical methods, including techniques for troubleshooting circuits and understanding their components. With a focus on theory-driven learning, the course equips you with the analytical tools necessary for dissecting and solving electrical challenges. By the end of this course, you will possess the confidence and expertise to interpret electrical diagrams, perform detailed analyses, and approach circuit design with clarity and precision. This is an ideal choice for anyone looking to advance their understanding of electrical systems without the need for physical attendance or hands-on training. Key Features of Electrician: Electricity & Circuit Analysis Bundle CPD Accredited Electrician: Electricity & Circuit Analysis Course Instant PDF certificate Fully online, interactive Electrician: Electricity & Circuit Analysiscourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Electrician: Electricity & Circuit Analysis Bundle course to excel! To become successful in your profession, you must have a specific set of Electrician: Electricity & Circuit Analysis skills to succeed in today's competitive world. In this in-depth Electrician: Electricity & Circuit Analysistraining course, you will develop the most in-demand Electrician: Electricity & Circuit Analysis skills to kickstart your career, as well as upgrade your existing knowledge & skills. Electrician: Electricity & Circuit Analysis Curriculum Course 01: Electrician Course Level 3 Course 02: Electricity and DC Circuit Analysis Course 03: Electric Circuits for Electrical Engineering Course 04: Power Analysis in AC Circuits Course 05: Short Circuit Analysis for HV Three Phase Systems Course 06: Light Current Systems for Electrical Engineering Course 07: High Voltage Generation for Electrical Engineering Course 08: Electrical Machines for Electrical Engineering Course 09: Power Electronics for Electrical Engineering Course 10: MATLAB Simulink for Electrical Power Engineering Course 11: Advanced Electrical Safety Accreditation This Electrician: Electricity & Circuit Analysis bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Electrician: Electricity & Circuit Analysis course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Electrician: Electricity & Circuit Analysis basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Electrician: Electricity & Circuit Analysis Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.

Electrician: Electricity & Circuit Analysis Course
Delivered Online On Demand1 hour
£54

Advanced Parenting Skills Course

4.8(9)

By Skill Up

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

Advanced Parenting Skills Course
Delivered Online On Demand3 hours 45 minutes
£25

Microsoft Excel 2021/365 - Beginner to Advanced

By Packt

A comprehensive and detailed course containing premium beginner, intermediate, and advanced level content. Start with the fundamentals and build a strong foundation before gradually studying Excel 2021's advanced features, formulae, and functions that will help you become a master.

Microsoft Excel 2021/365 - Beginner to Advanced
Delivered Online On Demand30 hours 36 minutes
£56.99

Parenting Skills Mastery Course Advanced

By Study Plex

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 Introduction Goals & First Concepts 00:12:00 The Myth Of “Nothing To It Parenting” 00:31:00 The 2 Phases Of Parenting 00:26:00 The Power Of Mentoring Your Child 00:17:00 Teaching Values They Will Keep 00:13:00 Parenting Basics … And Beyond 00:05:00 Powerful Communication Skills 00:33:00 The Power Of Re-Framing & Building Agreements 00:13:00 WHY Do Kids Do The Things They Do. 00:15:00 The Parent's Pledge 00:16:00 Disciplining The Right Way 00:13:00 The Power of Life Lessons 00:10: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

Parenting Skills Mastery Course Advanced
Delivered Online On Demand
£19

Inclusion Facilitation

By Inclusive Solutions

Inclusion Facilitation (IF) is an approach to enhancing the inclusion, in a mainstream community of any child or young person who is experiencing difficulties in the world because of disability, personal crisis or because of their challenging behaviour towards others. The IF approach works by mobilising the young person’s natural supports to provide support and engage with the person in difficulty. Inclusion Facilitation is designed to create a better life for an individual by the provision of an intense input designed to being about social change. This usually entails a series of visits focused on getting the person out and about to increase confidence, social skills and presence in their local community and to pursue goals and dreams. Uniquely, the work is carried out under the close clinical supervision of a practicing psychologist. What is Inclusion Facilitation Work? ‘We do whatever it takes!’ Usually a Person Centred Planning event would be carried out using the PATHor MAP process – majoring on dreams and goal setting leading to precise action planning.  An experienced psychologist alongside the inclusion facilitator would carry out a PATH. A large graphic will be one of the outcomes of the meetings this is a great visual record and a shared memory of the event. This will also inform the priorities for the inclusion facilitation work Optionally following the PATH event a ‘scoping report’ is created outlining what Inclusion Facilitation could offer and highlighting what dreams and goals the individual has. The PATH is also provides a good opportunity for the Facilitator to meet the focus person in a comfortable positive environment. 12 weekly visits from the Inclusion Facilitator followed by 5 monthly visits is our preferred model but we can be flexible with the delivery of this input. This is just a guideline, however we have received good results using this time frame. After this intensive input the Inclusion Facilitator will hand over to the existing family, carers and PA team to carry on where he or she has left off. This transition time is planned from the outset. An experienced psychologist is there to support the facilitator at all times and will guide all work done by the inclusion facilitator.  Is this just Support work? No! This is proactive engagement – doing whatever is required. We are not just passively or reactively providing what is asked for – we are actively pursuing a good life for the individual. Our work is built on careful research around a person’s interests and what opportunities exist locally. We carry out community mapping.  We actively work to tackle an individual’s own resistance and reluctance to engage more socially. We actively engage with people in social settings that the individual attends to build bridges and connections – we are bridge builders. We build circles around a person. We create the conditions in which friendships can flourish. We have direct psychological supervision and support throughout. This work is short term and intense. Enjoy participating in a multimedia workshop that will challenge, entertain and reach for your emotions. Learning Objectives 1.To be able to understand the values and wider context of inclusion. 2.To be able to set up and run an ‘Inclusion Facilitation project to improve the life chances and connections of a child or young person. 3.To understand and be able to maximise the power of the peer group in supporting relationships, achievement and behaviour. Course Content The course answers the questions: What do you do with the child who is isolated by their aggression and anger, through being different, disabled or new to the school or community? Practically how do we go about including high profile children or young people? How can we help some children be friends? We will cover:  Inclusion values underpinning this work The Intentional Building of Relationships –‘Inclusion Facilitation’ work as an example Not doing it alone – The Importance of Teams in developing inclusive practice Practical setting up and running of IF work Lessons learned Stories of IF work

Inclusion Facilitation
Delivered in UK Wide Travel Costs or OnlineFlexible Dates
£1,800 to £2,500

Medieval History Course

3.5(2)

By Elearncollege

Description Medieval History Diploma  The European Medieval Age is a fascinating period of human history. It spans almost a whole millennium, from the 5th to 15th century, including significant historical events such as the Holy Inquisition, the bubonic plague (Black Death), and the Islamic Golden Era.The Medieval History Diploma course allows one to travel through historical periods stretching from the fall of classical civilizations to the European Renaissance. It also takes one through the geographical areas of Britain, France, Italy, and Jerusalem (Israel). The Medieval Age was full of wars, warriors, artistry, and discovery. The period saw the emergence of new philosophical schools. It also saw the Western world rising from the fall of vast empires and laying the foundation for the exceptional paths that carried them to great discoveries and the Renaissance.This Medieval History Diploma course thoroughly examines every major historical event of the Medieval period from the perspective of the Catholic church's advent and fall. The Medieval History Diploma course starts by introducing the three medieval ages. The introductory classes will teach the reason for the Medieval Era's (Middle Ages) name and the events during this fascinating historical period.After multiple conflicts, the Vikings were magnificent monarchs and rulers who conquered the Anglo-Saxons. The Scandinavian kings governed England for a fascinating time in history.The Medieval History Diploma course also includes the study of the Crusade wars of religions, with a deeper look into how it unfolded and about the great expeditions. It also examines how the Crusade wars facilitated the Catholic church's rise in prestige and power and studies other important figures of the Crusading battlegrounds - rulers, warriors, and specifically, the Order of Solomon's Temple. What you will learn   1:Introduction To The Middle ages  2:Starting Up The Middle ages  3:Forming The Basis Of Europe  4:Early Middle Ages  5:The Origins Of The Crusades  6:Power Struggles And The Second Crusade  7:Other Crusades  8:Domestic Dramas  9:Other Issues In Medieval Europe  10:The End Of The Middle Ages Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Medieval History Course
Delivered Online On Demand9 days
£99

Learn to Master Google Analytics in No Time!

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Learn to Master Google Analytics in No Time! bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Learn to Master Google Analytics in No Time! related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Learn to Master Google Analytics in No Time! bundle will help you build a solid foundation to become a proficient worker in the sector. This Learn to Master Google Analytics in No Time! Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Google Data Studio: Data Analytics Course 2: Diploma in Data Analysis Fundamentals Course 3: Learn How To Optimize Your Google My Business Page In 2016 Course 4: How To Do Keyword Research For SEO & Ranking On Google Course 5: Excel Pivot Tables for Data Reporting Course 6: Research Methods in Business Course 7: Business Intelligence and Data Mining Course 8: Marketing Strategies for Business Course 9: Strategic Planning and Analysis for Marketing Course 10: Digital Marketing for Beginners to Advanced Course 11: Digital Marketing Starting an online E-Commerce Store Course 12: Microsoft Power BI - Master Power BI in 90 Minutes! Course 13: PowerBI Formulas Course 14: Statistical Analysis Course 15: Social Media Marketing-The Step by Step Guide Course 16: Create Your First Responsive Website Course 17: Complete Online Marketing & Advertising Course Course 18: Ultimate Social Media Marketing course Course 19: Python Course Course 20: Data Science & Machine Learning with Python Course 21: Basics of WordPress: Create Unlimited Websites Course 22: The Ultimate SEO Blueprint - Easily Ranking #1 On Google Course 23: Quick Data Science Approach from Scratch Course 24: Fundamentals of Business Analysis Course 25: Excel Data Analysis Course 26: Complete Communication Skills Master Class for Life Course 27: Public Speaking Course 28: Minute Taking Executive Training Course 29: Receptionist Skills Course 30: Time Management Training - Online Course 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Learn to Master Google Analytics in No Time! bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Learn to Master Google Analytics in No Time! Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Learn to Master Google Analytics in No Time! bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Learn to Master Google Analytics in No Time! Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Learn to Master Google Analytics in No Time!
Delivered Online On Demand9 days
£315

Hypno-Oncology Masterclass

5.0(22)

By The Northern College Of Clinical Hypnotherapy

Unlock the transformative power of hypnosis in cancer care with our "Hypno-Oncology Masterclass." Designed for healthcare professionals and hypnotherapists, this comprehensive masterclass offers cutting-edge techniques and insights to enhance patient well-being and improve therapeutic outcomes.

Hypno-Oncology Masterclass
Delivered Online On Demand1 hour
£25

Excel Crash Course

By The Teachers Training

Excel Crash Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Excel Crash Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 03 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Analysis of Twitter Dataset and Designing Heatmaps Introduction to the Excel crash course 00:06:00 Understanding the Twitter Dataset 00:05:00 Extracting Other Details for Analysis 00:09:00 Creating Pivot Tables 00:08:00 Applying Conditional Formatting using Color Scales 00:03:00 Adding Slicers to Dashboard 00:02:00 Applying Custom Number Formats 00:03:00 Adding Custom Images to Charts 00:11:00 Interlude - Data Manipulation Challenge 00:02:00 Adding Heatmap Legend 00:02:00 Wrapping Up - Introduction to Open Analytics 00:02:00 Advanced Currency Converter using Dynamic Arrays Introduction to Modern Excel Tables and Dynamic Arrays 00:11:00 Using Power Query for Data Manipulation 00:08:00 Applying Power Query Data Transformations 00:06:00 Structured Table Referencing 00:12:00 XLOOKUP Function and Pivot Table Calculations 00:05:00 Laundry Service Model and Invoicing Dashboard Introduction to the Project 00:01:00 Overview of the Laundry Model Project 00:04:00 Understanding the Inputs 00:03:00 Formatting the Input Tables 00:04:00 Duplicate and Combine Tables with Power Query 00:09:00 Rounding Digits in Power Query 00:02:00 Load Specific Tables from Power Query 00:02:00 Feature Extraction and Named Ranges 00:10:00 Combining Elements - Data Validation with Named Ranges 00:08:00 Combining Elements - Understanding the INDIRECT Function 00:02:00 Combining Elements - Dynamic Drop-down Menu with Data Validation 00:04:00 Combining Elements - INDEX and MATCH with Multiple Criteria 00:12:00 Understanding the MATCH Formula with Multiple Criteria 00:06:00 Business Invoice Dashboard Design 00:06:00

Excel Crash Course
Delivered Online On Demand2 hours 48 minutes
£27.99