4784 Courses

Elevate your job life and career with the ADHD, SEN, Autism & Child Care bundle, a comprehensive collection of courses designed to impact the lives of children with special educational needs positively. Enrolling in this bundle will give you valuable knowledge and insights that will significantly enhance your professional abilities in child care and special education. This bundle equips you with the expertise to better understand and support children with ADHD, SEN, and autism, enabling you to make a meaningful difference in their lives. By deepening your knowledge of these conditions, you can implement effective strategies and interventions, fostering a more inclusive learning environment. Learning Outcomes: Gain in-depth knowledge of ADHD, SEN, and autism, enabling adequate support for children with diverse needs. Develop skills in coordinating and implementing support systems as a SENCO or SEN Teaching Assistant. Understand child psychology and development, providing informed guidance to foster children's growth. Acquire practical strategies for adequate child care, promoting physical, cognitive, and emotional well-being. Familiarise with CBT and Play Therapy, supporting children's mental health and emotional well-being. Enhance employability in education, healthcare, and childcare sectors, meeting the growing demand for expertise in ADHD, SEN, autism, child psychology, and child care. The ADHD, SEN, Autism & Child Care Bundle is a comprehensive package designed to equip individuals with the knowledge and skills needed to support and positively impact the lives of children with special educational needs. This carefully curated bundle encompasses a range of courses that delve into the intricacies of ADHD, special educational needs coordination, autism, child psychology, child development and care, cognitive behavioural therapy (CBT), and play therapy. ADHD, SEN, Autism & Child Care Bundle Curriculum are: ADHD SENCO - Special Educational Needs Coordination Course Autism Diploma SEN Teaching Assistant Child Psychology Diploma Child Development and Care Cognitive Behavioural Therapy (CBT) Practitioner Certificate Course Play Therapy Don't miss this opportunity to expand your knowledge and enhance your professional skills. Enrol now and unlock the potential to make a meaningful difference in the lives of children with ADHD, SEN, and autism. Let's create inclusive and nurturing environments where every child can thrive together. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Educators and teachers Teaching assistants and SENCOs Childcare professionals Parents and caregivers Individuals interested in special education Healthcare and therapy professionals Career path SENCO (Special Educational Needs Coordinator): £25,000 - £45,000 per year. SEN Teaching Assistant: £15,000 - £25,000 per year. Childcare Manager: £20,000 - £40,000 per year. Behavioural Therapist: £20,000 - £40,000 per year. Child Psychologist: £30,000 - £50,000 per year. Please note that salary ranges vary based on location, experience, and specific job responsibilities. Certificates Certificate of Completion Digital certificate - Included Certificate of Completion Digital certificate - Included You will get a complimentary Hard Copy Certificate.

Are you ready to embark on an enlightening journey of wisdom with the Autism bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Pathological Demand Avoidance (PDA) with Autism. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: Pathological Demand Avoidance Course 02: Autism in Early Childhood Course 03: Dyslexia Course 04: ADHD Course 05: Advanced Parenting Skills Training Course Course 06: Child and Adolescent Mental Health Course 07: Disability Assessor Training Course 08: CBT for Children and Adults with Role Playing Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Pathological Demand Avoidance (PDA) with Autism bundle illuminate your path to wisdom. The Pathological Demand Avoidance (PDA) with Autism bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Pathological Demand Avoidance (PDA) with Autism package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Autism bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Pathological Demand Avoidance (PDA) with Autism community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Autism bundle. Establish robust bases across each course nestled within the Autism bundle. Decipher intricate concepts through the articulate content of the Autism bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Autism bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Autism bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Autism bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Autism bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Autism bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Autism journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Autism bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Autism bundle lays a solid groundwork. 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 Hard copy Transcript - £9.99

Are you ready to embark on an enlightening journey of wisdom with the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Special Needs: SEN Teaching, Phonics Teaching & Child Development. Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: SENCO - Special Educational Needs Coordination Course Course 02: SEN Teaching Assistant Course 03: Learning Support Assistant Course 04: Autism Diploma Course 05: Child Development and Care Course 06: Primary Teacher Course 07: Phonics Teaching Diploma Course 08: Speech and Language Therapy Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle illuminate your path to wisdom. The Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Special Needs: SEN Teaching, Phonics Teaching & Child Development package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Special Needs: SEN Teaching, Phonics Teaching & Child Development community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle. Establish robust bases across each course nestled within the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle. Decipher intricate concepts through the articulate content of the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Special Needs: SEN Teaching, Phonics Teaching & Child Development journey and let knowledge guide you towards a brighter future. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Special Needs: SEN Teaching, Phonics Teaching & Child Development bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Special Needs bundle lays a solid groundwork. Certificates CPD Accredited Certificate Digital certificate - Included CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript: £9.99

