494 Row courses

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

Overview of Data Analyst: Data Analysis in Excel Join our Data Analyst: Data Analysis in Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Data Analyst: Data Analysis in Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Data Analyst: Data Analysis in Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! Get a Quick Look at The Course Content: This Data Analyst: Data Analysis in Excel Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Data Analyst: Data Analysis in Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Data Analyst: Data Analysis in Excel course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Data Analyst: Data Analysis in Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  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 You don't need any educational qualification or experience to enrol in the Data Analyst: Data Analysis in Excel 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 course. Career Path The certification and skills you get from this Data Analyst: Data Analysis in Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

Unlock your fitness potential with our comprehensive course curriculum featuring modules on Introduction, Anatomy, Client Assessment, Resistance Training, Exercise Instruction Videos, Cardio & Endurance Training, and Flexibility. Enroll now to start your journey towards becoming a certified Personal Trainer.

Master SQL Database Queries with our comprehensive course. Learn SQL fundamentals, advanced techniques, and data analysis skills for efficient database management.

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

Elevate your SQL skills with our Microsoft SQL Server Bootcamp 2024. Master SQL Server administration and development for data-driven decision-making and analysis.

Touch Typing: Touch Typing Training Are you excited to learn how to type properly and quickly without having to glance at the keyboard? You are welcome in our dynamic touch typing course. This touch typing course includes hand and finger placement techniques. Also, this touch typing course explains the methods to increase typing accuracy and speed. In addition, this touch typing course covers how to practice typing exercises that concentrate on the home, top, and bottom rows of the keyboard. Students in this touch typing course also learn to use all 10 fingers. Drills and exams are a common part of this touch typing course. Join our touch typing course to increase productivity and lower the chance of repetitive strain injuries! Learning outcomes of touch typing course After completing this touch typing course, students will learn about: The introduction of touch typing methods, their types, and keys using processes. How to drill sentences is also described in our touch typing course. Figures and alphabetical paragraphs are also taught by our touch typing course. Moreover, this touch typing course explains the ergonomics and posture of touch typing. Throughout this touch typing course, you will learn about typing software and tools. Special Offers Of this Touch Typing: Touch Typing course This Touch Typing: Touch Typing course includes a FREE PDF Certificate. Lifetime access to this Touch Typing: Touch Typing course Instant access to this Touch Typing: Touch Typing course Get FREE Tutor Support from Monday to Friday in this Touch Typing: Touch Typing course. [ Note: Free Digital certificate as soon as completing the Touch Typing: Touch Typing course] Touch Typing: Touch Typing Training Unlock your typing potential with our comprehensive Touch Typing: Touch Typing course. This Touch Typing: Touch Typing program teaches essential hand and finger placement techniques, ensuring you master the fundamentals. Learn how to increase typing accuracy and speed through proven methods in our Touch Typing: Touch Typing course. You'll practice exercises focusing on the home, top, and bottom rows of the keyboard, and gain the skill of using all 10 fingers efficiently. With drills and exams integrated into our Touch Typing: Touch Typing course, you'll develop the expertise needed for fast and accurate typing. Enroll today! Who is this course for? Touch Typing: Touch Typing Training Students, professionals, and everyone else who wants to increase their typing efficiency and speed should take our touch typing course. Requirements Touch Typing: Touch Typing Training To enrol in this Touch Typing: Touch Typing Course Course, students must fulfil the following requirements. To join in our Touch Typing: Touch Typing Course, you must have a strong command of the English language. To successfully complete our Touch Typing: Touch Typing Course, you must be vivacious and self driven. To complete our Touch Typing: Touch Typing Course, you must have a basic understanding of computers. Career path Touch Typing: Touch Typing Training This touch typing course helps you get a job in: Administration Data entry Tanscribing Writing Programming Customer service

Transcription: Audio Typing & Touch Typing Are you looking to boost your Audio Typing & Touch Typing skills? If you are interested, you can try our comprehensive Audio Typing & Touch Typing course. Participants of the Audio Typing & Touch Typing course learn touch typing techniques and improve listening skills. Moreover, the Audio Typing & Touch Typing course, students familiarise themselves with transcription software. The Audio Typing & Touch Typing curriculum includes exercises to enhance typing speed and accuracy. Additionally, the Audio Typing & Touch Typing course describes strategies for managing complex audio recordings. Students in Audio Typing & Touch Typing course also gain knowledge about formatting, proofreading, and editing transcribed documents. Through this Audio Typing & Touch Typing course, you can prepare for roles in transcription services across various industries. Learning outcomes of Audio Typing & Touch Typing course This Audio Typing & Touch Typing course teaches: Introduction to Audio Typing & Touch Typing and basics of Audio Typing & Touch Typing. This Audio Typing & Touch Typing course teaches typing techniques & speed enhancement. Audio typing text-to-speech, formatting, and guidelines for transcription are included in this Audio Typing & Touch Typing course. Figures and alphabetical paragraphs are also taught by our Audio Typing & Touch Typing course. Moreover, this Audio Typing & Touch Typing course explains the ergonomics and posture of touch typing. Throughout this Audio Typing & Touch Typing course, you will learn about typing software and tools. Transcription: Audio Typing & Touch Typing Course This Audio Typing & Touch Typing: Audio Typing & Touch Typing Course includes a FREE PDF Certificate. Lifetime access to this Audio Typing & Touch Typing: Audio Typing & Touch Typing Course Instant access to this Audio Typing & Touch Typing: Audio Typing & Touch Typing Course Get FREE Tutor Support to this Audio Typing & Touch Typing: Audio Typing & Touch Typing Course Transcription: Audio Typing & Touch Typing This Audio Typing & Touch Typing course includes hand and finger placement techniques. Also, this Audio Typing & Touch Typing course explains the methods to increase typing accuracy and speed. In addition, this Audio Typing & Touch Typing course covers how to practise typing exercises that concentrate on the home, top, and bottom rows of the keyboard. Students in this Transcription: Audio Typing & Touch Typing course also learn to use all 10 fingers. Drills and exams are a common part of this Audio Typing & Touch Typing course. Who is this course for? Transcription: Audio Typing & Touch Typing Students, recent graduates, and job seekers might benefit from this Audio Typing & Touch Typing course. Requirements Transcription: Audio Typing & Touch Typing To enrol in this Audio Typing & Touch Typing Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Audio Typing & Touch Typing Course. Be energetic and self-motivated to complete our Audio Typing & Touch Typing Course. Basic computer Skill is required to complete our Audio Typing & Touch Typing Course. If you want to enrol in our Audio Typing & Touch Typing Course, you must be at least 15 years old. Career path Transcription: Audio Typing & Touch Typing Many employment options, including those for audio typists, legal secretaries, medical transcriptionists, and many more, will become available with the purchase of this bundle that combines Audio Typing & Touch Typing course.

