2684 Office Skills & Productivity courses in Worthing delivered On Demand

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Overview This Excel spreadsheet for Beginner course will unlock your full potential and will show you how to excel in a career in Excel spreadsheet for Beginner. So upskill now and reach your full potential. Everything you need to get started in Excel spreadsheet for Beginner is available in this course. Learning and progressing are the hallmarks of personal development. This Excel spreadsheet for Beginner will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Mental Health skills to help you advance your career. Acquire a comprehensive understanding of various Mental Health topics and tips from industry experts. Learn in-demand Mental Health skills that are in high demand among UK employers, which will help you to kickstart your career. This Excel spreadsheet for Beginner course covers everything you must know to stand against the tough competition in the Excel spreadsheet for Beginner field.  The future is truly yours to seize with this Excel spreadsheet for Beginner. Enrol today and complete the course to achieve a Excel spreadsheet for Beginner certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Excel spreadsheet for Beginner course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Excel spreadsheet for Beginner course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Excel spreadsheet for Beginner course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Excel spreadsheet for Beginner is suitable for anyone aspiring to start a career in Excel spreadsheet for Beginner; even if you are new to this and have no prior knowledge on Excel spreadsheet for Beginner, this course is going to be very easy for you to understand.  And if you are already working in the Excel spreadsheet for Beginner field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Excel spreadsheet for Beginner course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Excel spreadsheet for Beginner course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Excel spreadsheet for Beginner course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Excel spreadsheet for Beginner course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00 Assignment Assignment - Excel spreadsheet for Beginner 00:00:00

Medical Secretary: Medical Secretary Would you like to earn a professional qualification as a medical secretary? Our unique medical secretary diploma program offers thorough instruction in clerical and administrative duties unique to healthcare environments. Our diploma program for medical secretaries teaches students electronic health record management, scheduling and billing protocols, and medical terminology. Additionally, this medical secretary diploma program improves the communication abilities required for productive patient interactions. Participants in the diploma in medical secretary course gain expertise in managing patient inquiries and scheduling appointments through hands-on activities and realistic scenarios. Furthermore, this medical secretary diploma course teaches how to accurately and discreetly handle medical documentation. Basic office administration and regulatory compliance pertinent to healthcare settings are also included in this diploma program for medical secretaries. If you wish to help medical institutions run smoothly and provide high-quality patient care, enroll in our diploma program for medical secretaries. Learning outcome of diploma in medical secretary Upon completing the diploma in medical receptionist and secretary course, students will: Acquire proficiency in medical terminology, billing procedures, and electronic health record management. This diploma in medical secretary helps to develop effective communication and interpersonal skills for patient interaction and team collaboration. Master scheduling, appointment coordination, and administrative tasks specific to healthcare settings are included in this diploma in medical secretary. Also, this diploma in medical receptionist and secretary demonstrates accuracy and confidentiality in handling medical documentation and patient information. Through our diploma in medical secretary, you can gain knowledge of office management practices and regulatory compliance relevant to healthcare administration. Special Offers of this Medical Secretary: Medical Secretary Course: This Medical Secretary: Medical Secretary Course includes a FREE PDF Certificate. Lifetime access to this Medical Secretary: Medical Secretary Course Instant access to this Medical Secretary: Medical Secretary Course 24/7 Support Available to this Medical Secretary: Medical Secretary Course Medical Secretary: Medical Secretary Take your administrative skills to the next level with our Diploma in Medical Secretary: Medical Secretary program! This comprehensive training equips you with critical expertise as a Medical Secretary: Medical Secretary, including medical terminology, scheduling, billing, and electronic health record administration. The Medical Secretary: Medical Secretary diploma enhances your communication skills, enabling effective patient interactions and streamlined support in healthcare settings. Through immersive activities and real-life scenarios, you'll gain hands-on experience managing patient inquiries and scheduling with confidence. Plus, this Medical Secretary: Medical Secretary program teaches you how to handle medical records with precision and discretion, preparing you to thrive in a vital healthcare role. Who is this course for? Medical Secretary: Medical Secretary For health care professionals who currently or will work in healthcare environments, this diploma in medical secretary: medical secretary is perfect. Requirements Medical Secretary: Medical Secretary To enrol in this Medical Secretary: Medical Secretary Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Medical Secretary: Medical Secretary Course. Be energetic and self-motivated to complete our Medical Secretary: Medical Secretary Course. Basic computer Skill is required to complete our Medical Secretary: Medical Secretary Course. If you want to enrol in our Medical Secretary: Medical Secretary Course, you must be at least 15 years old. Career path Medical Secretary: Medical Secretary This diploma in medical secretary: medical secretary course can help students pursue careers as medical receptionists, medical secretary: medical secretary, or administrative assistants in healthcare facilities, clinics, hospitals, or medical offices.

