7795 Admin courses

Develop your awareness regarding mental health with our Mental Health Laws and Awareness - Level 2 course. This course will rapidly train you in mental health law. This comprehensive learning package will familiarise you with the mental health laws and its key elements. It will teach you about the mental capacity act principles, elements of the deprivation of liberty safeguards, and more. This program will also prepare you with all the vital skills required to be an expert. Sign up today to kickstart your career in the health or social care sector. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. With a single payment you will gain access to Mental Health Laws and Awareness - Level 2, including 10 Career development courses, an original hardcopy certificate, a transcript and a student ID card. This Bundle Consists of the following Premium courses: Course 01: Mental Health Laws and Awareness - Level 2 Course 02: Mental Health Course Course 03: Mental Health Awareness in Schools Course 04: Level 2 Mindfulness for Wellbeing Course 05: Stress Management Training Course 06: Depression Fundamentals Course 07: Mental Freedom: Freedom From Pain Course 08: Treating Post-Traumatic Stress Disorder Course 09: Master English Speaking 3 Course 10: Health, Safety & Laws at Workplace | Online Course Course 11: Post-COVID Mental Aid Course Mental Health Laws and Awareness - Level 2 has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Mental Health Laws and Awareness - Level 2 is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Benefits you'll get choosing Apex Learning for this bundle: One payment, but lifetime access to 11 CPD courses Certificates, student ID for the title course included in a one-time fee Full tutor support available from Monday to Friday Free up your time - don't waste time and money travelling for classes Accessible, informative modules taught 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 Course Curriculum Course 01: Mental Health Laws and Awareness - Level 2 Module 01: The Mental Capacity Act Module 02: Interface with Legislation, Policy and Procedures Module 03: Deprivation of Liberty Safeguards Module 04: The Mental Capacity Act (2005) and Deprivation of Liberty Safeguards During a Pandemic Module 05: Mental Health Legislation and Services Module 06: Liberty Protection Safeguards (LPS) Course 02: Mental Health Course Course 03: Mental Health Awareness in Schools Course 04: Level 2 Mindfulness for Wellbeing Course 05: Stress Management Training Course 06: Depression Fundamentals Course 07: Mental Freedom: Freedom From Pain Course 08: Treating Post Traumatic Stress Disorder Course 09: Master English Speaking 3 Course 10: Health, Safety & Laws at Workplace | Online Course Course 11: Post COVID Mental Aid Course 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) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? There is no experience or previous qualifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds. Requirements Our bundle 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 CPD certificate 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. 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 (Mental Health Laws and Awareness - Level 2) 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.

