9469 Office courses delivered Online

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before In today's fiercely competitive marketplace, the ability to effectively drive sales and execute marketing strategies is paramount for businesses operating in the UK. A survey reveals that companies with well-defined sales and marketing strategies generate up to 30% higher revenue, contributing over £120 billion to the UK economy annually. This comprehensive Sales and Marketing bundle aims to unlock the secrets of successful sales and marketing, empowering you to stay ahead of the curve. With a single payment, you will gain access to Sales and Marketing course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Sales and Marketing Bundle Package includes: Main Course : Advanced Diploma in Sales and Marketing Co-ordinator at QLS Level 7 10 Additional CPD Accredited Premium Courses related to Sales and Marketing: Course 01: B2B Sales & Marketing Course 02: Marketing Secrets for High Sales Course 03: Customer Relationship Management Course 04: NLP For Sales, Persuasion & Influence Course 05: Leads and Sales Generating Course 06: Internal Audit Analyst Training Course 07: Sales Management Training Course 08: Creating Highly Profitable Sales Funnel Blueprint Foundations Course 09: Creative Marketing Plan Course 10: Business Training: Digital Marketing This Sales and Marketing bundle equips you with comprehensive skills in sales and marketing management, customer relationship management, lead generation, persuasion techniques, internal audit analysis, sales management, sales funnel creation, and creative marketing strategies. You'll gain the tools to captivate your audience, drive conversions, and foster long-lasting customer relationships. Learning Outcomes of Sales and Marketing Develop a comprehensive understanding of sales and marketing management principles. Master customer relationship management techniques and sales and marketing strategies. Explore innovative approaches to lead generation and sales conversion. Gain insights into neuro-linguistic programming for persuasion and influence. Learn internal audit analysis and sales management best practices. Develop skills in creating highly profitable sales funnels and marketing plans. Don't miss this chance to gain the knowledge and expertise you need to succeed in this rewarding field. Enrol now! Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of this course Get a free student ID card with this Training This course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to this course materials This course comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Advanced Diploma in Sales and Marketing Co-ordinator at QLS Level 7 Module 01: Introduction Module 02: Sales Growth Module 03: Sales Hypnosis Module 04: Sales Presentation Module 05: Basics of Marketing Module 06: The Marketing Process Module 07: Strategic Marketing Module 08: Marketing Environment Module 09: Market Segmentations Module 10: Consumer Buying Behaviour and much more... Course 01: B2B Sales & Marketing Module 01: Introduction To B2B Sales And Marketing Module 02: Understanding The B2B Buyer Module 03: Creating A B2b Marketing Strategy Module 04: Sales And Marketing Alignment Module 05: Building A B2b Sales Team Module 06: B2b Lead Generation Module 07: B2B Sales Techniques Module 08: Customer Relationship Management Course 02: Marketing Secrets for High Sales Unit 01 - Introduction Unit 02 - Make Sure You're In The Right Niche Unit 03 - You Must Target The Right Client Unit 04 - Unlock The Power Of Segmentation Unit 05 - Case Study - A High Ticket Sale Unit 06 - Know The Big Picture Unit 07 - Get Inside The High-Ticket Buyers Mindset Unit 08 - Conducting A High-Ticket Sales Campaign Unit 09 - The Secret Shortcut To High-Ticket Sales Unit 10 - Fine-Tune Your Reverse Engineered Brand Unit 11 - Picking The Right High Ticket Product Or Service To Sell =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £139) CPD 255 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 bundle. This bundle is ideal for: Financial professionals and compliance officers. Aspiring careers in finance and banking. Risk management and legal professionals. Office administrators and executive assistants. Professionals seeking career advancement opportunities. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Sales Manager Marketing Director Business Consultant Account Executive Team Leader Entrepreneur Certificates Advanced Diploma in Sales and Marketing Co-ordinator at QLS Level 7 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free.

