18254 ESS courses in Bradford delivered Online

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  If you enjoy science and medicine a career as a pharmacist assistant might be right for you. Pharmacy Technician Diploma will help you gain a better grasp of the pharmaceutical sector, distributing prescription medication, and essential drug control rules. Pharmacy Technician Diploma is an online program that offers you the essential skills and knowledge you’ll need to operate in a variety of healthcare positions. This new programme is unlike any pharmacy technician programme you may have seen before. All knowledge, skills and behaviours are taught and assessed in one holistic programme The course covers a variety of topics, including pharmacy law, common abbreviations, basic computations, and a variety of other skills that pharmacy technicians utilize on a daily basis. Students will be able to study for the certification exam required to work as a pharmacy technician by taking advantage of the benefits of a self-paced course. What Will You Learn? Have a full understanding of what pharmacy technicians do. Understand commonly used pharmacy law. As a pharmacy assistant, effectively communicate with patients by focusing on essential patient counselling principles. Complete prescriptions and distribution in pharmacies correctly. Recognize the significance of risk assessment in the pharmaceutical industry. What classes are included in this package? Earn a digital certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This Pharmacy Technician Diploma is ideal for students, fresh graduates and anyone interested in this field as well as practitioners who are trying to polish their knowledge and skillset. Career Path Training offered by the Pharmacy Technician Diploma could potentially benefit a range of roles, but would particularly enhance careers in: Chemist Dispensing Assistant Pharmacy Technician Hospital Clerk Other professional pharmacy roles Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Retake fee If you do not pass the exam first time, you can purchase the Retake Exam for £1.99 and try again. Course Contents Pharmacy Assistant and Technician Introduction to Pharmacy Assistant and Pharmacy Technician Job Role of Pharmacy Technicians Pharmacy Assistant Patient Counselling Guide Communication in Pharmacy Settings The Pharmacy Team and Practices Prescription and Dispensing in Pharmacies Dispensing Methods, EPS, Minimising Dispensing Errors in Pharmacies Inventory Control and Management in Pharmacies Standard Operating Procedures (SOPs) Health and Safety Risks Assessment and Pharmaceutical Terminology

Embark on a comprehensive journey into Retail Management. From strategic planning and consumer behavior to multi-channel retailing and brand reputation, this course offers essential skills for thriving in the dynamic retail sector. Become an expert in managing and growing retail operations.

***Equip Yourself for Conflict Resolution with Mediation Basics for Conflict Management*** Did you know that according to a recent [CIPD]( Chartered Institute of Personnel and Development) report, 90% of HR professionals believe strong conflict resolution skills are important for a successful workplace? This "Mediation Basics for Conflict Management" course provides a comprehensive foundation for navigating disputes and fostering collaborative solutions. This "Mediation Basics for Conflict Management" course is designed to equip you with the theoretical knowledge and understanding to excel in the field of mediation. Through a series of engaging modules, you'll gain a strong grasp of core concepts, essential skills, and ethical considerations involved in this dynamic process. Learning Outcomes By participating in "Mediation Basics for Conflict Management," you will be able to: Define mediation and explain its role in conflict resolution. Identify the core skills necessary for effective mediation. Describe the different stages of the mediation process. Analyze the ethical principles and professional standards that govern mediation practice. Recognize special considerations that may arise in various mediation contexts. Apply your knowledge of mediation to better manage conflict situations. Delve into the core principles of mediation, starting with an exploration of introductory concepts and gradually advancing to essential skills crucial for effective mediation. Gain insights into the nuances of the mediation process and develop a profound understanding of the ethical standards that guide every mediator's practice. Course curriculum : Module 1: Introduction to Mediation Gain an overview of mediation, including its history, purpose, and significance in conflict management. Module 2: Essential Skills for Mediators Learn about the critical communication and interpersonal skills required for successful mediation. Module 3: The Mediation Process Understand the step-by-step process of mediation, from preparation to resolution. Module 4: Mediation Ethics and Professional Standards Explore the ethical principles and professional standards that guide mediators in their practice. Module 5: Special Considerations in Mediation Examine the unique challenges and considerations in various mediation contexts, such as workplace, family, and community disputes. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Mediation 15:04 1: Introduction to Mediation 15:04 Essential Skills for Mediators 17:39 2: Essential Skills for Mediators 17:39 The Mediation Process 15:39 3: The Mediation Process 15:39 Mediation Ethics and Professional Standards 19:12 4: Mediation Ethics and Professional Standards 19:12 Special Considerations in Mediation 17:25 5: Special Considerations in Mediation 17:25 Order Your CPD Quality Standard Certificate (Optional) 01:00 6: CPD Certificate (Optional) 01:00 Who is this course for? Mediation Basics for Conflict Management is ideal for anyone interested in: Pursuing a career in mediation Enhancing their conflict resolution skills in the workplace Building stronger relationships through effective communication Developing a deeper understanding of alternative dispute resolution (ADR) processes This course is designed to provide a strong theoretical foundation, and does not require prior experience in mediation. Requirements There are no prerequisites for this course. All participants will have the opportunity to actively engage with the course materials and ask questions to solidify their understanding of mediation principles. Career path Mediation is a growing field with applications in various sectors, including human resources, law, community organizations, and more. By successfully completing "Mediation Basics for Conflict Management," you'll be well-positioned to take the next step in your career path, potentially pursuing further training and certification to become a qualified mediator. Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed. CPD Quality Standard Certificate Digital certificate - £7.99

