16674 Manager courses

Level 6 Diploma in Health and Social Care Management This fully supported distance learning program is for you if you are looking for your first job or want to grow in your existing health and social care management profession. With our help, take the first significant step toward reaching your full potential now. Our Level 6 Diploma in Health and Social Care Management is designed to help you gain knowledge and basic professional employability skills in these fields. The Level 6 Diploma in Health and Social Care Management course will give information that will support your capacity to operate as successful management in the hospital or social care business. It also provides both theoretical and practical knowledge in health and social care professions. Professionals have designed this Level 6 Diploma in Health and Social Care Management course to help you learn fast and efficiently, at your own speed and convenience. Why Choose Level 6 Diploma in Health and Social Care Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Child Psychology developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Level 6 Diploma in Health and Social Care Management Learning Outcomes After completing this Level 6 Diploma in Health and Social Care Management course, you will be able to: Describe the fundamentals of health and social care management. Describe the concepts and principles of the NHS. Describe care and support planning. Know the importance of Person-centred Care. Develop effective communication and listening skills. Describe the concepts of Equality, Diversity and Rights concerning Health and Social Care. Maintain health and safety regulations. Know about safeguarding in social care. Identify social risk and needs in health care. Certificate of Completion You will receive a course completion certificate for free as soon as you complete the Level 6 Diploma in Health and Social Care Management course. Module 01: A Quick Overview of Health and Social Care 17:06 1: A Quick Overview of Health and Social Care 15:06 2: A Quick Overview of Health and Social Care 02:00 Module 02: Understanding Healthcare 14:20 3: Understanding Healthcare 13:20 4: Understanding Healthcare 01:00 Module 03: Understanding Social Care 18:01 5: Understanding Social Care 16:01 6: Understanding Social Care 02:00 Module 04: The UK Health System 17:12 7: The UK Health System 16:12 8: The UK Health System 01:00 Module 05: Care and Support Planning 13:08 9: Care and Support Planning 10:08 10: Care and Support Planning 03:00 Module 06: Person-Centred Care 20:01 11: Person-Centred Care 17:01 12: Person-Centred Care 03:00 Module 07: Communication in Health and Social care 21:09 13: Communication in Health and Social care 20:09 14: Communication in Health and Social Care 01:00 Module 08: Developing Effective Communication Skills 11:01 15: Developing Effective Communication Skills 08:01 16: Developing Effective Communication Skills 03:00 Module 09: Developing Listening Skills 07:37 17: Developing Listening Skills 05:37 18: Developing Listening Skills 02:00 Module 10: Promotion of Equality, Diversity, and Rights in Health Care Setting 08:41 19: Promotion of Equality, Diversity, and Rights in Health Care Setting 06:41 20: Promotion of Equality, Diversity, and Rights in Health Care Setting 02:00 Module 11: Responsibilities for Health and Safety 13:53 21: Responsibilities for Health and Safety 11:53 22: Responsibilities for Health and Safety 02:00 Module 12: Safeguarding in Social Care 23:19 23: Safeguarding in Social Care 21:19 24: Safeguarding in Social Care 02:00 Module 13:Identifying Social Risk and Needs in Health Care 25:28 25: Identifying Social Risk and Needs in Health Care 23:28 26: Identifying Social Risk and Needs in Health Care 02:00 Who is this course for? Level 6 Diploma in Health and Social Care Management The Level 6 Diploma in Health and Social Care Management has been professionally designed for motivated learners who want to learn the latest industry-specific information on health and social care management. Requirements Level 6 Diploma in Health and Social Care Management There are no specific requirements for this Level 6 Diploma in Health and Social Care Management because it does not require any advanced knowledge or skills. Students who intend to enrol in this Level 6 Diploma in Health and Social Care Management course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Level 6 Diploma in Health and Social Care Management Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Course Overview The Hospitality Management Level 5 course offers a comprehensive insight into the dynamic and fast-paced world of hospitality. Designed to build a strong foundation in management practices, service excellence, and operational efficiency, the course equips learners with the knowledge and leadership skills required for success in the industry. Covering critical areas such as front office operations, food and beverage management, customer satisfaction, and marketing in travel and tourism, it ensures a well-rounded understanding of hospitality business functions. The curriculum also embraces modern developments such as e-hospitality and the use of technology in operations. Upon completion, learners will have developed key competencies in managing service quality, human resources, and financial aspects of hospitality enterprises. This qualification is ideal for those seeking career progression or wishing to enter this vibrant sector, offering valuable insights into creating memorable guest experiences and efficient business practices within hotels, resorts, and related hospitality organisations. Course Description The Hospitality Management Level 5 course delves deeper into the essential principles, operational challenges, and strategic approaches within the hospitality sector. Learners will explore the structure and evolution of the hotel industry, the importance of efficient recruitment and training processes, and the management of core areas including front office, housekeeping, food and beverage, and security operations. In addition, the programme highlights the significance of customer satisfaction, quality service delivery, marketing strategies, and financial management within hospitality environments. Contemporary topics such as e-hospitality and technology adoption are also integrated to reflect current industry trends. Throughout the course, participants will gain valuable knowledge, analytical capabilities, and management techniques that are crucial for sustaining high service standards and fostering business growth. The course structure is designed to cater to a wide range of learners, providing the flexibility to support both career advancement and entry into this dynamic field. Course Modules Module 01: Introduction to Hospitality Management Module 02: An Overview of Hotel Industry Module 03: The Process of Selection and Recruitment in Hospitality Industry Module 04: The Process of Development and Training in Hospitality Industry Module 05: Management of Front Office Operations Module 06: Management of Housekeeping, Engineering and Security Operations Module 07: Management of Food and Beverage Operations Module 08: Management of Service Quality in Hospitality Industry Module 09: Marketing in Travel and Tourism Business Module 10: Accounting in Hospitality Industry Module 11: Customer Satisfaction Module 12: E-Hospitality and Technology (See full curriculum) Who is this course for? Individuals seeking to start a career in hospitality management. Professionals aiming to enhance their expertise in hospitality leadership and operations. Beginners with an interest in the hospitality and tourism industries. Entrepreneurs planning to launch or manage hospitality ventures. Employees wishing to transition into supervisory or management roles within hospitality. Career Path Hotel Manager Front Office Manager Food and Beverage Manager Guest Relations Manager Hospitality Operations Manager Housekeeping Manager Resort Manager Travel and Tourism Consultant Event Coordinator within Hospitality Industry Hospitality and Tourism Marketing Executive

