8887 Courses in Cardiff delivered On Demand

The most comprehensive, concise and impactful 6 weeks online course available. Fully accredited. Start immediately. Gain 18 CPD Credits and an exclusive Chartered Management Institute Certificate of Recognition Duration: 6 weeks starting immediately Who is this course for? All levels of seniority Language: English Effort: 16 hours of self-paced online learning Award: 18 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 22 video courses to watch. This includes 9 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Key learning areas: Benefits of being an emotionally intelligent leader Leading individuals and teams Critical thinking Managing stress Managing pressure to optimise performance Effective leadership Breaking bad news Decision making On completion of this course, you will receive: A certificate stating 18 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year World leading content supported by cutting edge technology. Made for healthcare professionals.    Did you know this course can be covered by the NHS study budget?   The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here. 

Develop your communication skills today and get certified in 6 weeks The most concise & impactful online course available. 20 CPD Credits & CMI Certificate of Recognition Duration: 6 weeks starting immediately Suitable for: All levels of seniority Language: English  Effort: 11 hours 30 minutes of self-paced online learning Award: 20 CPD Credits & CMI Certificate of Recognition  Accreditors: CMI, FMLM, CPD Certification Service  Content format: Videos with optional reading  Assessment Method: Multiple choice, instant result. Retake if required. In total there are 17 video courses to watch. This includes 10 CPD accredited courses that require you to complete a multiple choice assessment to confirm your understanding of the topic. A pass mark of 70% is required and this can be re-taken as many times as required. Optional reading and audio book resources are provided to enable you to explore a topic deeper if required. The content of the course is of the highest global standard and has been created by MIT Sloan Management Review. Our learning platform, called Skillsoft Percipio, provides a stunning learning experience. Your key learning areas: Conflict management Managing and setting priorities Leading across cultures Collaboration Navigating challenging situations Cultivating cross-functional teams Time management & organisation Active listening Critical conversations On completion of this course, you will receive: A certificate stating 20 CPD Credits- Awarded by the CPD Certification Service A Certificate of Recognition from the prestigious Chartered Management Institute (CMI) Chartered Management Institute Affiliate membership for 1 year A digital badge to share on LinkedIn and add to your resume Your official CPD Certificate Your official CMI Certificate You will also be awarded the following additional benefits: Chartered Management Institute alumni network access for 1 year Access to Chartered Management Institute networking and learning events for 1 year Fully accredited to the highest standards. Our accreditors: World leading content supported by cutting edge technology. Made for healthcare professionals.    Did you know this course can be covered by the NHS study budget? The study budget covers: Courses and education activities to support you achieving the curriculum Courses to help you prepare for postgraduate exams Discretionary courses that add value to you individually and support the wider system To access the study budget you should discuss this with your educational supervisor or line manager. To help you with this process, view our example study budget application letter here. 

The CMI Level 3 Certificate in Principles of Management and leadership is suitable for practising or aspiring managers who will supervise or manage a team to achieve clearly defined outcomes. They will set and monitor goals and objectives by providing instruction, direction and guidance. Day to day operational and project activities are a key part of their role. Study method Online, self-paced Duration 3 months Access to content Access until course completion Qualification CMI Level 3 Certificate in Principles of Management and Leadership CPD 40 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students General topics and themes include: Introduction to leadership and management essentials Culture, values and leadership... understanding the core essentials that will maximise results for your organisation Management models and leadership approaches... how to understand and apply these in a practical manner Improving your leadership and management capabilities... proven approaches that work Developing a personal action plan to improve your leadership and management capabilities... transforming your performance What the programme offers: Recognised Level 3 qualification in Leadership & Management from Chartered Management Institute (CMI) Full learning support and all course materials A blended learning experience allowing participants to continue to develop their skills in the workplace Delivery Format This is delivered online learning to cover core leadership and management knowledge, skills and behaviours and includes individual coaching. Who is this course for? The qualifications have been designed for practising or aspiring managers in roles such as: • Team Leader • Supervisor • Project Officer • Shift Manager • Foreperson Who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None Career path Leadership and management

