45585 Courses in Cardiff delivered On Demand

Master the art of TEFL with our Essential Guide. From self-evaluation to lesson planning, equip yourself with the skills and strategies to excel in English language instruction.

Learn Sage Payroll Management for UK VAT, Tax & Company Filling.

Gain the tools and knowledge needed to manage and improve your menstrual health or support others in their journey.

Unlock the power of AI with our ChatGPT Tutorial for Beginners. Learn to craft prompts, create content, and enhance your skills with AI text generation.

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 ESL teaching with our comprehensive guide. Explore teaching methods, phonics, and classroom management, plus insights on teaching and traveling in Asia.

How to overcome lust and live a life of purity.

Master Operational Risk Management with our step-by-step guide. Learn risk identification, measurement, mitigation, and effective communication strategies. Ideal for professionals seeking to enhance their ORM expertise and apply practical solutions in various industries.

Unlock the secrets to stronger, healthier hair in this transformative Hair Fall Prevention Masterclass. Navigate through the maze of hair care products, explore natural solutions, and formulate personalized routines to combat hair loss effectively. Your journey to luscious locks begins here.

Embark on a rewarding journey in adult care with our comprehensive Adult Care Diploma. Understand mental and physical health complexities, enhance quality of life for the elderly, and prepare for the future of care with advanced planning. Ideal for aspiring caregivers seeking depth, empathy, and expertise in their career.