Course Overview Learn the Latest Skills | Acknowledged by CPD | MCQ Based Exam & Tutor Support | Interactive Video Training  Building surveying is one of the broadest areas of surveying practice and includes a variety of occupations. You will be required to provide a range of services linked to building upkeep and maintenance, including building design, renovation, or alteration, as well as other property and construction-related tasks. Therefore, in order to exhibit your proficiency in building surveying practice, it's imperative that you comprehend essential knowledge of construction technology, contracts, and building pathology. The fundamentals of contract administration, construction and environmental services, design and specification, inspection, and legal and regulatory compliance are topics covered in our course. Training in these key areas will furnish you with important knowledge and techniques for this multi-disciplined industry and will give you a practical skill set with which to implement key building surveying techniques. What Will You Learn? Introduction to building survey Learn about building information modelling and technology Understand work breakdown structure Reporting various aspects of the building sites All the legal aspects of building survey What classes are included in this package? Earn a digital Certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This Construction Surveyor course has been designed to train those individuals who work as Building Surveyors or are preparing to do so. It may also benefit comparable roles in the construction industry. Career Path Training offered by the Construction Surveyor could potentially benefit a range of roles but would particularly enhance careers in: Surveyor Contractor Civil Engineer Project Manager Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessments Assignment Certificate of Achievements from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Method of Assessment On successful completion of the Construction Surveyor, you will be required to sit an online multiple-choice assessment. You will need to score 60% or above to pass the course. 

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Overview of Office Administration With over 4 million people working in administrative roles, office administration is a growing field full of opportunities in the UK. This office administration course equips you with the essential skills like time management, business writing, communication, and organisation needed to thrive as an administrative professional. You'll gain practical insights into managing office tasks, interacting with staff and clients, and problem-solving issues that arise. With dedicated modules on skills like writing, communication, and stress management, this comprehensive course readies you for diverse administrative and secretarial jobs across sectors.  Invest in your potential. Become the backbone of success. Enrol today and unlock the thriving world of Office Administration in the UK! Get a Quick Look at The Course Content: This Office Administration Course will help you to learn: Employ advanced communication skills to thrive in any business environment. Implement organisational strategies to ensure efficiency and productivity. Master negotiation techniques to secure advantageous outcomes. Manage stress effectively to maintain a healthy work-life balance. Develop leadership qualities to excel in your chosen career path. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Office Administration. 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 Certificate of Completion - Digital / PDF Certificate After completing the Office Administration course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals seeking a rewarding career in Office Administration. Existing professionals looking to refine their skills and climb the ladder. Business owners are eager to empower their teams with essential administrative expertise. Anyone seeking to enhance their organisational and communication skills for personal growth. Requirements You don't need any educational qualification or experience to enrol in the Office Administration 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 This UK-focused Office Administration course paves the way for a diverse range of rewarding careers, including: Executive Assistant - £32,000 to £48,000/year. Office Manager - £18,000 to £38,000/year. Sales Administrator - £17,000 to £28,000/year. Receptionist - £16,000 to £24,000/year. Customer Service Advisor - £18,000 to £26,000/year. Course Curriculum Office Administration Module 1: Introduction to Office Administration 00:17:00 Module 2: Skills of an Effective Administrator 00:18:00 Module 3: Business Writing Skills 00:39:00 Module 4: Communication Skills 00:27:00 Module 5: Managing Meetings and Giving Feedback 01:29:00 Module 6: Organisational Skills 01:18:00 Module 7: Telephone Etiquette 01:09:00 Module 8: Negotiation Techniques 00:18:00 Module 9: Conflict Management 00:16:00 Module 10: Stress Management 00:18:00 Module 11: Time Management 00:39:00 Assignment Assignment - Office Administration 00:00:00

