5743 Courses

An in depth look at Pivot Tables and their powerful features to summarise and visualize your data. Course overview Duration: 1 day (6.5 hours) Our Excel – Pivot Table Specialist course is a comprehensive guide to working with Pivot Tables for those who need to learn more about the use of Pivot Tables to summarise and analyse information. This course is designed for existing experienced users of Excel. You should be a confident Excel user and be able to create and edit worksheets and write basic formulas. Objectives By the end of the course you will be able to: Build and customise Pivot Tables Group and sort information Filter information Use slicers and the timeline filter Add different summary calculations Create Pivot Charts Add calculated fields and items Content The anatomy of a Pivot Table Using a Pivot Cache Building a Pivot Table The Pivot Table interface Refreshing the Pivot Table Adding column, row, page and data fields Changing data orientation Showing data fields in columns or rows Drilling down to underlying data Setting Pivot Table options Format options Totals and filters options Display and printing options Data options Customising Pivot Tables Modifying field names Data formatting Changing field layout options Changing summary calculations Working with subtotals Filtering and sorting Filtering items Sorting data Value and label filters Creating top 10 reports Using the Search filter Using the Slicer tool Use the Timeline filter Grouping Grouping date fields Grouping numeric fields Adding your own groups Summary calculations Running totals Differences year on year, month on month % Differences year on year, month on month % of Row, Column, Total and other fields Pivot charts Pivot Chart rules Creating a Pivot Chart Working with your Pivot Chart Creating calculations Adding calculated fields Adding calculated items

Learn how to use Macros in Excel to automate your work and start to see the power these can give you. Course overview Duration: 1 day (6.5 hours) Our Excel – Working with Macros course aims to show how macros can be used to automate commonly used commands and processes. This course is designed for existing experienced users of Excel. You should be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course. Objectives By the end of the course you will be able to: Record and run macros Navigate within the Visual Basic Environment Edit pre-recorded macros Create your own functions Content Recording macros Accessing the Developer Tab Naming conventions and storage locations Recording macros Absolute and relative cell addressing Running macros Assigning macros to the Quick Access Toolbar Assigning macros to objects Creating new tabs Workbook macros Recording macros in a specific workbook Saving the workbook as an Excel Macro-Enabled Workbook Creating quick access items specific to workbooks Importing and manipulating data Importing Delimited Text Files Importing Fixed Width Text Files The Visual Basic environment Project explorer Code window Properties window Renaming modules Deleting modules Working with code Code structure Adding comments Navigating within your code Editing macro code Getting help with syntax Debugging Errors Using debug Function procedures Creating function macros

All about how to get the best out of social media in a business. Looking at business strategy, business development and the practicalities of employing people and agencies to support your social media activity.

An introduction to art market data, sources, analysis and tools As the art market is gradually moving from a small niche market towards becoming a global industry – data, information and research are becoming essential tools in supporting the development and growth of both new and existing art businesses. Whilst data and research traditionally was focusing on auction data and prices of art, the new art industry is in need of a broader set of indicators to help them navigate an increasingly complex marketplace. In this course, Anders Petterson, Founder of ArtTactic and regular lecturer of Sotheby's Institute since 2005, will introduce you to the changing nature of the global art eco-system, and discuss the type of data sources, analytical tools and industry research available. The course includes: Videos: You will have access to 2h 20min of online video content. The content of this course is an in-depth look at data in the art market, and is building on what Anders Petterson is regularly teaching for MA and Executive Programmes at Sotheby's Institute, Christie's Education and ESA Business School in Beirut. Slides: The students can download pdf copies of the slides used in the presentations. Certification: The student will be issued with a certificate of completion when all the online videos and test quizzes have been completed. CPD Accredited: Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. Certification: Continuing Professional Development (CPD) Our courses have been independently evaluated for Continuing Professional Development (CPD) purposes by The CPD Certification Service. This means our courses comply with universally accepted principles of Continual Professional Development (CPD) and have been structured to meet the criteria of personal development plans. Join one of the online courses below and get an ArtTactic Certificate of Completion with the Continuing Professional Development (CPD) certification stamp. Your Instructor Anders Petterson, Founder of ArtTactic Anders Petterson is a leading authority on the art market, with particular focus on art market research and analysis. He is the Founder and Managing Director of ArtTactic, a London-based art market research and data intelligence company he set up in 2001. All the online courses are based on his own experience in collecting, analysing and presenting data on the global art market, and the courses will give an insight into how ArtTactic conceptualizes, designs and executes research projects linked to art market and introduces analytical models to better understand the value of art. Anders is regularly lecturing on MA and Executive courses at Sotheby's Institute, Christie's Education and ESA Business School (Beirut) covering topic such as Art Market Analysis, Art & Technology and NFTs as well as Art as an Asset Class. He is also a regular speaker on these topics at international conferences and seminars. ArtTactic is also well-known for its industry research on the art market and its intersection with other industries, such as the Deloitte | ArtTactic Art & Finance Report, TEFAF Art Dealer Finance Report 2018, and the TEFAF Art Patronage Report 2020. ArtTactic has also produced the Hiscox Online Art Trade Report annually since 2013. Anders Petterson is a founding Board Member of Professional Advisors to the International Art Market (PAIAM), a role he had between 2011 and 2021. PAIAM was founded in London in 2011 bringing together professionals who provide specialist services to the art market.such as lawyers, accountants, tax advisors, insurance specialists and logistics experts, amongst others. Connect on LinkedIn Course Curriculum Art Market Data - Models and Applications Lecture 1: Introduction by Anders Petterson, Founder of ArtTactic (2:56) Lecture 2: About ArtTactic (10:49) Lecture 3: Art Forecasting (5:28) Lecture 4: Big and Small Data in the Art Market (12:59) Lecture 5: Macro Data in the art market (20:18) Lecture 6: Micro Data and the art market eco-system (25:59) Art Market Data - Sources and Tools Lecture 7: Art Market Footprints - An Overview (9:39) Lecture 8: Auction Data (13:32) Lecture 9: Primary art market data (19:50) Lecture 10: Media and Social Media Data (9:35) Lecture 11: Crowd-sourced data (17:21) Download presentation slides Download complimentary ArtTactic Reports Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