Would You Like To Learn The Best Hacks To Boost Your Productivity & Time Management In Under 40 Minutes? I've packed the best productivity tools and time management techniques in this short but intense course. There will be no fluff, only important concepts that will really move the needle for your productivity and time management. Would you like to learn what kills your productivity and time management? The 5 step process to have unlimited productivity? How to delegate and say no? How to have more time for yourself? What you should do first in the morning and how to plan your day? How to kill procrastination? And so much more! You will learn the best productivity hacks! This course if for people who would like to become more productive and master time management in their personal and professional life. Would you like to have more time to do the things that truly matter to you? Then join this course. Go ahead, enroll in the course now! There is a 30-day money-back guarantee so you can try the productivity hacks and time management techniques! This course is different because you'll have the most practical NLP techniques for sales, influence and persuasion. That's why I want you to try the course risk-free, you can enroll now and watch the course. If you don't like it you can ask your money back within 30 days. Go ahead and enroll now. You can only gain NLP, sales, influence and persuasion skills!  What you'll learn : Learn how to be more productive How to kill procrastination How to say no & delegate How to plan their day How to use willpower at their advantage How to be less stressed during the day because of their organization Requirements :  A willingness to apply the productivity techniques  Who is the target audience? People who would like to be more productive in their personal or professional lives People who would like to have more time to do things that matter to them People who procrastinate on the important tasks Master Productivity & Time Management What You Will Learn In This Course 00:01:00 The Productivity Killers & How To Overcome Them 00:04:00 The Right Way to Use Your Willpower To Be More Productive 00:01:00 The Magic Of Planning Your Day The Right Way 00:02:00 5 Steps To Unlimited Productivity 00:07:00 What You Should Do When You Arrive at The Office 00:06:00 How to Enter the FLOW to Unleash Your Productivity & Results 00:02:00 Delegate & Say No For More Productivity 00:04:00 Your Time in The Morning For More Productivity 00:04:00 How To Kill Procrastination 00:02:00 Recap + More Productivity Advice 00:05:00

IASSC lean six sigma yellow belt course. Online, 24/7 access to content and exam. Fee includes learning content, tutor support, and official IASSC exam.

This course teaches intermediate-level skills in Primavera Project Manager P6 PPM professional client. Explore user and admin preferences, create roles and resources, assign expenses, and resource optimization. Discover methods to resolve conflicts and update schedules. Improve your project management skills with the latest techniques and workshops.