Description Do you want to know about the function of Microsoft SharePoint? Are you interested to be an expert in this field? Be the first and look at the MS SharePoint 2016 Site Owner course. The proper guideline for this course may assist you to reach your acme of goal. The purpose of the course is to assist students to know the key issues of MS SharePoint providing the knowledge with their role and responsibilities. It enables students to know how to add and configure sites, create libraries and lists, generate and modify views. It provides them the idea of management and creation of content, and document and helps them to know how to manage it. It enhances the students' ability to navigate the site by using web parts and working with web page along with its change of regional setting. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? MS SharePoint 2016 Site Owner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our MS SharePoint 2016 Site Owner 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 Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:02:00 Role of the Site Owner Understanding the Role of the Site Owner 00:04:00 The Limitations of Folders 00:05:00 Adding and Configuring Sites Working with Collaboration Site Templates 00:02:00 Creating a Subsite with the Team Site Template 00:05:00 Creating a Subsite with the Project Site Template 00:04:00 Creating a Subsite with a Blog Site Template 00:05:00 Creating a Subsite with a Community Site Template 00:05:00 Understanding Site Settings 00:05:00 Customizing the Look of a Site 00:06:00 Changing a Site´s Title, Description, Logo, or URL 00:04:00 Creating Libraries Adding Apps 00:04:00 Creating a Document Library 00:04:00 Reviewing Library Settings 00:04:00 Switching Between the New and Classic Views 00:04:00 Creating a Picture Library 00:03:00 Deleting and Restoring a Library 00:03:00 Changing the Name of a Library or List 00:02:00 Modifying Library Versioning Options 00:04:00 Restoring a Previous Version 00:03:00 Overriding a Checked Out Document 00:03:00 Saving a Library as a Template 00:03:00 Adding Enterprise Key Words to a Library or List 00:03:00 Allowing Folder Creation in Libraries and Lists 00:02:00 Adding or Removing the Sync Library Feature 00:03:00 Using Content Approval for a Library 00:04:00 Using Content Approval with Alerts for Simple Workflows 00:06:00 Creating Lists Creating Lists 00:04:00 Reviewing List Settings 00:02:00 Deleting and Restoring a List 00:02:00 Creating a Calendar List 00:02:00 Adding or Removing the Group Calendar Option 00:02:00 Creating a Task List 00:03:00 Creating an Announcement List 00:02:00 Creating a Links List or Promoted Links List 00:04:00 Creating a Contact List 00:02:00 Creating a Survey 00:05:00 Creating an Issue Tracking List 00:03:00 Creating a List From an Excel Worksheet 00:04:00 Creating a Custom List 00:02:00 Changing a List Name or Description 00:02:00 Adding or Removing Versioning From a List 00:03:00 Adding or Disabling the Add Attachments Feature for a List 00:02:00 Adding or Removing the Quick Edit Feature for a Library or List 00:02:00 Creating and Modifying Views Changing or Modifying the List or Library Default View 00:04:00 Creating Public Views 00:06:00 Creating a Grouped Library or List View 00:05:00 Creating a Flat Library View 00:03:00 Creating and Customizing Columns Understanding SharePoint Columns 00:04:00 Adding an Existing Site Column to a Library or List 00:03:00 Creating a Site Column 00:05:00 Modifying, Renaming, or Deleting a Site Column 00:03:00 Creating a Library or List Column 00:04:00 Modifying or Renaming a List or Library Column 00:03:00 Removing a Column from a List or Library 00:03:00 Creating a Text Column 00:03:00 Creating a Choice Column 00:05:00 Creating a Number Column 00:03:00 Creating a Currency Column 00:02:00 Creating a Date and Time Column 00:03:00 Creating a Look Up Column 00:05:00 Creating a Calculated Column 00:04:00 Creating and Managing Content Types Exploring Content Types 00:03:00 Creating a Custom Content Type 00:08:00 Adding a Custom Content Type into a List or Library 00:03:00 Removing a Content Type from a Library or List 00:03:00 Creating a Document Set 00:08:00 Modifying a Content Type 00:03:00 Managing Permissions Understanding Permissions 00:05:00 Editing Permission Level Priveleges 00:04:00 Understanding Default Permission Groups 00:04:00 Viewing and Editing Group Permissions 00:04:00 Changing Permission Levels for a Group 00:02:00 Viewing, Adding, or Removing Users from a Group 00:03:00 Creating New SharePoint Groups 00:05:00 Changing a Group Name or Group Owner 00:02:00 Adding a SharePoint Group to a Site 00:03:00 Adding, Removing, or Editing Permission Levels for an Individual 00:02:00 Checking an Individuals Permission on a Site 00:02:00 Granting Access to the Site Using the Share Option 00:03:00 Changing the Default Share Group for the Site 00:02:00 Creating and Removing Unique Permissions for a Site 00:05:00 Creating and Removing Unique Permissions for a Library 00:06:00 Creating and Removing Unique Permissions for a Document or Folder 00:06:00 Enhancing the Site Working with Pages in SharePoint 00:04:00 Modifying or Adding Text to a Page 00:06:00 Understanding Web Parts or App Parts 00:09:00 Creating a Page in SharePoint 00:06:00 Adding a Page to the Quick Launch 00:03:00 Adding the Excel Web Access Web Part 00:07:00 Adding the Relevant Documents Web Part 00:04:00 Navigation and Regional Settings Changing Regional Time and Work Week Settings 00:05:00 Inheriting Top Links Navigation 00:02:00 Working with Top Links Bar 00:05:00 Working with the Quick Launch Area 00:06:00 Enabling Tree View 00:03:00 Conclusion Course Recap 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Learning how to express what you need is a basic human function. Reading is an action which is considered as a skill of reading and understanding written or printed materials. Writing, another action of communication is the ability to communicate through making words on papers and composing text. Speaking is also a form of communication through conveying information in spoken language. Through this course, you will learn how to master all these three skills to be able to communicate effectively. Who is the course for? People who are in need to enhance their English written skills. Professionals, writers, and editors who write in the English language. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Mastering Skills (Reading, Writing & Speaking) course is a useful qualification to possess, and will be very helpful to have especially for these careers: Businessmen Copywriter Editor Journalist Marketing Content Creator Product Creator Professor Teacher Technical Writer. Module 1: Reading Introduction 01:00:00 Before Speed Reading 01:00:00 How People Read 01:00:00 Radically Increasing Your Reading Speed 01:00:00 Suggestions for Improving Speed and Effectiveness 01:00:00 Human Mind and Vocalization 01:00:00 Getting the Main Idea 01:00:00 Conclusion 00:15:00 Module 2: Writing INDEX OF RULES 00:30:00 CLEARNESS AND FORCE 01:00:00 ORDER OF WORDS IN A SENTENCE 01:00:00 EXERCISES 01:00:00 CONTINUOUS EXERCISES 01:00:00 Module 3: Speaking Public Speaking Basics 01:00:00 Know Your Audience 00:30:00 Use The Right Words 00:30:00 Decide What You Want To Convey 00:30:00 Learn How to Communicate 00:30:00 What Happens If Your Don't Connect to Your Audience 00:30:00 Wrapping Up 00:15:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Master Microsoft Office 2021 with our comprehensive course. From Excel to PowerPoint and Word, learn essential tools and techniques for enhanced productivity and efficiency.

