• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

17114 Other courses in Smethwick delivered Online

Poultry Farming & Ornithology at QLS Level 7

By Imperial Academy

Level 5 & 7 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Poultry Farming & Ornithology at QLS Level 7
Delivered Online On Demand
£300

BUSINESS GRAMMAR & USAGE

5.0(4)

By Improving Communications Uk

KNOW THE RULES! POOR GRAMMAR SHOWS A LACK OF ATTENTION TO DETAIL AND ULTIMATELY CAN SLOW DOWN COMMUNICATIONS AS WELL AS PRODUCTIVITY. Business people who know grammar judge others based on their correct (or incorrect) usage. Be the professional who is able to be clear and correct in writing. Business Grammar & Usage: ENGLISH BOOT CAMP is the answer for today’s business competitive environment. Interactive instruction and collaboration with your fellow attendees means that you will master the skills and apply your new knowledge to the classroom exercises and activities. When you return to work, you’ll have new confidence about what is right and wrong, when it comes to writing. Attendees Will Be Able To: Know the Parts of Speech and their correct uses; Understand Sentence Structure, including applying rules for Subject-Verb and Pronoun-Antecedent Agreement; Be able to create Plurals and Possessives accurately and with certainty; Review and use the rules of Spelling, Mechanics (Capitalization, Abbreviation, Number Use), and Punctuation; Create original email / documents to employ newly-learned class material.   Online Format—Business Grammar and Usage is a 4-hour interactive virtual class for up to ten people. Register for this class and you will be sent ONLINE login instructions prior to the class date. It was great to have the opportunity to learn some new techniques and to gain more awareness of how I present myself. The most immediately applicable uses have been in reducing my “ums” and “ahs” and in trying to come to my point in a more succinct way. I’ve been cultivating this awareness in one-on-one settings; meetings and individual conversations. Christina Vargas

BUSINESS GRAMMAR & USAGE
Delivered Online
£316

Creative Writing & Copywriting - Advanced Diploma (CPD Certified)

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Creative Writing, Copy Writing 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 37 course mega bundle that will exceed your expectations within your budget. The Creative Writing, Copy Writing 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 Creative Writing, Copy Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Creative Writing, Copy Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Email Writing Training Course 24: Medieval History Course 25: Military History Course 26: Creative Advertising and Graphic Design for Everyone Course 27: Boost Your Confidence and Self-Esteem Course 28: Foundations of Leadership and Negotiation Skills Development Course 29: Personal Development and Productivity Level 2 Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Creative Writing, Copy Writing 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 Creative Writing, Copy Writing 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 370 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 Creative Writing, Copy Writing bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Creative Writing, Copy Writing 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. Certificates CPD Accredited Digital certificate - Included CPD Accredited Hard copy certificate - Included

Creative Writing & Copywriting  - Advanced Diploma (CPD Certified)
Delivered Online On Demand8 days
£370

Introducing GDPR-CPD Approved

By BAB Business Group

The General Data Protection Regulation (GDPR) is designed to strengthen and unify the principles of data protection for all individuals within the European Union and the European Economic Area. The GDPR is an incredibly important change to data privacy regulations so understanding its correct implementation is vital for all UK businesses and organisations, and particularly for staff who regularly deal with personal data. This online course is designed specially for those front line staff and provides a clear introduction to the main elements of the GDPR, including compliance and the consequences of non-compliance. It explains the roles of key players - Data Protection Officers, Data Controllers, Data Protection Leads and Data Processors and covers the main categories of personal data, along with the six lawful bases for processing data, and how to audit the data your organisation holds. Other topics examined include the Seven Principles of the GDPR and the Eight Rights for Individuals, along with the importance of your Privacy Policy - how to construct one, and how to use it effectively when dealing with data subjects. Finally, there's important information on data breaches; how to avoid them, what to do if one is discovered and how to file a breach report

Introducing GDPR-CPD Approved
Delivered Online On Demand
£30

Conduct Rules for All Staff

5.0(4)

By LGCA | London Governance and Compliance Academy

This module provides an overview of the individual Conduct Rules introduced by the Financial Conduct Authority (FCA) and the Prudential Regulation Authority (PRA) - the UK's financial services regulators - which initially came into effect progressively between 2016 and 2021. The rules are part of the Senior Managers and Certification Regime (SMCR), a package of measures that represent a fundamental change in the way in which individuals working within the UK financial services sector are held to account by the regulators. These Conduct Rules originally applied only to those firms which are 'dual-regulated' by both the PRA and the FCA. The SMCR was extended in December 2019 to apply to staff in all regulated firms. This module is intended for both staff who are subject to certification and to all other staff who are, apart from the Conduct Rules, not otherwise subject to the SMCR. If you are in a senior manager function (SMF) or a non-executive director (NED), this module does not address all of your Conduct Rule Obligations. You are encouraged to work through the LGCA's Conduct Rules for Senior Manager Professional course instead.