Do you find it difficult to feed your pet? Or are you unsure about which food to feed your pet? Our Nutrition : Pet Nutrition covers everything you need to know about pet nutrition. This course can help you in ensuring that you feed your pet the best food that meets their specific needs and requirements. The course will provide you a thorough understanding of the dietary needs of animals, food types, diet types, and pet food levels. This course includes the importance of pet nutrition, how to choose pet foods, digestion systems, and much more. By the end of this course, you will have a solid understanding in pet nutrition and understand the key pet nutrition concepts. The primary goal of this Nutrition : Pet Nutrition is to equip you with the essential knowledge to provide consultation on pet cat and dog or pet nutrition. Learning Outcomes After completing this course, learner will be able to: Understand the basic concepts of food types, types of diet and pet food labels Gain a thorough understanding of balanced nutrition Understand the importance of pet nutrition Gain in-depth knowledge of pet digestive systems Understand healthy pet weight Know how to use essential oils for dogs and other pets Why Choose Pet Nutrition Diploma Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] Detailed Course Curriculum Module 1: Introduction to Food Types, Types of Diet and Pet Food Labels Pet Food Types Types of Diet Understanding Pet food labels Module 2: Introduction to Balanced Nutrition Importance of Nutrition for Pets Who Determines Nutrient Requirements of Cats and Dogs? Nutritional requirements of the adult cat and dog Module 3: Importance of Pet Nutrition Benefits of Proper Nutrition What's the importance of good nutrition? What You Need to Know About Your Pet's Food Pet Nutrition: Life Stages Module 4: Pet Digestive Systems The Process of Food Digestion Module 5: Healthy Pet Weight Pet Weight Weight Problems and Solutions Module 6: Pet Feeding Guide Snacks and Treats Adding Herbs to Pet's Food Fruits and Veggies for Pets Pet Foods to Avoid Feeding Rabbits Feeding Hamsters Feeding Fishes Feeding Reptiles Module 7: Essential Oils for Dogs and Other Pets How to Use Essential Oils for Dogs and Other Pet How To Use Essential Oils for Pet Allergies Assessment Method After completing each module of the Nutrition : Pet Nutrition, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Nutrition : Pet Nutrition course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Nutrition : Pet Nutrition is ideal for anyone who works in a veterinary practice, a pet shop, or or has an interest in pet nutrition. Requirements There are no specific requirements for this Nutrition : Pet Nutrition course because it does not require any advanced knowledge or skills. Career path Completing this Nutrition : Pet Nutrition course may lead you to a variety of career opportunities. Such as: Pet nutritionist Animal nutritionist Certificates Certificate of completion Digital certificate - Included

Gain expertise in fire safety consultancy with our “Trajectory to Fire Safety Consultant” course. Learn essential skills such as fire risk assessment, emergency planning, and health and safety compliance. Start your journey today towards ensuring workplace safety and advancing your career in fire safety management.

