11748 Professional Development courses in Durham delivered Online

In the dynamic landscape of Biomedical Engineering, staying ahead is not just an advantage but a necessity. Recent challenges in the UK's biomedical sector underline the urgent need for skilled professionals equipped to navigate and innovate in this evolving field. Our CPD Certified Diploma in Biomedical Engineering addresses these concerns head-on, providing a comprehensive curriculum that delves into crucial areas such as Biomedical Science, Microbiology Lab Techniques, and Radiography. This Diploma in Biomedical Engineering - CPD Certified Bundle Consists of the following Premium courses: Course 01: Biomedical Science Course 02: Basic Biology Course 03: Anatomy and Physiology of Human Body Course 04: Human Anatomy, Physiology and Medical Terminology Diploma Course 05: Microbiology Lab Technician Course 06: Understanding the Immune System: Online Training in Immunology Course 07: Preventing Contamination in the Laboratory: Best Practices in Lab Safety Course 08: Cell Biology, Glycolysis and Gluconeogenesis Diploma Course 09: Neuroscience: Exploring the Wonders of the Human Brain Course 10: Radiography Course 11: Phlebotomy and Venipuncture Expert Training Course 12: Personal Hygiene Course 13: Infection Control & Medicine Handling Course 14: Health Science Diploma Level 3 Course 15: Epidemiology Certificate Course 16: Spill Management Training Course 17: Phlebotomist Training Course 18: Introduction to Orthodontic Biomechanics: Orthodontics Principles Course 19: Dermatology Level 3 Course 20: Nurse Prescribing and Medicine Management 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01: Effective Communication Skills Diploma Course 02: Business Networking Skills Course 03: Influencing and Negotiation Skills Course 04: Delegation Skills Training Course 05: Time Management Course 06: Leadership Skills Training Course 07: Decision Making and Critical Thinking Online Course Course 08: Emotional Intelligence and Social Management Diploma Course 09: Assertiveness Skills Course 10: Touch Typing Complete Training Diploma Learning Outcomes: Upon completion of this Diploma in Biomedical Engineering - CPD Certified bundle, you should be able to: Grasp the core principles of Biomedical Science and Healthcare. Acquire hands-on skills in Microbiology Lab Techniques and Radiography. Gain in-depth knowledge through online training in Immunology. Implement best practices for laboratory safety and infection control. Develop expertise in Phlebotomy, Epidemiology, and Dermatology. Explore the interconnected aspects of healthcare, from neuroscience to orthodontics. Embark on a transformative educational journey where you'll master the intricacies of Human Anatomy, delve into the wonders of Neuroscience, and gain expertise in preventing contamination with Best Practices in Lab Safety. As you progress, you'll explore the principles of Orthodontic Biomechanics, understand Dermatology at Level 3, and even enhance your capabilities in Nurse Prescribing and Medicine Management. This diploma not only equips you with theoretical knowledge but also fosters a hands-on approach, ensuring you're prepared to excel in the multifaceted realm of Biomedical Engineering. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to be versatile professionals in the healthcare sector. Anyone interested in the dynamic field of Biomedical Engineering. Professionals seeking to enhance their skills in laboratory techniques. Those keen on specialisations such as Phlebotomy, Radiography, and Dermatology. Individuals who want a holistic understanding of healthcare and medical terminology. Aspiring healthcare contributors keen on mastering infection control and prevention. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Biomedical Engineering course, all you need is - A smart device A secure internet connection And a keen interest in Biomedical Engineering Career path Biomedical Scientist: •30,000 - •45,000 Microbiology Lab Technician: •25,000 - •35,000 Radiographer: •28,000 - •40,000 Phlebotomist: •20,000 - •30,000 Epidemiologist: •35,000 - •50,000 Dermatology Assistant: •25,000 - •35,000 Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Learn effective workplace communication skills that will transform your career Includes Open & Closed Questions, Active Listening, Understanding the Message, Body Language and Non-Verbal Messages

