47322 Courses

Did you know "Goodbye" used to be "God be with you"? Imagine whispering that ancient blessing to your students in a bustling Tokyo classroom, or explaining its evolution to eager learners in Rio. This TEFL / TESOL & English Grammar course isn't just about mastering verb conjugations and comma placement - it's about unlocking the 15 hidden superpowers of language. Imagine this: Decoding the secret societies of idioms: Unearth the playful paradoxes of "raining cats and dogs" and "killing two birds with one stone," leaving your students giggling with newfound understanding. Time-traveling through tenses: Master the magic of the past, present, and future, showing your students how to paint vivid pictures with words and navigate the ever-shifting sands of time. Conquering the Everest of sentence structures: Climb the peaks of complex grammar with confidence, guiding your students through the valleys of clauses and the forests of phrases with clear, concise explanations. Building bridges with prepositions: Explore the hidden stories within "by," "to," and "of," revealing how these tiny words connect us across cultures and continents. Orchestrating the symphony of speech: Discover the rhythm and melody of language, helping your students find their voice and express themselves with captivating fluency. Teaching English Language: TEFL / TESOL & English Grammar isn't a textbook drill - it's a passport to endless possibilities. Picture yourself sipping chai with students in Mumbai, sharing laughter and stories over perfectly-conjugated verbs. Imagine the thrill of guiding eager minds in Prague through the labyrinthine beauty of the English language. This course isn't just about teaching English - it's about connecting with the world, one sentence, one smile, at a time. So, pack your passion for language and prepare to embark on a transformative journey. Enroll in Teaching English: TEFL / TESOL & English Grammar today, and say "hello" to a world of unforgettable experiences! Learning Outcomes of the Teaching English: TEFL / TESOL & English Grammar Course: Upon successful completion of the Teaching English: TEFL / TESOL & English Grammar course, you will be able to, Recognise the importance of studying and teaching English. Discover many language strategies with the Teaching English Language: TEFL / TESOL & English Grammar course. Learn how to pronounce English words well. Learn enough of the vocabulary and grammatical basics with the Teaching English Language: TEFL / TESOL & English Grammar course. Boost your reading, writing, speaking, and listening abilities with the Teaching English Language: TEFL / TESOL & English Grammar course. Gain further knowledge about TEFL lesson frameworks with the Teaching English Language: TEFL / TESOL & English Grammar course. Gain further knowledge about TESOL lesson frameworks. Utilise activities and games with the Teaching English Language: TEFL / TESOL & English Grammar course. Recognise the role of technology in the teaching and learning of second languages. Determine various situational perspectives with the Teaching English Language: TEFL / TESOL & English Grammar course. Examine the connection between employment and professional growth. What will make you stand out? On completion of this with the Teaching English Language: TEFL / TESOL & English Grammar course, you will gain: CPD QS Accredited After successfully completing the with the Teaching English Language: TEFL / TESOL & English Grammar Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. This Teaching English Language: TEFL / TESOL & English Grammar course has Lifetime access. The online test with immediate results You can study and complete the Teaching English: TEFL / TESOL & English Grammar course at your own pace. Master the Art of Teaching English Language: TEFL/TESOL & English Grammar! This comprehensive 15-module Teaching English Language: TEFL/TESOL & English Grammar program is your gateway to a rewarding career in Teaching English Language: TEFL/TESOL & English Grammar. Dive deep into the world of language learning and equip yourself with the skills and knowledge to confidently guide students of all ages and backgrounds. Here's what you'll conquer with the Teaching English Language: TEFL / TESOL & English Grammar course: Module 1-5: Laying the Foundation: Grasp the core principles of TEFL/TESOL by understanding how students learn English, exploring the intricacies of linguistics, and mastering English pronunciation. Dive into effective methods for teaching grammar and vocabulary, and discover a range of language teaching methodologies. Module 6-9: Honing Your Skills: Become a skilled instructor in all four language domains. Learn proven techniques for teaching reading, writing, listening, and speaking, ensuring your students develop all-around fluency and confidence in using English. Module 10-12: Engaging the Classroom: Craft captivating lessons that keep your students enthralled! Learn how to plan effective lessons, create engaging materials, and incorporate games, activities, and technology to keep the learning dynamic and fun. Module 13-15: Mastering the Craft: Delve into essential classroom management strategies to handle diverse learners and keep your students motivated. Explore the situational approach to language teaching, and gain valuable insights into professional development and employment opportunities in the global TEFL/TESOL field. Finally, the Teaching English Language: TEFL / TESOL & English Grammar Assignment puts your knowledge to the test, solidifying your mastery of Teaching English Language: TEFL/TESOL & English Grammar. Embrace the adventure of teaching English, and embark on a journey of personal and professional growth with this Teaching English Language: TEFL / TESOL & English Grammar program. So, are you ready to unlock the magic of Teaching English Language, TEFL/TESOL & English Grammar? Enroll today and let the learning begin! CPD 10 CPD hours / points Accredited by CPD Quality Standards Module 01: Introduction to English Language Teaching & Learning 08:46 1: Introduction to English Language Teaching & Learning Preview 08:46 Module 02: Linguistics 24:19 2: Linguistics Preview 24:19 Module 03: English Pronunciation 13:36 3: English Pronunciation 13:36 Module 04: Teaching Grammar and Vocabulary 17:01 4: Teaching Grammar and Vocabulary 17:01 Module 05: Language Teaching Methodologies 11:38 5: Language Teaching Methodologies 11:38 Module 06: Teaching Receptive Skills: Reading 11:28 6: Teaching Receptive Skills: Reading 11:28 Module 07: Teaching Productive Skills: Writing 09:51 7: Teaching Productive Skills: Writing 09:51 Module 08: Teaching Receptive Skills: Listening 10:02 8: Teaching Receptive Skills: Listening 10:02 Module 09: Teaching Productive Skills: Speaking 08:54 9: Teaching Productive Skills: Speaking 08:54 Module 10: Lesson Planning and Creating Materials 16:49 10: Lesson Planning and Creating Materials 16:49 Module 11: Use of Games and Activities 09:03 11: Use of Games and Activities 09:03 Module 12: Technology in Second Language Teaching & Learning 13:37 12: Technology in Second Language Teaching & Learning 13:37 Module 13: Classroom Management and Student Motivation 18:55 13: Classroom Management and Student Motivation 18:55 Module 14: Teaching English: Situational Approach 20:28 14: Teaching English: Situational Approach 20:28 Module 15: Professional Development and Employment 14:25 15: Professional Development and Employment 14:25 Assignment - TEFL / TESOL Certification 03:00 16: Assignment On TEFL / TESOL 03:00 PDF Who is this course for? Anyone can enrol in this Teaching English Language: TEFL / TESOL & English Grammar course including: Novice English teachers. Anyone who wishes to improve their learning techniques and perhaps one day teaches the English language. Note: This Teaching English Language: TEFL / TESOL & English Grammar course is not a regulated course. To get qualified, you may choose: Level 5 Certificate in Teaching English as a Foreign Language (RQF) Level 5 Certificate in Teaching English as a Foreign Language (TEFL) (The TEFL Academy) Level 5 Diploma - Certificate in Teaching Practice (TEFL) (The TEFL Academy) Level 7 Diploma in Teaching English to Speakers of other Languages ESOL Level 5 Diploma in Teaching English: Literacy and ESOL (RQF) Level 1 Award in ESOL Skills for Life (Reading) (RQF) Level 1 Award in ESOL Skills for Life (Speaking and Listening) (RQF) Level 1 Award in ESOL Skills for Life (Writing) (RQF) Level 2 Award in ESOL Skills for Life (Reading) (RQF) Level 2 Award in ESOL Skills for Life (Speaking and Listening) (RQF) English literature GCSE English GCSE English A-level English Language A-level English Literature Functional Skills Qualification in English at Entry Level 1 Functional Skills Qualification in English at Entry Level 2 Requirements Without any formal requirements, you can delightfully enrol in this Teaching English Language: TEFL / TESOL & English Grammar course. Career path This Teaching English Language: TEFL / TESOL & English Grammar course enables you to learn in-depth knowledge and develop the skills you need to succeed in the following career opportunities: English Teacher TEFL Teacher IELTS Instructor English Language Teacher English Grammar Teacher Teaching Assistant

