30312 Tea courses

Overview This comprehensive course on Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 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 Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4. It is available to all students, of all academic backgrounds. Requirements Our Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 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 • 22 lectures • 04:20:00 total length •Introduction: 00:16:00 •Installing PostgreSQL and PostGIS: 00:08:00 •Creating the Application Database: 00:03:00 •Installing Django in a Python Virtual Environment: 00:08:00 •Installing the ATOM IDE: 00:09:00 •Creating the Django Base Project: 00:08:00 •Adding the Database Configuration to the settings.py File: 00:09:00 •Creating a Model in the models.py File: 00:07:00 •Extracting Data from the Web: 00:24:00 •Cleaning and Transforming the Data Part 1: 00:18:00 •Cleaning and Transforming the Data Part 2: 00:10:00 •Loading the Data into the Model: 00:12:00 •Adding the Web Map Tile Service Link in settings.py: 00:08:00 •Reading from the Model and Creating a GeoJSON Dataset: 00:12:00 •Adding Template Files (HTML): 00:10:00 •Adding a Layout and the Base Map: 00:25:00 •Plotting Circle Markers: 00:16:00 •Creating a Sliding Sidebar: 00:14:00 •Creating a Doughnut Chart: 00:19:00 •Creating a Multi-Bar Bar Chart: 00:12:00 •Creating a Multi-Bar Bar Chart: 00:12:00 •Resource: 00:00:00

Overview For building a solid position in the world of digital marketing understanding Google Ads is mandatory. So, if you are planning to pursue a career in marketing or want to promote your business, grasp the ins and outs of Google Ads. The Google Ads For Beginners course is the perfect place to start learning. This comprehensive course will give you an overall understanding of Google Ads. from the easy-to-follow modules you will learn how to create Google Ads. The course will teach you the techniques to avoid common mistakes and build a successful Adward campaign. Then you will learn about Adwords display advertising, content remarketing strategies, Adwords bidding strategies and much more. Furthermore, the course will help you reduce the expenditure on waste Ads. You will also grasp the skills for tracking Adwards analytics. At the end of the course, you will receive a certificate of achievement. This certificate will help you build an impressive CV. So, join now and start learning! 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? This Google Ads For Beginners course is available to all students, of all academic backgrounds. Anyone who wants to pursue a career in the relevant industry can take the course and develop their skills and knowledge. Requirements There is no experience or previous qualifications required to enrol in this course It is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path This course will equip you with valuable knowledge and effective skills in this area. After completing the course, you will be able to explore career opportunities in the fields such as Digital Marketer Marketing Executives Business Owner Course Curriculum 1 sections • 15 lectures • 01:01:00 total length •Course Promo: 00:03:00 •Lesson 01: Getting started with Google Ads: 00:04:00 •Lesson 02: Create your Google Ads: 00:04:00 •Lesson 03: Ingredients to build a successful Adwords camping: 00:04:00 •Lesson 04: Google Adwords mistakes to be avoided: 00:04:00 •Lesson 05: Google Adwords audit - Optimisation guide: 00:06:00 •Lesson 06: Improving quality score in Google Adwords: 00:04:00 •Lesson 07: Adwords display advertising: 00:05:00 •Lesson 08: Turbocharge Adwords for breakthrough performance: 00:03:00 •Lesson 09: Content remarketing strategies with Google display network: 00:04:00 •Lesson 10: Adwords bidding strategies your competitors don't know: 00:07:00 •Lesson 11: Using Google Adwords for small business: 00:03:00 •Lesson 12: How to reduce wasted Adwords spend: 00:02:00 •Lesson 13: Google Adwords features updated: 00:04:00 •Lesson 14: Tracking Google Ads analytics: 00:04:00