Embark on a journey of transformation and empowerment with our 'Diploma in Leadership & Management at QLS Level 3' course. This immersive programme is expertly tailored to shape emerging leaders and enhance the capabilities of existing managers. The journey begins with a thorough understanding of the fundamental principles of management and leadership, laying a solid foundation for advanced learning. As you advance, the course introduces a plethora of leadership theories, offering diverse perspectives to mould your unique leadership style. The course is meticulously designed to cover a wide spectrum of essential managerial skills and leadership qualities. You will explore high-performance team building, employee motivation, and organisational skills - all crucial for effective management. Delving further, the programme offers insights into talent management, succession planning, and business process management, equipping you with the tools to make strategic decisions and drive business success. Enhance your interpersonal skills with modules on communication, negotiation, and managing meetings, while also mastering personal effectiveness through time and stress management. The course culminates with an emphasis on emotional intelligence, conflict resolution, navigating office politics, and understanding corporate responsibility and ethics, preparing you to lead with integrity and vision. Learning Outcomes Understand key management and leadership concepts and theories. Develop skills to build and lead high-performance teams. Master techniques in motivating employees and enhancing organisational efficiency. Acquire expertise in managing change, time, and stress effectively. Enhance interpersonal skills including communication, negotiation, and emotional intelligence. Why choose this Diploma in Leadership & Management at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Diploma in Leadership & Management at QLS Level 3 course for? Aspiring leaders and managers seeking to develop their leadership skills. Professionals aiming to improve their managerial performance and team management. Individuals interested in learning about organisational development and talent management. Those looking to enhance their negotiation and communication skills. Managers and team leaders focusing on ethical leadership and corporate responsibility. Career path Team Leader: £24,000 - £34,000 Operations Manager: £31,000 - £45,000 Human Resources Manager: £35,000 - £50,000 Project Manager: £33,000 - £48,000 Business Development Manager: £30,000 - £50,000 Corporate Responsibility Manager: £40,000 - £60,000 Prerequisites This Diploma in Leadership & Management at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Leadership & Management at QLS Level 3 was made by professionals and it is compatible with all PC's, Mac's, 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Leadership & Negotiation Management Understanding Management and Leadership 00:39:00 Leadership Theories 00:25:00 Improving Management and Leadership Performance 00:15:00 High Performance Teams 00:32:00 Motivating Employees 00:26:00 Organisational Skills 00:26:00 Talent Management 00:37:00 Succession Planning 00:24:00 Business Process Management 00:29:00 Communication Skills 00:28:00 Negotiation Techniques 00:15:00 Managing Meetings and Giving Feedback 00:22:00 Managing Change 00:22:00 Time Management 00:37:00 Stress Management 00:15:00 Emotional Intelligence in Leadership 00:32:00 Managing Conflict 00:14:00 Dealing with Office Politics 00:34:00 Risk Management 00:35:00 Corporate Responsibility and Ethics 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Chart your path to success with our Advanced Leadership & Management Diploma. This CPD-certified course is an exceptional route to mastering the sophisticated strategies and profound insights required in modern leadership and management. With this course, you'll unlock the potential within, learning the intricate aspects of Advanced Leadership & Management. Uncover the art of decision-making, team motivation, conflict resolution, and strategic planning. All in one comprehensive course designed to transform your leadership skills. The Advanced Leadership & Management Diploma helps you understand and implement essential management concepts, strengthening your leadership arsenal. It explores the mechanics of effective leadership and the innovative strategies used in successful management. Whether you're a budding leader or an experienced manager, this course is your ticket to a comprehensive understanding of Advanced Leadership & Management. Empower your professional journey with this dynamic course, equipping you with the knowledge needed to inspire teams and steer your organisation toward its strategic goals. Courses Are Included in this Advanced Leadership & Management Diploma - CPD Certified Bundle: Course 01: Advanced Diploma in Leadership and Management at QLS Level 7 Course 02: Project Management Course 03: Smart Goal Setting Course 04: Office Administration & Skills Diploma Course 05: Team Building & Management Diploma Course 06: Self-Esteem & Confidence Building Learning Objectives: Understand the core principles of Advanced Leadership & Management, including strategic planning and decision-making. Learn the art of effective communication and team motivation within the scope of Advanced Leadership & Management. Gain knowledge on how to manage change and conflict, two inevitable elements in any organisation. Delve into the dynamics of project management and learn how to apply leadership and management principles to drive successful project outcomes. Develop insights into the role of ethics and corporate responsibility in Advanced Leadership & Management. Enrich your understanding of the latest trends and challenges in leadership and management, preparing you for a future-focused career. Why Choose Our Leadership & Management Course? FREE Leadership & Management certificate accredited Get a free student ID card with Leadership & Management Training Get instant access to this Leadership & Management course. Learn Leadership & Management from anywhere in the world Leadership & Management is affordable and simple to understand Leadership & Management is entirely online, interactive lesson with voiceover audio Lifetime access 24/7 tutor support Start your learning journey straightaway with an Advanced Leadership & Management Diploma - CPD Certified! This Leadership & Management curriculum has been designed by Leadership & Management experts with years of experience behind them. This course is extremely dynamic and well-paced to help you understand Leadership & Management with ease. You'll discover how to master Leadership & Management skill while exploring relevant and essential topics. Assessment Process of Advanced Leadership & Management Diploma - CPD Certified Once you have completed all the courses in the bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterward. CPD 230 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is suitable for everyone. Requirements You will not need any prior background or expertise to enrol in this course. Career path This bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Gain advanced cleaning skills with the Level 5 Certificate in Cleaning. Elevate your expertise, ensuring top-notch cleanliness standards in professional environments.

