hello
Loading Events
  • This event has passed.

Free Excel 365 Webinar (Dynamic Arrays)

November 12, 2020

Note: This one-hour webinar was recorded live on November 12, 2020 and can be accessed by clicking the link at the bottom of this page. This session gives a high-level overview of key features – to learn more, register for our half-day webinar (including small class-sizes & hands-on assignments). Registration link for the half-day session is also at the bottom of this page.

For many decades, “the core” of Microsoft’s Excel has remained the same. We type a formula in one cell, hit enter, and then receive results in the same cell. With recent changes to Excel under Microsoft 365, significant aspects of this behaviour have changed with the introduction of Dynamic Arrays and associated functions. It is now possible to write a formula in a single cell that will populate multiple cells (a few… or a few thousand), and we can refer to those cells in new and helpful ways.

This webinar will provide an overview of the following topics:

  • What are Dynamic Arrays, and how will this change affect how you use spreadsheets in your day-to-day workflow?
  • How can we leverage the power of Dynamic Arrays (and new associated functions) to make previously challenging data analysis tasks faster and less error prone?
  • How can I “CTRL+Z” this behaviour so that Excel behaves in the way I am used to it behaving?
  • How might Dynamic Arrays change the landscape of financial modeling & analysis?

The activities undertaken during this webinar will make heavy use of Microsoft 365 features. If you have an older version of Excel, you will not be able to follow along, but you will get a feel for the new features.

 

Available Tickets

Nov 12, 2020 - Admission - Office 365 - USD $0

Join the waitlist to be emailed when this product becomes available

Already registered?

Special Offers

15% off Bundled Discount

If you are planning on purchasing three or more Marquee sessions, a 15% discount will be applied at checkout.

40% off Student Discount (Current, Full-Time Students only)

Email a photo of your student ID to tickets@marqueegroup.ca and include the course you want to attend.

Refund & Cancellation Policy

Read here.

Details

Date:
November 12, 2020
Cost:
Free
Event Tags:

Organizer

The Marquee Group
Phone
416-583-1802
Email
tickets@marqueegroup.ca