Overview Gain expert tuition in Hairdressing and Barbering and begin a new and exciting career in the UK beauty industry. This comprehensive course covers all aspects of unisex hairstyling and will provide you with the perfect experience for working in a salon or starting a business. The Diploma in Hairdressing and Hair Cuttingcourse presents multiple tips and recommendations over a range of online modules. You will be taught all relevant skills from cutting, colouring, plaiting, and cleaning hair, to trimming beards and engaging in lively consultations with your clients. It will empower you to promote your acquired talents and put yourself in the local hair care marketplace. 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 Diploma in Hairdressing and Hair Cutting. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Hairdressing and Hair Cutting 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 4 sections • 27 lectures • 06:56:00 total length •Who are Barbers: 00:10:00 •Anatomy of the skull: 00:05:00 •Hair Type: 00:05:00 •Face shapes, Characteristics & Style concepts: 00:05:00 •Tools of the Trade (Barbers): 01:15:00 •Hair Salon Equipments & Furnitures: 00:05:00 •Code of Practices for Barbering Services: 00:45:00 •Safe Startup Guide for Barbers: 00:35:00 •Shaving: 00:35:00 •Cutting the Hair: 00:05:00 •Cutting: Barber Skills & Techniques: 00:35:00 •Cutting hair - One length hair: 00:13:00 •Cutting hair - Uniform Layer: 00:11:00 •Cutting hair - Short graduation: 00:13:00 •Cutting hair - Long graduation: 00:12:00 •Cutting hair - Curly hair: 00:10:00 •Cutting hair - Fringes: 00:12:00 •About Of Hair Style: 00:05:00 •Check Out Your Face Shape: 00:08:00 •Choosing Your Style On Your Shape: 00:07:00 •Best Hairstyles For A Long Face: 00:08:00 •Best Hairstyles For A Square Face: 00:20:00 •Best Hairstyles For A Round Face: 00:06:00 •Best Hairstyles For A Heart Shaped Face: 00:06:00 •How To Love Your Style: 00:05:00 •Glossary of Cuts: 00:10:00 •Shampooing: 00:10:00

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 Learn effective business research methods and develop a more productive supply chain to enhance profitability, by enrolling in our exclusively designed Logistics and Supply Chain Management course.This course will equip you with strong management skills to supervise storage and distribution of goods in a company, and handle industrial challenges and trends to ensure business profitability and customer satisfaction.All successful companies demand skilled supply managers for generating large product volumes on time, using cost-effective techniques. After your successful completion, you will be far more capable of using logistics while making lucrative decisions, matching the operations to established budgets, tracking the transfer process of supplies, materials, and more. Make sure you're ready to manage supply chains during a time of crisis. 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 Logistics and Supply Chain Management. It is available to all students, of all academic backgrounds. Requirements Our Logistics and Supply Chain Management 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 3 sections • 25 lectures • 14:20:00 total length •Course Overview: 00:05:00 •Getting Started: 00:15:00 •The Evolution of the Supply Chain: 00:15:00 •The Basic Supply Chain Structure: 00:15:00 •Supply Chain Drivers: 00:15:00 •Aligning Your Supply Chain with Business Strategy: 00:15:00 •Managing Supply Chain Risks: 00:15:00 •Tracking and Evaluating Supply Chain Data: 00:30:00 •Troubleshooting Supply Chain Problems: 00:15:00 •Sharing Supply Chain Activities: 00:15:00 •Sustainable Supply Chain Strategies: 00:15:00 •Applying Lean Techniques to the Supply Chain: 00:15:00 •The Future of Supply Chain Management: 00:15:00 •Module One - Getting Started: 00:30:00 •Module Two - Understanding Lean: 01:00:00 •Module Three - Liker's Toyota Way: 01:00:00 •Module Four - The TPS House: 01:00:00 •Module Five - The Five Principles of Lean Business: 01:00:00 •Module Six - The First Improvement Concept (Value): 01:00:00 •Module Seven - The Second Improvement Concept (Waste): 01:00:00 •Module Eight - The Third Improvement Concept (Variation): 01:00:00 •Module Nine - The Fourth Improvement Concept (Complexity): 01:00:00 •Module Ten - The Fifth Improvement Concept (Continuous Improvement): 01:00:00 •Module Eleven - The Improvement Toolkit: 00:30:00 •Module Twelve - Wrapping Up: 01:00:00

