1544 Running courses delivered Online

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

Learn core Apache Kafka features along with creating Java, Node.js and Python producers and consumers

Understanding the basics of Apache Maven through practical demonstration

A series of six creative writing for wellbeing workshops offering ex-boarders and their partners/spouses inroads towards achieving a better understanding of the boarding school experience.

Unlock the secrets to entrepreneurial success with our 'Start Up' course. Dive into the world of startups and discover how institutions, tasks, stakeholders, and more shape these ventures.

Description Learn how to train animals, walk them safely, look after them and start your own pet business! This Pet Business Certificate starts with the basics of first aid and find out how to administer pills, liquid medications, and injections to an uncooperative cat or dog. You will explore pet care, including nutrition, exercise, first aid, and identification of common diseases. You'll also explore sticky situations that can arise, such as lost pets, pets that die unexpectedly, and pets that need immediate veterinary care. You will learn about finances and explore start-up costs, accounting, fee-setting, business plans, and low-cost marketing. You'll learn how to obtain required insurance, hire employees as your business expands, and entice financial institutions to loan you money.  By the end of this course, you'll have all the knowledge you need to become a professional pet sitter. In addition, you'll see how your pet sitting business can grow to continually challenge and satisfy you. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is This Pet Business Certificate Course for? Pet Business Certificate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Pet Business Certificate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction 00:06:00 Legal Requirements Legal Requirements 00:37:00 Running Your Own Business Running Your Own Business 00:16:00 Marketing Marketing 00:16:00 Setting Your Prices Setting Your Prices 00:11:00 Business Costs Business Costs 00:08:00 Forms & Record Keeping Forms & Record Keeping 00:15:00 Pre-Service Visit Pre-Service Visit 00:07:00 Difficulties & Challenges Difficulties & Challenges 00:17:00 Assessment Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Looking to build a career in Hospitality? Our Concierge Work Environment and Etiquettes course is the perfect opportunity to learn about delivering exceptional customer service, necessary skills, and emergency measures for hotel concierges. With our course, you'll gain a strong understanding of the principles behind the concierge service business and learn how to create a successful career in this industry. Learning Outcomes: Gain a thorough understanding of Concierge Services and their types Develop the necessary skills to excel in the Hospitality industry as a Concierge Learn the principles of running a successful Concierge Service Business Understand the importance of delivering exceptional customer service Acquire knowledge of Emergency Measures for a Hotel Concierge Master the Concierge Work Environment and Etiquette In the Hospitality industry, Concierge services play a crucial role in creating an unforgettable guest experience. Our Concierge Work Environment and Etiquettes course is designed to equip you with the necessary knowledge and skills to excel in this industry. This theoretical course covers various modules, including understanding the service, types of Concierge services, necessary skills for any Concierge, principles for a Concierge Service Business, delivering customer service, Concierge work environment and etiquette, and emergency measures for a Hotel Concierge. By the end of this course, you will gain a thorough understanding of Concierge services, develop the necessary skills to excel in the Hospitality industry as a Concierge, learn the principles of running a successful Concierge Service Business, understand the importance of delivering exceptional customer service, acquire knowledge of emergency measures for a Hotel Concierge, and master the Concierge Work Environment and Etiquettes. Join us now and unlock endless possibilities in the Hospitality industry! Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is perfect for: Individuals aspiring to become Concierge Hospitality professionals who want to advance in their careers Business owners looking to start or improve their Concierge Service Business Graduates in Hospitality Management Anyone interested in the Hospitality industry Career path Our course will prepare you for a range of careers, including: Concierge - starting salary of £18,000 to £22,000 per annum Head Concierge - starting salary of £22,000 to £30,000 per annum Concierge Manager - starting salary of £30,000 to £35,000 per annum Front Office Manager - starting salary of £22,000 to £35,000 per annum Hotel Manager - starting salary of £35,000 to £50,000 per annum