In today's fast-paced and interconnected world, mastering Basic Telephone EtiquetteSkills is more crucial than ever. Telephone Etiquette ensures that every call you handle is professional, efficient, and courteous, which is essential in both daily life and your professional career. Learning Telephone Etiquette can significantly enhance your job prospects in the UK, where excellent communication skills are highly valued. In fact, mastering Telephone Etiquette can open doors to various roles in customer service, administration, and support, with average salaries ranging from £18,000 to £25,000 per year. The demand for professionals with strong Telephone Etiquette skills is on the rise, with the customer service sector growing by approximately 5% annually. By enrolling in this course, you will learn how to prepare for calls, handle difficult situations, and practice best Telephone Etiquette, making you an invaluable asset to any organization. Whether you're looking to improve your personal interactions or seeking career advancement, Telephone Etiquette is a skill that will set you apart. Key Features: CPD Certified Basic Telephone Etiquette Skills Course Free Certificate from Reed CIQ Approved Basic Telephone Etiquette Skills Course Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Telephone Skills Module 02: Preparing for the Call Module 03: Answering Calls Module 04: Conducting a Business Call Module 05: Handling Difficult Situations Module 06: Holding and Transferring Calls Module 07: Ending the Call Module 08: Telephone Etiquette for Customer Service Module 09: Best Practices of Telephone Etiquette Learning Outcomes: Cultivate confident call handling with strategic preparation techniques. Master the art of conducting seamless and impactful business conversations. Navigate and resolve challenging situations with poise and professionalism. Acquire proficiency in the seamless transfer of calls. Enhance your telephone etiquette to provide exceptional customer service. Apply best practices, setting yourself apart as a communication virtuoso. CPD 10 CPD hours / points Accredited by CPD Quality Standards Basic Telephone Etiquette Skills 1:51:23 1: Module 01: Introduction to Telephone Skills Preview 15:27 2: Module 02: Preparing for the Call 08:23 3: Module 03: Answering Calls 12:19 4: Module 04: Conducting a Business Call 11:26 5: Module 05: Handling Difficult Situations 09:24 6: Module 06: Holding and Transferring Calls 11:50 7: Module 07: Ending the Call 09:38 8: Module 08: Telephone Etiquette for Customer Service 19:58 9: Module 09: Best Practices of Telephone Etiquette 11:58 10: Leave A Review 01:00 Who is this course for? This Basic Telephone Etiquette Skills course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Basic Telephone Etiquette Skills. Moreover, this course is ideal for: Professionals seeking to refine their telephone communication skills. Customer service representatives aiming for excellence in phone interactions. Individuals aspiring to enhance their business communication finesse. Team members involved in call handling and transfers. Anyone looking to elevate their overall telephone communication competency. Requirements There are no requirements needed to enrol into this Basic Telephone Etiquette Skills course. We welcome individuals from all backgrounds and levels of experience to enrol into this Basic Telephone Etiquette Skills course. Career path After finishing this Basic Telephone Etiquette Skills course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Basic Telephone Etiquette Skills are: Customer Service Representative - £18K to 25K/year. Receptionist - £16K to 22K/year. Office Administrator - £18K to 24K/year. Call Centre Operator - £17K to 23K/year. Telemarketer - £16K to 20K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