Do you want to improve your customer service skills & want to make your customers happy? Do you want to exceed customer expectations and want to create clients who spread words about your business? If yes, then enrol now and benefit from this course. Description: This Customer Service course teaches the basics of customer service and translates that knowledge into practical application. Students will come away from this customer service course knowing how a positive attitude, going a step beyond basic customer service, and dealing effectively with complaints will enhance their work experience. Students will learn the difference between internal and external customers and will find out how the development and implementation of a comprehensive customer service policy promote consistency in how customers are treated and keep customers happy. Who is the course for? Individuals who have any interaction with customers in any business. People who want to take their customer service skills to the next level. Students. Job seekers. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Level 2 Certificate in Customer Service is a useful qualification to possess, and would be beneficial for the following professionals: Administrative Receptionist. Assistant Office Manager. Call Center Customer Service Representative. Call Center Representative. Call Center Supervisor. Customer Care Representative. Customer Service Administrative Assistant. Customer Service Agent. Customer Service Analyst. Customer Service Assistant. Customer Service Associate. Customer Service Introduction To Customer Service 00:15:00 The Power of Positive Thinking in Customer Service 00:30:00 Types of Difficult Customers and How to Help them 01:00:00 How to Deal with Difficult Customers 00:30:00 Conclusion 00:15:00 Customer Service Basics Customer Service and Retention Templates 01:00:00 Customer Service & Retention Checklist 01:00:00 Customer Service Checklist 01:00:00 Customer Service Skills First Lesson 00:30:00 Second Lesson 01:00:00 Third Lesson 00:30:00 Fourth Lesson 00:30:00 Fifth Lesson 01:00:00 Microsoft Word Module One - Getting Started 00:30:00 Module Two - Opening 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Sharing Your Document 01:00:00 Module Twelve - Wrapping Up 00:30:00 Microsoft Excel Module One - Getting Started 00:30:00 Module Two - Opening Excel 01:00:00 Module Three - Working with the Interface 01:00:00 Module Four - Your First Worksheet 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Building Formulas 01:00:00 Module Seven - Using Excel Functions 01:00:00 Module Eight - Using Quick Analysis 01:00:00 Module Nine - Formatting Your Data 01:00:00 Module Ten - Using Styles, Themes, and Effects 01:00:00 Module Eleven - Printing and Sharing Your Workbook 01:00:00 Module Twelve - Wrapping Up 01:00:00 Mock Exam Mock Exam- Certificate in Customer Service 00:30:00 Final Exam Final Exam- Certificate in Customer Service 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview To create interactive and effective web applications, JavaScript is one of the first choices for developers. Learn how you can use JavaScript and node.js to make your website more interactive and entertaining from this Learn Node.JS Framework in 2021 course and boost and update your programming skill. The Learn Node.JS Framework in 2021 course will teach you the steps of creating websites using JavaScript from scratch. You will familiarize yourself with the concepts of JavaScript and node.js, how node.js works and its beauty. You will learn about node package manager, asynchronous JavaScript and promises, event emitter, file system, creating a path and many other functions that node.js offers. This course will also help you to create a strong authentication and verification system so that you can secure your website from common threats and get notifications if there is any problem. This course is helpful to learn web development and will assist you to increase your skill in no time. Learning Outcomes Familiarize with node.js basics Be able to create API development Understand the basics of asynchronous JavaScript Learn how to create a login system and password hashing Be able to secure your device using user verification, data validation and email verification using node.js Learn in detail about authentication and authorization system Who is this course for? This course is ideal for anyone who wants to learn web designing or web development and use JavaScript to design their websites. This course will help you to understand the functions of JavaScript and node.js and how to design websites from scratch. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Learn Node.JS Framework in 2021 is a useful qualification to possess and would be beneficial for any related profession or industry such as: JavaScript Developers Web Developers App Developers Software Engineers Programmers Unit 01: Introduction Module 01: Introduction 00:02:00 Unit 02: Node.js Basics Module 01: Introduction 00:01:00 Module 02: What's & Why Node.js? 00:07:00 Module 03: Installation 00:01:00 Module 04: First Node.js app 00:12:00 Module 05: Mechanism of Node.js 00:07:00 Module 06: Event Loop 00:09:00 Module 07: Loop tick 00:04:00 Module 08: Modules 00:07:00 Unit 03: Asynchronous JavaScript Module 01: Introduction 00:01:00 Module 02: JSON format 00:03:00 Module 03: Callback pattern 1 00:05:00 Module 04: Callback pattern 2 00:03:00 Module 05: Callback hell 00:01:00 Module 06: Promises pattern 1 00:02:00 Module 07: Promises pattern 2 00:02:00 Module 08: Master promises 1 00:03:00 Module 09: Master promises 2 00:05:00 Module 10: async/await pattern 1 00:02:00 Module 11: async/await pattern 2 00:02:00 Module 12: Promisify a function 00:03:00 Unit 04: Core Modules Module 01: Introduction 00:01:00 Module 02: Event emitter I 00:03:00 Module 03: Event emitter II 00:02:00 Module 04: Event emitter III 00:03:00 Module 05: File system I 00:02:00 Module 06: File system II 00:01:00 Module 07: File system III 00:04:00 Module 08: Streams I 00:03:00 Module 09: Streams II 00:02:00 Module 10: Path I 00:02:00 Module 11: Path II 00:02:00 Module 12: Path III 00:02:00 Unit 05: npm Module 01: Introduction 00:01:00 Module 02: package.json file 00:01:00 Module 03: Commands I 00:02:00 Module 04: Commands II 00:03:00 Module 05: Commands III 00:04:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Grateful Leadership (In-Person) Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model TRUE acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?

