42810 Learning courses delivered Online

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.

Master the critical domain of Know Your Client (KYC) practices with this in-depth course. Gain a comprehensive understanding of KYC regulations, client due diligence, anti-money laundering, and more. Elevate your compliance acumen and set a new standard in client onboarding and risk assessment.

Diet and Weight Loss Coaching will teach you the perfect diet plan and all weight loss hacks. Learn to become healthy and fit.

Embark on a comprehensive journey into Retail Management. From strategic planning and consumer behavior to multi-channel retailing and brand reputation, this course offers essential skills for thriving in the dynamic retail sector. Become an expert in managing and growing retail operations.

Enhance your professional communication with our Writing Effective Email at Work course. Learn email etiquette, error-free writing, and advanced techniques to craft impactful emails tailored to diverse audiences and contexts. Boost your workplace communication efficiency today.