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

3744 Relationships courses in Tonyrefail delivered Online

The Art of Persuasive Communication

By NextGen Learning

The Art of Persuasive Communication Course Overview This course explores the essential techniques and principles of persuasive communication, equipping learners with the skills to influence and engage effectively across diverse settings. Covering key areas such as rhetorical strategies, emotional intelligence, and audience analysis, the course offers practical knowledge that enhances personal and professional interactions. Learners will develop confidence in crafting compelling messages, improving negotiation abilities, and fostering meaningful connections. Designed for a wide range of individuals, this course provides valuable tools to advance communication proficiency, enabling participants to stand out in business, leadership, sales, or everyday conversations. Course Description Delving deeper into the art and science of persuasion, this course covers foundational topics including persuasive language, storytelling, non-verbal cues, and ethical communication practices. Through a structured learning experience, participants will examine various communication models and apply these to real-life scenarios, enhancing clarity and impact. Emphasis is placed on understanding audience needs, overcoming objections, and building trust. By completing this course, learners gain advanced skills to influence decision-making, resolve conflicts, and inspire action with confidence and integrity. The content is carefully designed to develop critical thinking, empathy, and effective dialogue within both professional environments and personal relationships. The Art of Persuasive Communication Curriculum Module 01: Introduction to Persuasive Communication Module 02: Principles and Techniques of Persuasion Module 03: Crafting Powerful Messages Module 04: Understanding and Engaging Your Audience Module 05: Emotional Intelligence in Communication Module 06: Non-Verbal Communication and Its Impact Module 07: Overcoming Resistance and Handling Objections Module 08: Ethical Considerations in Persuasive Communication Module 09: Persuasion in Leadership and Negotiation Module 10: Enhancing Communication for Career Success (See full curriculum) Who Is This Course For? Individuals seeking to improve their influence and communication skills. Professionals aiming to enhance leadership and negotiation abilities. Beginners with an interest in mastering effective communication techniques. Anyone looking to boost confidence in personal and business conversations. Career Path Communications Specialist Sales and Marketing Executive Public Relations Officer Customer Relationship Manager Leadership and Management Roles Negotiation Consultant Corporate Trainer in Communication

The Art of Persuasive Communication
Delivered OnlineFlexible Dates
£7.99

CBT for Abandonment Anxiety

By NextGen Learning

CBT for Abandonment Anxiety Course Overview: This course on CBT for Abandonment Anxiety explores the core principles of Cognitive Behavioural Therapy (CBT) as a tool for addressing abandonment anxiety. The programme is designed to provide learners with a comprehensive understanding of how CBT techniques can help individuals overcome fears related to abandonment, fostering emotional resilience and healthier relationships. Learners will gain insight into the underlying causes of abandonment anxiety, alongside methods for managing emotional distress, improving self-esteem, and building secure attachments. By completing this course, participants will be equipped to apply CBT strategies in both personal and professional settings, enhancing their ability to support others struggling with similar issues. Course Description: This course covers key topics such as the psychology behind abandonment anxiety, common behavioural patterns, and the role of cognitive distortions. Learners will delve into specific CBT techniques such as cognitive restructuring, exposure therapy, and emotion regulation strategies. Through structured learning, participants will explore how to identify and challenge irrational thoughts, manage emotional responses, and develop healthier relationship dynamics. Throughout the course, learners will also examine real-world case studies to better understand how CBT is applied to address abandonment anxiety. By the end of the course, learners will have gained valuable skills to manage anxiety and build lasting emotional resilience. CBT for Abandonment Anxiety Curriculum: Module 01: Introduction to Abandonment Anxiety Module 02: Understanding Cognitive Behavioural Therapy (CBT) Module 03: Cognitive Restructuring for Abandonment Anxiety Module 04: Exposure Therapy Techniques Module 05: Emotion Regulation and Mindfulness Module 06: Building Secure Attachments Module 07: CBT in Practice: Case Studies and Applications (See full curriculum) Who is this course for? Individuals seeking to manage abandonment anxiety Professionals aiming to enhance therapeutic skills in CBT Beginners with an interest in mental health and anxiety management Therapists looking to deepen their knowledge of CBT applications Career Path Cognitive Behavioural Therapist Mental Health Counsellor Clinical Psychologist Therapeutic Support Worker Anxiety Specialist in Healthcare