Overview Don't listen to 'Fake News' and Conspiracy Theories. Learn the facts about Climate Change and how you can make a difference. This innovative course will enlighten and educate you with scientifically proven facts about the world's changing environment and the challenges ahead. The Solving Climate Change Problems with Renewable Energy course has been written with the assistance of industry professionals and is designed to give you the complete and verified details about Climate Change. You will be taught about current weather patterns and ongoing pollution concerns. The content also covers sustainable energy sources and the achievable goals that everyone should attempt. Know the truth and become 'greener' today. How will I get my certificate? At the end of the course there will be a written assignment 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 Solving Climate Change Problems with Renewable Energy. It is available to all students, of all academic backgrounds. Requirements Our Solving Climate Change Problems with Renewable Energy 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 3 sections • 32 lectures • 19:25:00 total length •Introduction: 00:30:00 •What is Renewable Energy?: 00:30:00 •Types of Renewable Energy: 00:15:00 •Solar Power: 00:30:00 •Wind Power: 01:00:00 •Hydropower: 01:00:00 •Biofuel: 00:30:00 •The Possibilities of Renewable Energy: 01:00:00 •Government Incentives: 01:00:00 •Renewable Energy Is Key to Fighting Climate Change: 01:00:00 •Energy Audits: 01:00:00 •LEED: 01:00:00 •BREEAM: 01:00:00 •EPC: 01:00:00 •How to Choose Your Renewable Energy Sources: 01:00:00 •The Advantages and Disadvantages of Renewable Energy: 01:00:00 •Solar Geometry: 01:00:00 •Solar Chimney: 00:30:00 •Solar Wall: 00:30:00 •PV/Thermal: 00:10:00 •Solar Water Heaters: 00:30:00 •Solar Water Heaters: 00:30:00 •Solar Photovoltaic Technology Basics: 00:30:00 •Other Energy Saving Technologies: 00:15:00 •Underground Thermal Energy Storage (UTES): 00:15:00 •Trigeneration / CCHP: 00:15:00 •Rainwater Harvesting: 00:15:00 •Fuel Cell: 00:45:00 •Earth Duct: 00:15:00 •Light Pipe: 00:15:00 •Conclusion: 00:15:00 •Assignment - Solving Climate Change Problems with Renewable Energy: 00:00:00

Overview Improve your work and your writing dramatically by harnessing the untapped capabilities of Microsoft Word. Every writer and administrator uses Microsoft Word, but by taking this innovative course, you will learn how to use its many functions to your advantage. This MS Word Diploma course presents ways in which you can use extra functions built into Word to automate and invigorate your communications. You'll be taught how to use Mail Merge and customise the software to your specific requirements, making it easy to enhance and format letters or documentation. It could provide you with a revelation in terms of use and make Word an invaluable assistant. 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 MS Word Diploma. It is available to all students, of all academic backgrounds. Requirements Our MS Word Diploma 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 9 sections • 31 lectures • 03:58:00 total length •Navigate in Microsoft Word: 00:12:00 •Create and Save Word Documents: 00:24:00 •Manage Your Workspace: 00:06:00 •Edit Documents: 00:16:00 •Preview and Print Documents: 00:04:00 •Customize the Word Environment: 00:08:00 •Apply Character Formatting: 00:17:00 •Control Paragraph Layout: 00:19:00 •Align Text Using Tabs: 00:07:00 •Display Text in Bulleted or Numbered Lists: 00:03:00 •Apply Borders and Shading: 00:04:00 •Make Repetitive Edits: 00:06:00 •Apply Repetitive Formatting: 00:10:00 •Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00 •Sort a List: 00:05:00 •Format a List: 00:06:00 •Insert a Table: 00:07:00 •Modify a Table: 00:06:00 •Format a Table: 00:03:00 •Convert Text to a Table: 00:04:00 •Insert Symbols and Special Characters: 00:04:00 •Add Images to a Document: 00:11:00 •Apply a Page Border and Color: 00:03:00 •Add Headers and Footers: 00:05:00 •Control Page Layout: 00:05:00 •Add a Watermark: 00:04:00 •Check Spelling Grammar and Readability: 00:07:00 •Use Research Tools: 00:06:00 •Check Accessibility: 00:03:00 •Save a Document to Other Formats: 00:04:00 •Assignment - MS Word Diploma: 00:05:00