24 Hour Flash Deal **25-in-1 Adult Learning, Educational Psychology and Development Mega Bundle** Adult Learning, Educational Psychology and Development Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Adult Learning, Educational Psychology and Development package online with Studyhub through our online learning platform. The Adult Learning, Educational Psychology and Development bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Adult Learning, Educational Psychology and Development course provides complete 360-degree training on Adult Learning, Educational Psychology and Development. You'll get not one, not two, not three, but twenty-five Adult Learning, Educational Psychology and Development courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Adult Learning, Educational Psychology and Development courses are yours for as long as you want them once you enrol in this course This Adult Learning, Educational Psychology and Development Bundle consists the following career oriented courses: Course 01: Adult Learning: A Comprehensive Guide for Educators Course 02: Enhancing Adult Literacy and Numeracy Skills Course 03: Adult Education Mastery Training Course 04: Super Learning Course 05: Teaching Techniques & Methodologies Diploma Course 06: Educational Psychology and Development Course 07: Education Management course Course 08: Planning, Delivery and Assessment in Teaching Course 09: Teach to Engage Students Course 10: Blended Learning Course for Teachers Course 11: Understanding Specific Learning Difficulties: Supporting Diverse Learners Course 12: SEND Teaching Course Course 13: Lesson Planning for Teaching Course 14: Positive Handling in Schools Course 15: Mental Health-Self Care Course 16: Emotional Intelligence: Become EQ Counsellor Course 17: Diploma in Psychology Course 18: Human Growth and Development Course 19: Conflict Resolution Course 20: Motivational Mentorship: Inspiring Personal and Professional Growth Course 21: Diversity Training Course 22: Performance Management Course 23: Mental Health and Wellbeing Course 24: Employee Training Responsibilities: Effective Training Management Course 25: Resilience Training: Developing Mental Resilience The Adult Learning, Educational Psychology and Development course has been prepared by focusing largely on Adult Learning, Educational Psychology and Development career readiness. It has been designed by our Adult Learning, Educational Psychology and Development specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Adult Learning, Educational Psychology and Development Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Adult Learning, Educational Psychology and Development bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Adult Learning, Educational Psychology and Development Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Adult Learning, Educational Psychology and Development Elementary modules, allowing our students to grasp each lesson quickly. The Adult Learning, Educational Psychology and Development course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive Adult Learning, Educational Psychology and Development bundle, you really hit the jackpot. Here's what you get: Step by step Adult Learning, Educational Psychology and Development lessons One to one assistance from Adult Learning, Educational Psychology and development professionals if you need it Innovative exams to test your knowledge after the Adult Learning, Educational Psychology and Development course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Adult Learning, Educational Psychology and Development courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Adult Learning, Educational Psychology and Development certificate and transcript on the next working day Easily learn the Adult Learning, Educational Psychology and Development skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Adult Learning, Educational Psychology and Development training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Adult Learning, Educational Psychology and Development Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Adult Learning, Educational Psychology and Development course, all you need is - A smart device A secure internet connection And a keen interest in Adult Learning, Educational Psychology and Development Career path You will be able to kickstart your Adult Learning, Educational Psychology and Development career because this course includes various courses as a bonus. This Adult Learning, Educational Psychology and Development is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Adult Learning, Educational Psychology and Development career opportunities Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Psychology and Criminology bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Psychology and Criminology related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Psychology and Criminology bundle will help you build a solid foundation to become a proficient worker in the sector. This Psychology and Criminology Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Diploma in Psychology Course 02 :Child Psychology & Development Course 03 :Parapsychology Course 04 :Psychiatry Course 05 :Child Psychology and Mental Health Development Course 06 :Criminology and Psychology Course 07 :Sports Psychology Course 08 :Level 2 Youth Work Certificate Course 09 :Level 3 Coaching & Mentoring Course Course 10 :Behaviour Support Worker Course 11 :Child Language Disorder (CLD) Course 12 :Child Playwork Course 13 :Leadership Skills Course 14 :Communication Skills Course 15 :Obsessive Compulsive Disorder (OCD) Awareness Course 16 :ADHD Awareness Course 17 :COVID-19: Psychological First Aid Course 18 :Psychotherapy Training Course 19 :Psychology of Anxiety and Stress Course 20 :Interrogations And Confessions Psychology Course 21 :Educational Psychology Course 22 :Mental Health Course 23 :Mental Health Nursing Course 24 :Counselling Level 3 Course 25: Cognitive Behavioural Therapy (CBT) Course 26: Child Playwork Course 27: Play Therapy Course 28: Anti Social Behaviour (ASB) Course 29: Cross-Cultural Awareness Training Course 30: Equality, Diversity and Discrimination 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Learning Outcome This tailor-made Psychology and Criminology bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Psychology and Criminology Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Psychology and Criminology bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Psychology and Criminology Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

