2823 Relationships courses in Attleborough delivered On Demand

Psychotherapy Do you have an interest in the psychology of human behaviour? This Psychotherapy course will teach you how to provide psychotherapy to children, adults, families, and groups and build the most positive relationship with your client. The Psychotherapy course begins with the fundamental knowledge and gradually shares expert knowledge. It will provide you with a comprehensive understanding of psychotherapy, including key concepts, strategies for using it, and in-depth knowledge. By the end of this Psychotherapy course, you will be able to apply this knowledge in your work with your clients, assisting them in overcoming current difficulties related to relationships, mental health, work-related issues, or finding their life purpose during your sessions! Why choose this Psychotherapy course from the School of Health Care? Self-paced course, access available from anywhere in the world. High-quality study materials that are easy to understand. Course developed by industry experts. After each module, there will be an MCQ quiz to assess your learning. Assessment results are generated automatically and instantly. 24/7 support is available via live chat, phone call, or email. Free PDF certificate after completing the course. Psychotherapy Learning Outcomes After completing this Psychotherapy course, the learner will be able to: Understand the fundamental concept of psychotherapy. Understand the relationship between psychology, counselling and psychotherapy. Gain a solid understanding of the role of a psychotherapist and where they work. Identify the types of people who would benefit from psychotherapy. Know how to set up the therapeutic environment and maintain a positive therapeutic relationship. Know how to conduct individual, child, family and couple psychotherapy sessions. Understand the different approaches in psychotherapy, including CBT. Know how to conduct online therapy sessions and work as an online psychotherapist. Understand the benefits of both short-term and long-term psychotherapy. Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Psychotherapy course. Who is this course for? Psychotherapy This Psychotherapy course is suitable for anyone interested in working as a therapist, counsellor, coach, or psychologist. Anyone who wants to use psychotherapy in their work should take this Psychotherapy course. Requirements There are no particular requirements for this Psychotherapy course because it doesn't call for any specialized training. Career path Opportunities includes with this Psychotherapy course in this field: Psychologists Psychiatrists Psychoanalysts Social Workers

This course covers all the key concepts that will help you prepare for and pass the AWS Certified Cloud Practitioner certification exam for the latest CLF-C01. A practical-based course where you will gain practical knowledge about AWS Cloud through videos and demo sessions.

Venture on a heart-enriching journey with the ADHD, SEN & EYFS Teaching Diploma bundle. Let empathy and knowledge intertwine as you delve into the world of diverse young minds. This ADHD, SEN & EYFS, Teaching Diploma bundle isn't just about eight courses; it's a voyage of understanding, patience, and growth. Crafted to nurture emotional connections, the ADHD, SEN & EYFS Teaching Diploma bundle allows you to step into children's lives, making a lasting impact. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: ADHD Course 02: Dyslexia Course 03: Autism Diploma Course 04: Teaching Assistant Course 05: SEN Teaching Assistant Course 06: EYFS Teaching Diploma Course 07: Phonics Teaching Diploma Course 08: Speech and Language Therapy With every word learned, you're inching closer to becoming a source of inspiration and change. The ADHD, SEN & EYFS Teaching Diploma isn't just an educational choice; it's a soulful commitment to shaping futures and embracing differences. Learning outcome Uncover insights into ADHD, SEN strategies, and EYFS principles. Adapt methods for diverse needs, from ADHD to dyslexia and autism. Collaborate, communicate, and empathise to support teachers and students. Engage, manage behaviours, and create tailored plans for unique needs. Craft play-based experiences that nurture growth and dreams. Elevate language, literacy, and communication skills with precision. In a world where every child's potential deserves to be nurtured, our ADHD, SEN & EYFS Teaching Diploma bundle opens the doors to compassion-driven education. Gain knowledge through the ADHD, SEN & EYFS Teaching Diploma bundle that promises the power to impact young lives profoundly. Why Choose the ADHD, SEN & EYFS Teaching Diploma Bundle? Learn to understand, support, and empower children with diverse needs, from ADHD to autism, through specialised SEN strategies and the Early Years Foundation Stage (EYFS) framework. Embrace an approach that celebrates individuality and growth. Our carefully curated courses combine expert insights, real-world scenarios, and real-life techniques. Gain a deep understanding of ADHD, SEN strategies, and EYFS principles. Discover adaptable teaching methods that resonate with diverse learners. Unleash your potential as a teaching assistant, collaborator, and advocate for those who need it most. Where Will It Lead You? This ADHD, SEN & EYFS Teaching Diploma bundle is a compass that guides you towards impactful roles in classrooms, support settings, and even your family environment. Emerge equipped to sculpt tailored learning plans, create engaging experiences, and foster holistic development. Your journey might take you to schools, therapy centres, or even your venture as an advocate for inclusive education. Join us in creating a world where every child's uniqueness is celebrated, and you play a pivotal role in shaping brighter futures. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Education professionals Early childhood practitioners Advocates for inclusive education Current educators Aspiring educators Parents & caregivers Career path Special Ed Teacher Early Years Educator Learning Support Specialist Speech and Language Therapist SEN Teaching Assistant Educational Consultant Inclusion Coordinator Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Using Blueprints in UE5, you can learn game development without coding. This beginner-friendly course will teach you how to use Unreal Engine's visual coding system. There is no prior experience required, and each lesson will gradually increase your knowledge.