Do you find it difficult to feed your pet? Or are you unsure about which food to feed your pet? Our Pet Nutrition Diploma covers everything you need to know about pet nutrition. This course can help you in ensuring that you feed your pet the best food that meets their specific needs and requirements. The course will provide you a thorough understanding of the dietary needs of animals, food types, diet types, and pet food levels. This course includes the importance of pet nutrition, how to choose pet foods, digestion systems, and much more. By the end of this course, you will have a solid understanding in pet nutrition and understand the key pet nutrition concepts. The primary goal of this diploma course is to equip you with the essential knowledge to provide consultation on pet cat and dog or pet nutrition. Learning Outcomes After completing this course, learner will be able to: Understand the basic concepts of food types, types of diet and pet food labels Gain a thorough understanding of balanced nutrition Understand the importance of pet nutrition Gain in-depth knowledge of pet digestive systems Understand healthy pet weight Understand the pet feeding guide Know how to use essential oils for dogs and other pets Why Choose this Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] Detailed Course Curriculum Module 1: Introduction to Food Types, Types of Diet and Pet Food Labels Pet Food Types Types of Diet Understanding Pet food labels Module 2: Introduction to Balanced Nutrition Importance of Nutrition for Pets Who Determines Nutrient Requirements of Cats and Dogs? Nutritional requirements of the adult cat and dog Module 3: Importance of Pet Nutrition Benefits of Proper Nutrition What's the importance of good nutrition? What You Need to Know About Your Pet's Food Pet Nutrition: Life Stages Module 4: Pet Digestive Systems The Process of Food Digestion Module 5: Healthy Pet Weight Pet Weight Weight Problems and Solutions Module 6: Pet Feeding Guide Snacks and Treats Adding Herbs to Pet's Food Fruits and Veggies for Pets Pet Foods to Avoid Feeding Rabbits Feeding Hamsters Feeding Fishes Feeding Reptiles Module 7: Essential Oils for Dogs and Other Pets How to Use Essential Oils for Dogs and Other Pet How To Use Essential Oils for Pet Allergies Assessment Method After completing each module of the Pet Nutrition Diploma, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Pet Nutrition Diploma course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This course is ideal for anyone who works in a veterinary practice, a pet shop, or or has an interest in pet nutrition. Requirements Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Completing this Pet Nutrition Diploma course may lead you to a variety of career opportunities. Such as: Pet nutritionist Animal nutritionist Certificates Certificate of completion Digital certificate - Included

Do you find it difficult to feed your pet? Or are you unsure about which food to feed your pet? Our Nutrition : Pet Nutrition Diploma covers everything you need to know about pet nutrition. This course can help you in ensuring that you feed your pet the best food that meets their specific needs and requirements. The course will provide you a thorough understanding of the dietary needs of animals, food types, diet types, and pet food levels. This course includes the importance of pet nutrition, how to choose pet foods, digestion systems, and much more. By the end of this course, you will have a solid understanding in pet nutrition and understand the key pet nutrition concepts. The primary goal of this Nutrition : Pet Nutrition Diploma is to equip you with the essential knowledge to provide consultation on pet cat and dog or pet nutrition. Learning Outcomes After completing this course, learner will be able to: Understand the basic concepts of food types, types of diet and pet food labels Gain a thorough understanding of balanced nutrition Understand the importance of pet nutrition Gain in-depth knowledge of pet digestive systems Understand healthy pet weight Understand the pet feeding guide Know how to use essential oils for dogs and other pets Why Choose Pet Nutrition Diploma Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Diploma Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. ***Others Benefits of this Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] Detailed Course Curriculum Module 1: Introduction to Food Types, Types of Diet and Pet Food Labels Pet Food Types Types of Diet Understanding Pet food labels Module 2: Introduction to Balanced Nutrition Importance of Nutrition for Pets Who Determines Nutrient Requirements of Cats and Dogs? Nutritional requirements of the adult cat and dog Module 3: Importance of Pet Nutrition Benefits of Proper Nutrition What's the importance of good nutrition? What You Need to Know About Your Pet's Food Pet Nutrition: Life Stages Module 4: Pet Digestive Systems The Process of Food Digestion Module 5: Healthy Pet Weight Pet Weight Weight Problems and Solutions Module 6: Pet Feeding Guide Snacks and Treats Adding Herbs to Pet's Food Fruits and Veggies for Pets Pet Foods to Avoid Feeding Rabbits Feeding Hamsters Feeding Fishes Feeding Reptiles Module 7: Essential Oils for Dogs and Other Pets How to Use Essential Oils for Dogs and Other Pet How To Use Essential Oils for Pet Allergies Assessment Method After completing each module of the Nutrition : Pet Nutrition Diploma, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Nutrition : Pet Nutrition Diploma course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Nutrition : Pet Nutrition Diploma is ideal for anyone who works in a veterinary practice, a pet shop, or or has an interest in pet nutrition. Requirements There are no specific requirements for this Nutrition : Pet Nutrition Diploma course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Completing this Nutrition : Pet Nutrition Diploma course may lead you to a variety of career opportunities. Such as: Pet nutritionist Animal nutritionist Certificates Certificate of completion Digital certificate - Included