With the ongoing impact post pandemic and the shift to more remote working longer term, managing the mental health and well-being of our lawyers has become more important than ever. We know that as a HR professional / Head of People, you play a crucial role in ensuring the mental health and well-being of your firm. Often juggling this alongside many other responsibilities and demands on your time. A Head of People recently commented on what a lonely role this can be and we want to offer some support. That's why we're excited to invite you to our upcoming webinar on managing mental health and well-being in your firm. Webinar host, lawyer, coach and trainer specialising in lawyer wellbeing for the last 7 years, will offer valuable insights and practical tips on how you can support your lawyers' mental health during increasingly challenging times.

These friendly informal sessions started in lockdown 1.0 and are a chance for some informal networking with a supportive group of lawyers, at various stages of their career from student to law firm Managing Director!

Responsible for delivery and coaching of improvement activity within an area of responsibility.

Buy Big. Save Big! Save: £403! Offer Ends Soon; Hurry Up!! Want to learn Accountancy? This course will guide you in the right direction in the field of Accounting. Enrol in this comprehensive course and make yourself one step closer to achieving your career goal. This course includes: Introduction to Accounting The Role of an Accountant Accounting Concepts and Standards Double-Entry Bookkeeping Balance Sheet Expand your expertise with high-quality training - study the and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through this online training course. This course is endorsed by The Quality Licence Scheme and accredited by CPD (with 150 CPD points) to make your skill development and career progression related to Accountancy substantial and easier than ever! This course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of this course, you will receive an instant e-certificate as proof of the comprehensive skill development and competency. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. You will fulfil your dreams and prepare for your ideal career by taking this intensive this course. This course offers students an in-depth learning experience that they can work through at their own pace to advance their careers. This same course will teach you everything you need to know to advance in your chosen field. You'll get a free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling in this course will help you find your dream career sooner than you ever imagined. With this program, you will stand out from the crowd and prepare for the career you want. Experts created this course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in this course right now, and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access this 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! Why Prefer this Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another 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) Standard-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 tutor support on weekdays (Monday to Friday) Diploma in Accountancy at QLS Level 5 Module 01: Introduction to Accounting What Is Accounting? Accounting and Bookkeeping Who Uses Accounting Information? Accountability in Accounting Financial Statements How Different Business Entities Present Accounting Information Module 02: The Role of an Accountant What Is an Accountant? Roles and Responsibilities Important Skills Accounting Automation Transparency and Security Data Analysis Module 03: Accounting Concepts and Standards Introduction to Accounting Concepts Introduction to Accounting Standards Accounting Standards in the UK International Standards International Financial Reporting Standards Module 04: Double-Entry Bookkeeping Introduction of Double-Entry Bookkeeping What Does the Account Show? Account NameDebits and CreditsAccount Details Rules for Double-Entry Transactions Inventory Double-Entry Transactions for Inventory Returns of Inventory Drawings Income and Expenses How Many Different Expense Accounts Should Be Opened? Balancing Accounts General Rules for Balancing Accounts Module 05: Balance Sheet Introduction of Balance Sheet The Components of a Balance Sheet AssetsLiabilitiesNet Worth or Equity The Equation Understanding the Balance Sheet What Does the Date on the Balance Sheet Mean? Module 06: Income statement Understanding the Income Statement The Accrual Concept Revenue Expenses Net Income Interest and Income Taxes Bad Debt Expense Module 07: Financial Statements Introduction of Financial Statements Trial Balance Statement of Comprehensive Income Calculation of Profit Difference between Gross and Net Profits Trading Account Profit and Loss Account Statement of Financial Position Non-Current AssetsCurrent AssetsCurrent LiabilitiesNon-Current LiabilitiesCapital Module 08: Cash Flow Statements What Is a Statement of Cash Flows? What Is the Purpose of the Cash Flow Statement? Cash and Cash Equivalents Operating Activities Investing Activities Financing Activities Module 09: Understanding Profit and Loss Statement Introduction of Profit and Loss Account Measurement of Income Relation Between Profit and Loss Account and Balance Sheet Preparation of Profit and Loss Account Module 10: Financial Budgeting and Planning What Is a Budget? Planning and Control Advantages of Budgeting Developing the Profit Strategy and Budgeted Profit and Loss Statement Budgeting Cash Flow from Profit for the Coming Year Capital Budgeting Module 11: Auditing What Is an Audit? Types of Audits External AuditsInternal AuditsInternal Revenue Service (IRS) Audits Why Audits? Who's Who in the World of Audits What's in an Auditor's Report Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrollment, and you can access the course materials from any location in the world. This course is preferable for people who want to pursue a career in Aspiring Accountant Recent Graduates Individuals interested in building a career in this sector Individuals working in the relevant field Professionals who have rooms to improve skills and knowledge Requirements This course does not require any prior knowledge; everyone may participate! This course is open to anyone who is 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 own speed while earning an industry-recognized certification. Career path This course will allow you to kickstart or take your career in the related sector to the next stage. Our whole course will assist you in achieving a position of respect and dignity, as well as allowing you to gain an advantage over your competitors. The certificate will strengthen your CV and assist you in finding work in the related industry. Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Accountancy at QLS Level 5 Hard copy certificate - £119 After successfully completing the Diploma in Accountancy at QLS Level 5 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