Conduct Rules for All Staff
Delivered Online On Demand
£60

A Practical Guide through Business Analysis

4.5(3)

By Studyhub UK

lated 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 Guide through Business Analysis bundle will help you build a solid foundation to become a proficient worker in the sector. This Guide through Business Analysis Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Fundamentals of Business Analysis Course 02 :Strategic Business Management - Online Diploma Course Course 03 :Business Intelligence Analyst Course Course 04 :Business Intelligence and Data Mining Course 05 :Research Methods in Business Course 06 :International Business Principles Course 07 :Google Data Studio: Data Analytics Course 08 :Stock Trading Analysis with Volume Trading Course 09 :Lead Generation with Attraction Marketing for Business Course 10 :Business Law: Applied Fundamentals Course 11 :Compliance and Risk Management Course Course 12 :Payroll Management Course Course 13 :Anti-Money Laundering (AML) Training Course 14 :Document Control Course 15 :SAP S4HANA Controlling - Cost Center Accounting Course 16 :Certificate in Purchasing and Procurement Course 17 :Financial Analysis : Finance Reports Course 18 :Financial Ratio Analysis for Business Decisions Course 19 :Basic Data Analysis Course 20 :Disruptive Innovation for Business Course 21 :Business Plan for Entrepreneours Course 22 :Business Management and Finance Course Course 23 :Capital Budgeting & Investment Decision Rules Course 24 :Making Budget & Forecast Course 25: Branding Fundamentals for New Business Course 26: Business Performance Management Course 27: "SAP Controlling (CO) - Product Costing S4HANA" Course 28: Homebased Business Masterclass Course 29: Business Writing Course 30: Business Cas 10 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 Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Guide through Business Analysis 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 Guide through Business Analysis 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 400 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 Guide through Business Analysis 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 Guide through Business Analysis 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.

A Practical Guide through Business Analysis
Delivered Online On Demand9 days
£315

Education: Transformative Teaching

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Education: Transformative Teaching 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 40 course mega bundle that will exceed your expectations within your budget. The Education: Transformative Teaching 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 Education: Transformative Teaching bundle will help you build a solid foundation to become a proficient worker in the sector. This Education: Transformative Teaching Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Teaching Assistant Diploma Course 2: The Complete Guide To Getting A Teaching Job Course 3: SEND Teaching Assistant Course 4: EYFS Teaching Assistant Course 5: Phonics Teaching Certificate Course 6: Remote Teaching Course 7: Child Language Disorder (CLD) Course 8: Child Playwork Course 9: Child Neglect Awareness & Protection Course 10: Communication Skills Course 11: Team Management Course 12: Problem Solving Skills Course 13: Leadership Skills Course 14: Presentation Skills Course 15: Microsoft Office Course 16: Cross-Cultural Awareness Training Course 17: Lesson Planning for Teaching Course 18: Learning Disability Nursing Course 19: Nursery Nurse Course 20: Mental Health Teaching Assistant Course 21: ADHD Awareness Course 22: Leadership in Teaching Course 23: Positive Handling in Schools Course 24: Learning to Learn - Super Learning Course 25: Educational Psychology Course 26: Education Management Course 27: Education and Pedagogy Course 28: Blended Learning Course for Teachers Course 29: Understanding Autism Level 3 Course 30: Health and Safety Training for School Administrators 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Course 6: Business English Perfection Course Course 7: Networking Skills for Personal Success Course 8: Boost Your Confidence and Self-Esteem Course 9: Public Speaking Training Course 10: Learn to Fight Procrastination Learning Outcome This tailor-made Education: Transformative Teaching 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 Education: Transformative Teaching 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 400 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 Education: Transformative Teaching 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 Education: Transformative Teaching 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.

Education: Transformative Teaching
Delivered Online On Demand9 days
£315