CBT for Abandonment Anxiety
Delivered OnlineFlexible Dates
£7.99

Emotional Intelligence Course - CPD Certified

5.0(3)

By School Of Health Care

Emotional Intelligence: Emotional Intelligence Online Discover the Power of Emotional Intelligence: Enhance Your Skills and Propel Your Success! Are you ready to take your personal and professional life to the next level? Do you want to improve your relationships, excel in your career, and unlock your true potential? Look no further than our groundbreaking Emotional Intelligence: Emotional Intelligence course! Unlock the transformative power of Emotional Intelligence: Emotional Intelligence course and propel your success to new heights. Join our Emotional Intelligence: Emotional Intelligence course today and embark on a journey of self-discovery, growth, and achievement. Don't miss this opportunity to invest in yourself and take charge of your future. Enroll Emotional Intelligence: Emotional Intelligence now and experience the profound impact of Emotional Intelligence: Emotional Intelligence course on your personal and professional life! Main Course: Emotional Intelligence Gift Courses Included with Emotional Intelligence: Emotional Intelligence Course: Course 01: Anger Management Course 02: Level 5 Personal Development Course 03: Communication Skills Course Course 04: Level 5 Negotiation Skills Course [ Note: Free PDF certificate as soon as completing Emotional Intelligence: Emotional Intelligence Course] Emotional Intelligence: Emotional Intelligence Online This Emotional Intelligence: Emotional Intelligence Course consists of 08 modules. Course Curriculum of Emotional Intelligence: Emotional Intelligence Course Module 01: Emotional Intelligence Module 02: Introduction to Emotional Intelligence Module 03: Emotion Module 04: Neuro-Linguistic Programming (NLP) Module 05: Biological Behaviour of Psychology Module 06: Behaviours (Personality) Module 07: Learning Module 08: Motivation Assessment Method of Emotional Intelligence: Emotional Intelligence Course After completing Emotional Intelligence: Emotional Intelligence Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Emotional Intelligence: Emotional Intelligence Course After completing the Emotional Intelligence: Emotional Intelligence Course, you can instantly download your certificate for FREE. Who is this course for? Emotional Intelligence: Emotional Intelligence Online An Emotional Intelligence: Emotional Intelligence course is designed to help individuals develop and enhance their emotional intelligence skills. Emotional intelligence refers to the ability to recognize, understand, and manage our own emotions and the emotions of others. Requirements Emotional Intelligence: Emotional Intelligence Online To enrol in this Emotional Intelligence: Emotional Intelligence Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Emotional Intelligence: Emotional Intelligence Course. Be energetic and self-motivated to complete our Emotional Intelligence: Emotional Intelligence Course. Basic computer Skill is required to complete our Emotional Intelligence: Emotional Intelligence Course. If you want to enrol in our Emotional Intelligence: Emotional Intelligence Course you must be at least 15 years old. Career path Emotional Intelligence: Emotional Intelligence Online This Emotional Intelligence: Emotional Intelligence course is beneficial for various groups of people, including: Professionals and Leaders Managers and Supervisors Sales and Customer Service Professionals Educators and Trainers Human Resources Professionals Individuals seeking personal growth

Emotional Intelligence Course - CPD Certified
Delivered Online On Demand45 hours
£12

CRM: Customer Relationship Management - CPD Certified

5.0(3)

By School Of Health Care

