28317 Courses delivered Online

Master Final Cut Pro X from scratch! Create captivating videos with industry-standard editing techniques in this comprehensive tutorial for beginners.

Unlock the potential of real estate investing with our comprehensive course. Master probate deals, financing, and marketing while boosting your mindset. Start your journey now!

Elevate your administrative prowess with our Administrative Assistant course. Learn to manage daily routines, communication, records, and office technology effectively. Become the organizational backbone in any professional setting with top-tier relationship and conflict management skills.

Step into the future of AI with our Prompt Engineering course! Master the art of prompt crafting for Dall-E, Stable Diffusion, ChatGPT, and more. Learn advanced techniques and best practices to optimize interactions with cutting-edge AI models.

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.

Navigate the complexities of Global Economics with our expertly designed course. Explore international trade, finance, globalization, and the intricacies of economic development. Prepare for the future with insights into geoeconomics, geopolitics, and global governance.

Empower families as a dedicated Family Support Worker. This course equips you with the skills to tackle family challenges, support addiction recovery, and safeguard children. Join us to make a meaningful difference in lives and build a rewarding career.

Discover the holistic world of Bach Flower Remedies with our comprehensive course. Learn to prepare, preserve, and integrate these natural remedies for emotional balance and well-being across various age groups and emotional states.

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.

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