SQL programming is the programming that manages data in the Relational Database Management System. The Mastering SQL Programming course aims to teach you how to optimise the accessibility and maintenance of data with the Structured Query Language SQL programming language, and gain a solid foundation for building, querying, and manipulating databases. This SQL Programming course will provide you the standard language, but also identifies deviations from the standard in two widely-used database products, Oracle and Microsoft SQL Server. You will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Learn what SQL is and how to create, manipulate, and create reports from database tables from the best SQL courses. Important concepts associated with relational databases will be covered. You will run SQL commands to create database tables and define data element types. Enrol Now to start boosting your SQL skills! Key topics to be covered Stored Procedures Returning Data Testing and Debugging SQL CLR Code Dynamic SQL Column sets Learning Outcomes Know the tools for creating views with examples, columns and indexed views, creating stored procedures, testing and debugging. Learn how to create triggers, execute with result sets, use inline table valued functions, and use the multi statement function. Learn about transaction concepts, explicit transactions, and structured error handling. Understanding of different functions, data tools, database management, comparing database schemas, offline database management and much more. Master partitioning, managing partitions, querying partitions, complex querying, table expressions, efficient queries and complex queries. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? Anyone who wants to gain extensive knowledge, potential experience and expert skills in SQL programming. Those who have an interest in production planning. Students from any academic backgrounds

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Turn Your Dreams into Reality with the Excel Analyst - Excel Data Analysis and Visualisation Course Training course. This comprehensive Excel Analyst - Excel Data Analysis and Visualisation Course online course will equip you with the knowledge and skills you need to succeed in your chosen field. Whether you're a beginner or looking to take your career to the next level, this course has covered you. Key Learning Outcomes: Understanding the core concepts and theories in your field Building your knowledge and skills through practical, hands-on learning Developing the ability to think critically and solve problems effectively Enhancing your communication skills and the ability to work effectively with others Gaining a competitive edge in your career and reaching your full potential With a flexible online format that allows you to learn at your own pace, Excel Analyst - Excel Data Analysis and Visualisation Course training course offers a convenient and accessible way to boost your career prospects. So why wait? Enrol today and take the first step towards success! Vital Component of the Excel Analyst - Excel Data Analysis and Visualisation Course course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced online course Modules Covers to Explore Multiple Job Positions Transform your career with the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Don't wait-enrol in the Excel Analyst - Excel Data Analysis and Visualisation Course Bundle now and take the first step towards a successful and fulfilling career! Course Outline: Modifying a Worksheet Working with Lists Analyzing Data Visualizing Data with Charts Using PivotTables and PivotCharts Working with Multiple Worksheets and Workbooks Using Lookup Functions and Formula Auditing Automating Workbook Functionality Creating Sparklines and Mapping Data Forecasting Data CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is the perfect fit for anyone seeking to start or advance in the Excel Analyst - Excel Data Analysis and Visualisation Course industry. Whether you're a beginner or looking to expand your knowledge, this comprehensive training will provide you with the essential skills and expertise to succeed. Requirements Join the Excitement-With this Excel Analyst - Excel Data Analysis and Visualisation Course course, there's no limit to what you can achieve. From day one, you'll be on your way to building a fulfilling career in this thriving field. No prior experience is required to enrol in this course. Career path Upon completion, you'll have the opportunity to pursue a variety of in-demand Excel Analyst - Excel Data Analysis and Visualisation Course jobs, with endless possibilities for growth and success. Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