Good Coaching & mentoring - Skilled employees - Productive business culture As a mentor, you don't just enhance employee skills, but lift their confidence too. It makes a genuine difference in their professional and personal development. So if you want to step into a mentorship position and empower employees to become more confident in their roles, this Level 3 Diploma in Coaching & Mentoring course is all you need. Effective coaching and mentoring are essential in today's time. It helps in improving employee performance, enhancing employee productivity and reducing employee turnover. This Level 3 Diploma in Coaching & Mentoring course will give you valuable insights into how coaching and mentoring work. The Coaching & Mentoring course will teach you much more than just people management. You will learn to develop excellent communication skills, understand neuro-linguistic programming, read body language, provide motivation and emotional support, and recognise success. Alongside this, you will be taught how to seize business opportunities with this skill and thrive in a growing industry. Enrol now and upskill your workforce for better organisational benefits! Along with this Coaching & Mentoring Course, you will get 10 Premium courses absolutely free. Also, you will get an original hardcopy certificate, transcript and a student ID card for Free. Courses included in this Coaching & Mentoring Bundle? Course 01: Coaching & Mentoring Course 02: Diploma in Becoming Career Smart Course 03: Leadership & Management Diploma Course 04: Level 4- Office Management Course 05: Life Coaching | Online Course Course 06: Level 3 Mental Health Awareness Course Course 07: Stress Management Training Course 08: Performance Management Course 09: Decision-Making Course 10: Personal Hygiene Course 11: Effective Communication Skills Learning Outcomes of Coaching & Mentoring Course: Understand the principles and importance of Coaching & Mentoring. Identify and implement effective Coaching & Mentoring processes and models. Recognise and adhere to ethical guidelines in coaching and mentoring. Develop effective communication skills to facilitate coaching and mentoring. Apply personal skills such as self-awareness and emotional intelligence to coaching and mentoring. Demonstrate management skills in coaching and mentoring relationships. Apply functional skills to tailor coaching and mentoring to specific contexts. So enrol now in this Coaching & Mentoring Course to advance your career! Coaching & Mentoring Training Course Curriculum of Coaching & Mentoring Course 01: Coaching & Mentoring Lesson 01: Introduction to Coaching & Mentoring Lesson 02: Objectives & Processes Lesson 03: Ethical Aspects Lesson 04: Coaching & Mentoring Models Lesson 05: Effective Communication Skills Lesson 06: Personal Skills Lesson 07: Coaching & Mentoring Management Skills Lesson 08: Functional Skills How will I get my Certificate? After successfully completing the Coaching & mentoring course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously, it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Coaching & mentoring Requirements Coaching & mentoring Career path Coaching & Mentoring The Advanced Diploma in Coaching & Mentoring would be beneficial for the following careers: Coach Development Instructor Facilitator Life Coach Life Consultant Mentor Talent Coach. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Coaching & Mentoring) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included

