40129 Learning courses in Liverpool delivered On Demand

Family law course is designed for individuals who are interested in doing research on the legal implications of marriage, cohabitation, divorce, and other family issues.

Ensure the health and safety of canines with our Dog First Aid Diploma course. From emergency response to preventive care, gain vital skills in canine first aid, CPR, and healthcare. Perfect for pet owners and animal professionals, this course is your guide to safeguarding man’s best friend.

Begin your sales journey with the ‘Basics of Sales’ course. From sales skills development to market understanding, presentation techniques, and future trends, this course provides a foundational blueprint for success in the sales arena.

Master Infection Prevention and Control in Food with our specialized course. Learn about contamination types, food storage, preparation, and comply with safety legislation. Perfect for food industry professionals seeking to elevate their expertise in food safety and hygiene.

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

Master the art of artisan sourdough baking! From creating your own starter to crafting a variety of sourdough breads and pastries, this course offers a comprehensive journey into the world of authentic sourdough baking. Perfect for both beginners and seasoned bakers.

Unlock profound insights into mental health with our comprehensive Diploma in Mental Health, Neurophysiology, and Dual Diagnosis. Explore the complexities of addiction, the impact of drugs, and the latest in neurophysiological research for effective treatment and support strategies.

Gain expertise in fire safety consultancy with our “Trajectory to Fire Safety Consultant” course. Learn essential skills such as fire risk assessment, emergency planning, and health and safety compliance. Start your journey today towards ensuring workplace safety and advancing your career in fire safety management.

Instagram Marketing course will show you how to use Instagram to market your products and build your business community so that you can grow your business.

Dive into the intricacies of American Contract Law with this comprehensive course. Master contract formation, enforceability, and interpretation, along with performance, defenses, remedies, and third-party rights. Equip yourself to draft effective contracts with our expert guide.