Sustainability: The Future of Energy

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Sustainability: The Future of Energy 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 40 course mega bundle that will exceed your expectations within your budget. The Sustainability: The Future of Energy 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 Sustainability: The Future of Energy bundle will help you build a solid foundation to become a proficient worker in the sector. This Sustainability: The Future of Energy Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Sustainable Energy, Development and Environmental Impacts Course 02 :Oil and Gas Industry Course 03 :Solar Energy Course 04 :Petroleum Refining Demystified Course 05 :Online Course in Conservation Course 06 :Environment Management Course 07 :Environmental Health Course 08 :Environmental Law 2021 Course 09 :Marine Biology Course - Online Diploma Course 10 :Garden Design Course 11 :Reproduction in Flowering Plants Course 12 :Kitchen Gardening Course 13 :Mushroom Growing Course Course 14 :Carbon Literacy Knowledge Course 15 :Animal Science Course 16 :Architectural Studies Course 17 :Cleaning: Disinfection, Waste Management and Chemical Safety Course 18 :COSHH (Control of Substances Hazardous to Health) - Awareness Course 19 :Spill Management Training Course 20 :Horticulture & Organic Gardening Course 21 :Meteorology Course 22 :Land Management Course 23 :Diploma in Water Treatment Course 24 :Forestry Course 25: Agricultural Science Course 26: Botany Course 27: Wildlife Rescue and Rehabilitation Course 28: Homesteading Diploma Course 29: Floristry Academy Diploma Course 30: Arboriculture 10 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 Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Sustainability: The Future of Energy 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 Sustainability: The Future of Energy 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 400 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 Sustainability: The Future of Energy 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 Sustainability: The Future of Energy 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.

Sustainability: The Future of Energy
Delivered Online On Demand9 days
£315

Effective Land Management through Environmental Studies

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Effective Land Management through Environmental Studies 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 40 course mega bundle that will exceed your expectations within your budget. The Effective Land Management through Environmental Studies 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 Effective Land Management through Environmental Studies bundle will help you build a solid foundation to become a proficient worker in the sector. This Effective Land Management through Environmental Studies Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Land Management Course 02 :Agricultural Science Course 03 :Online Course in Conservation Course 04 :Environment Management Course 05 :Environmental Health Course 06 :Environmental Law 2021 Course 07 :Meteorology Course 08 :Diploma in Water Treatment Course 09 :Forestry Course 10 :Oil and Gas Industry Course 11 :Botany Course 12 :Wildlife Rescue and Rehabilitation Course 13 :Architectural Studies Course 14 :Cleaning: Disinfection, Waste Management and Chemical Safety Course 15 :COSHH (Control of Substances Hazardous to Health) - Awareness Course 16 :Spill Management Training Course 17 :Horticulture & Organic Gardening Course 18 :Homesteading Diploma Course 19 :Floristry Academy Diploma Course 20 :Arboriculture Course 21 :Marine Biology Course - Online Diploma Course 22 :Garden Design Course 23 :Reproduction in Flowering Plants Course 24 :Kitchen Gardening Course 25: Mushroom Growing Course Course 26: Carbon Literacy Knowledge Course 27: Animal Science Course 28: Ornithology Course 29: Biotechnology Course 30: Biomedical Science 10 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 Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Effective Land Management through Environmental Studies 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 Effective Land Management through Environmental Studies 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 400 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 Effective Land Management through Environmental Studies 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 Effective Land Management through Environmental Studies 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.

Effective Land Management through Environmental Studies
Delivered Online On Demand9 days
£315

Excel Module 4 Advanced Formulas and Functions

By Underscore Group

Enhance your skills and learn how to use a range of advanced formulas and functions to manage and extract data more efficiently. There are some great ones here that will save a lot of time. Course overview Duration: 1 day (6.5 hours) Our Excel Module 4 – Advanced Formulas and Functions course looks at some of the more advanced functions of Excel that can be used to manipulate and extract data. This is an intensive one-day course and designed for experienced users of Excel. Participants should be confident in creating and using Excel and be able to build simple formula before attending. Objectives By the end of the course you will be able to: Use a range of Text functions to manage text data Create and use different types of date and time functions Work with rounding functions Use logical statements Build nested formula Use SUMIF, COUNTIF and AVERAGEIF Cross reference data from other worksheets using LOOKUP, INDEX and MATCH functions Use IS functions and IFERROR to test cell values Content Working with text Splitting text into multiple cells Merging data into one cell Extracting data using text functions Tidying data Working with dates and times Formatting dates and times Date and time functions Calculating date and time differences Using functions to round numbers up and down ROUND ROUNDUP ROUNDDOWN CEILING FLOOR Use lookup functions Lookup functions Creating a lookup table Range naming Using VLOOKUP Using HLOOKUP Using INDEX and MATCH Working with logical statements Creating an IF statement Using the AND plus OR functions Nesting functions Calculating values based on given criteria SUMIF(S) COUNTIF(S) AVERAGEIF(S) Using IS and IFERROR and test cell values ISBLANK ISNUMBER ISTEXT ISERROR IFERROR

Excel Module 4 Advanced Formulas and Functions
Delivered OnlineFlexible Dates
£270