Waiter Training: Waiter Training Course online Unlock the Power of Waiter: Waiter Training Course: Enrol Now! Do you want to embark on a career as a waiter or develop your waiter skills? Our Waiter: Waiter Training Course will help you to acquire the information and abilities necessary to land a position in the waiter industry. The goal of the Waiter: Waiter Training Course was to provide participants a thorough understanding of Waiter. This Waiter: Waiter Training Course will outline numerous service categories and create a communication gap with different clientele. By completing this waiter training, you will be able to securely serve food and preserve food items. Also, waiter training will teach you how to handle grievances. After completing this Waiter: Waiter Training Course, you will be a pro at upholding personal hygiene and health requirements. Participate in our Waiter: Waiter Training Course program to increase your productivity and become more organised and efficient at work! Main Course: Waiter Training Course Special Offers of this Waiter: Waiter Training Course: This Waiter: Waiter Training Course includes a FREE PDF Certificate. Lifetime access to this Waiter: Waiter Training Course Instant access to this Waiter: Waiter Training Course 24/7 Support Available to this Waiter: Waiter Training Course Waiter Training: Waiter Training Course online The waiter training course is designed to provide participants with a thorough grasp of the waiter. This waiter training course includes sanitary procedures, cleanliness, and food service procedures. Additionally, this waiter training course is ideal for enhancing your position, developing your communication skills, and building relationships with clients. Moreover, this waiter training: waiter training course will help you comprehend VIP service, waiter upkeep, and food handling. The waiter training course supports effective problem-solving in handling challenging circumstances. Who is this course for? Waiter Training: Waiter Training Course online This Waiter: Waiter Training Course is accessible to learners with no prior waiter experience. Requirements Waiter Training: Waiter Training Course online To enrol in this Waiter: Waiter Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Waiter: Waiter Training Course. Be energetic and self-motivated to complete our Waiter: Waiter Training Course. Basic computer Skill is required to complete our Waiter: Waiter Training Course. If you want to enrol in our Waiter: Waiter Training Course, you must be at least 15 years old. Career path Waiter Training: Waiter Training Course online UK people will benefit from this Waiter: Waiter Training Course by getting new opportunities in a variety of industries.

