5649 Productivity courses

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Course Overview: Materials Handling Safety Training   In today's industrial and warehouse environments, the efficient and safe handling of materials is paramount. The 'Materials Handling Safety Training' course is designed to equip participants with the knowledge and skills necessary to navigate various hazards and challenges associated with material handling operations. From loading docks to forklift operations, this comprehensive training program focuses on promoting a culture of safety and adherence to best practices.   Module 1: Introduction to Loading Dock Safety Equipment and Maintenance Understanding the importance of loading dock safety Identifying loading dock hazards Proper maintenance and inspection of loading dock equipment Safety protocols for loading and unloading procedures Module 2: Safe Forklift Operations and Hazardous Materials Handling Forklift operation fundamentals Pre-operation inspection and maintenance procedures Techniques for safe maneuvering and load handling Handling hazardous materials safely and responsibly Module 3: Fall Protection and Fire Safety Recognizing fall hazards in the workplace Implementing fall prevention measures and equipment Fire prevention and extinguishing techniques Emergency evacuation procedures Module 4: Material Handling and Traffic Management Efficient material handling techniques Traffic management in busy warehouse environments Pedestrian safety protocols Organizing and optimizing material flow for productivity and safety Module 5: Hazard Communication and Security Awareness Understanding chemical hazards and safety data sheets Proper labeling and storage of hazardous materials Recognizing and reporting security threats Protocols for handling suspicious packages or activities Module 6: Incident Reporting and Safety Culture Importance of incident reporting and investigation Procedures for documenting and reporting accidents or near misses Promoting a culture of safety and accountability in the workplace Continuous improvement and feedback mechanisms for enhancing safety practices   Course Format: Each module consists of interactive presentations, case studies, and practical exercises. Participants will have access to online resources and materials for further learning. Assessments and quizzes will be conducted to ensure understanding and retention of key concepts. Experienced instructors will be available for guidance and clarification throughout the course.   Who Should Attend: Warehouse workers Material handlers Forklift operators Safety officers Supervisors and managers overseeing material handling operations   By completing this course, participants will not only enhance their own safety awareness but also contribute to creating a safer and more efficient work environment for themselves and their colleagues. Course Curriculum Module 1 Introduction to Loading Dock Safety Equipment and Maintenance Introduction to Loading Dock Safety Equipment and Maintenance 00:00 Module 2 Safe Forklift Operations and Hazardous Materials Handling Safe Forklift Operations and Hazardous Materials Handling 00:00 Module 3 Fall Protection and Fire Safety Fall Protection and Fire Safety 00:00 Module 4 Material Handling and Traffic Management Material Handling and Traffic Management 00:00 Module 5 Hazard Communication and Security Awareness Hazard Communication and Security Awareness 00:00 Module 6 Incident Reporting and Safety Culture Incident Reporting and Safety Culture 00:00

Get ready for an exceptional online learning experience with the Logistics Management bundle! This carefully curated collection of 30 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. Logistics Management is a dynamic package that blends the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Logistics Management package has something for everyone. As part of the Logistics Management package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Logistics Management bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following 30 CPD Accredited Courses: Course 01: Logistic Management Course 02: Import/Export Course 03: Supply Chain Management Course 04: Certificate in Purchasing and Procurement Course 05: Purchase Ledger Course 06: Operations Management: Process Mapping & Supply Chain Course 07: Supply Chain Management for Different Retail Formats Course 08: Transport Planner Course Course 09: Delivery Manager Course 10: Port Management Diploma Course 11: Commercial law Course 12: Warehouse Operative Course 13: Inventory Controller Course 14: Diploma in Lean Process and Six Sigma Course 15: Organisation & People Management Course 16: Retail Management Course 17: Retail Psychology Course 18: Merchandising Course 19: Visual Merchandising Diploma Course 20: Product Management Course 21: Quality Management Course 22: Level 3 E-commerce Management Course 23: Sales Negotiation Training Course Course 24: Creating Highly Profitable Sales Funnels Course 25: Customer Relationship Management Course 26: SAP Controlling (CO) - Product Costing S4HANA Course 27: Xero Accounting and Bookkeeping Training Course 28: Compliance and Risk Management Diploma Course 29: Workplace Productivity Training Course 30: Workplace Stress Management What will make you stand out? Upon completion of this online Logistics Management bundle, you will gain the following: CPD QS Accredited Proficiency with this Logistics Management bundle Lifetime access to the whole collection of learning materials of this Logistics Management bundle The online test with immediate results You can study and complete the Logistics Management bundle at your own pace. Study for the Logistics Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Logistics Management bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Logistics Management, a rich anthology of 30 diverse courses. Each course in the Logistics Management bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Logistics Management bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Logistics Management bundle offers you the flexibility and convenience to learn at your own pace. Make the Logistics Management package your trusted companion in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Logistics Management bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Career path Unleash your potential with the Logistics Management bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path, or personal growth. Embrace the journey with the Logistics Management bundle package. Certificates CPD Quality Standard Certificate Digital certificate - Included 30 CPD Quality Standard Certificates - Free

