33783 BA courses delivered On Demand

From beginner to expert, this course will help you advance your career using Microsoft Excel skills.

Advance your Java skills with our Level 2 course. From mastering collections and file handling to understanding multi-threading and lambda expressions, this course culminates in building a User Authentication system, solidifying your Java expertise for real-world applications.

This Career Planning and Life Goals Setting course will provide tips on setting life goals and career plans to help you succeed.

You will thoroughly understand every relevant concept about human resources management within this course.

Embark on an immersive Web Development journey with our comprehensive Level 5 course, focusing on HTML, CSS, and JavaScript. From setting up your environment to mastering advanced techniques and launching a live website, this course equips you with the skills to become a proficient web developer.

Dive into the complex world of Commercial Law with our comprehensive course. From understanding agency relationships to navigating international trade laws, equip yourself with the legal know-how to navigate commercial transactions effectively and securely.

Unlock the secret to confident parallel parking with our 30-minute formula! Empower yourself to teach your teenager to parallel park without traditional driving lessons. Pass on the same method used by Professional Driving Instructors and boost your teen's chances of acing their driving test.

How to overcome lust and live a life of purity.

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

Health & Safety at Work: Ladder Safety Level 1 (HSE Compliant) Start your Health & Safety journey with Ladder Safety Level 1. Master Types of Ladders in Health & Safety. Learn Pre-use Safety Inspections for Ladder Safety. Excel in Health & Safety Ladder Set-Up. Achieve safe Ladder Placement in Health & Safety. Complete your Health & Safety Training in Ladder Safety. Learning Outcomes: Master Health & Safety in ladder use. Identify ladders in Health & Safety contexts. Conduct Health & Safety ladder inspections. Apply Health & Safety in ladder setup. Place ladders safely in Health & Safety. Train others in Health & Safety for ladders. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Health & Safety at Work: Ladder Safety Level 1 (HSE Compliant) Course Syllabus Master Health & Safety Importance: Understand the vital role of Health & Safety in ladder usage to prevent accidents and injuries. Identify Ladders for Health & Safety: Familiarise yourself with various types of ladders and their appropriate applications within a Health & Safety framework. Conduct Health & Safety Inspections: Learn to execute rigorous pre-use safety inspections in alignment with Health & Safety standards. Ensure Ladder Setup in Health & Safety: Acquire the knowledge and techniques for ladder setup, fully compliant with Health & Safety guidelines. Optimise Ladder Placement for Health & Safety: Understand the principles for securely placing ladders in varied work environments to uphold Health & Safety. Complete Ladder Safety Training: Obtain comprehensive ladder safety training, focusing on Health & Safety protocols for climbing, descending, and balance.