In today's fast-paced and interconnected world, mastering Basic Telephone EtiquetteSkills is more crucial than ever. Telephone Etiquette ensures that every call you handle is professional, efficient, and courteous, which is essential in both daily life and your professional career. Learning Telephone Etiquette can significantly enhance your job prospects in the UK, where excellent communication skills are highly valued. In fact, mastering Telephone Etiquette can open doors to various roles in customer service, administration, and support, with average salaries ranging from £18,000 to £25,000 per year. The demand for professionals with strong Telephone Etiquette skills is on the rise, with the customer service sector growing by approximately 5% annually. By enrolling in this course, you will learn how to prepare for calls, handle difficult situations, and practice best Telephone Etiquette, making you an invaluable asset to any organization. Whether you're looking to improve your personal interactions or seeking career advancement, Telephone Etiquette is a skill that will set you apart. Key Features: CPD Certified Basic Telephone Etiquette Skills Course Free Certificate from Reed CIQ Approved Basic Telephone Etiquette Skills Course Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Telephone Skills Module 02: Preparing for the Call Module 03: Answering Calls Module 04: Conducting a Business Call Module 05: Handling Difficult Situations Module 06: Holding and Transferring Calls Module 07: Ending the Call Module 08: Telephone Etiquette for Customer Service Module 09: Best Practices of Telephone Etiquette Learning Outcomes: Cultivate confident call handling with strategic preparation techniques. Master the art of conducting seamless and impactful business conversations. Navigate and resolve challenging situations with poise and professionalism. Acquire proficiency in the seamless transfer of calls. Enhance your telephone etiquette to provide exceptional customer service. Apply best practices, setting yourself apart as a communication virtuoso. CPD 10 CPD hours / points Accredited by CPD Quality Standards Basic Telephone Etiquette Skills 1:51:23 1: Module 01: Introduction to Telephone Skills Preview 15:27 2: Module 02: Preparing for the Call 08:23 3: Module 03: Answering Calls 12:19 4: Module 04: Conducting a Business Call 11:26 5: Module 05: Handling Difficult Situations 09:24 6: Module 06: Holding and Transferring Calls 11:50 7: Module 07: Ending the Call 09:38 8: Module 08: Telephone Etiquette for Customer Service 19:58 9: Module 09: Best Practices of Telephone Etiquette 11:58 10: Leave A Review 01:00 Who is this course for? This Basic Telephone Etiquette Skills course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Basic Telephone Etiquette Skills. Moreover, this course is ideal for: Professionals seeking to refine their telephone communication skills. Customer service representatives aiming for excellence in phone interactions. Individuals aspiring to enhance their business communication finesse. Team members involved in call handling and transfers. Anyone looking to elevate their overall telephone communication competency. Requirements There are no requirements needed to enrol into this Basic Telephone Etiquette Skills course. We welcome individuals from all backgrounds and levels of experience to enrol into this Basic Telephone Etiquette Skills course. Career path After finishing this Basic Telephone Etiquette Skills course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Basic Telephone Etiquette Skills are: Customer Service Representative - £18K to 25K/year. Receptionist - £16K to 22K/year. Office Administrator - £18K to 24K/year. Call Centre Operator - £17K to 23K/year. Telemarketer - £16K to 20K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