This course is a short and crisp introduction to those who do not have any prior knowledge of scripting or any programming basics. The instructor has tried to explain the concepts in such a simple terminology that even non-technical people will find it very easy to grasp the various Windows PowerShell concepts.

Are you someone who wants to utilise the database and how it can be effectively used for your business? Do you have the plans to make your database but you are struggling since don't have the right skills to start it? Worry no more! This course is designed to help you in this dilemma. Have you ever heard about the database? Or have you heard about it and want to use it on your own? Then this course will be able to help you in that. There are a lot of people who do not like to deal with database, scripts and all the technical parts, this hinders them to start learning because they already have the mindset that it is difficult. Database creation might be difficult, but with the correct attitude and practical database skills, you will surely avoid the difficulties! You have to keep in mind that the end goal should guarantee the creation of the database and to be able to make more whenever you need it. In this course, you will first know how to create your database and database users. You will then master how to import database tables since most new scripts come with a built-in installer, the scripts create all database, but when the time comes that there is no installer provided, then you have to create one manually. Course Highlights Database for Beginners is an award-winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Database for Beginners into 9 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 8 hours, 40 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Database for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment, and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Database for Beginners is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Database for Beginners 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Database Basics What is a Database FREE 01:00:00 Definition of Terms FREE 01:00:00 Database Users and Languages 01:00:00 Components of a Database System 01:00:00 Basic Set Concepts 01:00:00 Relations as a Database 01:00:00 Relational Database Operators 01:00:00 Database keys 01:00:00 Additional Supporting Material Database_Basics 00:00:00 Mock Exam Mock Exam- Database for Beginners 00:20:00 Final Exam Final Exam- Database for Beginners 00:20:00

Overview This Microsoft Excel: Master Power Query course will unlock your full potential and will show you how to excel in a career in Microsoft Excel: Master Power Query. So upskill now and reach your full potential. Everything you need to get started in Microsoft Excel: Master Power Query is available in this course. Learning and progressing are the hallmarks of personal development. This Microsoft Excel: Master Power Query will quickly teach you the must-have skills needed to start in the relevant industry. In This Microsoft Excel: Master Power Query Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Microsoft Excel: Master Power Query skills to help you advance your career. Acquire a comprehensive understanding of various Microsoft Excel: Master Power Query topics and tips from industry experts. Learn in-demand Microsoft Excel: Master Power Query skills that are in high demand among UK employers, which will help you to kickstart your career. This Microsoft Excel: Master Power Query course covers everything you must know to stand against the tough competition in the Microsoft Excel: Master Power Query field.  The future is truly yours to seize with this Microsoft Excel: Master Power Query. Enrol today and complete the course to achieve a Microsoft Excel: Master Power Query certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Microsoft Excel: Master Power Query course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Microsoft Excel: Master Power Query course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Microsoft Excel: Master Power Query course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Microsoft Excel: Master Power Query is suitable for anyone aspiring to start a career in Microsoft Excel: Master Power Query; even if you are new to this and have no prior knowledge on Microsoft Excel: Master Power Query, this course is going to be very easy for you to understand.  And if you are already working in the Microsoft Excel: Master Power Query field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Microsoft Excel: Master Power Query course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This Microsoft Excel: Master Power Query course has no prerequisite.  You don't need any educational qualification or experience to enrol in the Microsoft Excel: Master Power Query course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Microsoft Excel: Master Power Query course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Microsoft Excel: Master Power Query 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