- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Microsoft Excel Complete Course - Beginner Intermediate & Advanced
By iStudy UK
Microsoft Excel Complete Course - Beginner Intermediate & Advanced To make learning Microsoft Excel easier for you, we have thoughtfully bundled our three greatest courses: Microsoft Excel Beginners, Intermediate, and Advanced. At this price, you won't find a better deal anywhere else. One of the most popular applications for visualizing and analyzing data that has been created to date is Microsoft Excel. These days, practically every industry and household use this helpful program for personal purposes. Excel is used by business owners for a plethora of tasks, including data analysis, visualizing data, tracking hours worked, money, and statements. This Microsoft Excel Complete Course can be very helpful to you whether you are a newbie, have some training and experience with the program, or haven't used Excel in a long time and need a thorough refresher to develop your skills. After completing this course, you will be a proficient Excel user. In a short period of time, our simple lessons will impart the knowledge in a very easy way. There won't be a rush because you can study whenever you want and at your own speed. After completing the course, your confidence in using Excel will increase. Course Highlights Microsoft Excel Complete Course - Beginner Intermediate & Advanced is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Microsoft Excel Complete Course - Beginner Intermediate & Advanced into 73 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 11 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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? Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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 Microsoft Excel Complete Course - Beginner Intermediate & Advanced 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. Microsoft Excel Complete Course - Beginner Intermediate & Advanced Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features 00:07:00 CONCAT 00:02:00 IFS 00:01:00 MAXIFS 00:01:00 MINIFS 00:01:00 SWITCH 00:02:00 TEXTJOIN 00:01:00 Map Chart 00:02:00 Funnel Chart 00:01:00 Better Visuals 00:06:00 Pivot Table Enhancements 00:02:00 Power Pivot Updates 00:01:00 Getting Started With Microsoft Office Excel Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:28:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 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 Formatting A Worksheet Apply Text Formats 00:16:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:08:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:09:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:06:00 Working With Functions Work with Ranges 00:18:00 Use Specialized Functions 00:11:00 Work with Logical Functions 00:24:00 Work with Date & Time Functions 00:08:00 Work with Text Functions 00:11: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:06:00 Visualizing Data With Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:13:00 Using PivotTables And Pivot Charts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with Pivot Charts 00:08: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:06:00 Using Lookup Functions And Formula Auditing Use Lookup Functions 00:13:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:09:00 Sharing And Protecting Workbooks Collaborate on a Workbook 00:20:00 Protect Worksheets and Workbooks 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:09:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00 Excel Templates Excel Templates 00:00:00 Resources Microsoft Excel 2019 00:00:00 Assignment Assignment - Microsoft Excel Complete Course - Beginner Intermediate & Advanced 00:00:00
Children require extra attention and protection. However, not everyone is able to create a safe environment. It requires good skills and knowledge of this area. Therefore, if you want to pursue a career where you will work with children, you must develop your safeguarding skills. Our Safeguarding: Child Protection and Prevent course will help you out. It will equip you with the right knowledge and skills in this subject. This online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 05 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. From the comprehensive course, you will receive an overall understanding of child protection and safeguarding. The course will help you deepen your knowledge of child abuse and child sexual exploitation. In this step-by-step training course, you will pick up effective skills for risk assessment. The course will ensure you have a clear understanding of the reporting and record-keeping process. By the end of the course, you will grasp a solid foundation in safeguarding children. After completing this ultimate training, you will receive a certificate of achievement. This certificate will add significant value to your resume and increase your employability. Enrol now! Key Learnings Familiarise yourself with the laws and regulations regarding Enrich your knowledge of child abuse and child sexual exploitation Develop the skills required for risk assessment Learn about the process of reporting Build your expertise in record keeping Why Prefer this Advanced Safeguarding: Child Protection and Prevent Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support Experts created the course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the Advanced course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Advanced Safeguarding: Child Protection and Prevent course: Advanced Safeguarding: Child Protection and Prevent Course Module 01:Introduction to Safeguarding This Advanced course module cover the following topics: What is Safeguarding? Who is a child? What is child protection? Who commits maltreatment? Why is safeguarding training important? and more Module 02: Laws and Guidance This Advanced course module cover the following topics: History of Child Protection in the UK The Victoria Climbey Enquiry Child Protection System in England (The department of Education) The Children Act (short one or two sentence overview and then, key principles in bullet points; need to be short and concise) The Children Act 1989 The Children Act 2003 Children and Social Work Act 2017 Policy and Guidance Working together to safeguard children 2017 (key principle and amendments and Key changes from the 2015 version) Keeping children safe in education (key principles) What to do if you're worried a child is being abused: advice for practitioners (key advice) and more Module 03: Child Abuse This Advanced course module cover the following topics: Definition of child abuse Who is at risk and why? Types of Abuse Neglect Domestic Abuse Physical Abuse Emotional Abuse Sexual Abuse (short description and then refer to module 4 for further study) Bullying and more Module 04: Child Sexual Exploitation This Advanced course module cover the following topics: Child Sexual Exploitation Types of Sexual Abuse Contact Abuse Non-Contact Abuse Harmful Sexual Behaviour Female Genital Mutilation (overview, signs and effects) Who are the abusers? Online Sexual Offenders Signs of Sexual Abuses in Children Impact of Sexual Abuses in Children What to do when a child reveals sexual abuses to you Lessons from child sexual abuses Common Patterns of child Sexual Abuses in the UK The relation between the child and the abuser Different patterns and styles of male sexual offending against children Female abuser and more Module 05: Responding to Disclosure and Reporting This Advanced course module cover the following topics: What is Disclosure? Understand why children don't disclose What to do if a child discloses Taking Action Your Responsibilities Fulfilling 'Duty of Care' What, when and How to Report Myths about reporting The structure of reporting in the UK Organisations that may provide support Talking to the parents Referrals to Social Care How is a referral made Module 06: Risks and Risk Assessment This Advanced course module cover the following topics: Factors that may increase the risk Where do risks come from? Single Assessment Process How to assess if the child is at risk of harm or not? How to recognise a risky situation? Parental Risk factors Parental Mental Health Parental Substance Misuse Module 07: Things to Do After Referral This Advanced course module cover the following topics: Social Care's Decision What to do If you disagree with the decision Early Help Assessment Statutory Assessment The strategy Discussions Child Protection Conferences Child Protection Plans Learning and improving the framework Child death reviews The review Conference Online Child Protection Learning Resources Module 08: Record Keeping This Advanced course module cover the following topics: What to Record? When to Record? How to Record? What is a Concern? Why should one keep records? What happens if one doesn't keep effective records? Who needs to understand record keeping? Storage of Information Sharing of Information Data Protection How to transfer the safeguarding files? How long are records kept for? Assessment Process Once you have completed all the modules in the Advanced Safeguarding: Child Protection and Prevent course, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course will be beneficial for professionals working with children. It will be an excellent training opportunity for aspiring professionals in the relevant industries. In addition, parents or anyone with an interest in learning about child protection can take the course. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your speed and grow a quality skillset. Career path Safeguarding Officer (Annual salary range £26,000- £37,000) Social Worker (Annual salary range £34,000- £67,000) Teacher (Annual salary range £31,000- £41,000) Child Care Worker (Annual salary range £22,000- £58,000) Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
24-Hour Flash Sale! Prices Reduced Like Never Before!! It's very disheartening to live in a world where your voice isn't heard, where your needs and challenges are overlooked just because of a lack of understanding. In the UK alone, over 1.5 million individuals are navigating life with learning disabilities, facing barriers that many of us can't fathom. It's a reality that's often hidden in plain sight, creating a silent epidemic of isolation and unmet potential. This is why the "Learning Disability Nursing" course is designed to bridge this gap, equipping you with the knowledge and skills to make a profound difference. Understand the complex relationship between Learning Disabilities and Mental Health. Master Psychosocial and Psychodynamic Interventions. You'll explore the full spectrum of care throughout the lifespan, learning to advocate for health and well-being and to craft personalised care plans in mental health settings. With lessons dedicated to Nursing Models, Behavioural Interventions, and the future of the profession, this course sets you on a path to becoming a pivotal part of individuals' lives, offering hope and tangible support where it's needed most. Learning Outcomes of the Learning Disability Nursing Course: Understand the complex needs of individuals with learning disabilities. Apply psychosocial and psychodynamic interventions effectively. Support the lifelong health and well-being of those with learning disabilities. Develop and implement targeted care plans in mental health settings. Explore and understand the evolving role of learning disability nurses. Prepare for future spheres of practice in learning disability nursing. Step into a career that transcends the ordinary. The "Learning Disability Nursing" course offers you not just a job, but a calling-a chance to be the change in the lives of those who navigate the world differently. With the skills and insights gained from this course, you're not just improving careers; you're transforming lives and shaping the future of healthcare. Join us on this journey to make a difference, one individual at a time! Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Curriculum Breakdown of the Learning Disability Nursing Course Module 01: Learning Disability and Mental Health Explores the relationship between learning disabilities and mental health, addressing common mental health issues, their impact on individuals with learning disabilities, and strategies for effective management and support. Module 02: Learning Disability Nursing Provides an overview of the principles and practices of learning disability nursing, emphasizing person-centered care, advocacy, and tailored interventions to meet individual needs. Module 03: Psychosocial Interventions Covers various psychosocial interventions for individuals with learning disabilities, including cognitive-behavioral therapy, social skills training, and support groups, aiming to enhance mental health and quality of life. Module 04: Psychodynamic Approaches Examines psychodynamic theories and their application in learning disability nursing, focusing on understanding unconscious processes, emotional development, and therapeutic relationships. Module 05: Learning Disability Nursing Throughout the Lifespan Discusses the role of learning disability nurses in providing care across different life stages, from childhood to old age, addressing age-specific needs and challenges. Module 06: Role of the Learning Disability Nurse in Promoting Health and Well-Being Highlights the proactive role of learning disability nurses in promoting overall health and well-being, including health education, preventive care, and lifestyle interventions. Module 07: Care Planning in Mental Health Settings Focuses on developing and implementing effective care plans for individuals with learning disabilities in mental health settings, ensuring comprehensive, coordinated, and person-centered care. Module 08: Nursing Models and Behavioural Interventions Explores various nursing models and behavioral interventions used in learning disability nursing, emphasizing evidence-based practices and individualized approaches. Module 09: The Future of Learning Disability Nursing Discusses emerging trends, challenges, and opportunities in the field of learning disability nursing, preparing nurses for future advancements and evolving practices. Module 10: Future Spheres of Practice for Learning Disability Nursing Examines potential future roles and specializations for learning disability nurses, including advanced practice, research, policy development, and interdisciplinary collaboration. Assessment Process Once you have completed all the modules on the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 1: Learning Disability and Mental Health 26:13 1: Learning Disability and Mental Health Preview 26:13 Module 2: Learning Disability Nursing 25:47 2: Learning Disability Nursing 25:47 Module 3: Psychosocial Interventions 25:11 3: Psychosocial Interventions 25:11 Module 4: Psychodynamic Approaches 21:32 4: Psychodynamic Approaches 21:32 Module 5: Learning Disability Nursing Throughout the Lifespan 54:38 5: Learning Disability Nursing Throughout the Lifespan 54:38 Module 6: Role of the Learning Disability Nurse in Promoting Health & Well-Being 46:59 6: Role of the Learning Disability Nurse in Promoting Health and Well-Being 46:59 Module 7: Care Planning in Mental Health Settings 20:24 7: Care Planning in Mental Health Settings 20:24 Module 8: Nursing Models and Behavioral Interventions 25:12 8: Nursing Models and Behavioural Interventions 25:12 Module 9: The Future of Learning Disability Nursing 26:25 9: The Future of Learning Disability Nursing 26:25 Module 10: Future Spheres of Practice for Learning Disability Nursing 21:51 10: Future Spheres of Practice for Learning Disability Nursing 21:51 Order Your Certificate 02:00 11: Order Your CPD Certificate 01:00 12: Order Your QLS Endorsed Certificate 01:00 Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring nurses Healthcare workers Social care staff Mental health professionals Educational support staff Career changers Please note: This course doesn't entitle you to practice as a professional in this specific field. Rather, this course will assist you in understanding the fundamentals so that you can improve your knowledge in the relevant field. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Learning Disability Nurse - £24,000 to £30,000 Mental Health Nurse - £24,000 to £30,000 Healthcare Coordinator - £20,000 to £25,000 Special Educational Needs (SEN) Teacher - £25,000 to £41,000 Care Manager - £30,000 to £40,000 Behavioural Therapist - £27,000 to £37,000 Certificates Cademy certificate of completion Digital certificate - Included Will be downloadable when all lectures have been completed CPD Accredited Digital Certificate Digital certificate - £12.99 Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.
Kickstart your career in real estate or gain recognition of your existing skills with this comprehensive online course. The Property Viewing Agent Course is designed, delivered and taught by industry experts, ensuring you learn the practical, effective skills necessary to succeed in a range of expert property and real estate roles. Through online lessons, PDH handouts and multiple-choice online assessments, you will be given all the essential knowledge you need in property law, real estate practice and investment. This includes modules on the property and building management, developing a client base, acquiring the property, and successful strategies for investment. Upon completion, you will have a complete understanding of the roles of an expert estate agent, and also gain broader, transferable business management and sales skills. Learning Outcomes Get to know the types of estate agents Learn how to list the property and find the sellers Also, learn about how to sell the property and find the buyers Gain knowledge of negotiating as estate agents Learn the techniques of letting property Get familiar with the technologies for estate agents Understand the rules and regulations of estate agents 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 Online study materials Mock exams Multiple-choice assessment Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Certificate of Achievement CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. garding real estate agents. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Method of Assessment To successfully complete the 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 course. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Why study this course You will learn everything that is needed regarding real estate agents. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Who is this course for? This is the best online course for being a successful estate agent and suitable for anyone who wants to gain extensive knowledge, potential experience, and expert skills in the related field. Industry experts designed this course, so you don't have to worry about the quality. Requirements The Property Viewing Agent Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career path Training offered by the Property Viewing Agent Course could potentially benefit a range of roles, but would particularly enhance careers in- Real Estate Property Management Loan Underwriting Consultancy Property Law Investment Other property or estate agent roles
Kickstart your career in real estate or gain recognition of your existing skills with this comprehensive online course. The Estate Agency Branch Manager Course is designed, delivered and taught by industry experts, ensuring you learn the practical, effective skills necessary to succeed in a range of expert property and real estate roles. Through online lessons, PDH handouts and multiple-choice online assessments, you will be given all the essential knowledge you need in property law, real estate practice and investment. This includes modules on the property and building management, developing a client base, acquiring the property, and successful strategies for investment. Upon completion, you will have a complete understanding of the roles of an expert estate agent, and also gain broader, transferable business management and sales skills. Learning Outcomes Get to know the types of estate agents Learn how to list the property and find the sellers Also, learn about how to sell the property and find the buyers Gain knowledge of negotiating as estate agents Learn the techniques of letting property Get familiar with the technologies for estate agents Understand the rules and regulations of estate agents 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 Online study materials Mock exams Multiple-choice assessment Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Certificate of Achievement CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. garding real estate agents. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Method of Assessment To successfully complete the 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 course. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Why study this course You will learn everything that is needed regarding real estate agents. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Who is this course for? This is the best online course for being a successful estate agent and suitable for anyone who wants to gain extensive knowledge, potential experience, and expert skills in the related field. Industry experts designed this course, so you don't have to worry about the quality. Requirements The Estate Agency Branch Manager Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career path Training offered by the Estate Agency Branch Manager Course could potentially benefit a range of roles, but would particularly enhance careers in- Real Estate Property Management Loan Underwriting Consultancy Property Law Investment Other property or estate agent roles
