536 Apps courses delivered On Demand

This Access 2016 Intermediate is specially designed for you if you are thinking to take your Microsoft Access skills to the next level. Through the course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.  From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. You will learn to design tables for improved accuracy in data entry by setting default values and restricting data entry, review the various options to share data with other applications, including Word and Excel, learn about Action Queries to automate updating, appending and deleting table data, and review various advanced query techniques such as using Query Joins, Parameter queries, working with totals and Crosstab queries. Finally, you'll build a navigation form to make it easy for your users to find their way around your database.  WHAT WILL I LEARN? * Design Tables for Better Data Entry * Share Data with Other Applications * Work with Action Queries * Advanced Query Techniques * Automate Processes with Macros * Advanced Forms * Advanced Report Techniques REQUIREMENTS * Access 2016 Introduction or equivalent experience. WHO IS THE TARGET AUDIENCE? * Students who want to take Access to the next level and improve their database design skills. Introduction Introduction FREE 00:01:00 Designing Tables for Better Data Entry Reviewing Table Design Principles 00:04:00 Setting Field Size, Formats and Captions 00:06:00 Setting Default Value and Required Fields 00:03:00 Restricting Data Entry Using Data Validation 00:02:00 Restricting Data Entry Using Input Masks 00:06:00 Sharing Data with Other Applications Exporting Tables and Queries to Excel 00:03:00 Importing Data from a TXT File 00:03:00 Importing Data from Excel 00:02:00 Exporting Data to a TXT File 00:02:00 Linking External Data Sources 00:03:00 Using Word Merge 00:02:00 Working with Action Queries What are Action Queries 00:02:00 Creating an Update Query 00:02:00 Creating an Append Query 00:03:00 Creating a Delete Query 00:02:00 Creating a Make Table Query 00:02:00 Changing the Start Number of an Auto Number Field 00:03:00 Advanced Query Techniques Creating Query Joins 00:05:00 Creating Find Unmatached and Find Duplicate Queries 00:03:00 Creating Parameter Queries 00:04:00 Using -Like- Keyword in Parameter Queries 00:02:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:03:00 Summarizing Query Data with Totals 00:03:00 Inserting Where Statements in Summary Queries 00:01:00 Creating a Crosstab Query 00:03:00 Automating Processes with Macros Understanding Macro Basics 00:06:00 Creating Macros to Open Forms by Record 00:04:00 Validating Data Entry with Macros 00:04:00 Creating a Macro to Automate Data Entry 00:03:00 Advanced Data Entry Using Macros and DLOOKUP Function 00:06:00 Advanced Form Using Conditional Formatting 00:02:00 Organizing Form Fields with Tab Controls 00:03:00 Creating a Combo Box Control 00:02:00 Creating an Option Group Control 00:03:00 Using a Subform to Show Data from a Related Table 00:03:00 Advanced Report Techniques Inserting a Chart on a Report 00:03:00 Showing Data in Columns 00:02:00 Inserting a Subreport 00:02:00 Configuring Reports with Parameter Queries 00:04:00 Sending Reports 00:02:00 Conclusion Course Recap 00:01:00 Resources Resources - Access 2016 Intermediate 00:00:00 Course Certification

The Microsoft Office 2016 Excel PowerPivot is designed for new PowerPivot users to get up to speed on how it works and its feature set. The course covers different features of the interface, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data. You will learn how to enable and navigate Power Pivot, how to manage data relationships, how to visualize Power Pivot data, how to create a Power Pivot report, and more. You will also learn some commonly used DAX functions. Prerequisite Course: Excel Level 3 or equivalent. COURSE HIGHLIGHTS Microsoft Office 2016 Excel PowerPivot is an award-winning and the best selling course that has been given the CPD Qualification Standards & 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 Microsoft Office 2016 Excel PowerPivot into 19 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 12 hours, 30 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 MICROSOFT OFFICE 2016 EXCEL POWERPIVOT * Lifetime access to the course * No hidden fees or exam charges * CPD Qualification Standards 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? Microsoft Office 2016 Excel PowerPivot is CPD Qualification Standards 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 Microsoft Office 2016 Excel PowerPivot 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 Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Microsoft Office 2016 Excel PowerPivot Enable and Navigate 00:30:00 Import Data from Various Data Sources 01:00:00 Refresh Data from a Data Source 00:30:00 Create Linked Tables 00:30:00 Organize and Format Tables 00:30:00 Create Calculated Columns 00:30:00 Sort and Filter PowerPivot Data 00:30:00 Create and Manage Table Relationships 01:00:00 Create PivotTables 01:00:00 Create PivotCharts 00:30:00 Create Power Views 01:00:00 Filter Data Using Slicers 00:30:00 Present PivotTable Data Visually 01:00:00 Manipulate PowerPivot Data Using DAX Functions 01:00:00 Extract Data from Tables Using Functions 00:30:00 Save Reports in Different File Formats 01:00:00 Work with Time Dependent Data 00:30:00 Protect Reports 00:30:00 Activities and Exercise Files - Microsoft Office 2016 Excel PowerPivot 00:00:00

DESCRIPTION Learn to create data dashboard and visualization within minutes using Microsoft Power BI. Microsoft Power BI - Master Power BI in 90 Minutes! course teaches you how to transform your data into live dashboards and reports and helps you to find answers to your company's most important questions. Microsoft Power BI is data visualization software. It is a business analytics service provided by Microsoft that will deliver insights throughout your organization.  You can connect hundreds of data sources. It simplifies data prep and drives ad hoc analysis. Microsoft Power BI - Master Power BI in 90 Minutes! course covers all the essential features and usage of Microsoft Power BI and guides you to use the program for organizing your business tasks. Throughout the course, you will learn how to unify data from many sources to create interactive, immersive dashboards and reports which will provide actionable insights and drive business results. ASSESSMENT: * At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. * Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. 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? Microsoft Power BI - Master Power BI in 90 Minutes! 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 Microsoft Power BI - Master Power BI in 90 Minutes! 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. Power BI - Introduction Overview of Power BI Course 00:02:00 Power BI Intro 00:03:00 03 - Power BI High Level Flow 00:02:00 04 - Install and Sign Up 00:03:00 05 - Power Query Intro 00:05:00 06 - Power Pivot Intro 00:01:00 07 - Power View Intro 00:02:00 Your First Power BI Dashboard 08 - Big Picture 00:02:00 09 - Get Data 00:07:00 10 - How to Get More Data 00:01:00 11 - Modelling Data 00:03:00 12 - Adding Relationships Manually 00:02:00 13 - Visualization 00:05:00 14 - Visualization Customization 00:01:00 15 - More Visualizations 00:02:00 16- Visualization Format and Analytics 00:03:00 17 - Ask a Question 00:02:00 Your Advanced Power BI Dashboard with Real Live Data Adv 01 - Real World Example 00:06:00 Adv 02 - Get Data 00:13:00 Adv 03 - Modelling Data 00:05:00 Adv 04 - Visualization with multiple charts 00:11:00 Adv 05 - Publishing 00:05:00 Adv 06 - Power BI Website 00:08:00 Course Bounses FINAL 00:01:00 Resources Resources - Microsoft Power BI - Master Power BI in 90 Minutes! 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This course aims to prepare individuals for the AWS Certified Solutions Architect Associate exam. It covers essential AWS services, cloud architecture design, deployment strategies, and best practices for managing various AWS components. LEARNING OUTCOMES: * Understand the fundamental concepts of AWS Cloud Services and their application in real-world scenarios. * Design and implement AWS Storage and Virtual Private Cloud (VPC) solutions. * Learn how to design, implement, and manage Compute Services effectively. * Master Identity and Access Management (IAM) and its best practices for secure access control. * Explore Auto Scaling Solutions and Virtual Network Services to optimize AWS infrastructure. * Gain proficiency in deploying applications and databases on AWS. * Discover additional AWS services and their integration for comprehensive cloud solutions. * Develop insights into achieving operational excellence with AWS services. WHY BUY THIS AWS CERTIFIED SOLUTIONS ARCHITECT ASSOCIATE PREPARATION? 1. Unlimited access to the course for forever 2. Digital Certificate, Transcript, student ID all included in the price 3. Absolutely no hidden fees 4. Directly receive CPD accredited qualifications after course completion 5. Receive one to one assistance on every weekday from professionals 6. Immediately receive the PDF certificate after passing 7. Receive the original copies of your certificate and transcript on the next working day 8. Easily learn the skills and knowledge from the comfort of your home CERTIFICATION After studying the course materials of the AWS Certified Solutions Architect Associate Preparation there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. WHO IS THIS COURSE FOR? This AWS Certified Solutions Architect Associate Preparation course is ideal for * Students * Recent graduates * Job Seekers * Anyone interested in this topic * People already working in the relevant fields and want to polish their knowledge and skill. PREREQUISITES This AWS Certified Solutions Architect Associate Preparation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AWS Certified Solutions Architect Associate Preparation was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CAREER PATH As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This AWS Certified Solutions Architect Associate Preparation is a great way for you to gain multiple skills from the comfort of your home. COURSE CURRICULUM Section 01: Introduction Introduction 00:03:00 Section 02: Exam Tips and Tricks What is AWS? 00:02:00 Why use AWS? 00:03:00 How to Get Started with AWS 00:04:00 AWS Certifications 00:04:00 Preparation Resources 00:02:00 Benefits of Certification 00:02:00 AWS CSA-A Overview 00:04:00 What's New on the 2020 Updated Exam? 00:03:00 AWS CSA-A Exam Objectives 00:06:00 The Four Key Areas (Compute, Networking, Storage, and Databases) 00:04:00 Master the Knowledge Areas 00:02:00 Use the System 00:05:00 Take Notes 00:03:00 Be Mentally and Physically Prepared 00:04:00 Take the Exam 00:04:00 Section 03: AWS Cloud Services Overview Cloud Computing Defined 00:08:00 Benefits of Cloud Computing 00:10:00 Cloud Computing Models 00:07:00 History 00:07:00 Platform 00:06:00 Services, Part 1 00:10:00 Services, Part 2 00:08:00 Security and Compliance 00:07:00 Regions and Availability 00:06:00 Section 04: AWS Storage Design Storage Services 00:07:00 S3 Storage Class 00:07:00 S3 Terminology 00:09:00 S3 Advanced Features 00:08:00 Creating S3 Buckets Lab 00:08:00 S3 Bucket Properties 00:08:00 S3 Managing Objects Lab 00:11:00 Glacier 00:07:00 Setting up a Glacier Vault Lab 00:08:00 S3 and Tape Gateway 00:06:00 S3 Enhanced Features 00:08:00 Elastic Block Store (EBS) 00:08:00 Creating EBS Volumes Lab 00:07:00 Elastic File System (EFS) 00:07:00 Creating an EFS File System Lab 00:07:00 EFS and PrivateLink 00:03:00 Intro to Amazon FSx 00:06:00 Hands-on with FSx 00:06:00 Integrating on-Premises Storage 00:07:00 Storage Access Security Lab 00:10:00 Storage Performance 00:08:00 Section 05: Virtual Private Cloud (VPC) Virtual Private Cloud (VPC) Overview 00:10:00 Creating a VPC Lab 00:11:00 Configuring DHCP Options Lab 00:04:00 Elastic IP Addresses 00:07:00 Elastic Network Interfaces (ENIs) 00:05:00 Endpoints 00:07:00 VPC Peering 00:08:00 Creating a VPC Peering Connection Lab 00:10:00 Security Groups Overview 00:07:00 Network Address Translation (NAT) 00:11:00 Gateways (VPGs and CGWs) 00:08:00 VPN Configuration Option 00:04:00 Section 06: Compute Services Design EC2 Overview 00:11:00 EC2 Instance Types 00:11:00 EC2 Pricing 00:13:00 EBS and EC2 00:05:00 Section 07: Compute Services Implementation Launching an EC2 Linux Instance Lab 00:13:00 Configuring an EC2 Linux Instance Lab 00:08:00 Setting up an EC2 Windows Instance Lab 00:12:00 Shared Tenancy 00:05:00 Dedicated Hosts 00:08:00 Dedicated Instances 00:06:00 AMI Virtualization 00:12:00 Section 08: Compute Services Management Instance Management 00:09:00 Connecting to Instances Lab 00:09:00 Working with Security Groups 00:10:00 Working with Security Groups Lab 00:10:00 Advanced EC2 Management 00:06:00 AWS Batch 00:06:00 Elastic Container Service (ECS) 00:08:00 Elastic Beanstalk Environment 00:11:00 Section 09: Identity and Access Management (IAM) Identity and Access Management (IAM) Overview 00:07:00 Principals 00:10:00 Root User 00:06:00 Authentication 00:06:00 Authorization Policies 00:13:00 Multi-Factor Authentication 00:08:00 Key Rotation 00:10:00 Multiple Permissions 00:06:00 AWS Compliance Program 00:07:00 AWS Security Hub 00:06:00 Shared Responsibility Models 00:06:00 Section 10: IAM Best Practices User Accounts 00:11:00 Password Policies 00:09:00 Credential Rotation 00:06:00 Principle of Least Privilege 00:05:00 IAM Roles 00:08:00 Policy Conditions 00:08:00 CloudTrail 00:12:00 Section 11: Auto Scaling Solutions Auto Scaling Overview 00:06:00 Auto Scaling Groups 00:04:00 Termination Policies 00:07:00 Auto Scaling Configuration Lab 00:13:00 Launch Methods 00:04:00 Load Balancer Concepts 00:08:00 Elastic Load Balancing (ELB) 00:10:00 Section 12: Virtual Network Services DNS 00:14:00 Configuring DNS Lab 00:07:00 Configuring Route 53 Lab 00:13:00 Configuring ACLs and NACLs Lab 00:09:00 Flow Logs 00:07:00 Section 13: AWS Application Deployment Application and Deployment Services 00:04:00 Lambda 00:06:00 API Gateway 00:09:00 Kinesis 00:06:00 Kinesis Data Streams and Firehose 00:06:00 Kinesis Data Analytics 00:04:00 Reference Architectures 00:06:00 CloudFront 00:10:00 Web Application Firewall (WAF) 00:09:00 Simple Queue Service (SQS) 00:10:00 Simple Notification Service (SNS) 00:08:00 Simple Workflow (SWF) 00:07:00 Step Functions 00:05:00 OpsWorks 00:08:00 Cognito 00:04:00 Elastic MapReduce (EMR) 00:05:00 CloudFormation 00:10:00 CloudFormation Properties 00:03:00 CloudWatch 00:06:00 Trusted Advisor 00:07:00 Organizations 00:09:00 Section 14: AWS Database Design Database Types 00:08:00 Relational Databases 00:08:00 Database Hosting Methods 00:05:00 High Availability Solutions 00:06:00 Scalability Solutions 00:06:00 Database Security 00:08:00 Aurora 00:06:00 Redshift 00:11:00 DynamoDB 00:10:00 Section 15: Database Deployment DynamoDB Tables Lab 00:08:00 MySQL Lab 00:13:00 Configuration Lab 00:13:00 Backups Lab 00:04:00 Restore Lab 00:04:00 Snapshot Lab 00:08:00 Monitoring Lab 00:06:00 Section 16: Additional AWS Services Media Content Delivery 00:13:00 Desktop and Appstreaming 00:06:00 ElastiCache 00:05:00 Security Services Lab 00:12:00 Analytics Engines 00:11:00 Development Operations (DevOps) 00:12:00 AWS Solutions 00:05:00 AWS Transit Gateway 00:03:00 AWS Backup 00:04:00 AWS Cost Explorer 00:04:00 Section 17: Operational Excellence with AWS The Operational Excellence Process 00:08:00 Widget Makers Scenario 00:06:00 Resilient Design 00:08:00 Resilient Design Scenario 00:05:00 Performant Design 00:09:00 Performant Design Scenario 00:06:00 Secure Design 00:08:00 Secure Design Scenario 00:05:00 Cost Optimization 00:07:00 Cost Optimization Scenario 00:05:00 General Best Practices 00:07:00

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: 1. Acquire proficiency in using Excel Power Query for efficient data management. 2. Master the art of transforming raw data into actionable insights. 3. Learn advanced techniques for data manipulation and analysis. 4. Develop the ability to streamline complex data processes. 5. 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 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. 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 1. Data Analyst: £25,000 - £40,000 Per Annum 2. Business Analyst: £30,000 - £50,000 Per Annum 3. Financial Analyst: £28,000 - £45,000 Per Annum 4. Marketing Analyst: £24,000 - £40,000 Per Annum 5. Operations Analyst: £26,000 - £42,000 Per Annum 6. 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

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