Description: Microsoft Excel is claimed as the most-used spreadsheet program in the world. Through this course, you will understand that the web app is designed to make a few edits available anywhere as long as you are online. Know how to use Excel 2010 to do more complicated edits and learn using cell references instead of numbers in your formulas and functions. This course will help you in enhancing all your knowledge about Excel to become more efficient in your daily work. Who is the course for? Professionals who want to learn about Microsoft Office 365 Excel Web App features. People who have an interest in knowing all the essentials in Office 365 Excel Web App. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Microsoft Excel 365 Essentials is a useful qualification to possess and would be beneficial for any Office job, such as: Admin Assistant PA Secretary Administrator Account Assistant Bookkeeper Accountant Office Manager. Microsoft Excel 365 Essentials Module One - Getting Started 01:00:00 Module Two - Welcome to Office 365 Web Apps 01:00:00 Module Three - Worksheets and Workbooks 02:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Editing in the Browser (I) 02:00:00 Module Six - Editing in the Browser (II) 02:00:00 Module Seven - Building Formulas 02:00:00 Module Eight - Understanding Functions 02:00:00 Module Nine - Working with Data 02:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - The Insert Tools 02:00:00 Module Twelve - Wrapping Up 01:00:00 Activities Activities- Microsoft Excel 365 Essentials 00:00:00 Mock Exam Mock Exam- Microsoft Excel 365 Essentials 00:20:00 Final Exam Final Exam- Microsoft Excel 365 Essentials 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Improve your work and your writing dramatically by harnessing the untapped capabilities of Microsoft Word. Every writer and administrator uses Microsoft Word, but by taking this innovative course, you will learn how to use its many functions to your advantage. This MS Word Diploma course presents ways in which you can use extra functions built into Word to automate and invigorate your communications. You'll be taught how to use Mail Merge and customise the software to your specific requirements, making it easy to enhance and format letters or documentation. It could provide you with a revelation in terms of use and make Word an invaluable assistant. 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 MS Word Diploma. It is available to all students, of all academic backgrounds. Requirements Our MS Word Diploma 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 9 sections • 31 lectures • 03:58:00 total length •Navigate in Microsoft Word: 00:12:00 •Create and Save Word Documents: 00:24:00 •Manage Your Workspace: 00:06:00 •Edit Documents: 00:16:00 •Preview and Print Documents: 00:04:00 •Customize the Word Environment: 00:08:00 •Apply Character Formatting: 00:17:00 •Control Paragraph Layout: 00:19:00 •Align Text Using Tabs: 00:07:00 •Display Text in Bulleted or Numbered Lists: 00:03:00 •Apply Borders and Shading: 00:04:00 •Make Repetitive Edits: 00:06:00 •Apply Repetitive Formatting: 00:10:00 •Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00 •Sort a List: 00:05:00 •Format a List: 00:06:00 •Insert a Table: 00:07:00 •Modify a Table: 00:06:00 •Format a Table: 00:03:00 •Convert Text to a Table: 00:04:00 •Insert Symbols and Special Characters: 00:04:00 •Add Images to a Document: 00:11:00 •Apply a Page Border and Color: 00:03:00 •Add Headers and Footers: 00:05:00 •Control Page Layout: 00:05:00 •Add a Watermark: 00:04:00 •Check Spelling Grammar and Readability: 00:07:00 •Use Research Tools: 00:06:00 •Check Accessibility: 00:03:00 •Save a Document to Other Formats: 00:04:00 •Assignment - MS Word Diploma: 00:05:00

CPR & First Aid Course Overview Every year in the UK, 140,000 people pass away in situations where receiving first aid may have prevented their deaths. It follows that having a basic understanding of first aid is crucial. You've come to the correct place if you want to learn this potentially life-saving skill and have little to no experience with first aid. Your comprehension of first aid procedures will improve with the CPR & First Aid Course. Initially, this course will teach you how to conduct primary and secondary surveys. You will then learn fundamental first-aid procedures as the main focus of the training. You will receive CPR training in the following phase of the course. This training will also teach you how to address breathing issues. You will also learn how to administer first aid for fractures and dislocations during the training. You will also be guaranteed to know when to seek professional assistance by taking the course. This training will assist you in developing the skills and self-assurance necessary to respond in an emergency and save lives. So sign up now and get started studying! Why You Should Choose CPR & First Aid Course 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? CPR & First Aid Course 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 Office Admin, Secretarial and PA 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. CPR & First Aid Course Module 01: Primary Survey Primary Survey 00:15:00 Module 02: Secondary Survey Secondary Survey 00:15:00 Module 03: Basic First-Aid Techniques Basic First-Aid Techniques 00:20:00 Module 04: Secondary Illness: Loss of Responsiveness and CPR Secondary Illness: Loss of Responsiveness and CPR 00:14:00 Module 05: Secondary Illness: Breathing Problems Secondary Illness: Breathing Problems 00:15:00 Module 06: Secondary Illnesses and Injuries Secondary Illnesses and Injuries 00:27:00 Module 07: Dealing With Fractures and Dislocations Dealing With Fractures and Dislocations 00:17:00 Module 08: Call for an Emergency Call for an Emergency 00:10:00