Get ready for an exceptional online learning experience with the Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Developmentbundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Conflict Management, Psychology & Self Esteem package is dynamic, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Conflict Management, Psychology & Self Esteempackage has something for everyone. As part of the SEO & Digital Marketing, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development CPD-accredited courses: Course 01: Anger Management and Conflict Resolution Program Course 02: Self Confidence & Self Esteem Course 03: Self-Help Psychology: Mental Freedom Course 04: Positive Psychology Masterclass Course 05: Using Mindfulness at Work for Productivity Course 06: Organizational Behaviour, HR and Leadership Course 07: Coaching & Mentoring Course 08: Master Emotional Intelligence for Crucial Moments Course 09: Rational Emotive Behaviour Therapy (REBT) Certificate Course 10: Influencing and Negotiating Course 11: Personal and Networking Skills Course 12: Career Development and Passion Course 13: Goal Setting, Motivation, and Resilience for Life Course 14: Effective Communication Skills Course 15: Decision-Making and Critical Thinking Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass What will make you stand out? Upon completion of this online Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development bundle, you will gain the following: CPD QS Accredited Proficiency with this Conflict Management, Psychology & Self Esteembundle After successfully completing the Conflict Management, Psychology & Self Esteembundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials in this Conflict Management, Psychology & Self Esteembundle The online test with immediate results You can study and complete the Conflict Management, Psychology & Self Esteembundle at your own pace. Study for the Conflict Management, Psychology & Self Esteembundle using any internet-connected device, such as a computer, tablet, or mobile device. Each course in this Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Conflict Management, Psychology & Self Esteembundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development, a rich anthology of 30 diverse courses. Our experts handpick each course in the Conflict Management, Psychology & Self Esteembundle to ensure a wide spectrum of learning opportunities. This Conflict Management, Psychology & Self Esteembundle will take you on a unique and enriching educational journey. The Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Developmentbundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Developmentset, the Conflict Management, Psychology & Self Esteembundle offers you the flexibility and convenience to learn at your own pace. Make the Conflict Management, Psychology & Self Esteempackage your trusted companion in your lifelong learning journey. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development bundle is perfect for: Individuals interested in improving their interpersonal skills: Suitable for those who want to enhance their ability to handle conflicts and communicate effectively in both personal and professional settings. Professionals seeking career advancement: Ideal for employees in managerial or HR roles looking to deepen their understanding of psychology and mentoring to better support and lead their teams. Anyone looking to boost their self-esteem and mental well-being: Beneficial for individuals who aim to cultivate a positive self-image and adopt mindfulness techniques for a healthier mental state. Career changers exploring new opportunities: Suitable for those considering a shift to roles that require strong mentoring skills and a solid understanding of career development strategies. Educators and counsellors: Perfect for those in educational or counselling roles seeking to incorporate advanced psychological principles and mindfulness practices into their work. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Upon Conflict Management, Psychology, Self Esteem, Mindfulness, Mentoring & Career Development course completion, you can expect to: Conflict Resolution Specialist HR Professional Corporate Trainer Career Coach Wellness Coach Organisational Psychologist Mentor in Professional Settings Educational Counsellor Community Mediator Life Coach Certificates CPD Certificates Digital certificate - Included