Talk through problems Check up call Help with single parenting dating issue Dating advice Your own coach for 3 weeks Mini sessions Depression and stress relief strategies 30 mins x 2 per week for 3 weeks Support and anxiety issues addressed Time convenience coaching Phone sessions Dating advice for singles https://relationshipsmdd.com/product/single-parent-coaching-package/

"Unlock your potential in the real estate industry with our comprehensive 'Real Estate Course: Essential Training for Estate Agents.' Master the fundamentals, from property valuation and negotiation strategies to leveraging cutting-edge technology. Elevate your career, enhance your skills, and thrive in the dynamic world of real estate. Enroll now for a transformative learning experience!

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.

Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Online Psychology Counselling: Psychology Counselling Online Psychology Counselling: Psychology Counselling addresses cultural diversity, interpersonal and family relationships, vocational adjustment, and rehabilitation from a developmental perspective. Psychologists address individual, couple, family, community, and workplace problems in this field. Vocational counselling, substance abuse, rehabilitation, education, marital and family therapy, and community mental health are the most common specialities in counselling and psychology. Enrol in our Psychology Counselling: Psychology Counselling today to become a human mind expert and take the first step toward a psychologist or counsellor career. This Psychology Counselling: Psychology Counselling course aims to provide you with in-depth knowledge of Counselling and Psychology. Learn how to help people deal with personal and professional difficulties. There are numerous opportunities to work in well-known institutions and companies. Special Offers of this Psychology Counselling: Psychology Counselling Course. This Psychology Counselling: Psychology Counselling Course includes a FREE PDF Certificate. Lifetime access to this Psychology Counselling: Psychology Counselling Course Instant access to this Psychology Counselling: Psychology Counselling Course 24/7 Support Available to this Psychology Counselling: Psychology Counselling Course Courses are included in this Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Bundle Course Course 01: Diploma in Counselling and Psychology Course 02: Level 4 Diploma in Child Counselling Course 03: Level 1 Certificate in Well-being Course 04: Level 2 Certificate in Understanding Domestic Abuse Course 05: Nursing & Prescribing Course 06: Mental Health Support Worker Course 07: Introduction to Psychotherapy Course 08: Social Worker: Social Work Diploma Course 09: Level 5 Mental Health First Aid Certification Course 10: Level 2 Certificate in Understanding Children and Young People’s Mental Health [ Note: Free PDF certificate as soon as completing the Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy course] Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Online This Psychology, Counselling and Psychotherapy course consists of 14 modules. Assessment Method of Psychology, Counselling and Psychotherapy Course After completing Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Course, you will get quizzes to assess your learning. Certification of Psychology, Counselling and Psychotherapy Course After completing the Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy course, you can instantly download your certificate for FREE. Who is this course for? Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Online This Psychology, Counselling and Psychotherapy : Psychology, Counselling and Psychotherapy is designed for anyone who wants to gain knowledge in counselling and psychology. Requirements Psychology, Counselling and Psychotherapy: Psychology, Counselling and Psychotherapy Online To enrol in this Psychology, Counselling and Psychotherapy Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Psychology, Counselling and Psychotherapy Course. Be energetic and self-motivated to complete our Psychology, Counselling and Psychotherapy Course. Basic computer Skill is required to complete our Psychology, Counselling and Psychotherapy Course. If you want to enrol in our Psychology, Counselling and Psychotherapy Course, you must be at least 15 years old.

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 Courses you will get along with this CRM: Customer Relationship Management Course: CRM Course Offers free Close Protection Course CRM Course Offers free Security Management Course Others benefit Included with CRM: Customer Relationship Management Course. Free 03 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the CRM: Customer Relationship Management Course] CRM: Customer Relationship Management Online Course Curriculum of CRM: Customer Relationship Management Module 01: Introduction to Customer Relationship Management (CRM) Module 02: CRM Fundamentals Module 03: CRM Strategies Module 04: Data Analysis in CRM Module 05: CRM Databases Module 06: Deepening Customer Relationship Module 07: Handling Customer Complaints Module 08: Future of CRM Assessment Method of CRM: Customer Relationship Management After completing CRM: Customer Relationship Management 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. Certification of CRM: Customer Relationship Management After completing the CRM: Customer Relationship Management 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. 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!

Enhance your training & mentoring skills with this CPD-accredited, QLS-endorsed course. Gain expertise & career growth with flexible learning.

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