28899 Courses

Overview Do you face struggle when you open a Power Query seeing the number of things to do then and cannot make good use of your time? Then this Microsoft Excel: Master Power Query in 120 Minutes! Course is just what you need.to break free of your worries. Power Query is a business intelligence tool available in Excel that allows you to import data from many sources and then clean, transform and reshape your data as needed. The course is designed for learners opting to learn Power Query, a feature available in Excel. Power query is a data connection technology that enables you to connect combine refine and discover data from various sources to meet analysis needs.  The course will introduce you to the basic features of Power query and then show how to trim and transform Data in Excel Power Query, Format Dates and Values in Excel Power Query. You will also learn how to extract data from folders and doing auto clean up on Excel Power Query. You will also learn to merge and shape data according to analysis requirements and prepare models by tools such as power pivot. Learning Outcomes: Acquire proficiency in using Excel Power Query for efficient data management. Master the art of transforming raw data into actionable insights. Learn advanced techniques for data manipulation and analysis. Develop the ability to streamline complex data processes. Enhance your analytical thinking and problem-solving skills. How is the course assessed? To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion. Will I receive a certificate of completion? Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15. Why study this course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Requirements Our Microsoft Excel: Master Power Query in 120 Minutes! Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career paths Data Analyst: £25,000 - £40,000 Per Annum Business Analyst: £30,000 - £50,000 Per Annum Financial Analyst: £28,000 - £45,000 Per Annum Marketing Analyst: £24,000 - £40,000 Per Annum Operations Analyst: £26,000 - £42,000 Per Annum Management Consultant: £35,000 - £55,000 Per Annum Course Curriculum Microsoft Excel: Master Power Query in 120 Minutes! 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

Learn essential skills for a more inclusive world with our Disability Awareness & Inclusion Training course. Gain insights, strategies, and tools to foster equality.

Get ready to declutter and organise your space with our online course - say goodbye to the mess!

Gain essential skills in medical office management with the Medical Assistant Diploma. Learn medical terminology, record-keeping, confidentiality, and more. Perfect for aspiring medical assistants and healthcare professionals. Start your career today!

Join our Lab Technician Course to develop essential skills in medical laboratory services. Learn about laboratory techniques, equipment operation, and safety protocols, preparing you for a successful career in healthcare.

Unlock your career potential with the Microbiology Lab Technician Diploma. This comprehensive online course covers essential topics, including microbial diversity, laboratory safety, and clinical practices. Gain practical skills and theoretical knowledge to thrive in medical laboratory services. Enrol now to become a qualified microbiology lab technician!

Become a skilled Lab Technician with our Lab Technician Online Course. Master essential skills, laboratory techniques, and equipment operation to excel in medical lab services. Enrol now for hands-on training and earn a globally recognised CPD certificate!

Enhance your career in healthcare with the Laboratory Expert Diploma. This comprehensive online course covers essential topics for aspiring Lab Technicians, including laboratory services, equipment operation, and safety protocols. Gain practical skills and earn a CPD certificate upon completion.

Achieve proficiency in practical math skills with Functional Skills Maths Level 2. Build confidence and competence for everyday tasks and career advancement.

Beneath our feet lie untold stories waiting to be discovered. The fields of archaeology and surveying provide the tools and knowledge needed to unlock these mysteries, from ancient settlements to mediaeval towns. The course in Archaeology & Surveying takes you on a fascinating journey through the history of archaeological exploration. You will explore various archaeological subfields, ranging from the study of ancient civilisations to the investigation of shipwrecks. The course covers the concept of archaeological periods, helping you contextualise historical discoveries. You will learn essential surveying techniques to map archaeological sites and identify features of significance. Additionally, the course emphasises pre-excavation research and safety protocols to ensure responsible archaeological practices. Learning Outcomes of Archaeology & Surveying: Develop a comprehensive understanding of different archaeological subfields and their research methods. Explore the concept of archaeological periods and their influence on our understanding of human history. Master archaeological site surveying techniques and feature identification for effective data collection. Understand the importance of pre-excavation research and safety measures for responsible archaeological practice. Analyse the various excavation methods used to uncover archaeological sites and artefacts. Enhance critical thinking skills to interpret archaeological data and reconstruct past societies. Course Curriculum of Archaeology & Surveying: Module 01: Introduction To Archaeology Module 02: Different Types Of Archaeology Module 03: Archaeological Time Period Module 04: Archaeological Site Surveying And Features Module 05: Pre-Excavation Research: Dimensions Of Excavation And Safety Measures Module 06: Methods Of Excavation Module 07: The Process Of Excavation And Documentation Module 08: Post-Excavation Analysis Module 09: Understanding Dating In Archaeology Module 10: Archaeological Interpretation Module 11: Conservation: Protecting The World’s Heritage Who is This Course For: History enthusiasts are curious about archaeological methods. Individuals seeking a career in archaeology or related fields. Those interested in understanding how archaeological evidence shapes our knowledge of the past. Anyone passionate about cultural heritage and its preservation. Certification of Archaeology & Surveying: CPD QS certificates are available at an additional cost of £9.99 for a PDF, £16.99 for a printed hard copy, and £24.99 for both PDF and hard copy certificates. Requirements: This course does not have academic entry requirements and is open to students of all backgrounds. Career Paths: Field Archaeologist: £20,000 – £25,000 per year Archaeological Project Manager: £28,000 – £35,000 per year Museum Curator: £22,000 – £28,000 per year Heritage Officer: £25,000 – £32,000 per year University Lecturer (Archaeology): £30,000 – £40,000 per year And many more!