Essential trauma awareness training on the causes, symptoms and best ways to treat PTSD Join our expert tutor live online to deepen your understanding of trauma and our responses to it – recovery is possible… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Excellent online trauma course! I've worked with complex trauma for over 5 years and there was still plenty for me to take away...KAT MARLOW, PSYCHOTHERAPIST Why do some people become traumatised and others not? What makes an event traumatic? Why are the symptoms of trauma so many and varied? What happens if someone freezes – or experiences a shutdown or dissociative response – during a traumatic event? Live Online Training – Join Ros Townsend on Tues 16th April 2024 to find out the answers to these questions, and many more… You’ll also have time to ask your own questions and benefit from the group discussions. Once you’ve booked you’ll receive emailed confirmation – you’ll get your Zoom link the day before the event. Limited numbers – book soon to ensure your place. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. This inspiring and helpful online course with Ros Townsend, a highly experienced psychotherapist and trainer who specialises in treating trauma, will give you a thorough, clear understanding of how and why we can be impacted by traumatic events, what is happening in our brains, what causes post-traumatic stress (PTS) symptoms, why we respond in different ways (fight, flight, freeze or shutdown/dissociation), how to help someone who is suffering, when to seek professional help – and more. Why take this course Suffering from trauma, whether from a single incident or multiple events spread over the course of many years, can have a significantly detrimental impact on a person’s mental and physical health, and their quality of life. It can also greatly affect the lives of those around them. Since the Covid-19 Pandemic, more people than usual have experienced extremely stressful, distressing and/or frightening events, and many are finding that it has left them with symptoms of post-traumatic stress which can, in themselves, be very frightening. Recovery is possible – understanding is key Understanding what causes PTSD symptoms, how our brains and bodies react to distressing events and what makes us vulnerable to becoming traumatised, are all key to successful recovery. This knowledge creates a firm foundation on which to build successful coping strategies and clarifies what needs to happen to enable successful self-help and recovery. During the day you will also gain a clear understanding of how to spot the ‘early warning signs’ of trauma, before they go on to affect further areas of someone’s life, which red-flag signs indicate that it is time to seek professional help, and how trauma specialists are able to help people recover, from even the most difficult times, effectively – and lots more. Jam-packed full of essential information and important insights, real-life case studies and tips, this trauma course clarifies the different ways trauma can impact on people, leaving you better equipped to help support recovery and build resilience. It is an essential course for anyone who works with distressed people or who wishes to support someone they care for in their recovery from trauma, or for those simply wishing to better understand what they, or someone they care for, are experiencing. You will have plenty of time to ask questions throughout the day as the course is designed as a balance between structured learning, group discussion and activities (it is a live, expanded version of our shorter online course: Understanding Trauma). Ros is a brilliant teacher and presenter. She made the whole course interesting, engaging and informative as well as very supportive. She was also very patient with all our questions!GEMMA ROGERS, COUNSELLOR/COACH What you will learn A clear understanding of what trauma is – and the different survival responses we have evolved to help us deal with it What happens in our brains when we experience a traumatic event Why some people are affected by traumatic events, but not others What makes something ‘a trauma’ What symptoms may indicate that someone has been traumatised Why post-traumatic stress (PTS) occurs and the many different ways it can present The physical and psychological causes of post traumatic stress symptoms such as flash backs, hypervigilance, anger, poor sleep, poor memory, physical pain, difficulty thinking, digestive problems, low mood, apparent over-reaction to non-threatening situations Why PTS symptoms can develop years after a traumatic event The fight, flight and freeze response – its impact on our brain and body, and why it can be triggered inappropriately Why experiencing trauma in a passive survival state – such as freeze, shutdown or a dissociative state – can affect an individual particularly deeply How high emotional arousal impacts on our ability to think clearly Why our brains evolved this way Why some people experience trauma in a passive survival state such as freeze, shutdown or a dissociative state – and why we shouldn’t feel ashamed or guilty if we do The double whammy that comes with the ‘freeze’ response Why some sufferers experience ‘shutdown’ or dissociation as a result of trauma – and how this can lead to feelings of shame or guilt Why anger and other strong emotions can follow when someone comes out of a shutdown state during recovery from trauma How traumatic memories can stay ‘live’, keeping us on constant alert for danger ‘The straw that broke the camel’s back’: why one seemingly small event can tip someone into PTSD after years of exposure to other distressing events The importance of pattern-matching in understanding how our brains work Why post-traumatic stress triggers seemingly inappropriately extreme fear reactions The far-reaching impacts of unresolved trauma, including the development of co-morbid conditions and unhelpful coping strategies, such as addictions How unresolved trauma can lead to depression – the trauma / depression cycle Differences when treating single incident trauma, multiple trauma or ‘complex trauma’ When to seek professional help – spotting the ‘red-flag’ signs that you, or someone you care for, might need further support Where to find effective professional help An understanding of how the rewind technique works; its many advantages and applications The common elements of all effective treatments for post traumatic stress (PTSD) How we need to adapt traditional approaches to treating trauma for those experiencing shutdown or dissociative symptoms in the present Working holistically from the human givens approach The natural way we recover from distressing events What we all need as human beings to live emotionally healthy lives How to best employ self-help strategies to support your own recovery or to help others’ suffering from the effects of trauma How to build resilience and recover from symptoms How to access the ‘recovery zone’ Using breathing techniques with clients suffering from trauma Self-help strategies for improving your mental health and minimising traumatic symptoms A wonderfully informative course – I learned so much about traumaCOUNSELLOR Please note This live online training course is an expanded, live version of our shorter online course: Understanding Trauma. If you work with people with Complex Trauma, you may also like our attended workshops: Complex Trauma: Working effectively with challenging cases. Who this workshop is suitable for Anyone interested in understanding trauma and the many different ways it can present, the physical and psychological causes of post traumatic stress symptoms (PTSD), and what can be done to help – whether for personal or professional reasons. Anyone working with traumatised people including health and welfare professionals, such as: psychologists, counsellors, psychotherapists, mental health nurses, psychiatrists, school counsellors, student wellbeing officers, doctors, nurses, OTs, social workers, health visitors, youth workers, outreach, support workers, clinical psychologists, midwives, welfare officers, youth workers, hypnotherapists Anyone working with traumatised members of public services, such as: firefighters, police, paramedics and military personnel Family members of a traumatised individual who wish to understand more about how they can support their recovery or help them to access support Individuals wanting to understand more about their own experience of symptoms relating to trauma and learn more about what effective support is available – you will find the information on this course hugely helpful. Please note As the course deals with the subject of trauma, participants should be aware that discussion of specifically chosen examples of trauma and PTS symptoms will take place, for illustrative purposes, during the day. These will be generic examples for teaching purposes, however, and will not go into unnecessary detail or be voyeuristic or inherently distressing. Participants on the course will not at any stage be expected or put under pressure to discuss or disclose details of any personal experiences of a traumatic nature that they may have had. Course Programme The ‘Trauma: Patterns from the Past’ live online course starts at 9.15am and runs until 4.00pm. 9.15am Join the Zoom meeting 9.30am Introducing PTS 11.00am Comfort break and discussion 11.30am Understanding PTS 1.00pm Lunch break 1.45pm Red-flag signs – when to seek professional support 2.45pm Comfort break and discussion 3.00pm Self-help strategies 4.00pm Day ends This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using PivotTables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and function Overview #NAME? Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft© Excel© is designed for this purpose. Excel can connect to a wide range of data sources, perform robust data analysis and create diverse and robust data-backed visualizations to show insights, trends, and create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. 1 - DATA ANALYSIS FUNDAMENTALS Introduction to Data Science Create and Modify Tables Sort and Filter Data 2 - VISUALIZING DATA WITH EXCEL Visualize Data with Charts Modify and Format Charts Apply Best Practices in Chart Design 3 - ANALYZING DATA WITH FORMULAS AND FUNCTIONS Analyze Data with Formulas and Named Ranges Analyze Data with Functions Implement Data Validation, Forms, and Controls Create Conditional Visualizations with Lookup Functions 4 - ANALYZING DATA WITH PIVOTTABLES Create a PivotTable Analyze PivotTable Data 5 - PRESENTING VISUAL INSIGHTS WITH DASHBOARDS IN EXCEL Visualize Data with PivotCharts Filter Data Using Slicers and Timelines Create a Dashboard in Excel 6 - CREATING GEOSPATIAL VISUALIZATIONS WITH EXCEL Create Map Charts in Excel Customize Map Charts in Excel 7 - PERFORMING STATISTICAL ANALYSIS Visualize Trendlines and Sparklines with Excel Analyze Data with the Data Analysis ToolPa 8 - GETTING AND TRANSFORMING DATA Connect to Data with Queries Clean and Combine Data Shape and Transform Data 9 - MODELING AND ANALYZING DATA WITH POWER PIVOT Install Power Pivot in Excel Create Data Models with Power Pivot Create Power Pivots Perform Advanced Data Analysis and Visualization 10 - PRESENTING INSIGHTS WITH REPORTS (OPTIONAL) Plan a Report Create a Report