47107 Courses in Cardiff delivered On Demand

Overview This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Excel Sheet Comparison with VBA is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 23 lectures • 02:10:00 total length •Introduction to Compare Data Workbook: 00:06:00 •Download Resources: 00:00:00 •Key requirements for Comparing any Datasets or Worksheets: 00:03:00 •Tool to Compare Datasets or Worksheets: 00:06:00 •Overview of Compare Data Workbook: 00:09:00 •Most Important things to remember before you use compare data workbook: 00:03:00 •IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00 •Deep Dive into Compare Data Workbook's Environment: 00:10:00 •How to Change Header Rows for your data: 00:06:00 •Basics of Using macro enabled Excel files and Code Modules: 00:04:00 •Changing the Main two sheets name, variance tags in VBA Code: 00:05:00 •Changing various elements across VBA Code modules: 00:05:00 •Clear Sheet data button VBA Code: 00:04:00 •Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00 •Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00 •Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00 •IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00 •Conclusion: 00:01:00

Overview This Microsoft Excel Course for Everyone - Complete Excel Course is your passport to spreadsheet mastery.Explore Excel in detail and improve your abilities with practical activities that go beyond boring lectures. Take on spreadsheets like an expert, from data entry to difficult formulas and eye-catching graphics. But the magic doesn't end there! After finishing successfully, you'll not only impress with your proficiency with Excel, but you'll also obtain a respected CPD certification to enhance your CV and make a statement in the job market. Consider it your golden ticket to go up in your job!Enrol right away to see how your confidence and chances rise! Don't wait! 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 Microsoft Excel Course for Everyone - Complete Excel Course. It is available to all students, of all academic backgrounds. Requirements Compatible with a wide range of gadgets, including smartphones, tablets, laptops, Macs, and PCs. Particularly designed to be easily accessed with an internet connection on tablets and smartphones. No strict deadlines; learn whenever it's convenient for you. Individuals with basic English proficiency. Career Path After completing this course, it will increase the value of your CV and open you up to multiple sectors, such as : Data Analyst: £25,000 - £50,000 per year Financial Analyst: £30,000 - £60,000 per year Operations Manager: £35,000 - £70,000 per year Accountant: £25,000 - £50,000 per year Business Intelligence Analyst: £35,000 - £65,000 per year These salary ranges can vary based on factors such as experience, location, and the specific industry of the business. Course Curriculum 15 sections • 80 lectures • 06:51:00 total length •Introduction: 00:03:00 •Course Curriculum: 00:04:00 •Getting started on Windows, macOS, Android, and IOS: 00:01:00 •How to ask great questions: 00:02:00 •FAQ's: 00:01:00 •Starting Excel: 00:04:00 •Introduction: 00:02:00 •Worksheet basics: 00:22:00 •Entering values and formulas: 00:12:00 •Data formats: 00:10:00 •Data handling basics - cut copy and paste: 00:07:00 •Save and print in excel: 00:10:00 •Excel Ranges: 00:05:00 •Introduction: 00:01:00 •Basic formula operations: 00:06:00 •Mathematical functions level 1: 00:20:00 •Mathematical functions level 2: 00:12:00 •Text functions level 1: 00:09:00 •Text functions level 2: 00:13:00 •Logical functions: 00:11:00 •Date time functions: 00:06:00 •V Lookup formula: 00:12:00 •HLookup formula: 00:04:00 •HLookup + Match formula: 00:09:00 •Match + Index formula: 00:05:00 •Introduction: 00:02:00 •XLookup: 00:08:00 •Handling #NA and Approximates match in XLookup: 00:11:00 •Wildcard matching in XLookup: 00:06:00 •Introduction: 00:02:00 •Split text into columns: 00:07:00 •Flash Fill: 00:07:00 •Remove Duplicates: 00:08:00 •Data Validation: 00:07:00 •Get- import Data from Text: 00:06:00 •Get - import Data from CSV: 00:03:00 •Introduction: 00:01:00 •Formatting Font: 00:04:00 •Formatting Alignment: 00:06:00 •Formatting Number: 00:05:00 •Formatting Date: 00:03:00 •Formatting tables: 00:05:00 •Introduction: 00:01:00 •Creating Pivot Table: 00:07:00 •Value field settings: 00:04:00 •Number format: 00:02:00 •Pivot Table Design: 00:03:00 •Excel Exercise: 00:01:00 •Solution for Excel Exercise: 00:02:00 •Introduction: 00:01:00 •Excel Charts - Categories: 00:03:00 •Elements of a chart: 00:04:00 •Easy way to create charts: 00:02:00 •Column or Bar charts: 00:04:00 •Formatting charts: 00:04:00 •Line charts: 00:02:00 •Area charts: 00:02:00 •Pie and Doughnut charts: 00:04:00 •Format AreaPlot or XY chart: 00:08:00 •Scatter or bubble charts: 00:02:00 •Introduction: 00:01:00 •Frequency Distribution and Histograms: 00:04:00 •Waterfall charts: 00:02:00 •Hierarchy charts: sunburst and tree map: 00:03:00 •Combination charts: 00:02:00 •Sparklines: 00:05:00 •Pivot charts: 00:02:00 •Maps chart: 00:04:00 •3D Maps chart: 00:03:00 •Introduction: 00:01:00 •Stock charts: 00:02:00 •Radar charts: 00:02:00 •Surface charts: 00:02:00 •Heat maps: 00:04:00 •Named ranges: 00:05:00 •Indirect Name range Function: 00:06:00 •Import Data table from PDF file - Excel 2021: 00:04:00 •Import Data from Website - Excel 2019 above: 00:09:00 •Project: Sales forecast tracker: 00:07:00 •Product Sale Tax invoice: Tax Calculations: 00:05:00