CRM: Customer Relationship Management Online Are you excited to start a job as front desh executive or the job which have direct interaction with customers? Then our comprehensive CRM Course (Customer Relationship Management) is perfect for you. This CRM Course (Customer Relationship Management) delves into customer-centric strategies and emphasizing the use of CRM tools for enhanced customer interactions. The CRM Course (Customer Relationship Management) participants gain insights into customer data analysis, segmentation and effective communication techniques. The CRM Course (Customer Relationship Management) fosters skills in CRM system implementation and aligning sales. Moreover, the CRM Course (Customer Relationship Management) involves marketing and service functions. The CRM Course (Customer Relationship Management) helps in optimizing overall business performance through strengthened customer relationships. As the CRM Course (Customer Relationship Management) is a great method to progress your profession the what are you waiting? Sign up for this CRM Course (Customer Relationship Management) immediately! Main Course: CRM: Customer Relationship Management Free courses included with CRM: Customer Relationship Management Course: Along with CRM: Customer Relationship Management Course you will get free Close Protection Course Along with CRM: Customer Relationship Management Course you will get free Security Management Course Special Offers of this CRM: Customer Relationship Management Course: This CRM: Customer Relationship Management Course includes a FREE PDF Certificate. Lifetime access to this CRM: Customer Relationship Management Course Instant access to this CRM: Customer Relationship Management Course 24/7 Support Available to this CRM: Customer Relationship Management Course CRM: Customer Relationship Management Online Our CRM Course (Customer Relationship Management) provides an introduction to Customer Relationship Management (CRM) along with its all functions. Also, the CRM Course (Customer Relationship Management) explains CRM strategies, and data analysis in CRM and CRM Databases. Moreover, this CRM Course (Customer Relationship Management) includes difficulties handling processes. Additionally, the CRM Course (Customer Relationship Management) explain how to deepen the customer relationship and the future of CRM. Who is this course for? CRM: Customer Relationship Management Anyone can take this CRM Course (Customer Relationship Management). Requirements CRM: Customer Relationship Management To enroll in this CRM: Customer Relationship Management Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our CRM: Customer Relationship Management Course. Be energetic and self-motivated to complete our CRM: Customer Relationship Management Course. Basic computer Skill is required to complete our CRM: Customer Relationship Management Course. If you want to enrol in our CRM: Customer Relationship Management Course, you must be at least 15 years old. Career path CRM: Customer Relationship Management After completing this CRM Course (Customer Relationship Management), you can work as a manager, customer service manager, CRM analyst, and many other positions!

CRM: Customer Relationship Management - CPD Certified
Delivered Online On Demand1 hour 24 minutes
£12

Speech & language therapy with Dysphagia and Autism Awareness Diploma

5.0(1)

By Empower UK Employment Training

Speech & language therapy with Dysphagia and Autism Awareness Diploma Master the art and science of Speech & Language Therapy with our comprehensive diploma. Amplify your Speech & Language Therapy skills for diverse patient needs. Incorporate Autism Awareness into your Speech & Language Therapy practice. Learning Outcomes: Grasp the fundamentals of Speech & Language Therapy. Navigate the Speech & Language Therapy process effectively. Identify common speech disorders for focused therapy. Understand the role of a Speech & Language Therapist. Integrate Autism Awareness into Speech & Language Therapy. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from Speech & language therapy with Dysphagia and Autism Awareness Diploma: Overview of Speech and Language Therapy: Acquire an all-encompassing understanding of Speech & Language Therapy. Speech and Language Therapy Process: Master the step-by-step process integral to effective Speech & Language Therapy. Speech Disorders: Identify and categorise speech disorders for targeted Speech & Language Therapy. Speech & Language Therapist: Understand the professional duties and competencies of a Speech & Language Therapist. Diagnosis of Autism: Learn the diagnostic criteria for Autism within the realm of Speech & Language Therapy. Autism Awareness: Incorporate Autism Awareness as a critical aspect of your Speech & Language Therapy practice.

