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

1707 Courses

Prevent Duty Training Course

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 1 hour 5 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 prevent duty Understand the core competencies and principles of prevent duty Explore the various areas of prevent duty Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert employee and individual in the education sector Prevent Duty Training Course This prevent duty course is accredited by the CPD UK. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Intelligence indicates that further terrorist attacks in our country are 'highly likely'. Experience tells us that the threat comes not just from foreign nationals, but from terrorists born and bred in Britain. It is therefore vital that our counter-terrorism strategy contains a plan to prevent radicalisation and stop would-be terrorists from committing mass murder. The Prevent strategy, published by the Government is part of the overall counter-terrorism strategy. This prevent duty course starts with an overview of the Government's Prevent strategy, and then looks at some of the reasons people become extremists. It goes on to cover the objectives of the Prevent strategy, how to base your actions on a risk based approach, what to do if you are concerned and much more. Who is this Course for? This comprehensive Prevent Duty Training 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 prevent duty 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 Prevent Duty Training 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 Prevent Duty Training 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 Prevent Duty Training 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. Course Curriculum Module 1: Introduction to the Course Module 2: What is Prevent Module 3: Prevent Objectives Module 4: Delivering Prevent with a Risk-Based Approach Module 5: Extremism, Radicalisation and Terrorism Module 6: What Should You Do If You Are Concerned Module 7: The Channel Process Module 8: British Values Obtain Your Certificate Order Your Certificate of Achievement 00:00:00

Prevent Duty Training Course
Delivered Online On Demand
£19

Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law - 20 Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Entrepreneurship package has something for everyone. As part of the Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Entrepreneurship bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Entrepreneurship: Startup your New Venture Fundamentals of Entrepreneurship Entrepreneurial Mindset Advanced Pitching for Startups Make Business Plans: Forecasting and Budgeting Financial Ratio Analysis for Business Decisions Business Analysis Course Level 5 Business Management Setting & Achieving Goals Product Management Capital Budgeting & Investment Decision Rules Investment Banking: Venture Capital Fundraising for Startups Financial Management Tax Accounting Business Law 2021 Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Entrepreneurship Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Entrepreneurship Bundle. Build a strong knowledge base in your chosen course via the Entrepreneurship Bundle. Benefit from the flexibility and convenience of online learning. With the Entrepreneurship package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law, a rich anthology of 15 diverse courses. Each course in the Entrepreneurship bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisEntrepreneurship, Business Analysis, Investment, Financial Management & Business Law bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law bundle offers you the flexibility and convenience to learn at your own pace. Make the Entrepreneurship package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Entrepreneurship bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Entrepreneurship, Business Analysis, Investment, Financial Management & Business Law - 20 Courses Bundle
Delivered Online On Demand45 hours
£99

Agricultural Science, Botany, Forestry, Horticulture & Environmental Law - 20 Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Agricultural Science, Botany, Forestry, Horticulture & Environmental Law bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Agricultural Science, Botany, Forestry, Horticulture & Environmental Law is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Agricultural Science package has something for everyone. As part of the Agricultural Science, Botany, Forestry, Horticulture & Environmental Law package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Agricultural Science bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Agricultural Science Botany Forestry Horticulture Arboriculture Environmental Law 2021 The Basics of Reproduction Reproduction in Flowering Plants Environment Management Floristry Diploma in Poultry Farming Mushroom Growing Course Basic Biology Zoology Environmental Health Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Agricultural Science Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Agricultural Science Bundle. Build a strong knowledge base in your chosen course via the Agricultural Science Bundle. Benefit from the flexibility and convenience of online learning. With the Agricultural Science package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Agricultural Science, Botany, Forestry, Horticulture & Environmental Law, a rich anthology of 15 diverse courses. Each course in the Agricultural Science bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Agricultural Science, Botany, Forestry, Horticulture & Environmental Law bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Agricultural Science, Botany, Forestry, Horticulture & Environmental Law bundle offers you the flexibility and convenience to learn at your own pace. Make the Agricultural Science package your trusted companion in your lifelong learning journey. CPD 230 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Agricultural Science, Botany, Forestry, Horticulture & Environmental Law bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Agricultural Science, Botany, Forestry, Horticulture & Environmental Law bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Agricultural Science bundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Agricultural Science, Botany, Forestry, Horticulture & Environmental Law - 20 Courses Bundle
Delivered Online On Demand4 days
£99

NLP Business Diploma (Fundamentals of Collaborative Working)

By Proactive NLP Ltd

NLP Business Diploma - The Fundamentals of Collaborative Relationships training & certification with Proactive NLP Ltd is your first step towards developing collaborative leadership and collaborative cultures. Start transforming your projects now!

NLP Business Diploma (Fundamentals of Collaborative Working)
Delivered In-PersonFlexible Dates
£675 to £750

Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care - 20 Courses Bundle

By NextGen Learning

Get ready for an exceptional online learning experience with the Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Carebundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Infection Prevention Control package has something for everyone. As part of the Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Infection Prevention Control bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Infection and Prevention Control Phlebotomist Training Personal Hygiene Organic Cleaning Products For A Clean Green Home British Cleaning Course Dementia Awareness Basic Principles of Health Care Delivery Safe Handling of Medicines Medical & Clinical Administration Diploma Medical Law Medical Terminology Training Spill Management Training Chemical Spill Care Planning and Record-Keeping | Health & Safety Online Course" Care Worker Course Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Infection Prevention Control Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Infection Prevention Control Bundle. Build a strong knowledge base in your chosen course via the Infection Prevention Control Bundle. Benefit from the flexibility and convenience of online learning. With the Infection Prevention Control package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care, a rich anthology of 15 diverse courses. Each course in the Infection Prevention Control bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. ThisInfection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care bundle offers you the flexibility and convenience to learn at your own pace. Make the Infection Prevention Control package your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Infection Prevention Controlbundle package. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