Overview This Management Level 5 course meticulously delves into understanding the complexities and nuances of modern leadership, catering to those keen on mastering the art of effective management. This course has been curated meticulously to offer insights into various facets of management and leadership. From understanding the fundamental theories that govern administration to honing skills like negotiation and communication, the curriculum is a comprehensive voyage through the disciplines that develop a proficient manager. One would also find a detailed exploration of contemporary issues like corporate responsibility and the nuances of navigating office politics, promising a well-rounded educational experience.In addition to managerial theories and practices, the Management Level 5 course is robustly equipped to impart essential technological skills. With extensive modules on Microsoft Word, Excel, and PowerPoint, learners are primed to excel in the modern digital workspace, harnessing the power of these tools to augment their managerial prowess. 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 Management Level 5. It is available to all students, of all academic backgrounds. Requirements Our Management Level 5 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 22 sections • 23 lectures • 04:37:00 total length •Understanding Management and Leadership: 00:40:00 •Leadership Theories: 00:25:00 •Improving Management and Leadership Performance: 00:15:00 •High Performance Teams: 00:32:00 •Motivating Employees: 00:26:00 •Organisational Skills: 00:26:00 •Talent Management: 00:37:00 •Succession Planning: 00:24:00 •Business Process Management: 00:28:00 •Communication Skills: 00:27:00 •Negotiation Techniques: 00:15:00 •Managing Meetings and Giving Feedback: 00:21:00 •Managing Change: 00:22:00 •Time Management: 00:06:00 •Stress Management: 00:15:00 •Emotional Intelligence in Leadership: 00:32:00 •Managing Conflict: 00:14:00 •Dealing with Office Politics: 00:34:00 •Risk Management: 00:35:00 •Corporate Responsibility and Ethics: 00:14:00 •Microsoft Word: 08:06:00 •Microsoft Excel: 03:59:00 •Microsoft PowerPoint: 08:24:00

Duration 1 Days 6 CPD hours This course is intended for This basic course is for those who will be administering Information Server and its product components. Overview List Information Server functional categories and the Information Server products and components that support themList and describe the Information Server architectural tiersAccess Information Server clients, including thin clients using the Information Server Launch Pad, the Information Server Engine clients, and the Information Server Console clients including Information Analyzer and Information Services DirectorCreate and configure Information Server users and groupsManage Information Server active sessionsManage Information Server reportingWork with Information Server command-line tools including tools for session administration, user and group management, and encryptionUse the istool functionality to query, export, and import Information Server Repository assets This course gets those charged with administering Information Server v11.5 and its suite of many products and components started with the basic administrative tasks necessary to support Information Server users and developers. Information Server Technical Overview List the Information Server functional categories List the Information Server products and components that support these functional categories List the Information Server architectural tiers Working with Information Server Clients Use the Information Server Launch Pad to access Information Server thin clients including the Administrative Console, Information Governance Catalog, and Metadata Asset Manager Access Information Server Engine Clients including DataStage, QualityStage, FastTrack, and Information Server Manager Access Information Server Console Clients including Information Analyzer and Information Services Director Authentication and Suite Security Configure Suite users and groups Configure DataStage credentials for Engine users Session Management View a list of active sessions View session properties Disconnect sessions Configure global session properties Managing Reports Create and manage report folders Create a report Run a report View report results Administrative Tools Session Admin tool Directory Command tool Encrypt tool Managing Information Server Repository Assets Use istool to export and import common metadata assets Use istool to query information assets Use istool to export and import security assets Use istool to export and import reporting assets