Overview of Admin, Secretarial & PA Training In the bustling business landscape of the UK, office administration remains an indispensable cornerstone, employing thousands. The rise in demand for adept administrative specialists is palpable, with companies valuing precision, efficiency, and stellar communication. This Office Skills for Admin, Secretarial, PA (Executive PA) course offers a springboard into office skills, equipping learners with a competitive edge in tasks spanning data analysis to top-tier executive support. Dive deep into the intricacies of Excel, master the finesse of business writing, and step up your organisational prowess. As businesses evolve, so does the role of administrative professionals; stay ahead with the Office Skills for Admin, Secretarial, PA (Executive PA) course. This Admin, Secretarial & PA Training Course will help you to learn: Acquire core competencies in administrative support roles. Enhance organisational efficiency through effective tools and techniques. Cultivate superior business writing and communication skills. Develop expertise in time management and meeting arrangements. Master the basics of Excel and PowerPoint for efficient data handling. Understand and apply proper telephone etiquette in professional settings. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize with this Admin, Secretarial & PA Training. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online — Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion – Digital / PDF Certificate After completing the Admin, Secretarial & PA Training course, you can order your CPD Accredited Digital/ PDF Certificate for £5.99. Certificate of Completion – Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Those aspiring to establish a foothold in the world of office administration will find this Office Skills for Admin, Secretarial, PA (Executive PA) course invaluable. From those just starting, wishing to comprehend the breadth of administrative tasks to those eyeing roles that demand advanced organisational skills, this curriculum caters to a broad spectrum. Individuals keen on mastering business communication, whether it’s through crafting persuasive emails or presenting data-driven insights, will benefit immensely. The Office Skills for Admin, Secretarial, PA (Executive PA) course also appeals to those aiming to work alongside top-tier executives, understanding the nuanced responsibilities of a Personal Assistant. With a special emphasis on tools like Excel and PowerPoint, it’s tailored for those who seek fluency in these ubiquitous office tools. Requirements You don’t need any educational qualification or experience to enrol in the Admin, Secretarial & PA Training 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 course. Career Path Executive Personal Assistant - £30K to £45K/year. Office Manager - £25K to £35K/year. Administrative Coordinator - £20K to £28K/year. Receptionist - £18K to £25K/year. Data Entry Clerk - £19K to £24K/year.

Follow your dreams by enrolling on the Microsoft Excel Masterclass course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Excel Masterclass will help you arm yourself with the qualities you need to work towards your dream job. Study the Microsoft Excel Masterclass training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Excel Masterclass course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Microsoft Excel Masterclass course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Excel Masterclass course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Microsoft Excel Masterclass course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Excel Masterclass course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Excel Masterclass course. The Microsoft Excel Masterclass course is designed by industry experts and is tailored to help you learn new skills with ease.  The Microsoft Excel Masterclass is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Excel Masterclass when it suits you. Access the Microsoft Excel Masterclass course modules from any internet-enabled device, including computers, tablets, and smartphones. The Microsoft Excel Masterclass course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Excel Masterclass now and start learning instantly! What You Get Out Of Studying Microsoft Excel Masterclass With Janets: Receive a digital Certificate upon successful completion of the Microsoft Excel Masterclass course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Microsoft Excel Masterclass training course is delivered through Janets' online learning platform. Access the Microsoft Excel Masterclass content from any internet-enabled device whenever or wherever you want to. The Microsoft Excel Masterclass course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Microsoft Excel Masterclass 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 Microsoft Excel Masterclass course. After successfully passing the Microsoft Excel Masterclass course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Excel Masterclass qualification. Certification All students who successfully complete the Microsoft Excel Masterclass course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Excel Masterclass course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Microsoft Excel Masterclass is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Excel Masterclass course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Microsoft Excel Masterclass is open to all students and has no formal entry requirements. To study the Microsoft Excel Masterclass course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Microsoft Excel Masterclass is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Excel Masterclass and gain an industry-recognised qualification that will help you excel in finding your ideal job.