Psychotherapy: Psychotherapy course Online Unlock the Power of Psychotherapy: Psychotherapy Course: Enrol Now! Do you have an interest in the psychology of human behaviour? This Psychotherapy: Psychotherapy course will teach you how to provide psychotherapy to children, adults, families, and groups and build the most positive relationship with your client. The Psychotherapy: Psychotherapy course begins with the fundamental knowledge and gradually shares expert knowledge. It will provide you with a comprehensive understanding of psychotherapy, including key concepts, strategies for using it, and in-depth knowledge. By the end of this Psychotherapy: Psychotherapy course, you will be able to apply this knowledge in your work with your clients, assisting them in overcoming current difficulties related to relationships, mental health, work-related issues, or finding their life purpose during your sessions! Courses you will get: Course 01: Psychotherapy Course 02: Psychology Counselling [ Note: Free PDF certificate as soon as completing the Psychotherapy: Psychotherapy course] Psychotherapy: Psychotherapy course Online This Psychotherapy: Psychotherapy course consists of 04 modules. Course Curriculum of Psychotherapy: Psychotherapy course Module 01: Overview of Psychotherapy Module 02: Psychotherapy Practice Module 03: Prospective Clients in Therapy Module 04: Stages of Psychotherapeutic Relationship Certification of Psychotherapy: Psychotherapy course After completing the Psychotherapy: Psychotherapy course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Assessment Method of Psychotherapy: Psychotherapy course After completing Psychotherapy: Psychotherapy course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Who is this course for? Psychotherapy: Psychotherapy course Online This Psychotherapy: Psychotherapy course is suitable for anyone interested in working as a therapist, counsellor, coach, or psychologist. Anyone who wants to use psychotherapy in their work should take this Psychotherapy: Psychotherapy course. Requirements Psychotherapy: Psychotherapy course Online To enrol in this Psychotherapy: Psychotherapy course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Psychotherapy: Psychotherapy course. Be energetic and self-motivated to complete our Psychotherapy: Psychotherapy course. Basic computer Skill is required to complete our Psychotherapy: Psychotherapy course. If you want to enrol in our Psychotherapy: Psychotherapy course you must be at least 15 years old. Career path Psychotherapy: Psychotherapy course Online Opportunities includes with this Psychotherapy: Psychotherapy course in this field: Psychologists Psychiatrists Psychoanalysts Social Workers