🛫 Welcome to the gateway of endless possibilities! Introducing our comprehensive course: Airport Management 🎓, your passport to a thriving career in the dynamic world of aviation. Whether you're an aspiring professional or a seasoned veteran looking to soar higher, this course is your runway to success.   ️ Unlock Your Potential: In the fast-paced realm of airport management, staying ahead requires a blend of industry knowledge, strategic thinking, and operational expertise. Our course equips you with the essential skills and insights needed to navigate this complex landscape with confidence. From terminal operations to airside management, you'll gain a holistic understanding of the intricacies involved in running a successful airport.   🌟 Benefits Galore: By enrolling in our Airport Management course, you'll reap a multitude of benefits that will set you apart in the competitive aviation industry: Expert Guidance: Learn from seasoned professionals and industry experts who bring real-world experience to the classroom. Practical Insights: Gain hands-on experience through case studies, simulations, and practical exercises that mirror real-life airport scenarios. Networking Opportunities: Connect with fellow students, instructors, and industry insiders to expand your professional network and uncover exciting career opportunities. Career Advancement: Elevate your career prospects and unlock new opportunities for growth and advancement within the aviation sector. Global Perspective: Explore the nuances of airport management on a global scale, preparing you for roles in diverse environments and settings.   Who is this for? 👨‍️ Whether you're a recent graduate looking to kickstart your career in aviation, a seasoned professional seeking to broaden your skill set, or an entrepreneur with aspirations of venturing into airport management, this course is tailor-made for you. No matter your background or experience level, our program is designed to accommodate learners of all stripes and empower you to thrive in the dynamic world of airport management.   Career Path: Upon completing our Airport Management course, a world of exciting career opportunities awaits: Airport Operations Manager: Oversee day-to-day operations, ensure compliance with safety regulations, and optimize efficiency to keep the airport running smoothly. Airline Operations Coordinator: Coordinate with airlines, ground services, and regulatory agencies to ensure seamless flight operations and exceptional customer service. Airport Security Manager: Implement and enforce security protocols to safeguard passengers, personnel, and assets against potential threats and risks. Aviation Consultant: Provide strategic guidance and expertise to airports, airlines, and other aviation stakeholders to optimize performance, streamline processes, and drive growth. Airport Planning and Development Specialist: Play a pivotal role in the expansion, modernization, and development of airport infrastructure and facilities to meet the evolving needs of travelers and stakeholders.   In conclusion, our Airport Management course is your ticket to success in the dynamic and rewarding field of aviation. Are you ready to take off on your journey to greatness? Enroll today and let your career soar to new heights! 🚀️ Course Curriculum Module 1 Introduction to Airport Management Introduction to Airport Management 00:00 Module 2 Airport Operations Airport Operations 00:00 Module 3 Airport Planning and Development Airport Planning and Development 00:00 Module 4 Airport Finances and Economics Airport Finances and Economics 00:00 Module 5 Airport Operations and Safety Airport Operations and Safety 00:00

This training includes four (4) three-hour lessons, for a total of 12 contact training hours. Each lesson will include presentations, videos, interactive exercises, and a quiz. 1- Ladder and Lift Safety: In this lesson, we learn about different ladder options and how to choose the appropriate ladder(s) for a PV installation, based on the specific job site and task (accessing different roof surfaces, running conduit, etc.). We discuss how to properly inspect, set up and use ladders, and through interactive exercises we evaluate different installation sites to determine the best location to set up an extension ladder to access the PV array. In the second part of this lesson, we identify equipment and methods for safely lifting PV modules (and other materials) to the roof, including ladder lifts, boom lifts, reach forklifts, scaffolding, and cranes. 2- Fall Protection: Here, we review OSHA fall protection requirements and present different equipment options for working safely AND efficiently on a PV job site. We discuss the differences between fall restraint, positioning, and fall arrest systems; look at different anchor options for roof surfaces commonly seen on PV installations; and via interactive exercises determine where to place those anchors on the roof. 3- PV Mounting Safety: In this lesson, we identify job site hazards specific to PV mounting work, from array layout through securing modules to the racking system. We go step-by-step through a roof-mounted PV installation and call out ways to eliminate and/or control hazards through safe work practices, engineering controls, and personal protective equipment (PPE). Through interactive exercises and videos, we show best practice methods to safely handle PV equipment and manage small parts on a sloped roof. 4- Solar Electric Safety: In the final lesson of this series, we take an in-depth look at electrical hazards specific to PV installation and maintenance work, and discuss the requirements of OSHA, the NEC, and NFPA 70E to assure safe working conditions. We discuss shock and arc flash hazards and identify protective measures (including PPE and lockout / tagout). We dive even further into lockout / tagout and safe electrical testing methods in our interactive exercises and videos.

This course is intended to give you an overview of how the National Food Hygiene Rating Scheme works, what the scoring criteria are and how these are assessed by the inspectors, the appeals process, the Safer Food Better Business management system, E-Coli and concludes with some practical advice for ensuring your premises gets the best score possible.