Overview Attain the best online training possible to become a sought-after manager who can steer Hotels and Hospitality services in successful directions. This Hospitality and Hotel Revenue Management Advanced Diplomacourse is designed to coach you in every aspect and element of Hospitality responsibilities and guarantees you are able to deliver outstanding customer service. The course is designed to prepare for the demands of customers in Hotels, and also such other events or locations, such as cruise ships, popular bars or clubs, restaurants, and high-profile tourist destinations. You will learn how to recruit and train staff, maintain housekeeping, upkeep a facility, and organise large-scale events and the appropriate catering. 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 Hospitality and Hotel Revenue Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Hospitality and Hotel Revenue Management Advanced Diploma 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 • 22 lectures • 07:08:00 total length •Module 01: Introduction to Hospitality Management: 00:24:00 •Module 02: An Overview of Hotel Industry: 00:18:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:21:00 •The Process of Development and Training in Hospitality Industry: 00:24:00 •Module 05: Management of Front Office Operations: 00:19:00 •Management of Housekeeping, Engineering and Security Operations: 00:27:00 •Management of Food and Beverage Operations: 00:20:00 •Management of Service Quality in Hospitality Industry: 00:20:00 •Marketing in Travel and Tourism Business: 00:24:00 •Module 10: Accounting in Hospitality Industry: 00:26:00 •Module 11: Customer Satisfaction: 00:20:00 •Module 12: E-Hospitality and Technology: 00:22:00 •Module 1. Fundamentals of Hotel Revenue Management: 00:16:00 •Module 2. Importance of Revenue Management: 00:20:00 •Module 3. Key Performance Indicator in Revenue Management: 00:18:00 •Module 4. Forecasting of Hotel Revenue Management: 00:21:00 •Module 5. Pricing of Hotel Revenue Management: 00:22:00 •Module 6. Profitable Distribution Strategy: 00:07:00 •Module 7. Overbooking Practices in Hotel Revenue Management: 00:10:00 •Module 8. How to Promote your Hotel: 00:15:00 •Module 9. Customer and Other Essential Factors: 00:13:00 •Module 10. The Future of Hotel Revenue Management in UK: 00:21:00

Overview It doesn't matter in which part of the world you live or what culture you follow; one thing is undoubtedly considered harmful to your present and future. That is Debt. Debt can make your life worse. It is like a vicious circle; a continuing unpleasant situation created when one problem causes another problem that then makes the first problem worse. No one wants to be part of this chain of events. But honestly speaking, the concept of debt is not always harmful. It depends on how you see it and use it. Here comes the role of Debt Management. You should know how to manage debt smartly and efficiently. At Apex Learning, we share the goal of millions of people, which is to make the world better. We have prepared a tool to help deal with debt management: our Debt Management - Online Course. You can access our course anytime, anywhere. Enrol now before falling into a debt trap. What Can You Expect From The Course? Understanding the fundamentals of debt management and its importance. Distinguishing between long-term and short-term debt and their implications. Identifying and assessing your personal debt situation effectively. Developing a realistic debt management plan. Learning strategies for avoiding debt problems. Dealing with bankruptcy and insolvency within legal regulations. 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 Debt Management - Online Course. It is available to all students, of all academic backgrounds. Requirements Our Debt Management - Online 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 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 • 14 lectures • 05:08:00 total length •Module 01: Introduction to Debt Management: 00:22:00 •Module 02: Long Term and Short Term Debt: 00:20:00 •Module 03: Identifying Your Debt: 00:27:00 •Module 04: Debt Management Plan: 00:30:00 •Module 05: Debt Assessment: 00:23:00 •Module 06: Debt Financing: 00:18:00 •Module 07: Building Budget: 00:23:00 •Module 08: Debt Counselling: 00:18:00 •Module 09: When Is Debt Good?: 00:19:00 •Module 10: Avoiding Debt Problems: 00:19:00 •Module 11: How to Handle Debt Collectors: 00:16:00 •Module 12: How to Get Out of Debt: 00:18:00 •Module 13: Dealing with Bankruptcy and Insolvency: 00:32:00 •Module 14: Laws and Regulations: 00:23: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