In this course you will learn how to work with and create more advanced functions and features that will enable you to search, match and pre-populate your data. Using these functions will allow analysis, manipulation and comparison of your data for a variety of purposes.
Learning Outcomes: At the completion of this course you should be able to:
Understand formula theory
Use functions from the statistics options such as Count If, Count A, Median, Mode, Standard Deviation, etc.
Work with date and time functions
Operate a range of logical functions e.g. , If, And, OR, NOT, IfError