Join our Microsoft Power BI Masterclass 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 Microsoft Power BI Masterclass course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Power BI Masterclass 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! You will Learn The Following Things: 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 Microsoft Power BI Masterclass. 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 After completing the Microsoft Power BI Masterclass course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Power BI Masterclass 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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Power BI Masterclass 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 Microsoft Power BI Masterclass 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 Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:02:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up - Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Microsoft Power BI Masterclass 00:00:00

Microsoft Office skills are in high demand across industries, and proficiency in Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Office 365 opens up numerous career opportunities. In the UK, administrative roles, data analysis positions, office management, project coordination, and marketing support roles are just a few examples of job prospects. With average salaries ranging from £20,000 to £45,000 per year, individuals with comprehensive Microsoft Office skills can secure stable employment and contribute to the success of various organisations. Enrol in the Ultimate Microsoft Office Skills Training course today and equip yourself with the knowledge and expertise needed to thrive in the ever-evolving workplace. You Will Learn Following Things: Develop a solid foundation in Microsoft Office applications, including Word, Excel, PowerPoint, and Office 365. Acquire essential skills to efficiently navigate and manipulate data in Microsoft Excel, such as organising, sorting, filtering, and writing formulas. Gain proficiency in creating professional presentations in Microsoft PowerPoint, utilising features like multimedia, transitions, animations, and smart graphics. Master the art of document creation and formatting in Microsoft Word, including tables, styles, page layouts, envelopes, labels, and mail merges. Understand advanced features like pivot tables, charts, and data analysis tools in Microsoft Excel, enabling effective data visualisation and decision-making. This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. 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 This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Mastering Microsoft Office: Word, Excel, PowerPoint, and 365. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This course is designed for individuals who want to enhance their Microsoft Office skills for personal or skilled purposes. Whether you are a student, an experienced entrepreneur, or anyone who regularly works with Microsoft Word, Excel, PowerPoint, and Office 365, this Microsoft Office skills course will provide you with a solid foundation and advanced techniques to maximise your productivity and efficiency. No prior experience is required, making it suitable for beginners and intermediate users looking to expand their knowledge and capabilities in the Microsoft Office suite. On the other hand, anyone who wants to establish their career as: like MS Office User Microsoft Office 2019 User Touch Typing Worker Audio Typist Can take this Ultimate Microsoft Office Skills Training (Word, Excel, PowerPoint, and 365) course. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 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 Administrative Assistant - £20K to £30K/year Data Analyst - £25K to £45K/year Office Manager - £25K to £40K/year Project Coordinator - £25K to £35K/year Marketing Assistant - £20K to £30K/year Course Curriculum Section 01: Getting Started Introduction 00:03:00 Getting started on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: Excel 2021: Basics Excel Overview 00:05:00 Start Excel Spreadsheet 00:04:00 Enter Text and Numbers 00:07:00 Relative References 00:04:00 Working with ranges 00:07:00 Save and Save as Actions 00:08:00 File Extensions, Share, Export, and Publish files 00:06:00 Section 03: Excel 2021: Rows, Columns, and Cells Adding Rows and Columns 00:03:00 Modifying Rows and Column lengths 00:05:00 Section 04: Excel 2021: Data Handling Copy, Cut, and Paste 00:07:00 Copying Formulas 00:03:00 Section 05: Excel 2021: Page Setting Up and Print Page setup options 00:06:00 Fit to print on One Page 00:03:00 Print Workbooks 00:03:00 Section 06: Excel 2021: Sorting and Filtering Sorting Data Ascending Order 00:04:00 Sorting Data Descending Order 00:02:00 Filter Data 00:04:00 Section 07: Excel 2021: Writing Formulas Creating Basic Formulas 00:06:00 Datetime Formulas 00:06:00 Mathematical formulas phase1 00:20:00 Mathematical formulas phase2 00:12:00 Section 08: Excel 2021: Advanced Formulas VLOOKUP formula 00:12:00 HLOOKUP formula 00:04:00 Section 09: Excel 2021: XLOOKUP only for 2021 and Office 365 XLOOKUP 00:08:00 Handling #NA and Approximates match in XLOOKUP 00:11:00 Section 10: Excel 2021: Data and Tools Split Text into columns 00:07:00 Flash Fill 00:07:00 Data Validation 00:07:00 Remove Duplicates 00:08:00 Import Data from Text files 00:06:00 Import Data from .CSV files 00:03:00 Section 11: Excel 2021: Formatting data and tables Formatting Font 00:04:00 Formatting Alignment 00:06:00 Formatting Numbers 00:05:00 Formatting Date 00:03:00 Formatting Tables 00:05:00 Section 12: Excel 2021: Pivot Tables Pivot Tables 00:07:00 Pivot Charts 00:02:00 Section 13: Excel 2021: Charts Excel Charts - Categories 00:03:00 Elements of a chart 00:04:00 Creating Charts 00:02:00 Column or Bar charts 00:04:00 Formatting charts 00:04:00 Line Charts 00:02:00 Pie and Doughnut charts 00:04:00 Section 14: PowerPoint 2021: Course Introduction Overview 00:04:00 Start PowerPoint Presentation 00:05:00 Screen setting and Views 00:05:00 Section 15: PowerPoint 2021: Basics Presentation Tips and Guidelines 00:06:00 Creating a New Presentation 00:04:00 Working with Slides 00:04:00 Save a Presentation 00:04:00 Print Slides 00:03:00 Section 16: PowerPoint 2021: Text and Bullet Options Formatting Text 00:05:00 Slide Text Alignments 00:03:00 Multi-Column Text Alignments 00:02:00 Adding Bullets and Numbered List Items 00:03:00 Section 17: PowerPoint 2021: Adding Graphic Assets Insert Shapes 00:03:00 Insert Icons 00:03:00 Insert Graphics 00:04:00 Add 3D Models 00:03:00 Insert Pictures 00:03:00 Section 18: PowerPoint 2021: Picture Formatting Picture Options 00:04:00 Picture Cropping 00:03:00 Applying Built-in Picture Styles 00:04:00 Section 19: PowerPoint 2021: SmartArt Graphics Add SmartArt Graphic 00:03:00 Modifying SmartArt 00:03:00 Creating a Target Chart using SmartArt 00:03:00 Section 20: PowerPoint 2021: Working with Tables Create a Table on Slide 00:04:00 Formatting Tables 00:02:00 Inserting Tables 00:02:00 Table Layouts 00:01:00 Section 21: PowerPoint 2021: Working with Charts Add a Chart 00:02:00 Formatting Charts 00:02:00 Insert Chart from Microsoft Excel 00:03:00 Section 22: PowerPoint 2021: Adding Multimedia Adding Video to a Presentation 00:03:00 Adding Audio to a Presentation 00:02:00 Screen Recording and Adding 00:02:00 Section 23: PowerPoint 2021: Working with Transition Applying Transitions to Presentation 00:04:00 Section 24: PowerPoint 2021: Animation Object Animation 00:03:00 Effect Options 00:02:00 Advanced Animation 00:02:00 Triggers to control animation 00:02:00 Section 25: PowerPoint 2021: Slideshow Effects Onscreen Presentation 00:02:00 Hiding Slides 00:02:00 Changing Order of Slides 00:02:00 Copying Slides 00:02:00 Section 26: Word 2021: Introduction Overview of MS Word 00:04:00 Start MS Word 2021 00:05:00 Section 27: Word 2021: Basics Create a new blank document 00:04:00 Creating a paragraph text 00:05:00 Non-printing characters 00:03:00 Save a document 00:03:00 Open a document 00:01:00 Find and replace 00:04:00 Section 28: Word 2021: Word Formatting AutoCorrect options 00:03:00 Formatting text 00:04:00 Copy cut and paste 00:04:00 Character formatting 00:02:00 Format painter 00:04:00 Work with numbers 00:02:00 Add bullets 00:03:00 Outline creation 00:04:00 Section 29: Word 2021: Tables Creating a table 00:03:00 Adding rows and columns to a table 00:02:00 Formatting table data 00:02:00 Borders and shading 00:02:00 Sorting in a table 00:04:00 Draw a table 00:04:00 Convert text to table 00:03:00 Convert table to text 00:02:00 Insert a spreadsheet 00:02:00 Quick tables - readily available formats 00:02:00 Section 30: Word 2021: Styles Working with styles 00:02:00 Creating styles 00:02:00 Clear formatting 00:01:00 Section 31: Word 2021: Page Layout Margins 00:02:00 Orientation 00:01:00 Page size setting 00:01:00 Adding columns 00:03:00 Page break - section break 00:02:00 Adding watermark 00:03:00 Headers and footers 00:03:00 Section 32: Word 2021: Envelops and Lables Create envelops 00:02:00 Creating labels 00:02:00 Section 33: Word 2021: Mail Merges Creating a mail merge document 00:03:00 Section 34: Word 2021: Review and Printing Thesaurus and spell check 00:01:00 Word count 00:01:00 Speech - read aloud 00:01:00 Language - translate 00:01:00 Tracking 00:01:00

