1059 Courses delivered Online

Are you aspiring to become a team leader? If you want to know how to become an effective leader through conducting team building, then this course will be perfect for you and your team members! Description: You have the potential to become a leader and in this course, you will learn the skills to unleash your potential to become an inspiring team leader. You realise that your employees or team members are the most crucial factor in your business or company. You need to have the right skills to teach them how to develop for the company's success, and this course will train you in that. You will learn that team building is a solid way to help your team become closer which will result in more effective and efficient outputs. In this course, you will be able to hire and recruits employees and have them trained to unleash their creativity. Who is the course for? For employees who are aiming for a promotion, joining a team leader role for the first time or looking forward to becoming a top executive. Or anyone who is interested in becoming a team leader. 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 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: The Advanced Team Building Course will be useful and beneficial for the management positions, specifically the following careers: Administrative Services Manager Advertising, Promotions and Marketing Managers Agricultural Managers Architectural and Engineering Managers Compensation and Benefits Managers Computer and Information Systems Manager Construction Managers Financial Managers Food Services Managers Human Resources Managers Industrial Production Managers Management Directors Medical and Health Managers Natural Sciences Managers Top Executives. Team Building Introduction To Team Building 00:30:00 Effective Use Of Online Tools 00:15:00 Celebrate Your Commitment In Style 00:30:00 Empower Your Team To Innovate and Execute 00:30:00 Always Motivate Your Team 00:30:00 Keeping Up To Date On Your Own Training 00:15:00 Always Support And Train Your Team 00:30:00 Benefits Of Building A Good Team 00:15:00 Wrapping Up 00:15:00 Building Effective Teams Defining Teams 00:15:00 Establishing Team Norms 00:15:00 Working as a Team 00:15:00 Your Team Player Type 01:00:00 Building Team Trust 00:15:00 The Stages of Team Development 00:30:00 Communication 00:30:00 Becoming a Good Team Player 00:15:00 Mock Exam Mock Exam-Advanced Team Building Course 00:20:00 Final Exam Final Exam-Advanced Team Building Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about HR management or human resources management Understand the core competencies and principles of HR management or human resources management Explore the various areas of HR management or human resources management Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert HR manager or human resources manager Human Resources Management and Development Training Program - Part 2 Course Master the skills you need to propel your career forward in HR management or human resources management. This course will equip you with the essential knowledge and skillset that will make you a confident HR manager or human resources manager and take your career to the next level. This comprehensive human resources course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this human resources course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective HR management or human resources management practice and equip you with the essential skills, confidence and competence to assist you in the HR management or human resources management industry. You'll gain a solid understanding of the core competencies required to drive a successful career in HR management or human resources management. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for HR manager or human resources manager or for people who are aspiring to specialise in HR management or human resources management. Enrol in this human resources course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive human resources course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this HR management or human resources management can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This human resources course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This human resources course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Training and Development Welcome Back - Part 2 Starts Here 00:01:00 The Main Tasks of a Trainer 00:01:00 The Induction Training 00:01:00 The Administrative Tasks of a Trainer and Managing Feedback 00:01:00 The Training Library and The List of Courses That The Trainer Manages 00:01:00 The List of Skills and The Competency Assessments 00:01:00 Internal and External Cours 00:01:00 Training Procedures, Reporting and Communication 00:02:00 Employee Administration What Do Administration HR Specialists Do 00:01:00 What Should a Labor Contract Include 00:03:00 Occupational Medicine and Labor Protection 00:02:00 What Documents Does The Personnel File Include 00:02:00 Keeping Staff Files, Data Confidentiality, Documents Issues to Employees 00:01:00 External Service Providers and Reporting 00:02:00 Performance Evaluation What Is Performance Evaluation And Why Is It Useful 00:01:00 Giving the Employees Objectives 00:01:00 Ways / Tools for Conducting the Evaluation Process and People Involved 00:02:00 What Are the Results Used for and How Often Is It Recommended 00:01:00 Relationship With the Training Department 00:01:00 Evaluation Procedures and Activities Carried Out by HR 00:01:00 Employee Motivation Employees Engagement Questionnaire 00:01:00 Questionnaire Results 00:01:00 The Action Plan 00:01:00 Financial Motivation 00:01:00 Non-financial Motivation 00:01:00 The Exit Interview 00:01:00 Communication The Role of the Communication Specialist 00:01:00 Regular Communications 00:01:00 HR Communication Procedures 00:02:00 Organizing Team Outings 00:01:00 Meetings with Employees 00:01:00 See You in Part 3 00:01:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 3 hours 56 minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about functional skills ICT Understand the core competencies and principles of functional skills ICT Explore the various areas of functional skills ICT Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert functional skills ICT teacher IT Troubleshooting Training Advanced for Desktop Support Professional Course Master the skills you need to propel your career forward in functional skills ICT. This course will equip you with the essential knowledge and skillset that will make you a confident functional skills ICT teacher and take your career to the next level. This comprehensive IT troubleshooting training course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this IT troubleshooting training course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective functional skills ICT practice and equip you with the essential skills, confidence and competence to assist you in the functional skills ICT industry. You'll gain a solid understanding of the core competencies required to drive a successful career in functional skills ICT. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for functional skills ICT teacher or for people who are aspiring to specialise in functional skills ICT. Enrol in this IT troubleshooting training course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive IT troubleshooting training course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this functional skills ICT can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This IT troubleshooting training course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This IT troubleshooting training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This IT troubleshooting training course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Course Introduction Course Introduction 00:00:00 Prepare Virtual Test Lab Install Hyper-V on Local System 00:02:00 Create Virtual Machine (VM) 00:02:00 Download Free Evaluation Windows 10 Image 00:02:00 Installing Windows OS With Multiple Media Installing Windows 10 00:06:00 Make USB Bootable with GUI Tool 00:07:00 Make USB Bootable with Command (CLI Tool) 00:05:00 Access Boot Menu 00:03:00 Hyper-V Interface Overview 00:05:00 Increase Disk and Memory of Virtual Machine 00:07:00 Use of Snapshot (Time Saving) 00:03:00 System Troubleshooting without Reboot Fix Stuck Windows Service 00:11:00 Fix 'Not Responding' Application or Desktop Error 00:03:00 Logoff Another User from Local System 00:03:00 Logoff user Remotely through PowerShell 00:02:00 Delay in Replication of Assigned Permission on Client 00:03:00 Fix Domain Trust issue without Re-joining & Reboot 00:05:00 Find & Kill High Utilization Process 00:02:00 Optimize System Performance (Fix Slowness Issue) Monitor CPU, Memory & HDD Utilization (Task Manager & Resource Monitor) 00:06:00 Find & Kill High Utilization Process 00:02:00 Check Recently System Uptime and Reboot 00:03:00 Uninstall Unwanted Applications 00:03:00 Run Disk Cleanup (Remove Not Required System Files) 00:06:00 Deep Cleaning Through TreeSize Free Tool 00:06:00 Disable Startup Applications (Speed Up Booting Time) 00:02:00 Disable Unwanted Startup Services (MSCONFIG) 00:03:00 Active Directory Server Setup (Optional) Module Introduction 00:02:00 Create Virtual Machine for Server 2019 00:02:00 Install Windows Server 2019 00:03:00 Rename System Name 00:02:00 Server Manager Introduction 00:02:00 Install Active Directory Role 00:03:00 Promote Active Directory Domain Controller 00:06:00 Set Static IP Address 00:02:00 Active Directory Introduction Active Directory Users and Computers (ADUC) 00:04:00 Active Directory Administrative Center (ADAC) 00:03:00 Create Active Directory User 00:06:00 Join System in Active Directory Domain 00:04:00 Computer Account Introduction & Solution 00:05:00 Info about Default Quota for Rejoining System 00:02:00 Check Password Expiration and Account Status 00:02:00 File System Related Troubleshooting Recycle Bin Settings 00:02:00 Cleanup Recycle Bin Data of Multiple Users Profile (Advance) 00:08:00 Close Locked Open Files on File Server 00:06:00 How To Fix Filename Is Too Long Issue 00:04:00 Supplementary Resources Supplementary Resources - Advance IT Troubleshooting for Desktop Support Professional 00:00:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Course Overview Every office needs someone who can carry out the administrative duties effectively and also represent the company in the best possible way. For this reason, proficient office admins and receptionists are always in high demand. If you are looking for a promising job, then this could be your call. The Admin, Secretarial & PA - Level 7 course will help you pursue a career in this field.  In the Admin, Secretarial & PA - Level 7 course, you will learn the core skills required to become an office admin. Through this course, you will get introduced to business etiquette. The easy-to-follow modules will teach you business writing, communication and organisation skills. You will become skilled in providing quality customer services. In addition, the course will provide you with effective tips for planning and scheduling.  After completing the course, you will receive a certificate of achievement. This certificate will elevate your resume and boost your employability in this promising sector. Enrol now! Learning Outcomes of Admin, Secretarial & PA - Level 7 Familiarise with the key skills required for office administration Learn different business etiquette Develop the skills to organise meetings and conferences Improve your business writing, communication and organisation skills Build the expertise to provide quality customer service Pick up the effective planning and scheduling strategies Who is this Course for? The Admin, Secretarial & PA - Level 7 course is perfect for those who want to pursue a career in the relevant fields. This course will also be beneficial for those already working in this area.  Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the 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 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 The Admin, Secretarial & PA - Level 7 course will be beneficial for any related profession or industry, such as: Office Admin Secretarial Personal Assistant Receptionist Module 01 - Introduction to Personal Assistant & Admin Support Assistant Introduction to Office Administration 00:17:00 Module 02 - Introduction to Office Administration Introduction to Office Administration 00:17:00 Module 03 - Skills of an Effective Administrator Skills of an Effective Administrator 00:18:00 Module 04 - Introduction to Reception and Receptionist Introduction to Reception and Receptionist 00:29:00 Module 05 - Business Telephone Skills Business Telephone Skills 00:21:00 Module 06 - Representing Your Boss and Company Representing Your Boss and Company 00:25:00 Module 07 - Business Etiquette Business Etiquette 00:19:00 Module 08 - Mail Services and Shipping Mail Services and Shipping 00:26:00 Module 09 - Travel Arrangements Travel Arrangements 00:22:00 Module 10 - Organising Meeting and Conferences Organising Meeting and Conferences 00:19:00 Module 11 - Diary Management and Note taking Diary Management and Note taking 00:21:00 Module 12 - Time Management Time Management 00:25:00 Module 13 - Record Keeping and Filing Systems Record Keeping and Filing Systems 00:24:00 Module 14 - Business Writing Skills Business Writing Skills 00:25:00 Module 15 - Organisational Skills Organisational Skills 00:19:00 Module 16 - Communication Skills Communication Skills 00:19:00 Module 17- Customer Service Customer Service 00:22:00 Module 18- Effective Planning and Scheduling Effective Planning and Scheduling 00:39:00 Module 19 - Invoicing/Petty Cash Invoicing/Petty Cash 00:20:00 Assignment Assignment - Admin, Secretarial & PA - Level 7 03:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

