Sharpen your culinary leadership skills with our Kitchen Management course. Master safety, sanitation, menu creation, and strategic financial planning to excel as a kitchen manager. Dive into this all-encompassing guide to managing a high-functioning kitchen.
This one-day course will help you meet your regulatory requirements if your risk assessment indicates that first aid training covering emergency protocols only, is sufficient for your workplace.
Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful. Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one Course Requirements There are no pre-course requirements. Additional Resources Course Spreadsheet with the examples covered. About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel
The half-day First Aid for Mental Health Awareness course provides a concise yet impactful overview of essential mental health concepts. Participants gain a foundational understanding of common mental health conditions, learn to recognize signs and symptoms, and explore effective communication strategies.
This Emergency First Aid at Work (RQF) Level 3 Award qualification is designed for individuals who wish to act as an emergency first aider in their workplace. This Level 3 Award (EFAW) course is fully accredited and is statutory qualification specifically designed for individuals who wish to act as an emergency first aider in their workplace.
This First Aid at Work training meets the statutory needs of employers in England, Scotland, Wales and Northern Ireland needing at least one First Aider on the premises. By undertaking one of our first aid at work courses or CPR and AED sessions, you can be confident that you or your employee has undertaken a programme which meets the statutory needs of employers.
The main subject areas of the course are: Good practice in asbestos removal or remediation Asbestos Removal Control Plans Air sampling for asbestos Enclosures, clearance air monitoring and reporting
This Emergency First Aid at Work (RQF) Level 3 Award qualification meets the requirement of the Health and Safety (First Aid) Regulations 1981, where a person is required to become a qualified ‘First Aider’ (EFAW) in their workplace.
2 Day Supervising First Aid for Mental Health course is a specialized program catering to leaders and supervisors, equipping them with essential skills to foster a mentally healthy work environment.