Speech & language therapy with Dysphagia and Autism Awareness Diploma
Delivered Online On Demand2 hours 24 minutes
£5

Understand Customers Needs and Online Behaviours - Online Course

3.0(2)

By Alpha Academy

The Understand Customers’ Needs and Online Behaviours course helps you connect with customers in a better way. You will learn how people think, act, and respond when they interact with businesses, especially online. The course covers communication skills, body language, and telephone manners, so you can give customers the best service. Whether you're selling something, helping someone, or just want to improve your customer skills, this course makes it easy. Course Curriculum ✓ Module 01: Basic Communication Skills ✓ Module 02: Advance Communication (I) ✓ Module 03: Advance Communication (II) ✓ Module 04: Telephone Etiquette ✓ Module 05: Body Language and Effective Communication Learning Outcomes Understand the basics of clear and polite communication. Learn advanced communication skills for real situations. Improve your listening and response techniques. Build strong customer relationships. Use telephone etiquette to make good impressions. Understand how to read and use body language. Respond better to online and in-person customer needs. Know what influences customer actions online. Handle different customer types with confidence. Communicate clearly and calmly under pressure. Who is this course for? This course is perfect for anyone who works with customers or wants to improve their communication. It’s great for people in sales, customer service, support, hospitality, or anyone who deals with clients online or by phone. If you want to understand people better and respond the right way, this course is for you. Eligibility Requirements You don’t need any past training to take this course. If you are willing to learn and improve how you talk and listen, you’re ready to begin. Career Path After finishing this course, you can work in many customer-focused roles. These include customer service advisor, support representative, sales assistant, call centre worker, or hospitality staff. You can also use these skills in marketing, retail, or any job that needs strong communication. (Learn more about this online course)

Understand Customers Needs and Online Behaviours - Online Course
Delivered Online On Demand4 hours
£9.99

Telesales Management Strategies Course

5.0(14)

By Training Express

Mastering telesales is a vital skill for any sales professional aiming to excel in the competitive world of remote selling. This course offers a detailed exploration of telesales techniques designed to enhance communication and boost sales performance over the phone. From understanding the nuances of telemarketing to mastering the art of persuasive dialogue, participants will discover how to structure calls effectively and handle challenges with confidence. Every module focuses on refining the skills necessary to convert prospects into loyal customers, ensuring each interaction is purposeful and results-driven. With a clear emphasis on strategic communication, this course walks you through the entire telesales journey — from preparing and opening calls to overcoming objections and successfully closing sales. Additional guidance on expanding sales opportunities will also help increase earnings and build lasting client relationships. Designed for those seeking to sharpen their telephone sales abilities without the need for physical attendance, this programme provides practical insights into managing telesales teams and individual performance, ensuring your approach is both professional and impactful. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Tele Sales Executive Training Module 02: All About Telemarketing Module 03: Elevate Sales on Telephone Module 04: Prospective Telephone-Sales Expert Module 05: The Right Words and Phrases to Use on a Sales Call Module 06: Preparing The Call Module 07: Opening The Call Module 08: Structuring The Call Module 09: Verbal Communication Skills Module 10: Dealing with Objections Module 11: Closing the Sale/ Gaining Commitment Module 12: Dealing with Rejection Module 13: Close a Sale Call Module 14: Increasing your Earnings by Expanding Sales Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Telesales Management Strategies training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Telesales Management Strategies training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Telesales Management Strategies Course
Delivered Online On Demand1 hour
£15

Commercial Analyst Training Course

5.0(14)

By Training Express