MS Excel Training (2016) Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this intermediate Microsoft office Excel 2016 - online training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This intermediate Microsoft office Excel 2016 - online training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this intermediate Microsoft office Excel 2016 - online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as a office admin. The intermediate Microsoft office Excel 2016 - online training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as a office admin. This comprehensive intermediate Microsoft office Excel 2016 - online training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This intermediate Microsoft office Excel 2016 - online training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as a office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this intermediate Microsoft office Excel 2016 - online training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This intermediate Microsoft office Excel 2016 - online training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive intermediate Microsoft office Excel 2016 - online training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this intermediate Microsoft office Excel 2016 - online training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Career path This intermediate Microsoft office Excel 2016 - online training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Course Curriculum Course Overview Introduction and Course Overview Working With Functions Work With Function - Introduction Work with Ranges - Introduction Name and Edit Ranges Use Defined Names in a Formula Locate and Use Specialized Functions Work with Logical Functions - Introduction IF Function AND, OR and NOT Function Combine Functions Functions Similar to the IF Function Work with Date and Time Functions - Introduction Today Now and Date Functions Networkday, Weekday, Workday and Isoweeknum Functions Work with Text Functions - Introduction Left, Right and MID Functions Find Function Text to Columns Feature Concatenate Function Upper, Lower and Proper Functions Working With Lists Short Data - Introduction Sort Data Filter Data - Introduction Filter Data Query Data with Database Functions Database Functions Outline and Subtotal Data - Introduction Use Subtotals to Summarize Data Analyzing Data Create and Modify Tables - Introduction Create and Modify Tables Use Summary Functions in Tables Apply Intermediate Conditional Formatting - Introduction Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting - Introduction Use Logical Functions to Apply Conditional Formatting Visualizing Data With Charts Create Charts - Introduction Create Charts Modify and Format Charts - Introduction Modify and Format Charts Use Advanced Chart Features - Introduction Create a Dual-Axis Chart Create a Chart Template Visualizing Data with Charts - Best Practice Using PivotTables And PivotCharts Create a PivotTable - Introduction Create a PivotTable Analyze PivotTable Data - Introduction Analyze PivotTable Data Present Data with PivotCharts - Introduction Present Data with PivotCharts Filter Data by Using Timelines and Slicers - Introduction Filter Data by Using Slicers and Timelines Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Unleash your teachers potential, embrace resilience, and effortlessly cater to every child's needs across your school with the abundance of resources included with RISE: Resilience in Schools and Education.

