Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes.
In the second half of 2020, Microsoft released a significant upgrade to the most used spreadsheet program in the world. Microsoft Excel now offers the ability to handle dynamic arrays – functions that return a range of results that update as the source data changes. In this course, we discuss the power of dynamic arrays and introduce the new functions.
The functions I am going to cover are: • RANDARRAY- creating a table of random numbers or random dates • UNIQUE – identifying the distinct items in a list • SEQUENCE – listing numbers with a set interval • SORT and SORTBY – new ways of dynamically sorting data • FILTER – building the ability to filter data into formulae • XLOOKUP – replacing VLOOKUP with greater flexibility • IFS and SWITCH making it easier to construct IF statements • The new CONCAT, and TEXTJOIN text functions
If you have an earlier version of Microsoft Excel then these functions will not be available to you and this course might not be for you. But if you do have a subscription to Office365 – either personally or through your work – I think you will find this course extremely useful.
2 activities • 10 videos • duration: 1h 14m
Business author and consultant, specialising in performance measurement and improvement
I am a Fellow of the Chartered Institute of Management Accountants in the UK and work as an author of business courses and a process improvement consultant. I have over 30 years' experience and live near Stirling in Scotland, with my wife, daughter and Cocker Spaniel. I aim to make my courses accessible and understandable. My courses focus on business topics including KPIs, performance measurement, approaches to business improvement, Agile and Lean. I hope you enjoy my courses.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.
I am anxious to review the materials and see how I can use these functions.
Good overview of new Excel functions. The handout Excel file was essential - as the display screen for the course is too small on a laptop to see clearly what is being shown and what is being typed.
Certainly very useful and practical information provided in aiding with analyzing data. Presentation was at a good pace to be able to follow. Examples provided was very useful to be able to follow the formulas and see the desired results.
GREAT VERY USEFUL COURSE