The course will introduce you to some of the most enduring photographic portraits and provide discussion on why they remain so seminal. The course includes an introduction to lighting and composition techniques for portraiture, as well as providing guidance on shutter speed, aperture, lenses, and other visual controls. You will use studio flash lighting to explore basic techniques in formal and informal portrait photography – though all of the techniques taught are transferrable to natural and other lighting media. There will be time for participants to photograph under three standard lighting set-ups. Some digital SLR photography experience is recommended. Morning The morning session centres on discussion of the work of some classic portrait photographers and standard techniques employed. The discussions will include elements of composition, pose, gesture, format and technique. Afternoon The afternoon session will cover practical studio lighting, standard lighting set-ups, direction of sitters, and time permitting also a brief introduction to some of the editing capabilities of Adobe Photoshop. Project Days are designed for those who are already familiar with digital photography processes but who want to pursue a particular aspect or develop more specific skills in one or more areas. This course is the perfect follow-on from our Digital SLR training courses and will support you in building upon your existing knowledge of DSLR camera skills and becoming a better photographer in general. It will help you to work confidently on your own creative projects and develop the artist in you.   Courses are subject to minimum enrolment. Please register early, within five days of the start date, to reduce the likelihood of course cancellation. Please read our cancellation policy before booking. Students, anyone over the age of 65, and those in receipt of any form of benefits can claim the concessionary price, offering a 10% discount on the full course price. Valid proof of eligibility must be produced on the first day of the course. Please use the code CONCESSION when prompted at checkout.

Awareness of First Aid for Mental Health Half Day | Four Hours Cost:  £45 + vat per person SYLLABUS A range of First Aid for Mental Health related subjects are covered, including: What is First Aid for Mental Health? Identifying mental health conditions Providing advice and starting a conversation Stress Mental health conditions CERTIFICATION Level 1 Award in Awareness for First Aid for Mental Health will be issued to the learner, subject to successful assessment. This qualification is valid for three years from the date of achievement. It is strongly recommended that the learner attends annual refresher training. The learner must complete the full course again to re-qualify for a further three years. Maximum of 16 people First Aid • Mental Health One of our standout offerings is our In-Person Workshops on First Aid for Mental Health. These Workshops are designed to help participants understand mental health better, recognise signs of mental health issues in others and learn how to provide initial help and guide a person towards appropriate professional help. Mental Health is just as important as physical health, yet it often gets overlooked in traditional First Aid Training Programmes. We aim to change this at APLUS Medical Services & Training by providing comprehensive Mental Health First Aid Training. Our interactive and engaging Workshops provide participants with practical skills they can use in real-life situations. They are led by experienced Mental Health Professionals passionate about raising awareness about mental health issues and empowering others with the knowledge and skills to make a difference.