Overview From schools to big corporations, email is used as the formal communication channel. That is why, no matter which sector you want to work for, you must polish your email writing skills. You can take your email writing abilities to the next level with our Email Writing Masterclass course. The course aims to provide you with quality training in email writing. Through this course, you will be introduced to the essentials of writing effective emails. The course will teach you how to choose the right tone and style for your emails. In addition, you will grasp the techniques of managing emails and get effective tips to improve your email writing quality. So, if you want to master the art of email writing. Join now! Course Preview Learning Outcomes Learn the fundamentals of writing an email Understand what tone and writing style to use Know the strategies to manage your emails effectively Grasp useful tips and tricks for writing emails Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Email writing Email management Who Should Take This Email Writing Masterclass Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Email Writing Masterclass course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Email Writing Masterclass Certification After completing and passing the Email Writing Masterclass course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Email Writing Masterclass will equip you with effective skills and abilities and help you explore career paths such as  Business executives Copywriter Customer support executives PA Office admin Module 01: E-Mail Communications E-Mail Communications 00:40:00 Module 02: Fundamentals Of Writing Effective E-Mails Fundamentals of Writing Effective E-mails 00:55:00 Module 03: Manage Your E-Mail Manage Your E-mail 00:42:00 Module 04: Writing Styles And Tone Writing Styles and Tone 00:44:00 Module 05: Additional Tips For Writing Effective E-Mail Additional Tips for Writing Effective E-Mail 00:44:00 Module 06: Exercise Caution Exercise Caution 00:44:00 Assignment Assignment - Email Writing Training 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Attain the best online training possible to become a sought-after manager who can steer Hotels and Hospitality services in successful directions. This Hospitality and Hotel Revenue Management Advanced Diplomacourse is designed to coach you in every aspect and element of Hospitality responsibilities and guarantees you are able to deliver outstanding customer service. The course is designed to prepare for the demands of customers in Hotels, and also such other events or locations, such as cruise ships, popular bars or clubs, restaurants, and high-profile tourist destinations. You will learn how to recruit and train staff, maintain housekeeping, upkeep a facility, and organise large-scale events and the appropriate catering. 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 Hospitality and Hotel Revenue Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Hospitality and Hotel Revenue Management Advanced Diploma 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 2 sections • 22 lectures • 07:08:00 total length •Module 01: Introduction to Hospitality Management: 00:24:00 •Module 02: An Overview of Hotel Industry: 00:18:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:21:00 •The Process of Development and Training in Hospitality Industry: 00:24:00 •Module 05: Management of Front Office Operations: 00:19:00 •Management of Housekeeping, Engineering and Security Operations: 00:27:00 •Management of Food and Beverage Operations: 00:20:00 •Management of Service Quality in Hospitality Industry: 00:20:00 •Marketing in Travel and Tourism Business: 00:24:00 •Module 10: Accounting in Hospitality Industry: 00:26:00 •Module 11: Customer Satisfaction: 00:20:00 •Module 12: E-Hospitality and Technology: 00:22:00 •Module 1. Fundamentals of Hotel Revenue Management: 00:16:00 •Module 2. Importance of Revenue Management: 00:20:00 •Module 3. Key Performance Indicator in Revenue Management: 00:18:00 •Module 4. Forecasting of Hotel Revenue Management: 00:21:00 •Module 5. Pricing of Hotel Revenue Management: 00:22:00 •Module 6. Profitable Distribution Strategy: 00:07:00 •Module 7. Overbooking Practices in Hotel Revenue Management: 00:10:00 •Module 8. How to Promote your Hotel: 00:15:00 •Module 9. Customer and Other Essential Factors: 00:13:00 •Module 10. The Future of Hotel Revenue Management in UK: 00:21:00

Overview It doesn't matter in which part of the world you live or what culture you follow; one thing is undoubtedly considered harmful to your present and future. That is Debt. Debt can make your life worse. It is like a vicious circle; a continuing unpleasant situation created when one problem causes another problem that then makes the first problem worse. No one wants to be part of this chain of events. But honestly speaking, the concept of debt is not always harmful. It depends on how you see it and use it. Here comes the role of Debt Management. You should know how to manage debt smartly and efficiently. At Apex Learning, we share the goal of millions of people, which is to make the world better. We have prepared a tool to help deal with debt management: our Debt Management - Online Course. You can access our course anytime, anywhere. Enrol now before falling into a debt trap. What Can You Expect From The Course? Understanding the fundamentals of debt management and its importance. Distinguishing between long-term and short-term debt and their implications. Identifying and assessing your personal debt situation effectively. Developing a realistic debt management plan. Learning strategies for avoiding debt problems. Dealing with bankruptcy and insolvency within legal regulations. 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 Debt Management - Online Course. It is available to all students, of all academic backgrounds. Requirements Our Debt Management - Online Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 • 14 lectures • 05:08:00 total length •Module 01: Introduction to Debt Management: 00:22:00 •Module 02: Long Term and Short Term Debt: 00:20:00 •Module 03: Identifying Your Debt: 00:27:00 •Module 04: Debt Management Plan: 00:30:00 •Module 05: Debt Assessment: 00:23:00 •Module 06: Debt Financing: 00:18:00 •Module 07: Building Budget: 00:23:00 •Module 08: Debt Counselling: 00:18:00 •Module 09: When Is Debt Good?: 00:19:00 •Module 10: Avoiding Debt Problems: 00:19:00 •Module 11: How to Handle Debt Collectors: 00:16:00 •Module 12: How to Get Out of Debt: 00:18:00 •Module 13: Dealing with Bankruptcy and Insolvency: 00:32:00 •Module 14: Laws and Regulations: 00:23: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