Excel 365's Dynamic Array Functions

Course Dates: 31/01/22
Time: 10:00 - 13:00
Location: Online
Tutors: 
Learn how to use Excel 365's Dynamic Array Functions - powerful techniques that work on an array (series) of data in an Excel Workbook.
Students should have a PC or laptop with Excel 365 App installed, please note that an early version of Excel will not be compatible for the course to complete the tasks, you can have a pen and paper to take notes. Please note, certain commands do not work in Office 365 online and thus the installed Microsoft Office is required. Should you wish to install the desktop version of Office 365 on your computer, you can request a temporary licence from us by emailing at computing@citylit.ac.uk at least 3 days before the start of the course.
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Download
Book your place
In stock
SKU
179289
Full fee £49.00 Senior fee £39.00 Concession £25.00

Course Code: CUAF01

Mon, day, 31 Jan - 31 Jan '22

Duration: 1 session

Or call to enrol:020 7831 7831

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

Excel 365’s dynamic array functions ease the process of writing array formulas, which have often been viewed as mysterious and intimidating. This half-day class introduces and explains the new functions, and encourages users to think productively about spreadsheet data in array terms.

This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

These dynamic array functions will be introduced and explained:
• SORT
• SORTBY
• UNIQUE
• SEQUENCE
• FILTER
• RANDARRAY
• The #SPILL! Indicator
In addition, we’ll take a look at how existing Excel functions can also utilise the new dynamic array approach.

What will I achieve?
By the end of this course you should be able to...

Build usable array formulas and understand how they can streamline data analysis.

What level is the course and do I need any particular skills?

The session assumes the user is comfortable with writing Excel formulas.

How will I be taught, and will there be any work outside the class?

Attendees will work on a series of array formula exercises addressing a range of tasks. No official out-of-class assignments are required.

Are there any other costs? Is there anything I need to bring?

No other costs. You should have a PC or laptop with Excel 365 App installed. Please note that an early version of Excel will not be compatible for the course to complete the tasks, you can have a pen and paper to take notes. Please note, certain commands do not work in Office 365 online and thus the installed Microsoft Office is required. Should you wish to install the desktop version of Office 365 on your computer, you can request a temporary licence from us by emailing at computing@citylit.ac.uk at least 3 days before the start of the course.

When I've finished, what course can I do next?

Excel advanced,Excel analysing data: stage 1, Excel for financial modelling, Data analysis with Power BI,Introduction to VBA.

Abbott Katz

Abbott Katz has instructed Excel at numerous corporate and university venues, on both sides of the Atlantic - and both sides of the Channel. A native New Yorker with a doctorate in sociology, Abbott has written two books on Excel (Apress), authored the www.spreadsheetjournalism.com blog, and designs spreadsheets in a consultative capacity. He offered a 5-session, Excel-driven Data Stories workshop last year at the Sciences Po University in Paris (in English!), and his work with the application has been cited by the Wall Street Journal, the Guardian, the Freakonomics blog, and the spreadsheet expert Chandoo.

Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.