Cademy logoCademy Marketplace
  • Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

New Excel Functions

New Excel Functions

By Ideas Into Action

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • Intermediate level

Description

New Excel Functions

 

Course Description

 

Ross Maynard

 

 

Description

In the second half of 2020 Microsoft released a significant upgrade to the most used spreadsheet programme 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.

 

 

 

 

Learning Outcomes

Participants in this course will learn:

  • What the new dynamic arrays feature in Microsoft Excel means

  • How the new RANDARRAY function works

  • How the new UNIQUE function works

  • How the new SEQUENCE function works

  • How the new SORT and SORTBY functions work

  • How the new FILTER function works

  • How the new XLOOKUP function can replace VLOOKUP

  • How to build IF statements with the new IFS function

  • How the new SWITCH function works

  • How the new TEXTJOIN function can replace CONCATENATE and CONCAT

  • How the new functions can be used in management reporting

 

 

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

Course Content

Additional Materials
  1. New Excel Functions Course Description
  2. New Excel Functions Course Workbook
  3. New Excel Functions in Office365
Course Lessons
  1. Lesson 1 Introduction and Agenda
  2. Lesson 2 RANDARRAY
  3. Lesson 3 UNIQUE
  4. Lesson 4 SEQUENCE
  5. Lesson 5 SORT and SORTBY
  6. Lesson 6 SORT A Practical Example
  7. Lesson 7 FILTER
  8. Lesson 8 FILTER A Practical Example
  9. Lesson 9 Other Useful New Functions
  10. Lesson 10 Using the New Functions in Reports

About The Provider

Ideas Into Action
Ross Maynard is a Fellow of the Chartered Instit...
Read more about Ideas Into Action

Tags

Reviews

+ Add Review