Grateful Leadership: In-House Training Effective leaders must find ways to enhance people's level of engagement, commitment, and support, especially during the difficult periods of time that all organizations may face. Grateful leaders can tap into the power of personal commitment and dedication by acknowledging people in an authentic and heartfelt manner. Those leaders who model true acknowledgment behavior will inspire others to do the same and to want to dramatically increase their levels of contribution to the organization, making the power of acknowledgment transformational. What you will Learn You'll learn how to: Understand and develop the capability to act upon the need for Grateful Leadership to create a culture of appreciation in the workplace Understand the potentially huge benefits of Grateful Leadership in the workplace Overcome the barriers to using acknowledgment Demonstrate the language and subtleties of authentic and heartfelt acknowledgement behavior Describe the Seven Principles of Acknowledgment for 'High-Interest Benefits' in the context of participant's personal leadership style Describe how to coach teams, managers, and other corporate stakeholders in using Grateful Leadership to produce breakthrough results Getting Started Introductions Course goals and objectives Introspection on the practice of Grateful Leadership The Workforce Engagement Sustainability Challenge Employees who are engaged, not engaged, and actively disengaged The costs of non-engagement Meeting the workforce engagement challenge Acknowledgment, Engagement, and Leadership Acknowledgment and its benefits Recognition versus acknowledgment 'Challenging people' case study Blanchard, Covey, Keith (Servant Leadership): how acknowledgment fits into these leadership models Leadership and acknowledgment The 5 C's - Consciousness, Courage, Choice, Communication, Commitment Employing the Power of Acknowledgment Overcoming barriers to acknowledgment The Seven High-Interest Benefits Principles of Acknowledgment Exploring the acknowledgment process Applying the Principles of Acknowledgment within the Context of Your Personal Leadership Style Case study The ROI of Grateful Leadership Creating your Grateful Leadership Personal Action Plan™ Creating a Vision Statement for your organization that incorporates Grateful Leadership into your corporate culture The 360° Grateful Leadership Competency Assessment Summary What did we learn, and how can we implement this in our work environments?