Sale Ends Today HR (HR Management, Payroll & Performance Management) Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In the ever-evolving business landscape of the United Kingdom, effective human resource management has become a cornerstone of organizational success. According to a recent survey by the Chartered Institute of Personnel and Development (CIPD), over 60% of UK businesses struggle to recruit and retain top talent, highlighting the critical need for skilled HR professionals. Do you possess the tools to attract, develop, and retain top talent while fostering a culture of excellence? Our HR Management, Payroll & Performance Management Bundle provides a powerful combination of fundamental HR practices, payroll processing expertise, and performance management techniques. You'll master essential skills like conducting virtual interviews, recruiting top talent, maintaining workplace confidentiality, resolving conflict, and staying compliant with employment law. Key Features of the HR (HR Management, Recruitment & Performance Management ) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our HR (HR Management, Recruitment & Performance Management ) bundle, providing you with industry-recognised qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: HR Management at QLS Level 2 QLS Course 02: Payroll Management at QLS Level 4 QLS Course 03: Performance Management Level 3 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Virtual Interviewing for HR Course 02: Recruitment Training Course Course 03: Workplace Confidentiality Course 04: Dealing with Conflict at Work Course 05: Employment Law In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our HR (HR Management, Recruitment & Performance Management ) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of HR Management, Payroll & Performance Management Develop a comprehensive understanding of human resource management principles. Master payroll management techniques and ensure compliance with regulations. Learn effective performance management strategies to optimize workforce productivity. Acquire skills in virtual interviewing and recruitment best practices. Understand employment laws and maintain workplace confidentiality standards. Develop conflict resolution abilities for a harmonious work environment. Why Choose Us? Get 3Free QLS Endorsed Certificate upon completion of HR Management Get a free student ID card with HR Management Training program (£10 postal charge will be applicable for international delivery) The HR Management is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the HR Management course materials The HR Management comes with 24/7 tutor support Start your learning journey straight away! Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of HR. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the HR setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to HR-related fields, impacting their HR experiences and long-term development. Course Curriculum Course 01: HR Management at QLS Level 2 Module 01: Introduction to Human Resource Management Module 02: Strategic Human Resource Management Module 03: People Resourcing Module 04: Performance Management Module 05: Conflict Management Module 06: Health and Safety Management Course 02: Payroll Management at QLS Level 4 Module 01: Payroll System in the UK Module 02: Payroll Basics Module 03: Company Settings Module 04: Legislation Settings Module 05: Pension Scheme Basics Module 06: Pay Elements Module 07: The Processing Date Module 08: Adding Existing Employees Module 09: Adding New Employees Module 10: Payroll Processing Basics Module 11: Entering Payments Module 12: Pre-Update Reports Module 13: Updating Records Module 14: e-Submissions Basics Module 15: Process Payroll (November) Module 16: Employee Records and Reports Module 17: Editing Employee Records Module 18: Process Payroll (December) Module 19: Resetting Payments Module 20: Quick SSP Module 21: An Employee Leaves Module 22: Final Payroll Run Module 23: Reports and Historical Data Module 24: Year-End Procedures Course 03: Performance Management Level 3 Module 01: The Basics (I) Module 02: The Basics (II) Module 03: Goal Setting Module 04: Establishing Performance Goals Module 05: 360 Degree Feedback Module 06: Competency Assessments Module 07: Kolb's Learning Cycle Module 08: Motivation Module 09: The Performance Journal Module 10: Creating a Performance Plan =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*13 = £169) CPD Hard Copy Certificate: Free (For The First 3 Courses: Previously it was £90) QLS Endorsed Hard Copy Certificate: Free (For The First 3 Courses: Previously it was £267) CPD 460 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: HR professionals Recruitment Specialists Team leaders Career developers Aspiring HR managers Payroll administrators Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. HR Manager: £35,000 - £70,000 Payroll Specialist: £25,000 - £50,000 Recruitment Consultant: £22,000 - £40,000 HR Consultant: £30,000 - £60,000 Employee Relations Manager: £30,000 - £55,000 Learning and Development Coordinator: £25,000 - £45,000 Certificates Award in Modern HR Management Intro at QLS Level 2 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee. Diploma in Payroll Management at QLS Level 4 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Embark on a journey to master Microsoft Excel with our 'Excel Essentials for Office Administrators' course. Designed to transform beginners into proficient users, this comprehensive course is divided into two main sections: Excel Beginner and Excel Intermediate. In the initial phase, learners are introduced to the Excel interface, where they explore and identify its various elements. This is followed by practical activities such as creating basic worksheets, using the help system, and crafting formulas. As the course progresses, participants will delve into more advanced features like manipulating data, applying styles and formats, and managing worksheets. The intermediate section elevates your skills further, covering a wide range of topics from applying range names and specialized functions to creating sophisticated charts and PivotTables. Learning Outcomes Gain proficiency in navigating and utilizing the Excel interface. Develop the ability to create and manage complex worksheets effectively. Master a variety of Excel functions and formulas for diverse data processing needs. Learn advanced data management techniques including sorting, filtering, and using PivotTables. Acquire skills in visual data presentation and customization of Excel workbooks. Why choose this Excel Essentials for Office Administrators course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Excel Essentials for Office Administrators course for? Office administrators and secretaries seeking to enhance their Excel skills. Professionals in various sectors requiring proficiency in Excel for data management. Students and individuals interested in learning Excel from a beginner to an intermediate level. Business owners needing to manage business data more efficiently. Anyone aiming to improve their productivity and data analysis skills through Excel. Career path Data Analyst: £25,000 - £50,000 Administrative Assistant: £18,000 - £30,000 Office Manager: £22,000 - £40,000 Business Analyst: £30,000 - £60,000 Financial Analyst: £28,000 - £55,000 Project Coordinator: £24,000 - £45,000 Prerequisites This Excel Essentials for Office Administrators does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Excel Beginner Identify the Elements of the Excel Interface 00:30:00 Activity - Identify the Elements of the Excel Interface 00:05:00 Create a Basic Worksheet 01:00:00 Activity - Create a Basic Worksheet 00:05:00 Use the Help System 00:30:00 Activity - Use the Help System 00:05:00 Create Formulas in a Worksheet 01:00:00 Activity - Create Formulas in a Worksheet 00:05:00 Insert Functions in a Worksheet 00:30:00 Activity - Insert Functions in a Worksheet 00:05:00 Reuse Formulas 00:30:00 Activity - Reuse Formulas 00:05:00 Manipulate Data 00:30:00 Activity - Manipulate Data 00:05:00 Insert, Manipulate, and Delete Cells, Columns, and Rows 00:30:00 Activity - Insert, Manipulate, and Delete Cells, Columns, and Rows 00:05:00 Search For and Replace Data 00:30:00 Activity - Search For and Replace Data 00:05:00 Spell Check a Worksheet 00:30:00 Activity - Spell Check a Worksheet 00:05:00 Modify Fonts 00:30:00 Activity - Modify Fonts 00:05:00 Add Borders and Colors to Cells 01:00:00 Activity - Add Borders and Colors to Cells 00:05:00 Apply Number Formats 00:30:00 Activity - Apply Number Formats 00:05:00 Align Cell Contents 00:30:00 Activity - Align Cell Contents 00:05:00 Apply Cell Styles 00:30:00 Activity - Apply Cell Styles 00:05:00 Define the Basic Page Layout for a Workbook 01:00:00 Activity - Define the Basic Page Layout for a Workbook 00:05:00 Refine the Page Layout and Apply Print Options 00:30:00 Activity - Refine the Page Layout and Apply Print Options 00:05:00 Format Worksheet Tabs 00:30:00 Activity - Format Worksheet Tabs 00:05:00 Manage Worksheets 00:30:00 Activity - Manage Worksheets 00:05:00 Manage the View of Worksheets and Workbooks 00:30:00 Activity - Manage the View of Worksheets and Workbooks 00:05:00 Customize General and Language Options 00:30:00 Activity - Customize General and Language Options 00:05:00 Customize Formula Options 00:30:00 Activity - Customize Formula Options 00:05:00 Customize Proofing and Save Options 01:00:00 Activity - Customize Proofing and Save Options 00:05:00 Customize the Ribbon and Quick Access Toolbar 00:30:00 Activity - Customize the Ribbon and Quick Access Toolbar 00:05:00 Customize the Functionality of Excel by Enabling Add-Ins 00:30:00 Activity - Customize the Functionality of Excel by Enabling Add-Ins 00:05:00 Customize Advanced and Trust Center Options 00:30:00 Activity - Customize Advanced and Trust Center Options 00:05:00 Activities and Exercise Files - Microsoft Excel 2016 for Beginners 00:00:00 Excel Intermediate Apply Range Names 00:30:00 Use Specialized Functions 00:30:00 Use Text Functions 00:30:00 Use Logical Functions 00:30:00 Use Lookup Functions 00:30:00 Use Date Functions 00:30:00 Use Financial Functions 00:30:00 Create and Modify Tables 00:30:00 Sort and Filter Data 00:30:00 Use Subtotal and Database Functions to Calculate Data 00:30:00 Create Charts 00:30:00 Modify and Format Charts 00:30:00 Create a Trendline 00:30:00 Create Advanced Charts 00:30:00 Create a PivotTable 00:30:00 Filter Data by Using Slicers 00:30:00 Analyze Data with PivotCharts 00:30:00 Insert and Modify Graphic Objects 00:30:00 Layer and Group Graphic Objects 00:30:00 Incorporate SmartArt 00:30:00 Customize Workbooks 00:30:00 Manage Themes 00:30:00 Create and Use Templates 00:30:00 Protect Files 00:30:00 Preparing a Workbook for Multiple Audiences 00:30:00 Activities and Exercise Files - Microsoft Excel 2016 Intermediate 00:00:00

This course will start by covering some of the key terms you will need to understand before moving on to identifying critical control points and analysing some of the key hazards. It’ll show you how to determine control points and how to avoid cross-contamination in the food chain. It will also cover some of the control measures that can be taken along with how to address a problem if a critical limit is breached.

This course explores the risk to workers caused by the Covid-19 virus and covers actions that can be taken by employers and employees to protect themselves and each other as they return to work. The content of this course is based on the latest information from the UK government and the NHS. It covers information about the virus, risk assessments and personal safety, along with how to make changes to the daily work environment to address these risks.

The main outcome of this training course is to provide you with the knowledge to carry out the functions of a fire marshal. Please note, this course also contains all of the content in the Basic Fire Awareness and Fire Extinguisher.

R Programming for Statistics and Data Science is the course that will take you from a complete beginner in programming with R to a professional who can complete data manipulation on demand. It gives you the complete skillset to tackle a new data science project with confidence and be able to critically assess your and others' work.