AET Level 3 Award in Education and Training (Formerly PTLLS) ** SUMMER SALE----SUMMER SALE ** ➽➽➽ Live Zoom Microteaching Session with Tutor Tired of endlessly scouring the internet for an AET Level 3 Award in Education and Training (Formerly PTLLS) course? Struggling to find one that ticks all the boxes? Look no further - you've just stumbled upon the perfect solution. Take a moment to explore our comprehensive PTLLS course, meticulously crafted to provide everything you need for success. The AET Level 3 Award in Education and Training (Formerly PTLLS) program is tailored for individuals aspiring to work in education, particularly as early-age instructors and trainers across various contexts. It serves as the initial stepping stone towards becoming an entry-level teacher in the United Kingdom. Additionally, accredited by TQUK, a leading awarding organization in the UK, our AET Level 3 Award in Education and Training (Formerly PTLLS) ensures quality and recognition. This qualification is essential if you're eyeing a career as a FE teacher or trainer in the UK. Thinking about delving into the realm of teaching? Our AET Level 3 Award in Education and Training, previously known as the PTLLS course, provides an excellent starting point. As a teacher, you wield significant influence, shaping the lives of your students and contributing positively to society. With a global surge in demand for teaching positions, the satisfaction and impact of such a career are unparalleled. If you aspire to effect change, this course is tailor-made for you, accommodating both novices and seasoned educational professionals. Awarded by TQUK, a reputable accreditation body, our AET Level 3 Award in Education and Training (Formerly PTLLS) certification enhances your marketability within the industry. But wait, there's more! As a token of our commitment to your learning journey, we offer additional courses alongside the AET Level 3 Award in Education and Training (Formerly PTLLS) course. These supplementary teaching and training courses are curated to enrich your knowledge and bolster your employability. Upon completion of our AET/PTLLS - Level 3 Award in Education and Training, you'll possess a comprehensive skill set, including the ability to: Identify and execute the roles of a teacher. Implement effective teaching and learning approaches. Tailor training sessions for learners from diverse backgrounds. Understand teacher attributes and expectations. Develop inclusive lessons and training sessions. Analyze roles, responsibilities, and relationships in education and training. Administer assessments for students effectively. Embark on a rewarding career journey with our AET Level 3 Award in Education and Training (Formerly PTLLS) program. Whether you're seeking personal fulfillment or aiming to impact others' lives, teaching is a gratifying profession. It's an opportunity not only for personal growth but also to facilitate the growth of countless learners. With schools and universities constantly seeking qualified instructors, the demand for educators remains high. Teaching isn't just about imparting knowledge; it's about continual learning and growth. The PTLLS Training is a nationally recognized award suitable for both current and aspiring educators, providing the necessary qualifications to excel in the field. Special Note: Please be informed that apart from the initial fee, you have to pay GBP 169 when submitting assignments. AET Level 3 Award in Education and Training (Formerly PTLLS) By learning this AET Level 3 Award in Education and Training (Formerly PTLLS) You will learn about the role, responsibilities, and duties of a teacher. Besides, you will be able to identify the significance of your existence in your students' lives. Also, You will know how you can bring effective change to them with your influence through this PTLLS Training. Further, inclusive teaching and learning is a very important concept in an educational setting. That is why we have included this AET Level 3 Award in Education and Training (Formerly PTLLS) in our course so that you can learn. Besides, you will get an in-depth idea about how to perform an assessment. AET Level 3 Award in Education and Training (Formerly PTLLS) Course Curriculum Module 01: Understanding Roles, Responsibilities and Relationships in Education and Training Module 02: Understanding and Using Inclusive Teaching and Learning Approaches in Education and Training Module 03: Understanding Assessment of PTLLS AET Level 3 Award in Education and Training (Formerly PTLLS) Qualification at a Glance Total Qualification Time (TQT - 120 Hours Guided Learning Hours (GLH) - 48 Hours Credit Value - 12 Minimum Age - 19 AET Level 3 Award in Education and Training (Formerly PTLLS) Assessment Method PTLLS To be eligible for the certification, you need to complete the following assessments. Three written assignments One microteaching session - 60 Minutes (Which can be submitted as a recorded video) Please note that you will be given precise instruction in the course material about writing the assignments and performing the micro-teach session. Moreover, if you face any difficulty, your tutor will be there to support you. You must submit all assignments via the online portal with full tutor support. Certification As soon as you submit your assignments and micro-teaching video, your tutor will assess those. Based on the assessor's evaluation, you will be graded either achieved/not achieved yet. If you are in the achieved category, you will receive an accredited certificate from the renowned awarding body TQUK. Progression If you achieve this AET Level 3 Award in Education and Training (Formerly PTLLS) Course qualification, you could progress to: AET/PTLLS: Level 3 Award in Assessing Vocationally Related Achievement AET/PTLLS: Level 3 Certificate in Assessing Vocational Achievement AET/PTLLS: Level 3 Award in Assessing Competence in the Work Environment AET/PTLLS: Level 4 Certificate in Education and Training AET/PTLLS: Level 4 Certificate for the Advanced Practitioner in Schools and Colleges AET/PTLLS: Level 4 Award for Technology Enabled Educators AET/PTLLS: Level 5 Diploma in Education and Training Who is this course for? AET: AET Level 3 Award in Education and Training (Formerly PTLLS) Wherever you work, this AET Level 3 Award in Education and Training (Formerly PTLLS) is a must for you if you want to become a trainer. This course is suitable for: Beginners in AET Professionals Students Career changers Requirements AET: AET Level 3 Award in Education and Training (Formerly PTLLS) There are no fixed entry requirements for attending the AET Level 3 Award in Education and Training (Formerly PTLLS) course. However, you must be 19 years old or over upon certification. An interest in teaching adults and E-learning will be beneficial. Moreover, you must have basic ICT and time management skills. It will help you complete online written assignments. Since this is a PTLLS course, you must be ready to read through various texts, cross-reference, research theories or principles or practises of effective teaching. Career path AET: AET Level 3 Award in Education and Training (Formerly PTLLS) You can choose from a variety of professions either in teaching or training upon completion of the AET Level 3 Award in Education and Training (Formerly PTLLS). These include Primary School Teacher Secondary School Teacher Further Education Teacher Private Tutor Freelance Trainer Trainer at Your Workplace

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

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!

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