Step into the analytical core of commerce with our Commercial Analyst Training Course, designed to sharpen your understanding of how commercial decisions shape business outcomes. This course offers an in-depth look into the relationships, risks, and financial responsibilities that underpin commercial strategy—giving you the edge to assess, interpret, and respond to commercial data with confidence and clarity. From managing budgets and cash flow to navigating complex partnerships and shareholder roles, each module takes you further into the decision-making structures that keep businesses moving forward. You'll explore areas such as negotiation, project oversight, commercial risk, and customer lifecycle management—key components of a commercial analyst’s role. With a strong focus on data-driven insights and commercial awareness, this course equips you with the knowledge to evaluate performance, manage stakeholder expectations, and make informed contributions within any commercial environment. Whether you're working within an organisation or aiming to step into the commercial sector, this training gives you the tools to think commercially, act strategically, and interpret key financial and relational elements in a structured, effective manner. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Commercial Management Module 02: Commercial Relationship Part-1 Module 03: Commercial Relationship Part-2 Module 04: Partnership and Agreements Module 05: Budget Management Module 06: Cash Flow Management Part- 1 Module 07: Cash Flow Management Part- 2 Module 08: Negotiation Module 09: Commercial Risk Management Module 10: Commercial Project Management Module 11: Customer Relationship Management (CRM) Part-1 Module 12: Customer Relationship Management (CRM) Part-2 Module 13: Managing Customer Lifecycle Module 14: Roles of Shareholders in Commercial Management Module 15: Loans and Debts Management Module 16: Commercial Legislations Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Commercial Analyst training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Commercial Analyst training. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Commercial Analyst Training Course
Delivered Online On Demand1 hour
£15