An Introduction to Medical Terminology short course delivered online via Teams, suitable for anyone wishing to learn the basics of terminology. Dates of courses can be seen when clicking ‘register’ below. Level One – Introduction to Medical Terminology. “It's like a light has just been switched on and I now understand more of what I'm doing!” – Feedback from attendee of Level one course. This course is aimed at anyone who requires a knowledge of medical terminology in their role. It is suitable for administrative staff, health care workers, medical secretaries, managers, Allied Health Professionals, essentially anyone who may encounter medical terminology and wishes to develop their medical terminology knowledge further. We also offer sessions to those requiring an overview of medical terminology to support applications to study medicine, veterinary medicine or dentistry.We can train between 1-30 learners from any organisation. If you have a specific training request, please speak to us and we can accommodate your needs. We recently trained a group of sign language interpreters who found the training invaluable when working in medical environments.The sessions are delivered via Teams (2x 2 hour meetings) so are highly accessible, a webcam and microphone are required although not essential.The aim of the course is for learners to develop an understanding of medical terminology in an enjoyable, interactive and informative way so that they are better able to decipher and unravel the mystery of long medical words.The course covers the following topics:- Basics of medical terminology – word building Common Roots, prefixes and suffixes Anatomy and physiology via a virtual tour of the body Major bones of the body Prescription writing and abbreviations Classification of drugs Common Abbreviations Instruments and investigations Medical Specialities and personnel Blood tests At the end of the course students will have a clear understanding of medical terminology and are encouraged to use their newly learned skills in a series of quizzes and interactive games. All attendees are given a Certificate of Attendance and a comprehensive handout. Many people who attend these courses are keen to develop their skills further and may wish to proceed to the Level Two Intermediate Award in Medical Terminology. Medical Terminology Training Courses Established in 2006 and the UK’s largest provider of medical terminology training, we offer a range of courses to suit your needs from beginner through to advanced level. Our bespoke courses have been designed to suit the needs of healthcare professionals incorporating relevant terminology and content to directly benefit the workplace. Click 'more course information' below to view further details of each of our courses. 

Overview This comprehensive course on Career Development Training: Copywriting Masterclass will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Career Development Training: Copywriting Masterclass comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Career Development Training: Copywriting Masterclass. It is available to all students, of all academic backgrounds. Requirements Our Career Development Training: Copywriting Masterclass is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 6 sections • 33 lectures • 02:04:00 total length •Lesson 01: How to Find Your Niche: 00:04:00 •Lesson 02: How to Find a Niche Market: A Step-By-Step Guide: 00:04:00 •Lesson 03: The Advantages of Having a Niche Market: 00:04:00 •Lesson 04: 5 Ways to Research Your Potential Customers: 00:03:00 •Lesson 05: 5 Simple Steps To Find Your Niche Market: 00:04:00 •Lesson 06: Ways to Narrow Down Your Niche Market: 00:03:00 •Lesson 01: 10 Reasons Why People Who Read A Lot Are More Likely To Be Successful: 00:04:00 •Lesson 02: The Importance of Written Communication Skills: 00:04:00 •Lesson 03: 5 Reasons why Feedback may be the Most Important: 00:04:00 •Lesson 04: What Copywriting Certification Programs Can Teach You: 00:04:00 •Lesson 05: 8 Online Tools That Will Improve Your Writing: 00:03:00 •Lesson 06: Why Should You Network?: 00:04:00 •Lesson 07: Why New Writers Should Enter Writing Competitions: 00:03:00 •Lesson 01: How To Get The Most Out Of Customer Polls And Surveys: 00:04:00 •Lesson 02: How to Identify a Target Demographic: 00:04:00 •Lesson 03: Learn Your Customers Habits: 00:03:00 •Lesson 04: 11 Ways to Provide Great Customer Service: 00:03:00 •Lesson 05: Your Small Business Competitors: Where to Learn About Their Customers: 00:04:00 •Lesson 01: The Easiest Way to Build Your Business Through Referrals: 00:04:00 •Lesson 02: What is a Paid Online Advertising Strategy?: 00:03:00 •Lesson 03: What Is a Portfolio Website and Why You Need It?: 00:04:00 •Lesson 04: Copywriting for Social Media: 7 Tips to Boost Engagement: 00:03:00 •Lesson 05: 5 Rules for Customer-Centric Copywriting Your Support Reps Should Use: 00:03:00 •Lesson 01: Break into the Self-Improvement Market: 00:04:00 •Lesson 02: Fundraising - Selling Your Services to Non-Profit Companies: 00:04:00 •Lesson 03: Health Copywriting- Working to Improve People's Lives: 00:06:00 •Lesson 04: Financial Services: 00:04:00 •Lesson 05: Christian Market - Writing for a Higher Purpose: 00:04:00 •Lesson 01: Choose Your Own Working Hours: 00:05:00 •Lesson 02: The Newbie's Guide to Making the Most of Remote Work: 00:04:00 •Lesson 03: Copywriter Job Satisfaction: Why Copywriting is a Good Career: 00:03:00 •Lesson 04: Why Copywriting Helps your Business and Adds Value to your Marketing Assets: 00:04:00 •Lesson 05: Potential to Earn Higher than Average Income: 00:03:00