The purpose of this course is to help you start your video marketing agency.

Master DC circuit analysis and troubleshooting with our comprehensive Electrical Engineering course. Learn to analyze series-parallel networks and solve practice problems to become a skilled troubleshooter in the field.

You will learn all the features and settings of a DSLR in this course.

Master Kdenlive video editing with our comprehensive masterclass. Learn everything from basics to advanced techniques and unleash your creativity in video production.

This course at a glance Accredited by CPDQE Know how to treat a collapsed and unconscious pet animal Learn how to perform Cardiopulmonary Resuscitation (CPR) on pets Understand how to recognise the shock in pets and how to respond Identify wound types, learn how to manage the bleeding Get skills to bandage limbs and ears Pet first aid refers to care given to a domestic animal right away before access to professional medical care is available. Pet owners need to be prepared for emergencies because, in an emergency, our animals rely on us. As part of this pet care course, you will learn every aspect of first aid necessary for your pet’s safety when faced with a medical emergency. Our thorough First Aid for Pets course will give you all the necessary knowledge and skills to ensure your pet’s safety. If you’re worried about the well-being of your beloved pet in a dangerous situation, we are here to help. We’ll show you how to take care of wounds, prevent potential illness, and prolong the lives of animals. We’ll teach you how to treat animal bites and stings immediately because they happen frequently. Additionally, we will go over information regarding CPR, shock, bleeding, bandaging, poisoning, fractures when to take what kind of measures, and a lot more! Accredited by This course is CPDQE accredited, which serves as an impactful mechanism for skill enhancement.  Continuing Professional Development (CPD) stands as a crucial, widely acknowledged method that aids individuals, organisations, and entire industries in staying current with their skills and knowledge. CPD not only facilitates the elevation of global standards and benchmarks, aligning with the growing forces of globalisation and consumer expectations but also transforms learning into a deliberate and proactive process. It motivates professionals to uphold a consistently high level of performance and demonstrates their unwavering commitment to a specific job role or profession. Course Curriculum Module 1: Introduction to The Course Module 2: Collapse & Unconsciousness Module 3: Cardiopulmonary Resuscitation Module 4: Shock Module 5: Bleeding Module 6: Bandaging Module 7: Fractures Module 8: Seizures Module 9: Choking & Drowning Module 10: Heat Stroke & Hypothermia Module 11: Burns & Scalds Module 12: Poisoning Module 13: Bites & Stings Module 14: Common Emergencies Module 15: Managing a First Aid Scenario Module 16: Pet First Aid Kit Course Instructor Emma started her career in the UK as a College Lecturer in 1999, specialising in Animal Science and Welfare. She holds a Post-Graduate Certificate of Education and has had several senior management roles, including Director of Faculty. Emma is the Owner and Founder of Duty of Care Pet Services, an Animal Ambulance service covering London and South East England. She appeared on Channel 4’s It’s Me Or The Dog as Britain’s leading dog intelligence expert, and also featured on BBC Radio’s The Barking Hour launching the Pet Alert Scheme. Emma is also a Microchip Implanter. Emma has been writing and delivering online pet related courses to pet owners, students and professionals since 2016. Her passion for promoting animal welfare in education is enhanced in her previous roles as a National Standards Verifier for BTEC Animal Care courses and Training Director for the Hybrid Breeders Association, promoting ethical breeding of dogs.

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