ICA Certificate in Managing Sanctions Risk Sanctions can be complex, and dealing with sanctioned parties can be risky. National or international sanctions may be issued against individuals, entities, groups or nations; or even trading activities/particular sectors. Those bodies charged with enforcing sanctions compliance are particularly active at the moment, with multiple fines for firms in recent years stretching into billions of dollars. Suitable for those working in financial crime and regulatory compliance, this could help you: understand sanctions and the international context discover the screening systems and controls define a sanctions governance framework manage alert investigations learn the challenges of change and the cost of getting it wrong This course is awarded in association with Alliance Manchester Business School, the University of Manchester. There are many benefits of studying with ICA: Flexible learning solutions that are suited to you Our learner-centric approach means that you will gain relevant practical and academic skills and knowledge that can be used in your current role Improve your career options by undertaking a globally recognised qualification that hiring managers look for as part of their hiring criteria Many students have stated that they have received a promotion and/or pay rise as a direct result of gaining their qualification The qualifications ensure that you are enabled to develop strategies to help manage and prevent risk within your firm, thus making you an invaluable asset within the current climate Students who successfully complete the course will be awarded the ICA Certificate in Managing Sanctions Risk and will be entitled to use the designation- Spec.Cert(Sanctions) This qualification is awarded in association with Alliance Manchester Business School, the University of Manchester. This course provides Participants with a detailed understanding of the following topics: Understanding sanctions The international context Defining a sanctions governance framework Sanctions lists and screening Managing alert investigations The cost of getting it wrong The challenges of change

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