Accountancy provides an excellent opportunity to gain the skills and knowledge you'll need to advance in your career. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. Accountancy will provide you with the right CPD Accredited qualifications that you'll need to succeed. Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd. Accountancy has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows. All of our courses have interactive online modules that allow studying to take place where and when you want it to. The only thing you need to take Accountancy is Wi-Fi and a screen. You'll never be late for class again. Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes. Why Choose Accountancy Training? Opportunity to earn a certificate accredited by CPD after completing this Accountancy Training course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the Accountancy Training program in your own time, at your own pace Each of our students gets full 24/7 tutor support ****Course Curriculum**** Here are the topics you will cover in the Accountancy Training Course: ***Accounting and Finance*** Module 01: Introduction to Accounting What Is Accounting? Accounting and Bookkeeping Who Uses Accounting Information? Financial Statements How Different Business Entities Present Accounting Information Module 02: The Role of an Accountant What Is an Accountant? Roles and Responsibilities Important Skills Transparency and Security Data Analysis Module 03: Accounting Concepts and Standards Introduction to Accounting Concepts Standards International Accounting Standards International Financial Reporting Standards Module 04: Double-Entry Bookkeeping Introduction of Double-Entry Bookkeeping What Does the Account Show? Rules for Double-Entry Transactions Accounting for Inventory Double-Entry Transactions for Inventory Returns of Inventory Drawings Income and Expenses How Many Different Expense Accounts Should Be Opened? Balancing Accounts Module 05: Balance Sheet Introduction of Balance Sheet The Components of a Balance Sheet The Accounting Equation Understanding the Balance Sheet What Does the Date on the Balance Sheet Mean? Module 06: Income statement Understanding the Income Statement The Accrual Concept Revenue Expenses Net Income Interest and Income Taxes Bad Debt Expense Module 07: Financial statements Introduction of Financial Statements Trial Balance Statement of Comprehensive Income Calculation of Profit Difference between Gross and Net Profits Trading Account Profit and Loss Account Statement of Financial Position Module 08: Cash Flow Statements What Is a Statement of Cash Flows? What Is the Purpose of the Cash Flow Statement? Cash and Cash Equivalents Operating Activities Investing Activities Financing Activities Module 09: Understanding Profit and Loss Statement Introduction of Profit and Loss Account Measurement of Income Relation Between Profit and Loss Account and Balance Sheet Preparation of Profit and Loss Account Module 10: Financial Budgeting and Planning What Is a Budget? Planning and Control Advantages of Budgeting Developing the Profit Strategy and Budgeted Profit and Loss Statement Budgeting Cash Flow from Profit for the Coming Year Capital Budgeting Module 11: Auditing What Is an Audit? Types of Audits Why Audits? Who's Who in the World of Audits What's in an Auditor's Report Assessment Process Once you have finished the learning stages in the Accountancy Training course, your abilities will be assessed by an automated multiple-choice question session, after which you will receive the results immediately. Showcase Your Accomplishment of New Skills: Get a Certification of Completion The learners have to successfully complete the assessment of this Accountancy Training course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. The learner can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