Infection Prevention Control, Phlebotomy, Medicine, Medical Law & Health Care - 20 Courses Bundle
Delivered Online On Demand3 days
£79

Microsoft Excel from A-Z: Beginner to Expert

4.7(26)

By Academy for Health and Fitness

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Microsoft Excel course might help you get there! Expand your expertise with high-quality training - study the Microsoft Excel course 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 the Microsoft Excel online training course. The Microsoft Excel 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 the Microsoft Excel course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Microsoft Excel training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover in the Course: >> Microsoft Excel - Beginner, Intermediate & Advanced << Unit 01: Excel from A-Z Course Introduction Unit 02: Getting Started With Excel Unit 03: Values, Referencing and Formulas Unit 04: Intro to Excel Functions Unit 05: Adjusting Excel Worksheets Unit 06: Visually Pleasing Cell Formatting Unit 07: How to Insert Images and Shapes! Unit 08: Visualize Data with Charts Unit 09: Excel's Printing Options Unit 10: Benefits of Using Excel Templates Unit 11: Working with Excel Datasets Unit 12: Excel Database Functions Unit 13: Excel Data Validation Unit 14: Excel PivotTables Unit 15: Excel's PowerPivot Add-In Unit 16: Excel's Conditional Functions Unit 17: Excel's Lookup Function Unit 18: Text Based Functions in Excel Unit 19: Auditing Formulas and Views in Excel Unit 20: Excel's 'what If?' Tools Unit 21: Welcome to Excel VBA Unit 22: The VBA Language Unit 23: Writing VBA Code Unit 24: Important VBA Tools and Logic Unit 25: Excel VBA Lopps Unit 26: Triggering Macros Unit 27: Excel User Forms Unit 28: Starting a Career in Excel Tutor Support Once you enrol in our Microsoft Excel Course with the Academy for Health & Fitness, you are allocated your tutor. The tutor's guidance and assistance will be available throughout your studies with the college. He/ she will evaluate your work and will provide you with regular feedback on your progress. CPD 15 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 Microsoft Excel 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. 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.

Microsoft Excel from A-Z: Beginner to Expert
Delivered Online On Demand13 hours
£12

Flask for Beginners

By Packt

Learn Flask, the simple yet powerful Python web framework. This course is a ridiculously simple way to learn Flask in less than a weekend.

Flask for Beginners
Delivered Online On Demand6 hours 32 minutes
£26.99

Accountant's Guide to Climate Change

By SkillWise

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents, and interests with our special Accountant's Guide to Climate Change Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides the professional training that employers are looking for in today's workplaces. The Accountant's Guide to Climate Change Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Accountant's Guide to Climate Change Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Accountant's Guide to Climate Change Course, like every one of Skillwise's courses, is meticulously developed and well-researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Accountant's Guide to Climate Change ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Accountant's Guide to Climate Change there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the PDF certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Accountant's Guide to Climate Change course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Accountant's Guide to Climate Change does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Accountant's Guide to Climate Change was made by professionals and it is compatible with all PCs, Macs, tablets, and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as a bonus, you will be able to pursue multiple occupations. This Accountant's Guide to Climate Change is a great way for you to gain multiple skills from the comfort of your home. Accountant's Guide to Climate Change Module 01: Introduction and Agenda 00:05:00 Module 02: Climate Change Business Trends 00:02:00 Module 03: The Circular Economy 00:03:00 Module 04: The Zero Carbon Economy 00:03:00 Module 05: Sustainable Investing 00:04:00 Module 06: The Power of People and Values 00:04:00 Module 07: Business as a Force for Change 00:05:00 Module 08: New Technological Solutions 00:03:00 Module 09: Government Policy and Regulation 00:04:00 Module 10: Climate Adaptation 00:03:00 Module 11: People and Habitats on the Move 00:02:00 Module 12: Other Impacts of Climate Change 00:11:00 Module 13: The Accountant's Action Plan 00:07:00 Module 14: What the Accounting Institutes are saying 00:03:00 Module 15: The Accountant's Guide to Climate Change: Closing Remarks 00:02:00 Assignment Assignment - Accountant's Guide to Climate Change 00:59:00 Order Your Certificate Order Your Certificate QLS

Accountant's Guide to Climate Change
Delivered Online On Demand
£29

WNAI41 SAP Information Design Tool Delta 4.1

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for Experienced universe designers upgrading from a previous version of SAP BusinessObjects Designer to SAP BusinessObjects Information Design Tool 4.1. NOTE: This workshop is not designed for users new to the tool. In this course, participants will gain an understanding of the Delta between Universe Design and the Information Design Tool. Course Outline New File extension Universe components -Projects -Connections -Data foundation -Business Layer Universe Testing Lists of Values Parameters @Execute function Calculated Columns Multisource universe Federated Tables Additional course details: Nexus Humans WNAI41 SAP Information Design Tool Delta 4.1 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the WNAI41 SAP Information Design Tool Delta 4.1 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

WNAI41 SAP Information Design Tool Delta 4.1
Delivered OnlineFlexible Dates
Price on Enquiry

Excel - advanced (In-House)

By The In House Training Company

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Excel - advanced (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry