If you are part or will be part of Human Resource Management you just don't need to know the functions of your department. You need to learn also about the functions of other departments since you'll be the one who will help in finding people perfect for it. In this course, you will learn the necessary skills, knowledge, and information about Human Resource Management and the implications of a different aspect of Human Resources with the daily responsibilities of people in this department. Course Highlights Professional Diploma in Human Resource Management 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 Professional Diploma in Human Resource Management into 13 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 11 hours, 40 minutes 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 Professional Diploma in Human Resource Management 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? Professional Diploma in Human Resource Management 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 Professional Diploma in Human Resource Management 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. Professional Diploma in Human Resource Management Module One - Getting Started FREE 00:30:00 Module Two - Human Resources Today FREE 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities 00:00:00 Mock Exam Mock Exam- Professional Diploma in Human Resource Management 00:20:00 Final Exam Final Exam- Professional Diploma in Human Resource Management 00:20:00
Whether you are an athlete, bodybuilder or want to live a healthier life and trying to adopt a diet plan that burns body fats rather than carbohydrates, then why not give Ketogenic diet a try and get absolutely amazed with the results! This Ketogenic Diet Mastery: Keto Meal Planning For Beginners course is designed to introduce you to one of the most popular weight-loss diets - Ketogenic diet and reveal the science behind it. In this course, you will learn how to create the perfect Ketogenic diet and meal plan that boost weight loss, reduce your appetite, and more muscle gains. This course will provide a firm understanding of what nutrients your body requires and take you through all the steps involved in setting up and following through with your Keto diet. Moreover, you will discover the best sources for Keto, along with a detailed overview of which type of Keto will work most suitable for you and your body. This comprehensive course is ideal for beginners who are trying to get the most out of their Ketogenic diet in no time. What you'll learn Gain an advanced understanding of the Ketogenic diet, including how it works. Explore the fundamentals of Keto dieting such as protein, calories, fat, vitamins, carbs, and minerals. Create a Ketogenic diet and meal plans that are ideal for your needs and lifestyle. Understand how the Ketogenic diet can benefit you and your overall health. Build muscle and lose fat faster by correctly optimising your meal plan. Know what to eat, what to find, keto-friendly food list, and their alternatives. Improve immunity, lower your risk of heart disease and develop energy levels with the right vitamins and minerals Who this course is for: Anyone wanting to learn the truth about ketogenic dieting & meal planning Anyone with an open mind towards dieting Requirements No prior health knowledge is required or assumed A digital food scale will help but is not required Introduction Course Overview: What You Will Learn 00:02:00 Ketogenic Diet Overview: What it is & how it works 00:07:00 Keto Diet Myths Debunked 00:05:00 Is Keto Right For You? 00:07:00 Setting Up Your Ketogenic Diet Overview 00:02:00 Calories Explained 00:04:00 Calories And The Ketogenic Diet 00:02:00 How To Calculate Your Maintenance Calories (TDEE) 00:03:00 Protein Explained 00:02:00 How Much Protein On Keto 00:02:00 How Many Carbs On The Ketogenic Diet 00:02:00 Fat Explained 00:03:00 How Much Fat On The Ketogenic Diet 00:01:00 Sample Diet 00:03:00 Adjusting Your Diet For Weight Loss & Muscle Growth Adjusting Your Diet For Weight Loss 00:05:00 Adjusting Your Diet For Muscle Gains 00:04:00 Targeted Keto Diet: For Athletes 00:02:00 How To Overcome Weight Loss Plateaus 00:04:00 Explaining Unexpected Weight Changes 00:03:00 How To Track Your Progess 00:04:00 Best Food Sources For Keto Quality Protein Sources 00:01:00 Quality Carb Sources 00:02:00 Quality Fat Sources 00:01:00 Supplements 00:04:00 How To Use Protein Powder 00:06:00 How To Use Creatine 00:04:00 Fish Oil 00:03:00 Other Dieting Tips Alcohol & Caffeine On Keto: Is it ok? 00:02:00 How To Detect Ketosis 00:04:00 Should You Take Multivitamins 00:02:00
Get the best out of your product with Google Plus Marketing As the most popular site in the world, Google can really help boost your revenue. Having the top rankings can mean the difference between being in business and being out of business. Whether you like or hate Google Plus, you have no choice but to leverage it. Why? Because Google owns it! Which is why this course can be very important to you. Google+ is a powerful search engine marketing tool for companies, influencers, and your own personal branding. Sharing blog posts on Google+ in particular is an excellent way to Rank for keyword terms that you might otherwise not be able to and to drive search traffic to your Google+ profile and then back to your blog and website. By the end of this course,the students will be able to set up their profile, connected with other leaders & businesses in their industry,obtain 1000 targeted followers and give their business an almost immediate boost using Google+. Course Highlights Google Plus Marketing Diploma 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 Google Plus Marketing Diploma into several 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 20/30 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 Google Plus Marketing Diploma 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? Google Plus Marketing Diploma 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 Google Plus Marketing Diploma 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. Introduction to Google +/+1 01:00:00 How to Sign Up for a Google Account 01:00:00 Google Plus Profile for Marketing 02:00:00 Google Buzz 01:00:00 Using Circles for Marketing 02:00:00 Google Streams of Information 01:00:00 Realtime Chat 00:15:00 Google Plus Hangouts 01:00:00 Google Sparks 00:30:00 Google Plus Button and Google Plus Statistics 01:00:00 Google Plus Realtime Search 00:30:00 Use Google Chrome Extensions With Google Plus 00:30:00 Tips on Getting More Google +1 Recommendations 00:30:00 Conclusion 00:15:00 Mock Exam Final Exam
This course helps you prepare for your CISSP certification. In this course, we will be discussing CISSP? Certification Domain 3: Security Architecture and Engineering, which makes up 13% of the weighted exam questions; being so broad, it contains close to 25% of the exam materials.
Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! The course contains two of our best-selling courses for one discount price: Level 2 Certificate in Workplace Management: Violence Workplace Harassment Course Are you looking to improve your current abilities or make a career move? Our unique Certificate in Preventing Workplace Violence and Harassments course might help you get there! Expand your expertise with high-quality training - study the Certificate in Preventing Workplace Violence and Harassments and get an expertly designed, great-value training experience. The Certificate in Preventing Workplace Violence and Harassments course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Certificate in Preventing Workplace Violence and Harassments course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Certificate in Preventing Workplace Violence and Harassments training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! The Managing Workplace Violence, Harassment and Safety course will help you: Understand what constitutes harassment in the workplace Discover how to implement anti-harassment policies in the workplace Learn about employer and employee rights in the workplace Know how to spot bullying, aggression, and harassment in the workplace Build your communication skills to interact effectively with other employees Learn to understand common sources of conflict in the workplace Why Prefer Us? Opportunity to earn a certificate accredited by CPD. Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Certificate in Preventing Workplace Violence and Harassments course: Couse 01: Level 2 Certificate in Workplace Management: Violence** Module One: What Is Workplace Harassment? Module Two: Identifying the Bully Module Three: How to Handle Workplace Violence Module Four: Risk Assessment (I) Module Five: Risk Assessment (II) Module Six: Being the Victim Module Seven: Checklist for Employers Module Eight: Interview Process Module Nine: Investigation Process Module Ten: Developing a Workplace Harassment Policy Couse 02: Workplace Harassment Course** Why Tackle Harassment What Is Harassment Realistic Expectation What It Takes Assessment Process Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Certificate in Preventing Workplace Violence and Harassments course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Certificate in Preventing Workplace Violence and Harassments course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates Certificate Accredited by CPD Digital certificate - £10 Certificate Accredited by CPD Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Basic Adobe Photoshop Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training employers seek in today's workplaces. The Basic Adobe Photoshop Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Basic Adobe Photoshop Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Basic Adobe Photoshop Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Basic Adobe Photoshop? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standards accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Basic Adobe Photoshop 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Basic Adobe Photoshop 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 skills. Prerequisites This Basic Adobe Photoshop does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Basic Adobe Photoshop was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Basic Adobe Photoshop is a great way for you to gain multiple skills from the comfort of your home. Unit 01: Shortcuts & the Brush Introduction 00:01:00 Hot keys, Other Functions 00:02:00 Brush Properties 00:06:00 Unit 02: Layers Cropping 00:02:00 Make the horizon horizontal 00:01:00 Organize highlights in groups 00:02:00 Hidden details in the shadows 00:02:00 Make corrections in the perspective 00:01:00 Work with layers 00:05:00 Organize layers in groups 00:04:00 Merging, rasterizing and flattening layer 00:04:00 Gradient layer mask 00:03:00 Combine recordings with layer masks 00:03:00 Unit 03: Modify Your Portrait Eliminate irregularities 00:06:00 Make skin smoother 00:02:00 Whiten teeth 00:02:00 Clear eyes 00:05:00 Update body contours 00:03:00 Make irregularities less conspicuous 00:03:00 Unit 04: Watermark & Figures Place a transparent logo or watermark 00:02:00 Change color 00:02:00 Cut out figures and release them from the background 00:13:00 Unit 05: Modify Your Text Add text to a photo 00:05:00 Place text blocks in an image 00:01:00 Let text follow a path 00:02:00 Display photos in letters 00:03:00 Text warp and twist 00:03:00 Character Styles and Paragraph Styles 00:05:00 Assignment Assignment - Basic Adobe Photoshop 00:58:00 Order Your Certificate Order Your Certificate QLS
Do you have an interest in learning about forensic science and want to pursue a career in this field? Then our course would be a suitable one for you. The course provides a fundamental idea about forensic science and how science is used by law enforcement agencies during criminal investigations. Moreover, this course would give the students the skills to comprehend and analyse every crime scene, as every crime committed is unique in its way. Also, you will learn about the basic principle of forensic science. Next, the course modules cover the investigation aspects and how it is crucial to the entire legal process because it gives the investigator a link that could connect the victim to the relevant crime and the steps taken to conduct an investigation. You will learn how to use computer data and gather evidence while studying the characteristics of computer data. The functionality of computer hardware, various boot methods, and data-collecting techniques will be covered throughout this course. This Forensic Scientist & Crime Investigator Level 3 Bundle Consists of the following Premium courses: Course 01: Forensic Scientist & Crime Investigator Level 3 Course 02: Criminology and Forensic Profiling - Level 4 Course 03: Criminal Intelligence and Crime Analysis Complete Diploma Course 04: Accident Investigation Course 05: Criminal Law Course 06: Human Rights Course 07: Emotional Intelligence and Human Behaviour Course 08: Addiction and Mental Health - Dual Diagnosis Course 09: Domestic Violence and Abuse Awareness - Level 2 Course 10: Creativity and Problem Solving Skills Course 11: First Aid at Work As one of the top course providers in the UK, we're committed to providing you with the best educational experience possible. Our industry experts have designed the Forensic Scientist & Crime Investigator Level 3 to empower you to learn all at once with accuracy. You can take the course at your own pace - anytime, from anywhere. So, enrol now to advance your career! Learning outcome Here are a few important skills you will achieve from our course: The course will go through all of forensic psychology and criminology's foundational concepts. Learn how to conduct a crime scene investigation. Discusses the fundamentals of criminal behaviours, an offender's personality, and the features of psychopaths. You will be given the necessary tools, including the ability to think critically and conduct thorough research. Learn how to collect and package physical samples from the crime scene. Recognise criminal psychology Comprehend the significance of judgment in criminal intelligence Create workable fixes for accident inquiry Improved knowledge of the documentation preparation process for concluding the accident investigation Grasp the gist of criminal law Benefits you'll get choosing Apex Learning for this Bundle: Pay once and get lifetime access to 11 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Gain valuable knowledge without leaving your home How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) Curriculum of Forensic Scientist & Crime Investigator Level 3 Bundle Course 01: Forensic Scientist & Crime Investigator Level 3 Module 1: The History and Organisation Module 2: Crime Scene Investigation Module 3: Collecting and Packaging Physical Evidence Module 4: Fingerprints: Your Personal Signature Module 5: Bloodstain Analysis Module 6: DNA Analysis Module 7: Drug Analysis Module 8: Firearms Examination Module 9: Questioned Documents: Handwriting And Forgery Examinant Module 10: Digital Evidence Module 11: Delving into the Criminal Mind Course 02: Criminology and Forensic Profiling - Level 4 Module 01: Introduction to Criminology and Profiling Module 02: Classification of Crime Module 03: Violent Crimes Module 04: The Crime Scene Module 05: Dealing with Crime Module 06: Understanding Criminal Psychology Module 07: Forensic Science Module 08: Phases of Profiling Module 09: Criminal Profiling: Science, Logic and Metacognition Module 10: Offender Profiling: Pragmatic Solution and Behavioural Investigative Advice Module 11: Victimology Module 12: The Criminal Justice System in England and Wales Course 03: Criminal Intelligence and Crime Analysis Complete Diploma Module 01: Introduction to Intelligence Analysis Module 02: Criminal Intelligence Analysis Module 03: Criminal Intelligence Analyst - Skills and Competencies Module 04: Understanding Criminal Psychology Module 05: Research Methods Module 06: Decision Making in Criminal Intelligence Analysis Module 07: Intelligence-Led Policing Module 08: Counterterrorism and Criminal Intelligence Analysis Module 09: Technology in Criminal Intelligence Analysis Module 10: The Criminal Justice System in England and Wales Course 04: Accident Investigation Module 01: Understanding the Investigation Module 02: Why Investigate? Module 03: Accident Investigation Procedure Module 04: Documenting The Accident Scene Module 05: Conducting Effective Interviews Module 06: Investigation and Cause Analysis Module 07: Developing Solutions Module 08: Report Documentation and Communication Course 05: Criminal Law Module 1: Introduction to Criminal Law Module 2: Elements of a Crime Module 3: Incitement, Conspiracy and Attempt Module 4: Accomplice Module 5: Crime Prevention Module 6: The Police Module 7: Prosecution, Caution and Diversion Module 8: Youth Justice Module 9: The Trial Module 10: Sentencing Process Module 11: Homicide Module 12: Offences against Person Module 13: Sexual Offences Module 14: Theft Module 15: Blackmail, Robbery & Burglary Module 16: White-Collar Crime Module 17: Terrorism & Law Module 18: Property Offences Module 19: Cybercrime & Piracy Module 20: Prisons Module 21: Probation Service Module 22: War Crimes Course 06: Human Rights Module 1: Basic Concept of Freedom and Human Rights Module 2: Classification of Human Rights Module 3: Women's and Children's Right Module 4: Various Aspects of Freedom Module 5: Various International Human Rights Organisations Course 07: Emotional Intelligence and Human Behaviour Module 01: Human Behaviour and Basic Psychological Process Module 02: Evolutionary Perspective of Human Behaviour Module 03: Human Intelligence Module 04: Intelligence Test and Variations in Intelligence Module 05: Learning and Conditioning Module 06: Language and Communication Module 07: Introduction to Emotion Module 08: Emotion Influences Cognition Module 09: Stress, Anger and Conflict Module 10: Emotional Intelligence Module 11: Self-Leadership Module 12: Neuro-Linguistic Programming (NLP) Course 08: Addiction and Mental Health - Dual Diagnosis Promotional Video SAMHI Dual Diagnosis Intro video Module 01 - Drugs and Effects Module 02 - Addictions & Mental Health Module 03 - Harm Minimisation & Optimal Health Module 04 - Brain Works - Neurophysiology Module 05 - Trauma Model & Keys to Treatment Module 06 - Brief & Early Intervention and Tripod of Support Resources - Addiction & Mental Health (Dual Diagnosis) Course 09: Domestic Violence and Abuse Awareness - Level 2 Module 01: Introduction to Domestic Violence & Abuse Module 02: The Components of Domestic Violence Module 03: The Impact of Domestic Violence on Victims Module 04: The Impact of Domestic Violence and Abuse on Children Module 05: Assessing the Risks of Domestic Violence and Abuses on Children Module 06: Supporting the Victim and Reporting Incidents Module 07: Record Keeping Module 08: Domestic Violence and Abuse Legislation in the UK Course 10: Creativity and Problem Solving Skills Course 11: First Aid at Work Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing With Fractures and Dislocations Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing with Minor Injuries at the Workplace Call for an Emergency CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Forensic expert. Crime detective Law enforcement. Anyone who wants to gather knowledge in this sector. Anyone who is looking forward to advancing their career in this sector. Requirements This Forensic Scientist & Crime Investigator Level 3 course has been designed to be fully compatible with tablets and smartphones. Career path Upon completion of this course, the learner is able to begin a new career. Here are the few careers options the learner can take: Forensic collision investigator: Salary range- £20,000 to £40,000 Crime Officer: Salary range- Salary range- £16,000 to ££37,000 Forensic scientists: Salary range- £18000 to £45000 Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Forensic Scientist & Crime Investigator Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.
The "YAML Fundamentals" course helps beginners with the required skills to develop YAML documents. It will also help you gain skills to develop a properly structured YAML document in both block style and flow style. The "flow style" is also known as JSON style or compact style. If you are looking forward to adding YAML to your skillset, then this course is what you need. In today's market, every IT professional is expected to know YAML.
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