Overview This Develop Amazing Social Skills & Connect With People will unlock your full potential and will show you how to excel in a career in Develop Amazing Social Skills & Connect With People. So upskill now and reach your full potential. Everything you need to get started in Develop Amazing Social Skills & Connect With People is available in this course. Learning and progressing are the hallmarks of personal development. This Develop Amazing Social Skills & Connect With People will quickly teach you the must-have skills needed to start in the relevant industry. In This Develop Amazing Social Skills & Connect With People Course, You Will: Learn strategies to boost your workplace efficiency. Hone your Develop Amazing Social Skills & Connect With People skills to help you advance your career. Acquire a comprehensive understanding of various Develop Amazing Social Skills & Connect With People topics and tips from industry experts. Learn in-demand Develop Amazing Social Skills & Connect With People skills that are in high demand among UK employers, which will help you to kickstart your career. This Develop Amazing Social Skills & Connect With People covers everything you must know to stand against the tough competition in the Develop Amazing Social Skills & Connect With People field.  The future is truly yours to seize with this Develop Amazing Social Skills & Connect With People. Enrol today and complete the course to achieve a Develop Amazing Social Skills & Connect With People certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the Develop Amazing Social Skills & Connect With People can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the Develop Amazing Social Skills & Connect With People, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the Develop Amazing Social Skills & Connect With People, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This Develop Amazing Social Skills & Connect With People is suitable for anyone aspiring to start a career in Develop Amazing Social Skills & Connect With People; even if you are new to this and have no prior knowledge on Develop Amazing Social Skills & Connect With People, this course is going to be very easy for you to understand.  And if you are already working in the Develop Amazing Social Skills & Connect With People field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this Develop Amazing Social Skills & Connect With People is a win-win for you in all aspects.  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 This Develop Amazing Social Skills & Connect With People has no prerequisite.  You don't need any educational qualification or experience to enrol in the Develop Amazing Social Skills & Connect With People. 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 Develop Amazing Social Skills & Connect With People. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Introduction Welcome 00:02:00 Start & Have Powerful First Interactions 3 Best Ways To Always Start A Conversation 00:06:00 What To Say In Social Interactions 00:11:00 Never Run Out Of Things To Say Again! 00:06:00 Winning Mindset For Social Success 00:05:00 Join Group Conversations 00:04:00 Develop Rapport & Connection Fast Connect With People Fast 00:04:00 Make People Like You 00:06:00 Attractive Social Energy 00:08:00 Destroy Your Social Fears Fear Of Approaching People 00:10:00 Fear Of Rejection 00:07:00 Fear Of What People Think Of You 00:07:00 Unleash Your Social Confidence Become Confident in Social Interactions 00:05:00 Become Socially Relaxed & Anxiety Free 00:04:00 Stop Being Shy Socially 00:04:00 Love Yourself 00:02:00 Stop Approval Seeking Behavior 00:04:00 Master The End Of The Interaction Leave A Conversation Politely 00:03:00 Last Impression 00:03:00 Body Language For Social Success Eye Contact 00:07:00 Smiling 00:05:00 Positive & Confident Body Language 00:05:00 Voice 00:03:00 Skills For Social Success Visualization Exercise 00:03:00 Talkative Mood 00:03:00 Your environment 00:05:00