Join our Microsoft Excel course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Excel course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Microsoft Excel course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Excel. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Microsoft Excel course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Microsoft Excel is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Excel course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Microsoft Excel Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 01: Excel from A-Z Course Introduction Excel from A-Z Course Intro 00:03:00 Excel Job Opportunities 00:03:00 Excel Job Types 00:04:00 Microsoft Excel Marketplace 00:04:00 What is Microsoft Excel? 00:04:00 Who is This Course For? 00:03:00 Unit 02: Getting Started With Excel Finding & Opening Excel 00:01:00 Excel's Start Screen 00:03:00 Explaining the Excel Interface 00:03:00 Excel Interface Continued 00:01:00 Excel Workbook vs. Excel Worksheet 00:02:00 Saving an Excel Document 00:04:00 Customizing the Quick Access Toolbar 00:02:00 Customizing the Excel Ribbon 00:03:00 Excel Shortcut Keys 00:02:00 Unit 03: Values, Referencing and Formulas Creating Excel Labels 00:03:00 Entering Numeric Values in Excel 00:03:00 Formatting Date Values in Excel 00:05:00 Building Basic Formulas in Excel 00:05:00 Order of Operations 00:06:00 Relative vs. Absolute Cell References 00:07:00 Unit 04: Intro to Excel Functions Excel Functions Explained 00:03:00 The SUM() Function 00:08:00 The MIN() & MAX() Function 00:04:00 The AVERAGE() Function 00:02:00 COUNT() Functions 00:05:00 Unit 05: Adjusting Excel Worksheets Moving & Copying Data 00:07:00 Insert & Delete Rows and Columns 00:05:00 Adjusting the Width and Height of Cells 00:05:00 Hiding and Unhiding Excel Rows and Columns 00:04:00 Renaming, Moving & Deleting Excel Worksheets 00:05:00 Adding Protection to Specific Cells 00:04:00 Protecting the Structure of a Workbook 00:02:00 Adding a Workbook Password to Open File 00:02:00 Unit 06: Visually Pleasing Cell Formatting Formatting Fonts and Cell Background Color 00:05:00 Adding Cell Borders 00:05:00 Formatting Data Appropriately 00:05:00 The Magic behind Excel's Format Painter 00:03:00 Creating Styles for Formatting Efficiency 00:06:00 Merging Cells for a Cleaner Look 00:03:00 The Power of Conditional Formatting 00:06:00 Unit 07: How to Insert Images and Shapes! Grab User's Attention using Illustrations 00:09:00 Customizing Icons 00:05:00 Create Compelling Graphics with SmartArt 00:06:00 Unit 08: Visualize Data with Charts The Commonly Used Column Chart 00:03:00 Changing the Chart Design.mp4 00:02:00 Formatting Elements of a Chart 00:06:00 Modifying the Data, Type & Location of a Chart 00:06:00 Unit 09: Excel's Printing Options Print Preview Options 00:04:00 Excel's Page Layout View 00:07:00 Printing a Specific Range of Cells 00:03:00 Converting Spreadsheets to PDF Files 00:02:00 Unit 10: Benefits of Using Excel Templates Why Create an Excel Template 00:01:00 How to Create an Excel Template 00:05:00 Unit 11: Working with Excel Datasets How to Prepare Data for Analysis 00:04:00 How to Sort Data in Excel 00:03:00 Multi-Level Sorting 00:03:00 Custom Sorting Datasets in Excel 00:02:00 Applying Filters to Datasets 00:05:00 Creating Subtotals within a Dataset 00:06:00 Converting Datasets into Tables 00:06:00 Little Slice of Pie Charts 00:05:00 Finding & Removing Duplicate Values 00:07:00 Unit 12: Excel Database Functions The SUMIF() Function 00:09:00 The DSUM() Function 00:08:00 The DSUM() Function Cont. 00:07:00 The SUBTOTAL() Function 00:06:00 Unit 13: Excel Data Validation What is Excel Data Validation? 00:02:00 Creating a Drop Down List with Data Validation 00:07:00 Different Types of Excel Data Validation 00:06:00 Adding Custom Alerts to Data Validation 00:07:00 Creating a Dynamic Drop Down List 00:03:00 Complex Validation: Dependent Drop Down List! 00:09:00 Unit 14: Excel PivotTables Creating an Excel Pivot Table 00:06:00 Modifying Excel PivotTables 00:06:00 Grouping & Filtering PivotTable Data 00:06:00 Drilling Down into PivotTable Data 00:02:00 Creating Pivot Charts & Utilizing Slicers 00:08:00 Unit 15: Excel's PowerPivot Add-In What is PowerPivot? 00:04:00 Activating the Excel PowerPivot Add-In 00:02:00 Creating Relationships between Data Tables.mp4 00:06:00 Using Data Models to Create PivotTables 00:05:00 How to Create PowerPivot KPI's 00:08:00 Unit 16: Excel's Conditional Functions Excels IF Function 00:05:00 IF() Function with AND() Criteria 00:05:00 IF() Function with OR() Criteria 00:05:00 Nesting Multiple IF() Functions 00:07:00 The COUNTIF() Function 00:04:00 Key Benefits of Named Ranges 00:04:00 Unit 17: Excel's Lookup Function VLOOKUP() Function 00:09:00 The Beauty of Excel's IFERROR() Function 00:04:00 HLOOKUP() Function 00:06:00 The INDEX Function 00:05:00 MATCH() Function 00:05:00 INDEX() and MATCH() Combined 00:05:00 Two-Way Lookup with INDEX() and MATCH() 00:04:00 Unit 18: Text Based Functions in Excel LEFT(), RIGHT() and MID() Function 00:07:00 Extracting Specific Text using LEN() & SEARCH() 00:13:00 Combining Text with CONCATENATE() 00:06:00 Quick Tips & Other Text Based Functions 00:06:00 Unit 19: Auditing Formulas and Views in Excel Tracing Precedents & Dependents in Formulas 00:04:00 Showing Formulas 00:02:00 Grouping Data 00:03:00 3D Referencing in Formulas 00:05:00 Utilizing the Watch Window in Excel 00:03:00 How to Freeze Panes in Excel 00:03:00 Unit 20: Excel's 'what If?' Tools Excel's Scenario Manager Tool 00:06:00 Goal Seek in Excel 00:06:00 Compare Results with Excel Data Tables 00:04:00 Solver Tool 00:11:00 Unit 21: Welcome to Excel VBA The Power Behind Excel VBA 00:03:00 A Look Inside the Visual Basic Editor (VBE) 00:04:00 Recording a Macro 00:09:00 Saving & Opening a Macro-Enabled Workbook 00:02:00 Unit 22: The VBA Language Modules and Procedures 00:07:00 Objects, Methods and Properties 00:06:00 Excel VBA Variables 00:05:00 Unit 23: Writing VBA Code Referencing a Range 00:13:00 InputBox & MsgBox 00:06:00 Using Variables in VBA Code 00:05:00 If Then Else Statement 00:10:00 Worksheet Functions inside VBA 00:08:00 Creating User Defined Functions 00:09:00 User Defined Functions within VBA Scripts 00:06:00 Unit 24: Important VBA Tools and Logic Find Last Row of Data 00:06:00 Find Last Column of Data 00:03:00 With Statement 00:05:00 Debugging & Error Handling 00:07:00 Debugging & Error Handling Cont. 00:07:00 Unit 25: Excel VBA Loop For Next Loop 00:09:00 Do Until Loop 00:06:00 For Each Loop 00:04:00 Unit 26: Triggering Macros Assigning Macros to Shapes 00:04:00 Form Controls vs ActiveX Controls 00:08:00 Worksheet Events 00:04:00 Workbook Events 00:03:00 Fun with VBA Events! 00:07:00 Unit 27: Excel User Forms Creating an Excel UserForm 00:03:00 Adding Controls to UserForms 00:10:00 How to Show an UserForm 00:03:00 Passing TextBox Values to Desired Cells 00:07:00 Passing Option Buttons to Desired Cells 00:07:00 UserForm ComboBoxes 00:08:00 Clearing Values from UserForm Controls 00:03:00 How to Close an UserForm 00:02:00 UserForms and Protected Sheets 00:05:00 Unit 28: Starting a Career in Excel Creating an Excel Resume 00:05:00 Getting Started with Freelancing 00:06:00 How to Become an Excel Freelancer 00:05:00 Top Freelance Websites 00:05:00 How to Get Your First Client 00:08:00 Personal Branding 00:07:00 Networking Do's and Don'ts 00:04:00 Importance of Having a Website 00:04:00 Resources Resources - Microsoft Excel 00:00:00