Highlights of the Course Course Type: Online Learning Duration: 4 hours 13 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about microsoft excel Understand the core competencies and principles of microsoft excel Explore the various areas of microsoft excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel Online Training Course Master the skills you need to propel your career forward in Microsoft excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive Microsoft Excel course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Microsoft Excel course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft excel. Enrol in this Microsoft Excel course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive Microsoft Excel course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This Microsoft Excel course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This Microsoft Excel course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This Microsoft Excel course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Microsoft Excel: Basic Level Introduction to Microsoft Excel 0101 Touring the interface 00:03:00 0102 Enter data & saving workbook 00:04:00 0103 Applying Formulas 00:03:00 0104 Changing a worksheet's structure 00:04:00 0105 Find, Replace & Spell Check 00:03:00 0106 Applying fonts, background colors, and borders 00:05:00 0107 Formatting numbers and dates 00:04:00 0108 Making the pieces fit 00:04:00 0109 Inserting headers & footers and Repeating Rows 00:02:00 0110 Managing Large Workbooks 00:05:00 Microsoft Excel: Intermediate Level Excel Essentials 0201 Formula Writing (Don't Miss This) 00:08:00 Ex 0201 Formula Writing (Don't Miss This) 00:02:00 Sum Count Average Functionality - With Conditions 0301 SumIf & SumIfs 00:24:00 Ex 0301 SumIf & SumIfs 00:08:00 0302 Count Functions 00:08:00 Ex 0302 Count Functions 00:02:00 0303 AverageIf & AverageIfs 00:03:00 Ex 0303 AverageIf & AverageIfs 00:03:00 Text Functions - Manipulating Text 0401 Change Case (Upper, Lower, Proper) 00:04:00 Ex 0401 Change Case (Upper, Lower, Proper) 00:03:00 0402 Separating Text on Symmetrical Data 00:06:00 Ex 0402 Separating Text on Symmetrical Data 00:06:00 0403 Separating Text on Non-Symmetrical Data 00:08:00 Ex 0403 Separating Text on Non-Symmetrical Data 00:05:00 Logical Functions - Working With Conditions 0501 If Functionality 00:04:00 Ex 0501 IF Functionality 00:03:00 0502 If with AND 00:05:00 Ex 0502 If with AND 00:03:00 0503 If with OR 00:03:00 Ex 0503 If with OR 00:03:00 0504 If with “AND” & “OR” / IF with Countif 00:08:00 Ex 0504 If with “AND” & “OR” / IF with Countif 00:04:00 0505 Nested IF (A Genie with 3 wishes) 00:13:00 Ex 0505 Nested IF (A Genie with 3 wishes) 00:05:00 Lookup Functionality - Burn Simple Find Technique 0601 Vlookup (Exact Match) # 1 00:23:00 Ex 0601 Vlookup (Exact Match) # 1 00:04:00 0602 Type of References (Use of $ sign) 00:11:00 0603 Vlookup (Exact Match) # 2 00:04:00 Ex 0603 Vlookup (Exact Match) # 2 00:06:00 0604 Double Vlookup 00:11:00 Ex 0604 Double Vlookup 00:10:00 0605 Vlookup on Duplicate Values 00:10:00 Ex 0605 Vlookup on Duplicate Values 00:05:00 0606 Vlookup (Approximate Match) 00:08:00 Ex 0606 Vlookup (Approximate Match) 00:02:00 0607 Vlookup with If (Conditional Vlookup) 00:05:00 Ex 0607 Vlookup with If (Conditional Vlookup) 00:02:00 0608 Hlookup (Exact Match) 00:03:00 Ex 0608 Hlookup (Exact Match) 00:03:00 0609 Hlookup (Approximate Match) 00:02:00 Ex 0609 Hlookup (Approximate Match) 00:02:00 0610 Lookup (Don't use this !) 00:05:00 Ex 0610 Lookup (Don't use this !) 00:02:00 0611 Vlookup with Match (Create Magical Vlookup) 00:14:00 Ex 0611 Vlookup with Match (Create Magical Vlookup) 00:05:00 0612 Match (Gives us Column/Row Index #) 00:03:00 Ex 0612 Match (Gives us Column/Row Index #) 00:03:00 0613 Index & Match (Made for Each Other) 00:11:00 Ex 0613 (1) Index & Match (Made for Each Other) 00:05:00 Ex 0613 (2) Index & Match (Made for Each Other) 00:03:00 Date & Time Function - A Tricky Game 0701 How Excel Records Date & Time 00:02:00 0702 Now, Today & Autofill 00:02:00 0703 DateValue & TimeValue 00:02:00 0704 Calculate WorkingDays 00:03:00 0705 DatedIf 00:05:00 Financial Functions 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:12:00 Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.) 00:07:00 0802 Creating a Loan Table 00:09:00 Ex 0802 Creating a Loan Table 00:06:00 0803 Calculate Depriciation 00:02:00 Ex 0803 Calculate Depriciation 00:02:00 Sort & Filter 0901 Basic Sorting & Shortcut keys 00:16:00 Ex 0901 Basic Sorting & Shortcut keys 00:06:00 0902 Sorting Using Custom List 00:08:00 Ex 0902 Sorting Using Custom List 00:02:00 0903 Horizontal Sorting 00:01:00 Ex 0903 Horizontal Sorting 00:01:00 0904 Basic Filter & Shortcut Keys 00:09:00 Ex 0904 Basic Filter & Shortcut Keys 00:05:00 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:06:00 Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows) 00:03:00 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:07:00 Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data) 00:02:00 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:07:00 Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data) 00:01:00 0908 Advanced Filter (Applying Complex Criteria's) 00:13:00 Ex 0908 Advanced Filter (Applying Complex Criteria's) 00:05:00 Microsoft Excel: Advanced Level Excel Charts - Visual Presentation 1001 How to create a chart 00:06:00 1002 Format Axis 00:02:00 1003 Plot Values on Secondary Axis 00:04:00 1004 Life of Pie (Charts) 00:03:00 1005 How to Show Axis Title 00:03:00 1006 How to Show Data Label 00:02:00 1007 Show data with chart in Data Table 00:02:00 1008 Column Chart 00:02:00 1009 Bar Chart 00:02:00 1010 Line Chart 1 00:03:00 1011 Line Chart 2 00:03:00 1012 Area Chart 00:01:00 1013 Pie Chart 00:03:00 1014 Pie of Pie or Bar of Pie 00:03:00 1015 Line Chart with Log Scale 00:02:00 1016 Bubble Chart 00:01:00 1017 Selecting Chart Elements 00:05:00 1018 Use of Format Dialog box 00:03:00 1019 Modifying Chart & Plot Area 00:04:00 1020 Modifying Data Series 00:02:00 1021 How to handle Missing Data 00:04:00 1022 Modifying 3-D Charts 00:03:00 1023 Creating Combination of upto 5 Different Charts 00:03:00 1025 Creating Picture Charts 00:02:00 Data Consolidation - Multiple Workbooks Worksheets Consolidate Data using Excel Inbuilt Function 00:06:00 Ex Consolidate Data using Excel Inbuilt Function 00:03:00 Data Validation 1201 Applying Data Validation 00:13:00 Ex 1201 Applying Data Validation 00:05:00 1202 Dependent Dropdown List 00:07:00 Ex1202 Dependent Dropdown List 00:05:00 Using Data Validation with Vlookup & Match 00:05:00 Other Data Validation Examples 00:10:00 Protection of Worksheet Workbook 1301 Worksheet Level Protection 00:01:00 Ex 1301 Worksheet Level Protection 00:01:00 1302 Cell Level Protection 00:05:00 Ex 1302 Cell Level Protection 00:02:00 1303 Hiding Formulas from Formula Bar 00:03:00 Ex 1303 Hiding Formulas from Formula Bar 00:02:00 1304 Protecting Workbook Structure 00:01:00 Ex 1304 Protecting Workbook Structure 00:01:00 1305 Workbook Level Protection 00:02:00 Ex 1305 Workbook Level Protection 00:01:00 Pivot Table & Techniques 1401 Understanding pivot Table 00:12:00 1402 Using Pivot Table in Real Scenario 00:10:00 Ex 1402 Using Pivot Table in Real Scenario 00:09:00 1403 Grouping in Pivot Table 00:04:00 Ex 1403 Grouping in Pivot Table 00:01:00 1404 Using Slicers (A Visually attractive Filter) 00:03:00 Ex 1404 Using Slicers (A Visually attractive Filter) 00:01:00 What-If Analysis & Solver Add-In 1501 Goal Seek (A Reverse Approach) 00:04:00 Ex 1501 Goal Seek (A Reverse Approach) 00:02:00 1502 One Way Data Table 00:03:00 1503 Two Way Data Table 00:02:00 1504 Scenario Manager 00:04:00 1505 Solver Add-In 00:07:00 Automation in Excel - Macros 1601 Record your first Macro 00:15:00 1602 Record Another Macro 00:02:00 1603 Assigning macro to a Shape, Button, Picture etc 00:02:00 1604 Editing or Deleting a Macro 00:03:00 1605 Security Settings of a Macro 00:02:00 Supplementary Resources Supplementary Resources - Microsoft Excel Diploma 00:00:00 Assessment Assessment - Microsoft Excel Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00