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
Access to Level 1 Diploma: Criminology & Psychology Enrol in Access to Level 1 Diploma: Criminology & Psychology. Master Criminology & Psychology fundamentals, understand Violent Crimes intricacies, and apply Crime Scene investigation methods. Grasp Criminal Psychology principles and explore Criminal Profiling techniques. Familiarize yourself with the Criminal Justice System in England and Wales. Learning Outcomes: Summarise Criminology & Psychology basics. Clarify Violent Crimes in Criminology & Psychology. Apply Criminology & Psychology in Crime Scene analysis. Assess Criminal Psychology principles. Navigate Criminal Profiling and Criminal Justice System. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Access to Level 1 Diploma: Criminology & Psychology Course Syllabus Criminology & Psychology Foundations: Acquire foundational knowledge in Criminology & Psychology, exploring its significance and historical development. Violent Crimes in Criminology &Psychology: Examine violent crimes and their impact, utilizing Criminology & Psychology frameworks for understanding and prevention. Crime Scene Analysis: Master Criminology & Psychology methods for effective crime scene investigation, including evidence collection and forensic applications. Understanding Criminal Psychology: Delve into Criminal Psychology, examining contributing factors and analytical methods through Criminology & Psychology lenses. Criminal Profiling Techniques: Explore Criminal Profiling, using Criminology & Psychology methodologies to reason logically and develop profiles. Criminal Justice System: Understand the structure and operation of the Criminal Justice System through Criminology & Psychology perspectives, including law enforcement roles and court procedures.
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.
Master the art of private investigation with the Private Investigator Level 3 Diploma. This comprehensive course equips you with crucial skills such as interviewing, criminal psychology, surveillance, and business management, ensuring you have the expertise for a successful career in the field.
This course enables learners to logically and clearly work through the risk management process, from being aware of the relevant legislation, identifying hazards, assessing risk and onwards through risk reduction, balancing risk against individual choice, and the importance of recording keeping. It aims to increase learner awareness of both their responsibility and their organisation's responsibility, for meeting industry standards and keeping service users, staff, and workplaces safe.
Unlock the full potential of Microsoft Excel with our course for everyone. Learn essential skills and advanced techniques to excel in any data-driven role.
Success in Cambridge Maths is often a prerequisite for many competitive university courses, particularly in the fields of engineering, physics, computer science, and of course, mathematics. This self-paced course from Spark Generation provides a strong foundation for students planning to pursue mathematically-intensive careers or those who want to prepare for their high school journey in a smart way. :)