Overview This comprehensive course on Mental Health with Positive Psychology will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Mental Health with Positive Psychology 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 Mental Health with Positive Psychology. It is available to all students, of all academic backgrounds. Requirements Our Mental Health with Positive Psychology 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 6 sections • 48 lectures • 07:48:00 total length •Introduction to Positive Psychology: 00:02:00 •Overview of the Course: 00:02:00 •What is Positive Psychology?: 00:09:00 •Health Model: 00:03:00 •IAC Model: 00:09:00 •Uncovering Automatic Thoughts: 00:04:00 •Understanding Feedback Loops: 00:04:00 •Learned Optimisation: 00:24:00 •Positive Thinking: 00:19:00 •Limited Thinking Patterns: 00:24:00 •Positive Attitude New: 00:13:00 •Self-Image Selection New: 00:01:00 •Concept of Self Image: 00:05:00 •Experience Changes Self Image: 00:03:00 •Synthetic Experience: 00:08:00 •Experiences Prove: 00:01:00 •Self-Consistency & Association: 00:05:00 •Power of Suggestion: 00:07:00 •Perception Reality: 00:05:00 •Goal Striving Beings: 00:04:00 •Let the Dog Sleep: 00:04:00 •Habit of Happiness: 00:05:00 •Success Mechanism: 00:04:00 •Failure Mechanism: 00:03:00 •Unlock Real Personality: 00:05:00 •Mind Room: 00:02:00 •Becoming Alive: 00:06:00 •Getting the Winning Feeling: 00:02:00 •For Past: 00:03:00 •For Present: 00:02:00 •For Future: 00:01:00 •Other Areas and Role Playing: 00:03:00 •Introduction: 00:06:00 •Understanding Sleep: 00:28:00 •Drive for Deep Sleep: 00:08:00 •Sleep Schedule: 00:06:00 •Quite Your Mind: 00:09:00 •Buffer Zone: 00:12:00 •Relaxation Exercises: 00:02:00 •Abdominal Breathing: 00:04:00 •PMR: 00:06:00 •Cue Controlled Relaxation: 00:02:00 •Visualization: 00:04:00 •Think like a Good Sleeper: 00:09:00 •Focus on Day: 00:12:00 •Essentialism: 02:47:00 •Conclusion: 00:01:00 •Assignment - Mental Health with Positive Psychology: 00:00:00
Overview This comprehensive course on Workshop Technology: Machine Shop Theory will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Workshop Technology: Machine Shop Theory 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test 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 Workshop Technology: Machine Shop Theory. It is available to all students, of all academic backgrounds. Requirements Our Workshop Technology: Machine Shop Theory 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 9 sections • 41 lectures • 02:20:00 total length •Scope of the Course: 00:10:00 •Metal Cutting Processes: 00:02:00 •Cutting Tools: 00:03:00 •Nomenclature of Single Point Cutting Tool: 00:04:00 •Tool Signature: 00:02:00 •Mechanics of Metal Cutting: 00:04:00 •Types of Chips: 00:03:00 •Coolant or Cutting Fluids: 00:03:00 •Types of Lathe Machine: 00:09:00 •Construction of A Lathe: 00:09:00 •Accessories and Attachments: 00:07:00 •Specification of Lathe: 00:02:00 •Lathe Operations: 00:02:00 •Taper and Taper Turning: 00:04:00 •Thread Cutting: 00:03:00 •Cutting Speed and Feed: 00:02:00 •Construction of A Drilling Machine: 00:04:00 •Types of Drilling Machine: 00:09:00 •Types of Drills: 00:03:00 •Twist Drill Geometry: 00:04:00 •Drilling Operations: 00:05:00 •Size of Drilling Machine: 00:01:00 •Cutting Speed and Feed: 00:02:00 •Working Principle: 00:03:00 •Types of Shaper: 00:01:00 •Parts of Shaper: 00:05:00 •Shaper Mechanism: 00:04:00 •Shaper Operations: 00:01:00 •Types of Planer: 00:01:00 •Working Principle: 00:02:00 •Difference Between Shaper and Planer: 00:02:00 •Principle Parts of Slotter: 00:03:00 •Slotter Operations: 00:02:00 •Working Principle: 00:02:00 •Milling Methods: 00:03:00 •Types of Milling Cutters: 00:01:00 •Types of Milling Machines: 00:07:00 •Size of Milling Machine: 00:01:00 •Indexing and Dividing Head: 00:02:00 •Milling Operations: 00:03:00 •Assignment - Workshop Technology: Machine Shop Theory: 00:00:00
Overview This comprehensive course on TikTok Marketing for Business will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This TikTok Marketing for Business 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test 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 TikTok Marketing for Business. It is available to all students, of all academic backgrounds. Requirements Our TikTok Marketing for Business 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 8 sections • 25 lectures • 00:59:00 total length •Unit 1: Introduction to the TikTok Platform & Ecosystem: 00:02:00 •Unit 2: Optimal Account Setup: 00:02:00 •Unit 3: How to Find Your Niche Market in the TikTok Demographics: 00:04:00 •Unit 1: How the Algorithm Works: 00:04:00 •Unit 2: How to Get a 'Creator' Account: 00:02:00 •Unit 3: What Analytics to Pay Attention to: 00:02:00 •Unit 1: The 'Livestream' Feature: 00:02:00 •Unit 2: The 'For You' Page: 00:02:00 •Unit 3: The 'Discover' Page: 00:02:00 •Unit 4: Analytics: 00:02:00 •Unit 1: Make Money on Live Feature: 00:03:00 •Unit 2: Best Products to Sell on the Platform, & How to Sell Them: 00:02:00 •Unit 3: Requesting Link in Bio Feature: 00:02:00 •Unit 4: How to Get Brand Deals: 00:06:00 •Unit 5: Licensing Your Content: 00:02:00 •Unit 6: Sell Your Products & Services: 00:02:00 •Unit 1: How to Optimise Your Account: 00:02:00 •Unit 2: Best Camera & Audio Set Up: 00:02:00 •Unit 1: How to Create Targeted Content: 00:02:00 •Unit 2: Types of Content to Create for Your Audience: 00:02:00 •Unit 3: How to Increase Engagement with Your Community: 00:02:00 •Unit 1: What is Virality: 00:03:00 •Unit 2: How to Create Viral Loops in Your Content: 00:02:00 •Unit 3: Best Type of Content for Virality: 00:03:00 •Assignment - TikTok Marketing for Business: 00:00:00
Overview This comprehensive course on Cupping Massage Therapy Masterclass will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Cupping Massage Therapy Masterclass 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 Cupping Massage Therapy Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Cupping Massage Therapy Masterclass 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 16 sections • 41 lectures • 01:45:00 total length •Top 3 Benefits of Cupping: 00:03:00 •A Brief History of Cupping: 00:05:00 •A Word About Cupping Marks: 00:03:00 •Cupping Contraindications: 00:05:00 •Supplies and Room Set Up: 00:05:00 •Applying and Removing The Sllicone Cups: 00:01:00 •Light Friction Without Suction: 00:01:00 •Single Paraspinal Release: 00:01:00 •Double Paraspinal Release: 00:01:00 •Single Cup Lift and Twist: 00:01:00 •Double Cup Lift & Twist: 00:01:00 •Rib Release with Breath: 00:01:00 •Reverse Cross Fiber Friction: 00:01:00 •Trigger Point Release: 00:01:00 •Suction Release: 00:01:00 •Plunger Method: 00:01:00 •Popping Method: 00:01:00 •Cupping in Side lying Position: 00:02:00 •Reverse Pin & Stretch for the Neck: 00:02:00 •Reverse Pin & Stretch for the Shoulders: 00:01:00 •Reverse Pin & Stretch for Pecs: 00:01:00 •Reverse Pin & Stretch for Biceps: 00:01:00 •Reverse Pin & Stretch for Subscapularis: 00:01:00 •Reverse Pin & Stretch for Hamstrings: 00:04:00 •Active Cupping: 00:02:00 •Lymphatic Cupping for Back: 00:01:00 •Flash Cupping: 00:03:00 •Stationary Cupping: 00:02:00 •Cupping for Rotator Cuff: 00:04:00 •Cupping for the Forearms: 00:07:00 •Cupping for the Hips: 00:08:00 •Reverse Pin & Stretch for the Hamstrings and IT Band: 00:04:00 •Cupping for the Calves: 00:04:00 •Cupping for Plantar Fasciitis: 00:02:00 •Cupping for the Adductors: 00:02:00 •Cupping for the Quads: 00:03:00 •Cupping for Knee Pain: 00:03:00 •Cupping for Shin Splints: 00:04:00 •Massage Cupping Techniques for Shin and Calves: 00:06:00 •Safety and Sanitation of Cups: 00:05:00 •Assignment - Cupping Massage Therapy Masterclass: 00:00:00
Overview This comprehensive course on ITIL Practitioner will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This ITIL Practitioner 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 ITIL Practitioner. It is available to all students, of all academic backgrounds. Requirements Our ITIL Practitioner 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 9 sections • 52 lectures • 07:37:00 total length •Course Introduction!: 00:14:00 •Learning Objectives: 00:06:00 •Selecting a Management System: 00:11:00 •Systems Thinking: 00:13:00 •The 4Ps: 00:14:00 •Communication & Management Systems: 00:14:00 •Organizational Capabilities: 00:10:00 •Adopt, Adapt & Realize: 00:15:00 •Outside-in vs Inside-out Thinking: 00:11:00 •Defining a Service: 00:05:00 •Metrics & Measurement: 00:07:00 •Improvement, the Practitioner & CSI: 00:10:00 •Driving IT Service Management Summary: 00:15:00 •Checkpoint: 00:16:00 •Learning Objectives: 00:04:00 •Principles: 00:24:00 •Themes: 00:09:00 •Principles & Themes in Practice: 00:08:00 •Principles & Themes Summary: 00:03:00 •Checkpoint: 00:07:00 •Learning Objectives: 00:02:00 •Role & Impact of OCM on Improvement: 00:07:00 •OCM Activities: 00:16:00 •OCM & Systems Thinking: 00:06:00 •OCM Summary: 00:05:00 •Checkpoint: 00:10:00 •Learning Objectives: 00:01:00 •Value, Importance & Benefit of Good Communication: 00:05:00 •Principles of Communication: 00:11:00 •Role of Influence: 00:07:00 •Communication Summary: 00:05:00 •Checkpoint: 00:09:00 •Learning Objectives: 00:02:00 •CSFs, KPIs & Improvement: 00:18:00 •Analyze CSFs & KPIs in Context: 00:09:00 •Assessments: 00:04:00 •Use Metrics & Measurement Summary: 00:05:00 •Design a Report: 00:07:00 •Checkpoint: 00:08:00 •Learning Objectives: 00:02:00 •It Depends: 00:09:00 •Approach Deconstructed: 00:25:00 •Goal Question Metric (GQM) Approach Introduction: 00:08:00 •CSI Approach Summary: 00:05:00 •Checkpoint: 00:07:00 •Learning Objectives: 00:01:00 •CSI Approach for the ITIL Practitioner: 00:07:00 •CSI Approach in ITIL: 00:25:00 •CSI Approach, PRINCE2 & RESILIA: 00:06:00 •Integrating CSI with ITIL & Beyond Summary: 00:03:00 •Checkpoint: 00:06:00 •Workbooks - ITIL Practitioner - Video Training Course: 00:00:00
Overview This comprehensive course on QGIS Cartography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This QGIS Cartography 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 QGIS Cartography. It is available to all students, of all academic backgrounds. Requirements Our QGIS Cartography 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 9 sections • 44 lectures • 03:58:00 total length •Introduction: 00:01:00 •Labeling Basics: 00:03:00 •Labeling - Text Properties: 00:02:00 •Label Formatting: 00:06:00 •Label Buffers: 00:04:00 •Labels - Backgrounds: 00:03:00 •Labeling Callouts (Leader Lines): 00:03:00 •Labels - Placement: 00:04:00 •Labels - Rendering: 00:05:00 •Labeling Over Orthos: 00:06:00 •Fine Tuning Labels: 00:03:00 •Styling Single Points Lines and Polygons: 00:11:00 •Styling Categorical Data: 00:08:00 •Styling Graduated Data: 00:04:00 •Shapeburst Fills: 00:03:00 •Texture Fills: 00:04:00 •Inverted Polygons: 00:03:00 •Advanced Lines: 00:08:00 •XYZ Tile Basemaps: 00:04:00 •Getting Data from the OSM Website: 00:07:00 •Getting Basemaps from the QuickMapServices Plugins: 00:05:00 •Getting OSM Data with Overpass Turbo: 00:06:00 •Rule Based Symbology: 00:10:00 •Rule Based Labeling: 00:03:00 •Bringing in Mapbox Baselayers (an Introduction): 00:13:00 •Natural Earth Data: 00:07:00 •Setting Up a Page Layout: 00:14:00 •Layout Templates: 00:05:00 •Creating Map Grids (Lat & Long Graticules): 00:08:00 •Inset or Overview Maps: 00:05:00 •Global Overview Maps: 00:05:00 •Adding a Legend: 00:07:00 •Adding Text to a Layout: 00:03:00 •Adding Images: 00:05:00 •Coastal Glow Effect: 00:03:00 •Concentric Water Lines (Equally Spaced): 00:05:00 •Concentric Water Lines (Variably Spaced): 00:08:00 •Half Tone Coastal Fill Pattern: 00:06:00 •Getting DEMs from USDA/NRCS: 00:08:00 •Creating Contour Lines from DEMs (in Feet and Meters): 00:11:00 •Labeling Contour Lines: 00:06:00 •Drop Shadowing Polygon Features: 00:03:00 •Resources - QGIS Cartography: 00:00:00 •Assignment - QGIS Cartography: 00:00:00
Overview This comprehensive course on German Language: Intermediate Level will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This German Language: Intermediate Level 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 German Language: Intermediate Level. It is available to all students, of all academic backgrounds. Requirements Our German Language: Intermediate Level 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 1 sections • 29 lectures • 06:54:00 total length •Learn German - Famous Germans of the present: 00:19:00 •Learn German - The imperfect (weak verbs): 00:11:00 •Learn German - The imperfect of 'having,' 'being,' and 'becoming': 00:11:00 •Learn German - The past tense of strong verbs: 00:15:00 •Learn German - Exercises - Imperfect and explanations: 00:12:00 •Learn German - Recap - Nominative and Accusative: 00:10:00 •Learn German - Exercises and examples with the Nominative and A: 00:24:00 •Learn German - The Dative: 00:17:00 •Learn German - The Dative - Exercises: 00:17:00 •Learn German - The Genitive: 00:13:00 •Learn German - The Genitive - Exercises: 00:19:00 •Learn German - Two-way prepositions: 00:11:00 •Learn German - Brief History of Germany I: 00:16:00 •Learn German - Brief History of Germany II: 00:18:00 •Learn German - Brief History of Germany III: 00:14:00 •Learn German - What is German- Part I: 00:11:00 •Learn German - What is German- Part II: 00:16:00 •Learn German - German dialects still spoken today: 00:11:00 •Learn German - Recap exercises Lessons 2-10: 00:12:00 •Learn German - Recap exercises Lessons 11-19: 00:12:00 •Learn German - The Syntax - Part I- The main clause (I): 00:12:00 •Learn German - The Syntax - Part I- The main clause (II): 00:11:00 •Learn German - The Syntax - Part II- The subordinate clause: 00:11:00 •Learn German - The Syntax - Part II- The subordinate clause (I+II): 00:12:00 •Learn German - The Syntax - Part III- The Conjunctions: 00:19:00 •Learn German - Exercises for Conjunctions, Subjunctions, Conjunct: 00:16:00 •Learn German - Often used subordinate clauses with subjunctions: 00:13:00 •Learn German - Exercises with subordinate clauses with subjunctio: 00:14:00 •Learn German - Recap exercises Lessons 22-29: 00:17:00
Overview This comprehensive course on SAP Controlling (CO) - Product Costing S4HANA will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SAP Controlling (CO) - Product Costing S4HANA 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test 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 SAP Controlling (CO) - Product Costing S4HANA. It is available to all students, of all academic backgrounds. Requirements Our SAP Controlling (CO) - Product Costing S4HANA 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 11 sections • 25 lectures • 02:29:00 total length •Unit 1: Introduction to the Course: 00:02:00 •Unit 2: Introduction to Product Costing: 00:02:00 •Unit 3: Scenario for Product Costing: 00:03:00 •Unit 1: Create Material Master Data; Introduction to MAV, Standard Price and Planned Price: 00:14:00 •Unit 1: Introduction to Bill of Materials, Activities, Routing and Overheads: 00:08:00 •Unit 2: Introduction to Activity Type Price Planning: 00:05:00 •Unit 3: Configuration of Bill of Materials: 00:04:00 •Unit 4: Configuration for Activity Types and Creation of Secondary CE in S4HANA: 00:09:00 •Unit 5: Configuration for cost element input planning: 00:09:00 •Unit 6: Configuration for Activity type price planning: 00:04:00 •Unit 7: Activity price calculation: 00:03:00 •Unit 1: Configuration for Overhead Management: 00:05:00 •Unit 2: Configuration of Overhead Key and Overhead Group: 00:08:00 •Unit 1: Introduction to Costing Sheet: 00:04:00 •Unit 2: Configuration of Costing Sheet: 00:13:00 •Unit 1: Introduction to Costing Variant: 00:05:00 •Unit 2: Configuration of Costing Variant: 00:07:00 •Unit 1: Introduction to Routing and Work Centres: 00:03:00 •Unit 2: Configuration for Routing and Work Centres: 00:21:00 •Unit 1: Introduction and Configuration of Cost Component Structure: 00:08:00 •Unit 1: Steps in Standard Costing Run: 00:02:00 •Unit 2: Execution of Cost Estimation Run: 00:05:00 •Unit 3: Marking and Releasing the cost: 00:05:00 •Resources - SAP Controllling (CO) - Product Costing S4HANA: 00:00:00 •Assignment - SAP Controllling (CO) - Product Costing S4HANA: 00:00:00
Overview This comprehensive course on Microsoft Excel: Master Power Query in 120 Minutes! 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: Master Power Query in 120 Minutes! 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: Master Power Query in 120 Minutes!. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! 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 1 sections • 25 lectures • 02:25:00 total length •Power Query Intro and Excel version: 00:03:00 •Excel Power Query - Introduction: 00:03:00 •Excel Power Query - Query Editor Ribbon: 00:09:00 •Transform Data - Trim in Excel Power Query: 00:05:00 •Transform Data - Format Dates and Values in Excel Power Query: 00:02:00 •Transform Data - Parsing URLs in Excel Power Query: 00:05:00 •Transform Data - Split Text Fields in Excel Power Query: 00:10:00 •Transform Data - Group By in Excel Power Query: 00:03:00 •Transform Data - Unpivoting Columns in Excel Power Query: 00:05:00 •Transform Data - Pivoting Columns in Excel Power Query: 00:02:00 •Transform Data - Split Columns into Other Columns in Excel Power Query: 00:04:00 •Transform Data - Filtering Rows in Excel Power Query: 00:05:00 •Transform Data - Sorting Columns in Excel Power Query: 00:02:00 •Transform Data - Transform and Add Columns in Excel Power Query: 00:07:00 •From Folder - Import From Folder in Excel Power Query: 00:07:00 •From Folder - Doing Auto Cleanup in Excel Power Query: 00:13:00 •From Folder - Extract Data from Forms in Excel Power Query: 00:13:00 •From Workbook - Extract Multiple Criteria in Excel Power Query: 00:05:00 •From Workbook - Extract Multiple Worksheets in Excel Power Query: 00:04:00 •Joins - Intro to Joins: 00:04:00 •Joins - Merging: 00:08:00 •Joins - Full Outer Join: 00:06:00 •Joins - Right Anti Join: 00:09:00 •Power Query - Convert Reports into Pivot Tables: 00:05:00 •Modulo: 00:06:00