Microsoft Excel
Delivered Online On Demand13 hours 2 minutes
£11

Assistant Store Keeper Course

5.0(14)

By Training Express

This Assistant Store Keeper Course offers a detailed insight into the essential duties and responsibilities involved in managing retail inventory and supporting store operations. Designed for individuals eager to develop a strong foundation in store management, this course covers key areas such as retail management principles, consumer behaviour, and effective supplier relationships. Participants will gain a clear understanding of how to maintain stock accuracy, contribute to visual merchandising, and navigate the legal framework relevant to retail settings. The curriculum also explores customer interaction strategies and store psychology, ensuring learners appreciate the dynamics that influence shopping behaviour and store performance. Whether you are aiming to enter the retail sector or enhance your existing knowledge, this course provides the knowledge necessary to support store operations efficiently. Delivered entirely online, it suits those looking for flexible study without the need for physical attendance. Key Benefits Accredited by CPD Instant e-certificate Fully online, interactive course Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Curriculum Module 01: Introduction to Store Assistant Module 02: Roles and Responsibilities of a Store Assistant Module 03: Introduction to Retail Management Module 04: Managing a Retail Store Module 05: Visual Merchandising Module 06: Consumer Behaviour Module 07: Dealing with Customers Module 08: Dealing with Suppliers Module 09: Store Psychology Module 10: Legislations Related to Retail Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Certificate Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Assistant Store keeper training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Assistant Store keeper training. Certificates Certificate of completion Digital certificate - Included

Assistant Store Keeper Course
Delivered Online On Demand1 hour
£12