Overview Metaphysics is a fascinating field of study that has been around for centuries. It is the branch of philosophy & in this course, you'll explore the fundamental nature of reality, including the relationship between mind and matter, existence, causality, and more. The study of metaphysics is intellectually stimulating and has practical applications in various industries. Metaphysics, often regarded as the cornerstone of philosophical exploration, delves into the fundamental questions of existence. This meticulously crafted course comprises eight modules that weave through the intricacies of metaphysical thought, from the core subjects to the history, the supernatural, and beyond.  As a top-reviewed, recently updated, and trending course, Metaphysics offers an unparalleled learning experience. Enrol today and venture on a journey of intellectual exploration that will transform your perception of the world. 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 Metaphysics. It is available to all students, of all academic backgrounds. Requirements Our Metaphysics 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 8 sections • 8 lectures • 04:02:00 total length •Introduction to Metaphysics: 00:30:00 •Core Subjects of Metaphysics: 00:32:00 •History of Metaphysics: 00:30:00 •Fundamental Questions of Existence: 00:30:00 •New Age Movement and Metaphysics: 00:30:00 •Metaphysics and the Supernatural: 00:30:00 •Metaphysics, Religion and Occultism: 00:30:00 •Other Metaphysical Concepts: 00:30:00

Overview This comprehensive course on Sales Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Sales Training 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 Sales Training. It is available to all students, of all academic backgrounds. Requirements Our Sales Training 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 9 sections • 24 lectures • 01:30:00 total length •Preview of Course: 00:01:00 •Introduction: 00:04:00 •Introduction to Action Plan: 00:02:00 •Belief Part 1: 00:04:00 •Belief Part 2: 00:03:00 •Belief Part 3: 00:04:00 •Belief Reinforcement: 00:03:00 •Belief Chapter (Written Context from the Sales Pro Book): 00:12:00 •Belief Cartoon Story: 00:06:00 •Celebrity Moment: 00:02:00 •Belief Action Plan: 00:04:00 •Authenticity: 00:05:00 •Celebrity Moment: 00:01:00 •Establishing Trust Part 1: 00:03:00 •Establishing Trust Part 2: 00:08:00 •Selling Results Part 1: 00:07:00 •Selling Results Part 2: 00:02:00 •Animation Selling Results: 00:01:00 •Selling Results Cartoon Story: 00:02:00 •Selling Value: 00:02:00 •Matching Benefits & Adding Value: 00:03:00 •Experience of Value: 00:07:00 •It Is Time To Take Action!: 00:04:00 •Assignment - Sales Training: 00:00:00

Overview This comprehensive course on Sales & Selling Management Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Sales & Selling Management Course 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? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Sales & Selling Management Course. It is available to all students, of all academic backgrounds. Requirements Our Sales & Selling Management Course 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 1 sections • 10 lectures • 01:44:00 total length •Module 01: Understanding the Talk: 00:11:00 •Module 02: Getting Prepared to Make the Call: 00:08:00 •Module 03: Creative Openings: 00:08:00 •Module 04: Making Your Pitch: 00:11:00 •Module 05: Handling Objections: 00:10:00 •Module 06: Sealing the Deal: 00:11:00 •Module 07: Following Up: 00:14:00 •Module 08: Setting Goals: 00:10:00 •Module 09: Managing Your Data: 00:10:00 •Module 10: Using a Prospect Board: 00:11:00

Overview This comprehensive course on Rotating Machines will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Rotating Machines 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 Rotating Machines. It is available to all students, of all academic backgrounds. Requirements Our Rotating Machines is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 9 lectures • 07:30:00 total length •Module 01: Introduction to Rotation Machines: 00:06:00 •Module 02: Review of Machinery Principles: 00:43:00 •Module 03: DC Machines: 01:11:00 •Module 04: AC Machinery Fundamentals: 01:49:00 •Module 05: 3 Phase Induction Motor: 01:07:00 •Module 06: Synchronous Generator/Motors Part 1: 01:14:00 •Module 07: Synchronous Generator/Motors Part 2: 00:48:00 •Module 08: Synchronous Generator/Motors Prob-Sol.keyc: 00:32:00 •Assignment - Rotating Machines: 00:00:00

Overview This comprehensive course on Risk Assessment Training Online will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Risk Assessment Training Online 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 Risk Assessment Training Online. It is available to all students, of all academic backgrounds. Requirements Our Risk Assessment Training Online 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 15 sections • 15 lectures • 05:26:00 total length •Introduction to Risk Assessment: 00:20:00 •Risk Assessment at Workplace: 00:15:00 •Risk Management Process: 00:12:00 •Benefits of Risk Management: 00:12:00 •Health & Safety Risk Assessment and Common Risks: 00:18:00 •Work Equipment Hazards and Risk Control: 00:21:00 •Electrical Risk Assessment: 00:26:00 •Reducing and Controlling Electrical Risks: 00:24:00 •COSHH Risk Assessments: 00:39:00 •Control Measures and Monitoring COSHH Risk: 00:29:00 •Risk Factors of Asbestos: 00:20:00 •Surveys and Risk Assessment of Asbestos: 00:15:00 •Manual Handling Risk Assessments: 00:20:00 •Controlling and Reducing the Risks of Manual Handling: 00:28:00 •Working at Height Risk Assessment and Prevention: 00:27:00

Overview Prove you are a dedicated and ambitious Retail Worker by completing your full education in this dynamic business sector. This course presents the principles, regulations, and customer expectations that will drive you to become an outstanding member of the Retail Industry. The Retail Operations Training Level 3 course has been constructed with the assistance of professionals and explains the different aspects of Retailing and the UK Consumer Market. You will be coached on dealing with complaints, enhancing the selling process, promoting excellent customer service, and an understanding of UK laws and regulations regarding retail. For the complete learning package for any shop working, sign up today. 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 Retail Operations Training Level 3. It is available to all students, of all academic backgrounds. Requirements Our Retail Operations Training Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 14 lectures • 03:25:00 total length •Module 1: Introduction to Retail Associate: 00:15:00 •Module 2: Qualities of a Retail Associate: 00:23:00 •Module 3: Retail Psychology: 00:12:00 •Module 4: Importance of Consumer Behaviour: 00:10:00 •Module 05: The Importance of Communicating with Customers: 00:18:00 •Module 06: Taking Trends and Targeting Customers Effectively: 00:10:00 •Module 07: The Sales Process and Dealing with Customers at the Checkout: 00:10:00 •Module 08: Consumer Rights Act: 00:16:00 •Module 09: Introduction to Visual Merchandising: 00:16:00 •Module 10: In-Store Design: 00:18:00 •Module 11: Exterior Design: 00:20:00 •Module 12: Health & Safety for Retail Stores: 00:20:00 •Module 13: Management Skills for Leading Your Team: 00:17:00 •Assignment - Retail Operations Training Level 3: 00:00:00

Overview This comprehensive course on Read Construction & Structural Drawing Like Expert will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Read Construction & Structural Drawing Like Expert 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 Read Construction & Structural Drawing Like Expert. It is available to all students, of all academic backgrounds. Requirements Our Read Construction & Structural Drawing Like Expert 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 2 sections • 32 lectures • 12:14:00 total length •Reading The Architectural Plan of G+3 Residential Building & Planning It: 00:36:00 •Understanding To Read Footing Layout drawing Of G+3 Building: 00:31:00 •Learn to Read Footing Schedule and Reinforcement Drawing of G+3 Building: 00:24:00 •How Combined Footing Reinforcement Is given practically at Site & What is Chair: 00:26:00 •Learn To Read Column Layout & Column Schedule Drawings of G+3 Building: 00:14:00 •Learn to Read Column Reinforcement & Column Lateral Ties & SP-34 Detailing: 00:49:00 •Video Explaining depth of footing, PCC, Development Length & Column Placing: 00:16:00 •What is Vastu & How this G+3 Building Is planned According to vastu Theory: 00:38:00 •Plinth Beam Layout, How to Frame Plinth Beam layout & Understand Reinforcement: 00:20:00 •Practical Video of Plinth Beam Reinforcement, Shuttering & Concreting: 00:07:00 •Learn First Floor Shuttering Layout & Slab Centering Layout with Site Videos: 00:19:00 •Learn to Read 1st Floor Beam Reinforcements of a G+3 Residential Building: 00:24:00 •Practical Video Of Beam Reinforcement and Extra Bar Provided in Beam R/F: 00:06:00 •Difference Between 1-way Slab & 2-way Slab: 00:35:00 •Practical Video of How Crank Bars are Put Up In The Slab: 00:22:00 •Theory of 2 way Slab & Its Importance & How it is Provided Practically at Site: 00:32:00 •Learn to Read slab 1st Floor Slab Reinforcement Details & Slab practical Video: 00:26:00 •Second Floor Shuttering Layout & Minor Changes With Respect to 1st Floor Layout: 00:18:00 •Second Floor Beam Details & Theory Behind Extra Bar at Support ( MUST WATCH ): 00:29:00 •Second Floor Slab Details & Theory Behind Simply Supported & fixed Support Slab: 00:25:00 •Third-floor Slab shuttering Layout, Beam Details & Slab Reinforcement Details: 00:11:00 •Terrace Floor Plan & Head Room Architectural & Structural Details.: 00:13:00 •Learn How the G+3 Residential Building is Modeled On E tabs Software: 00:15:00 •How to Define Beam, Column & Slab Sizes in the Etabs Model: 00:23:00 •How Dead Load & Live loads are calculated practically and Applied On The Slab: 00:28:00 •How to Apply Wall load on Beams & How to calculate Wall Load Manually: 00:22:00 •How to Create Load Pattern & Load Combinations in Etabs: 00:21:00 •How to check Footing Reaction & How to Size the footing Using excel Sheets: 00:39:00 •Check Bending Moment of Beam & understand it with Structural drawings: 00:16:00 •Detailing of Beam from Etabs Results & Excel Sheet Values: 00:19:00 •Detailing Of Stirrups, Spacing between stirrups & Logic Behind Providing Them: 00:17:00 •Column Detailing Manually & with Excel Sheet from Etabs Results: 00:13:00

Overview This comprehensive course on Quantity Surveyor will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Quantity Surveyor comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Quantity Surveyor. It is available to all students, of all academic backgrounds. Requirements Our Quantity Surveyor is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 11 lectures • 03:52:00 total length •Quantity Survey: An Introduction: 00:18:00 •Development of the Quantity Surveyor: 00:15:00 •Quantity Surveying Measurement: 00:47:00 •Cost Management: 00:22:00 •Pricing and Operational Estimation: 00:25:00 •Contract Management and Tendering: 00:31:00 •Procurement and Bill Preparation: 00:27:00 •Predicting Potential Risk and Management: 00:14:00 •Regulation and Control: 00:18:00 •Report Writing: 00:15:00 •Assignment - Quantity Surveyor: 00:00:00