Success rarely arrives by accident – it’s built on clear strategy and decisive execution. This Strategy Planning and Execution Course is designed for those ready to shape business direction with precision and confidence. Whether you're responsible for driving departmental goals or overseeing entire operations, this course lays out the essential thinking patterns behind smart planning, and the logical steps needed to turn vision into results. You’ll explore the key frameworks that influence strategic decisions, how to assess internal and external environments effectively, and how to align goals with long-term organisational direction. It also guides you through execution techniques that keep plans from gathering dust—transforming ideas into outcomes through accountability, leadership alignment and timely action. If navigating high-level objectives with clarity and purpose is on your radar, this course will give you the tools to do just that—with less waffle, and more results. Meet the Accreditation CPD Quality Standards (CPD QS) accreditation assure the Strategy Planning and Execution course training and learning activities are relevant, reliable, and upto date. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) This masterclass Strategy Planning and Execution online training course is designed by industry experts and will give you an in-depth understanding of this topic. The Strategy Planning and Execution course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. If you want to work in this rapidly growing sector and stand out from the competition, then our Strategy Planning and Execution is the perfect place to kickstart your dream career. On the Strategy Planning and Execution course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the Strategy Planning and Execution course will help you land the job you want in a related field. Enjoy a pleasant and expert 100% online learning experience and enrol in our Strategy Planning and Execution today and take control of your career! Course Curriculum: Here is a curriculum breakdown of the Strategy Planning and Execution course: Unit 01: Introduction Introduction & Course Map Unit 02: Strategy Strategy Development Environmental Scanning Strategy Management Balanced Scorecard Unit 03: Key Performance Indicators KPIs Introduction KPIs Selection KPIs Quality KPIs Forms & Types KPIs Polarity, Status, & Documentation Target Setting Target Setting Methods & Example Unit 04: Alignment Vertical Alignment Horizontal Alignment Employee Alignment OGSM Method Cascading in Public Sector Unit 05: Leading Strategy Execution Kippy.cloud System Review Meeting Leadership & Communication Unit 06: Conclusion Terminology Bonus Book & Conclusion Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Strategy Planning and Execution course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Strategy Planning and Execution course is open to all, with no formal entry requirements. Career path Upon successful completion of the Strategy Planning and Execution Course, learners will be equipped with many indispensable skills and have the opportunity to grab. Certificates Certificate of completion Digital certificate - £9 Certificate of completion Hard copy certificate - £89 QLS Endorsed Certificate Hardcopy of this certificate of achievement endorsed by the Quality Licence Scheme can be ordered and received straight to your home by post, by paying - Within the UK: £89 International: £89+ £10 (postal charge) = £99 CPD Accredited Certification Hardcopy Certificate (within the UK): £15 Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Working with young people is no walk in the park — it takes patience, skill, and a good sense of humour. The Level 2 Youth Work Certificate Course is designed to give learners a solid grounding in the key knowledge and approaches used by youth workers in today’s communities. Whether you're supporting teens in schools, clubs, or community groups, this course helps you understand what makes them tick — and how to actually get through to them. From communication techniques to safeguarding responsibilities, you'll explore a variety of essential topics relevant to youth engagement. This course is ideal for those looking to enter the youth sector or sharpen their understanding of how to connect with and support young people in meaningful ways. It’s all online, self-paced, and available wherever you are — so you can study without rearranging your entire life. Learning Outcomes: Understand the role and methods of a youth worker Identify legal responsibilities in youth work Explore the social influences on young people Understand the relationship between youth work and mental health Analyse the connection between youth work and criminal justice Explore career options in social work Meet the Accreditation CPD Quality Standards (CPD QS) accreditation assure the Level 2 Youth Work Certificate course training and learning activities are relevant, reliable, and upto date. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Free PDF Certificate Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Please note: This course only gives you the theoretical knowledge you need to excel in this field. This Level 2 Youth Work Certificate training course doesn't entitle you to practise as a professional in this specific field. This course is designed by industry experts and will give you an in-depth understanding of this topic. The Level 2 Youth Work Certificate course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience. Enjoy a pleasant and professional 100% online learning experience and enrol the course today and take control of your career! Course Assessment To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%. When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals interested in pursuing a career in youth work Individuals passionate about social justice and empowering young people Individuals who want to make a difference in the lives of young people Requirements This Level 2 Youth Work Certificate course is open to all, with no formal entry requirements. Career path After completing the Course, learners will be fit with many essential skills and have the opportunity to grab, such as: Youth Worker - £20,000 to £32,000 per annum Social Worker - £24,000 to £40,000 per annum Counsellor - £20,000 to £40,000 per annum Probation Officer - £23,000 to £36,000 per annum Family Support Worker - £18,000 to £28,000 per annum Outreach Worker - £18,000 to £28,000 per annum