With the global financial markets in such turmoil, many people are looking for security in ways they may not have considered previously. This Start Up and Grow Your Own Business course is designed for students who want to learn the skills and knowledge required to develop a business start-up. It is crucial that you create an effective plan that will allow you to test your product or service and make any necessary changes and improvements. It all starts with developing a successful business idea. This Start Up and Grow Your Own Business course comprises several modules that will look into a different aspects of this subject. It will provide learners with an understanding of the initial processes and requirements of a Start Up, as well as knowledge of the first steps in Start Up, including marketing, legal, and financial requirements, as well as an understanding of how to write a business plan. Learning Outcomes After completing this Start Up and Grow Your Own Business course, you will be able to: Understand the steps for a business start-up. Understand what is required of you to start your own business. Polish your business idea. Build your competitive advantages. Increase self-awareness and aid personal development. Develop a Start-up Business Plan. Why Choose Business START UP Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course 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. Other courses are included with Start Up and Grow Your Own Business Bundle Course Course 01: Start Up and Grow Your Own Business Course 02: Level 7 Diploma in Operations Management Course 03: Level 7 Diploma in Facilities Management Course Course 04: Level 5 Diploma in Business Analysis Course 05: Level 5 Diploma in Risk Management Course Course 06: Level 2 Diploma in Business Administration Course 07: Level 7 Diploma in Leadership and Management Course ***Others Included in this Bundle Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] ***Start Up and Grow Your Own Business*** Detailed course curriculum Module 1: Fundamental Steps for a Business Start-up Basic Requirements of an Entrepreneur Identify the Type and Field of Business that is More Suitable for You Identify Your Skills and Creativity Related to New Business Opportunities Analyse the Commercial Potential of a Business Opportunity Module 2: Strategic Thinking about New Business Solving a Problem Beating the Deadlines Finding Products in Short Supply Opportunities Created by News or Events Investigating the Internet Thinking Start-to-finish Niche Strategies Demographic Trends Rethink Assumptions Module 3: The Best Business Ideas for You Case Study Screen Your Ideas List Field Study SWOT Analysis Module 4: Developing a Start-up Business Plan Introduction of Start-up Business Plan Executive Summary Company Description Products & Services Marketing Plan Operational Plan Management & Organisation Startup Expenses & Capitalization Financial Plan -------------- ***Level 5 Diploma in Business Analysis*** Module 01: What is a Business Analyst? Module 02: What Makes a Good Business Analyst? Module 03: Roles of the Business Analyst Module 04: The Business Analyst and the Solution Team Module 05: Define the Problem Module 06: Vision Phase Module 07: Process Phase - Gather The Information Module 08: Process Phase - Determine the Solution Module 09: Process Phase - Write the Solution Document Module 10: Production Phase - Producing the Product Module 11: Production Phase - Monitor the Product Module 12: Confirmation Stage -------------- ***Level 7 Diploma in Facilities Management Course*** Module 01: Introduction to Facilities Management Module 02: Developing a Strategy for Facilities Management Module 03: Facilities Planning Module 04: Managing Office WorkSpace Module 05: Vendor Management & Outsourcing Module 06: Managing Change Module 07: Managing Human Resources Module 08: Managing Risk Module 09: Facilities Management Service Providers Module 10: Managing Specialist Services Module 11: Public-Private Partnerships and Facilities Management Module 12: Health, Safety, Environment and UK Law -------------- ***Level 7 Diploma in Operations Management*** Module 01: Understanding Operations Management Module 02: Understanding Process Management Module 03: Understanding Supply Chain Management Module 04: Understanding Planning & Sourcing Operations Module 05: Understanding Talent Management Module 06: Understanding Procurement Operations Module 07: Understanding Manufacturing and Service Operations Module 08: Understanding Succession Planning Module 09: Understanding Project Management Module 10: Understanding Quality Control Module 11: Understanding Product and Service Innovation Module 12: Understanding Communication Skills Module 13: Understanding Negotiation Techniques Module 14: Understanding Change Management Module 15: Understanding Maintenance Management Module 16: Understanding Conflict Management Module 17: Understanding Stress Management Module 18: Understanding Business Ethics for the Office Module 19: Understanding Business Etiquette Module 20: Understanding Risk Management -------------- ***Level 5 Diploma in Risk Management Course*** Module 01: A Quick Overview of Risk Management Module 02: Risk and its Types Module 03: Others Types of Risks and its Sources Module 04: Risk Management Standards Module 05: Enterprise Risk Management Module 06: Process of the Risk Management Module 07: Risk Assessment Module 08: Risk Analysis Module 09: Financial Risk Management Module 10: The Basics of Managing Operational Risks Module 11: Technology Risk Management Module 12: Project Risk Management Module 13: Legal Risk Management Module 14: Managing Social and Market Risk Module 15: Workplace Risk Assessment Module 16: Risk Control Techniques Module 17: Ins and Outs of Risk Management Plan -------------- ***Level 2 Diploma in Business Administration*** Module 01: Communication in a Business Environment Module 02: Principles of Providing Administrative Services Module 03: Principles of Business Document Production and Information Management Module 04: Understand Employer Organisations Module 05: Manage Personal Performance and Development Module 06: Develop Working Relationships with Colleagues Module 07: Manage Diary Systems Module 08: Produce Business Documents Module 09: Health and Safety in a Business Environment Module 10: Handle Mail Module 11: Principles of Digital Marketing Module 12: Administer Finance Module 13: Understand Working in a Customer Service Environment Module 14: Principles of Team Leading Module 15: Principles of Equality and Diversity in the Workplace Module 16: Exploring Social Media Module 17: Understand the Safe Use of Online and Social Media Platforms -------------- ***Level 7 Diploma in Leadership and Management Course*** Module 1: Understanding Management and Leadership Module 2: Leadership over Yourself Module 3: Creativity and Innovation Module 4: Leadership and Teambuilding Module 5: Motivation and People Management Module 6: Communication and Leadership Module 7: Presentation, One-to-one Interview and Meeting Management Module 8: Talent Management Module 09: Strategic Leadership Module 10: Stress Management -------------- Assessment Method After completing each module of the Start Up and Grow Your Own Business, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Start Up and Grow Your Own Business This course is ideal for anyone who wants to start up his own business. Requirements Start Up and Grow Your Own Business There are no specific requirements for this Start Up and Grow Your Own Business course because it does not require any advanced knowledge or skills. Students who intend to enrol in this 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 Start Up and Grow Your Own Business Upon successful completion of this course, you may choose to become a: Business Owner Entrepreneur Business Analyst Business and Enterprise Advisor Business Development Executive Certificates Certificate of completion Digital certificate - Included