If you are looking forward to advance your skills with Microsoft Excel 2016 and want to learn more advanced skills or want to learn the topics covered in this course in the 2016 interface, this Excel 2016 Advanced will be the perfect choice for you! Through the course you will gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. Additionally, you will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in your worksheets and workbooks. You will also learn about Excel's many collaboration features, as well as how to import and export data to and from your workbooks. What Will I Learn? Use Advanced IF Statements Use Advanced Lookup Functions Use Complex Logical and Text Functions Auditing Formulas Working with What-If Analysis Tools Protecting Worksheet and Workbook Use Advanced PivotTables and PowerPivot Tools Automate with Macros Work with Form Controls Ensure Data Integrity Collaborate in Excel Import and Export Data to a Text File Requirements Excel Introduction and Intermediate courses or equivalent experience. Who is the target audience? Students who want to expand their Excel knowledge. Introduction Introduction FREE 00:01:00 Using Advanced IF Statements Summarize Data with SUMIF FREE 00:04:00 Summarize Data with AVERAGIF 00:03:00 Summarize Data with COUNTIF 00:02:00 Using Advanced Lookup Functions Using VLOOKUP with TRUE to find an Approximate Match 00:04:00 Using HLOOKUP TRUE to find an Approximate Match 00:01:00 Using the Index Function 00:03:00 Using the Match Function 00:02:00 Creating a Combined Index and Match Formula 00:04:00 Comparing Two Lists with VLOOKUP 00:02:00 Comparing Two Lists with VLOOKUP and ISNA 00:04:00 Using Complex Logical and Text Functions Creating a Nested IF Function 00:03:00 Using the IFERROR Function 00:02:00 Using the LEN Function 00:02:00 Using the TRIM Function 00:01:00 Using the Substitute Function 00:02:00 Formula Auditing Showing Formulas 00:01:00 Tracing Cell Precedents and Dependents 00:03:00 Adding a watch Window 00:02:00 Error Checking 00:02:00 What-If Analysis Tools Using the Scenario Manager 00:03:00 Using Goal Seek 00:02:00 Analyzing with Data Tables 00:02:00 Worksheet and Workbook Protection Protection Overview 00:02:00 Excel File Password Encryption 00:03:00 Allowing Specific Worksheet Changes 00:01:00 Adding Protection to only Certain Cells in a Worksheet 00:03:00 Additional Protection Features 00:02:00 Advanced Use of PivotTables and PowerPivot Using the Pivot Tables Charts Wizard 00:02:00 Adding a Calculated Field 00:02:00 Adding a Caculated Item 00:02:00 Apply Conditional Formatting to a Pivot Table 00:03:00 Using Filters in the Pivot Table Fields Pane 00:02:00 Creating Filter Pages for a Pivot Table 00:01:00 Enabling a Power Pivot Add In 00:04:00 Automating with Macros What are Macros 00:03:00 Displaying the Developer Tab and Enabling Macros in Excel 00:03:00 Creating a Basic Formatting Macro 00:03:00 Running a Macro 00:02:00 Assigning a Macro to a Button 00:02:00 Creating a More Complex Macro 00:02:00 Viewing and Editing the VBA Code for an Existing Macro 00:03:00 Adding a Macro to the Quick Access Toolbar 00:02:00 Working with Form Controls What are Form Controls 00:02:00 Adding Spin Buttons and Check Boxes to a Spreadsheet 00:02:00 Adding a Combo Box to a Spreadsheet 00:02:00 Ensuring Data Integrity What is Data Validation 00:01:00 Restricting Data Entries to Whole Numbers 00:02:00 Data Validation Restricting Data Entry to a List 00:01:00 Data Validation Restricting Data Entry to a Date 00:01:00 Data Validation Restricting Data Entry to Different Text Lengths 00:01:00 Composing Input Messages 00:02:00 Composing Error Alters 00:02:00 Finding Invalid Data 00:02:00 Editing and Deleting Data Validation Rules 00:01:00 Collaborating in Excel Working with Comments 00:03:00 Printing Comments and Errors 00:02:00 Sharing a Workbook 00:03:00 Tracking Changes in a Workbook 00:03:00 Working with Versions 00:02:00 Sharing Files via Email 00:02:00 Importing and Exporting Data to a Text File Importing a Text File 00:03:00 Exporting a Text File 00:01:00 Conclusion Course Recap 00:01:00 Course Certification