***Transform Yourself: From Beginner to Legal Secretary in One Course*** Did you know according to a recent report, the demand for Legal Secretaries is expected to grow by 5% in the next few years? This essential role provides the foundation for a successful legal career. If you're looking to step into the exciting world of law, this legal course comprehensive course equips you with the knowledge and skills to thrive as a Legal Secretary. This Legal Secretary - Legal Office Administration and Support course is designed to provide a theoretical grounding in all the key areas a Legal Secretary needs to excel. Through a series of engaging modules, you'll gain a thorough understanding of English Law, legal terminology, and essential secretarial practices. Learning Outcomes By the end of this Legal Secretary - Legal Office Administration and Support course, you will be able to: Gain a thorough understanding of the legal secretary's role and responsibilities within a legal practice. Develop a strong foundation in English Law and the legal systems that govern the UK. Master the fundamentals of contract law, tort law, wills & probate, property law, criminal law, and family law. Hone your skills in professional writing, document creation, proofreading, and editing. Learn effective meeting management, minute-taking techniques, and data management practices. Develop a comprehensive understanding of human rights and their application in legal contexts. Key Highlights for Legal Secretary - Legal Office Administration and Support Course: CPD QS Accredited Proficiency with this Legal Secretary course. After successfully completing the Legal Secretary course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Legal Secretary course. The online test with immediate results You can study and complete the Legal Secretary course at your own pace. Study for the Legal Secretary course using any internet-connected device, such as a computer, tablet, or mobile device. This Legal Secretary - Legal Office Administration and Support course is your gateway to a fulfilling career as a Legal Secretary. Throughout the course, you'll delve into various legal areas, including contract law, tort law, wills & probate, property law, criminal law, family law, and business law. You'll gain insights into the legal systems within the UK and explore the intricacies of legal documents. The Legal Secretary course also emphasizes the importance of communication, interpersonal skills, and organization, all essential for success as a Legal Secretary. Furthermore, you'll develop proficiency in document proofreading, editing, and minute-taking, ensuring accuracy and efficiency in your daily tasks. The Legal secretary course also covers essential secretarial skills like data management, record-keeping, and meeting management, equipping you to provide exceptional support to lawyers and legal teams. Curriculum Breakdown of the Legal Secretary - Legal Office Administration and Support Course Module 01: Introduction to Legal Secretary Module 02: English Law & Legal Systems Module 03: Law of Contract & Law of Tort Module 04: Wills, Probate, Estate Law Module 05: Property Law & Conveyancing Practice Module 06: Criminal Law Module 07: Understanding Criminal Psychology Module 08: Contract & Business Law Module 09: Family Law and Insurance Practice Module 10: Conflict and Conflict Resolution Module 11: Professional Writings and Documents Module 12: Document Proofreading and Editing Module 13: Meeting Management & Minute Taking Module 14: Data Management and Record-Keeping Module 15: Other Essential Skills for Secretarial Role Module 16: Human Rights CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Legal Secretary - Legal Office Administration and Support course is suitable for: Individuals with an interest in a career in law. Those seeking to become a Legal Secretary. Professionals looking to enhance their legal knowledge and secretarial skills. Graduates seeking entry-level positions in the legal sector. Career changers interested in transitioning into the legal field. Anyone who wants to gain a foundational understanding of the legal system. Requirements There are no specific prerequisites for this Legal Secretary - Legal Office Administration and Support However, a basic understanding of legal terminology and strong written communication skills will be beneficial. Career path This Legal Secretary - Legal Office Administration and Support course provides a strong foundation for a fulfilling career as : Paralegal Legal Assistant Solicitor (with further qualifications) Legal Compliance Officer Legal Consultant Legal Case Manager ***Enroll today and take the first step towards becoming a successful Legal Secretary!*** Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each