Learn how to become the best leader you could ever be with this Certificate Course in HR and Leadership Management! Description: What we offer is a high-quality Certificate Course designed to equip managers and potential leaders with necessary skills to be the best in the field. This course will also help you to discover new, innovative sources of opportunities to develop HR and Leadership management skills. Furthermore, it will help you enhance your general management and leadership skills for you to become an effective and efficient leader in your chosen industry. With this certificate course, you will be equipped with great information on leadership skills as we will help you learn, step by step, through the exact process that developed to help people put an end to the struggles to become a leader. This course will surely provide you with all the necessary knowledge and skills you need to have to achieve your career goals and become a successful leader! Who is the course for? For employees who are aiming for a promotion, joining a team leader role for the first time or looking forward to becoming a top executive. Or anyone who are interested in improving and honing their leadership potential Entry Requirement: This course is available to all learners, of all academic backgrounds. However, it's more advantageous if you have an experience in management or in a supervisory role. Learners should be ages 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: A Certificate Course in HR and Leadership Management will be useful and would be beneficial for the management occupations especially the following careers: General Manager Director Human Resources ManagersOperation Manager Supervisor Administrative Services Manager Management Directors And other Top Executives Certificate Course in HR and Leadership Management - Updated Version HR Management Introduction to Human Resources 00:20:00 Employee Recruitment and Selection Procedure 00:35:00 Employee Training and Development Process 00:24:00 Performance Appraisal Management 00:22:00 Employee Relations 00:19:00 Motivation and Counselling 00:22:00 Ensuring Health and Safety at the Workplace 00:19:00 Employee Termination 00:18:00 Employer Records and Statistics 00:17:00 Essential UK Employment Law 00:30:00 Leadership Management Module 01: Developing the Leader Within You 00:21:00 Module 02: Emotional Intelligence in Leadership 00:17:00 Module 03: Communication Skills 00:26:00 Module 04: Public Speaking 00:30:00 Module 05: Critical Thinking in Problem-Solving and Decision Making 00:23:00 Module 06: Motivation and Counselling 00:16:00 Module 07: Management and Leadership 00:26:00 Certificate Course in HR and Leadership Management - Old Version Leader & HR Management Leader and HR Management 00:30:00 Commitment and HR Management Commitment and HR Management 01:00:00 Team Management Team Management 00:30:00 Build A Mastermind Group Build A Mastermind Group 02:00:00 People Recognition in HR Management People Recognition in HR Management 00:30:00 Performance, Goals and Management Performance, Goals and Management 00:30:00 Think Outside The Box Think Outside The Box 00:30:00 Be Passionate about Your Work Be Passionate about Your Work 00:30:00 The Importance Of A Good Team Leader The Importance Of A Good Team Leader 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Certificate Course in HR and Leadership Management 00:20:00 Final Exam Final Exam- Certificate Course in HR and Leadership Management 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Are you currently a team leader? Are your team members needed to be trained? Or are you a team member that would like to conduct team training to be able to unleash their potentials? If so, then this course is what you are looking for. Description: Your employees are crucial assets that will decide the fate of your business. Finding the best employees for each position requires solid recruitment techniques. Best ability won't generally discover you. You should search out individuals to fill the positions that you have open. Selecting the most qualified hopefuls will guarantee that your employees stay with your running easily. Many organizations just sit tight for the ability to come to them. Essentially publicizing a vacant position and trusting that you locate the correct ability does not ensure that you will locate the best individuals for the occupations in your association. Effectively searching out qualified hopefuls is the ideal approach to guarantee that you discover the ability that you require. Recruitment is basic to the achievement of your business. In this course, you will be able to hire and recruits then have them trained to unleash their creativity. Who is the course for? For employees who are aiming for a promotion, joining a team leader role for the first time or looking forward to becoming a top executive. Or anyone who is interested in improving and honing their leadership potential. 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 hard copy 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 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: The Recruitment Training Course: Strategies & Skills will be useful and beneficial for the management positions, specifically the following careers: Administrative Services Manager Advertising, Promotions and Marketing Managers Agricultural Managers Architectural and Engineering Managers Compensation and Benefits Managers Computer and Information Systems Manager Construction Managers Financial Managers Food Services Managers Human Resources Managers Industrial Production Managers Management Directors Medical and Health Managers Natural Sciences Managers Top Executives. Recruitment Training Course - Updated Version Module 1 - Introduction to Recruitment: Importance and Implications 00:17:00 Module 2 - An Overview of the Recruitment Industry 00:26:00 Module 3 - The UK Recruitment Legislation 00:19:00 Module 4 - Sales and Selling in the Recruitment Industry 00:11:00 Module 5 - The Recruitment Process 00:47:00 Module 6 - Key Performance Indicators for the Recruitment Industry 00:25:00 Module 7 - Candidate Attraction for Recruitment 00:35:00 Module 8 - Candidate Management 00:22:00 Module 9 - Candidate Interview Processes 00:24:00 Module 10 - Client Acquisition 00:36:00 Module 11 - Client Strategy in the Recruitment Sector 00:25:00 Module 12: Client Management 00:27:00 Module 13 - Steps to Starting and Running a Successful Recruiting Service 00:23:00 Recruitment Training Course - Old Version Recruitment Module One - Getting Started 00:15:00 Module Two - Introduction to Recruitment 00:30:00 Module Three - The Selection Process 00:30:00 Module Four - Goal Setting 00:30:00 Module Five - The Interview 00:30:00 Module Six - Types of Interview Questions 00:30:00 Module Seven - Avoiding Bias in Your Selection 00:30:00 Module Eight - The Background Check 00:30:00 Module Nine - Making Your Offer 00:30:00 Module Ten - Orientation and Retention 00:30:00 Module Eleven - Measuring the Results 00:30:00 Module Twelve - Wrapping Up 00:15:00 Recruitment Training & Management Introduction to Recruitment 00:15:00 Recruitment 01:00:00 Shortlisting 00:15:00 Selection 01:00:00 Definitions of Training and Development 00:15:00 Considerations in the Design of Training Programmes 00:15:00 Implementing Training 00:15:00 Learning Methods 00:30:00 Mock Exam Mock Exam- Recruitment Training Course: Strategies & Skills 00:20:00 Final Exam Final Exam- Recruitment Training Course: Strategies & Skills 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview Microsoft Excel has brought a revolutionary change in the field of data management. It is one of the key skills that every employer looks for in a potential employee. The 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is designed to equip you with adequate expertise in Excel. This course is a golden opportunity to add a highly beneficial skill to your resume and impress your employers. In this 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course, you will receive a wide range of valuable tips to elevate your MS Excel skills. The course will show you the process of adding a link in the formula bar and adding multiple columns and rows within a blink. You will become skilled in quick calculations in the status bar. From the informative modules, you will identify the shortcut keys and learn to navigate between worksheets. The lessons will introduce you to the method of ZIP code format. You will understand how to move cell directions and convert numbers to text.  This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is packed with valuable information about MS Excel. So enroll in the course and become a proficient MS Excel user. Learning Outcomes Learn how to navigate between worksheets using shortcut keys Understand the process of creating a custom autofill list and importing data from webpages Build the skills to hide workbook elements Enrich your understanding of advanced transpose Grasp the techniques of moving cell directions and deleting data Know how to convert text to numbers Who is this course for? This 50 MS Excel Tips to Upgrade your Excel Skill to the Next Level course is for those who want to improve their Excel skills. 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  The 50 MS Excel Tips to Upgrade your Excel Skill to next Level course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Administrative Assistant Data Analyst Accountants Financial Analyst Retail Store Manager Project Manager Business Analyst Unit 01: Introduction Welcome 00:02:00 Unit 02: Excel Productivity Tips -Part 1 Camera Tool 00:05:00 Add Line Break in Formula Bar 00:03:00 Advanced Copy-Paste using Office Clipboard 00:03:00 Navigation between Worksheets using Shortcut Keys 00:01:00 Flash Fill 00:02:00 Add Multiple Rows and Columns Quickly 00:02:00 Delete Blank Rows 00:03:00 Multi Level Row and Column Sorting 00:04:00 Add Sparklines 00:03:00 Paste Special - Transpose 00:03:00 Unit 03: Excel Productivity Tips - Part 2 Snap to Grid 00:03:00 Create Custom Auto fill List 00:06:00 Absolute Cell Reference 00:03:00 Import Data from Web page 00:04:00 Move Cell Direction 00:03:00 Delete Data using Mouse 00:02:00 Status Bar Quick Calculations 00:03:00 Link Text Boxes to Cell 00:04:00 Phone Number and ZIP Code Format 00:04:00 Speaking Cell 00:05:00 Unit 04: Excel Productivity Tips - Part 3 Invisible Text 00:03:00 Worksheet Grouping 00:04:00 Advanced Transpose 00:04:00 XLStart Folder 00:03:00 Use Slicers 00:05:00 Convert Text to Numbers 00:03:00 Hiding Workbook Elements 00:02:00 Useful Shortcut Keys 00:03:00 Sort data from Left to Right 00:03:00 Advanced Filter (Complex) 00:11:00 Unit 05: Excel Productivity Tips - Part 4 Email as PDF 00:02:00 Synchronous Scrolling 00:03:00 Quick Analysis of data within Excel 00:02:00 Fill blank cells with Value 00:03:00 Hidden Chart Source Data 00:03:00 Two more Shortcuts 00:03:00 Add Blank Rows 00:03:00 Custom views in Excel 00:06:00 EMBED Feature 00:04:00 Adding Country code in Mobile Numbers 00:04:00 Unit 05: Excel Productivity Tips - Part 5 Plot an Average Line to a Chart 00:04:00 3D Referencing 00:04:00 Extract Unique Values 00:03:00 Excel Array Formula 00:04:00 Forecast Sheet 00:04:00 Add Spin Controls in Excel 00:05:00 Move Data using Mouse 00:01:00 Add new entry in Auto Correct to use across Office Applications 00:05:00 Find Differences between Two Lists 00:02:00 Find formulas Quickly 00:02:00 Unit: 06 Wrap Up Thank You 00:01:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Online Risk Assessment Course I2Comply Risk Assessment training will make you aware of the need for risk assessments in the workplace and the essential steps in carrying out an effective risk assessment. The course is designed to help employers and self-employed workers meet their legal duties under health and safety legislation. This training course is suitable for all workplace environments and ensures that your organisation complies with the Management of Health and Safety Regulations 1999. With over 565,000 UK workers sustaining an injury at work in 2021/22, employers must assess and control the health and safety risks in the workplace. This is a legal requirement, and is also an essential part of establishing and maintaining effective health and safety measures in the workplace. Why do we need risk assessments in the workplace? Risk assessments are crucial to prevent accidents and injuries in the workplace, and they help save lives. Employers have a legal requirement to assess and control health and safety risks in the workplace. Therefore by identifying the hazards, you can then eliminate or reduce the risk they pose to your workforce. Most injuries can be avoided if suitable health and safety controls are put in place to minimise the risks posed by workplace hazards. All of our courses conform to the Continuing Professional Development (CPD) guidelines. The CPD Certification Service has accredited this Risk Assessment training. Risk assessment course learning outcomes After completing the online Risk Assessment training course, you will be able to describe: The purpose of a risk assessment When risk assessments are necessary What is meant by the terms hazard and risk, and the relationship between them Reducing risk to as low as reasonably possible (ALARP) The 5 principal steps in a typical risk assessment How to conduct a successful risk assessment Following a hierarchy of control Recording your risk assessments The online Risk Assessment training course contains the following 10 topics: 1 - Introduction to risk assessment The first topic introduces you to risk assessment and identifies what a risk assessment involves. It explains what the term hazard means and provides examples of hazards in the workplace. You will also learn about the 5 step process of carrying out a risk assessment and where risk assessments are used. 2 - Describing risk The second topic explains what the term risk means and how risk is described. You will also learn about hazard effects and find out how severity and likelihood are used to focus on areas requiring action. Finally, this topic identifies what is meant by reducing risk to as low as is reasonably practicable (ALARP) and explains how this is done. 3 - The need for risk assessments In the third topic you will find out how common workplace injuries are in the UK and what HASWA and the Management Regulations say about managing risk in the workplace. Additionally, you will learn about other legislation that relates to specific high risk activities. This topic also outlines the responsibilities of employers, the self-employed and employees with regard to risk assessments. Lastly, it explains how occupier's liability legislation might influence the scope of your risk assessments. 4 - Preparing to carry out a risk assessment Topic 4 will make you aware of the preparation you need to do prior to carrying out your risk assessment. It will explain who should carry out the risk assessment and when it may be required. Also, you will find out why there is a need to understand why each specific risk assessment is being carried out. Finally, you will learn about why a risk assessment form is required. 5 - Step 1: Identify the hazards Topic 5 provides guidance on identifying workplace hazards. It indicates commonly occurring workplace hazards and reveals what sources of information you can use to help you identify hazards in the workplace. In this topic, you will also learn about important aspects to consider when conducting a walk-about. 6 - Step 2: Assess the risk Topic 6 identifies the things that must be considered when assessing the risk posed by a hazard. You will find out what you must determine with regards to risk and also who you need to consider in your risk assessment. Finally, you will learn the importance of identifying the level of risk and existing control measures for each hazard. 7 - Step 3: Control the risk Topic 7 provides guidance on the selection of appropriate hazard controls. In this topic you will find out about an acceptable level of risk and will work through the hierarchy of control to learn the most effective and least effective controls that are used to reduce risks in the workplace. This topic explains controls including hazard elimination, hazard substitution, engineering controls and administrative controls - including Safe Systems of Work, and PPE. Also, you will learn why PPE is a last resort and why it is important to involve and talk to workers. 8 - Step 4: Record your findings Topic 8 outlines the requirement to record your risk assessments. It identifies when you have a legal duty to record your risk assessments, what information you must record and how to present your information. Also, this topic provides examples of completed risk assessments in several different work environments. 9 - Step 5: Review the controls Topic 9 considers the need to review the controls. In this topic you will learn when you need to review controls and why it is important to monitor controls. 10 - Summary Topic 10 provides a brief summary of key points covered in the training. In this topic you will review the purpose of a workplace risk assessment and who should carry out a risk assessment. Finally, this topic summarises the 5 principal steps in a risk assessment.

Course Overview Grasp the opportunity to learn Microsoft Excel from the ABCs to an advanced level within one course. The Microsoft Excel Masterclass in 2021 course will start with the basics with MS excel and gradually turn you into an expert user. The Microsoft Excel Masterclass in 2021 course will first focus on the tools and functions of excel. You will comprehend the skills to create basic formulas in excel. In this step by the step learning process, you will have the adequate knowledge and ability to make all sorts of adjustments to your worksheets. The course will teach you many strategies for cell formatting. From the easy to follow modules, you will grasp the techniques to insert shapes and images into your sheets. You will also understand how to visualize your data in charts. In the end, you will study the benefits of using excel templates. The Microsoft Excel Masterclass in 2021 course will provide you with first-hand training on excel. Enroll in the course and take your excel skills to the next level. Learning Outcomes Get an introduction to Microsoft Excel and its functions Understand the process of data validation and data visualization Learn how to adjust excel worksheets Know about the conditional functions Familiarize yourself with the process of inserting images and shapes Who is this course for? Those who want to learn Microsoft Excel. 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 The Microsoft Excel Masterclass in 2021 course is a useful qualification to possess and would be beneficial for any related profession or industry such as: Business Professional Data Operator Administrative Officer Data Analyst 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:04: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:04: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 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 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:07: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 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 Excel's 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 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:14: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 Lopps 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 Masterclass in 2021 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00