Elevate your writing with our English Punctuation course, designed to refine your understanding and application of punctuation marks. Enhance clarity, tone, and effectiveness in various writing styles. Perfect for professionals and students alike. Enroll and transform your writing now!
Elevate your real estate wholesaling game with this comprehensive masterclass. From property acquisition and analysis to negotiating with sellers and reducing risk, this course is a step-by-step guide to mastering every facet of the wholesaling business.
Embark on a comprehensive journey through the intricacies of Project Management. From PMBOK guidelines to effective planning, quality control, and risk management, this course offers the tools and insights needed to excel in managing complex projects in any industry.
Embark on a journey to excellence in care with our Care Certificate Training course. Master vital care standards, from understanding your role and personal development to safeguarding and infection control. Essential for healthcare professionals committed to quality care.
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 hybrid team management with our comprehensive course. Learn effective techniques for transitioning, team building, and driving high performance in a hybrid work environment. Elevate your leadership skills and optimize your team’s effectiveness in today’s dynamic work landscape.