skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • 2019 MSBizAppsSummit Gallery
    • Microsoft Excel: Getting Started with Dynamic Arra...

    Microsoft Excel: Getting Started with Dynamic Arrays in Excel

    06-11-2019 03:00 AM

    Administrator Syndicate_Admin
    Administrator
    248 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Syndicate_Admin
    Administrator Syndicate_Admin
    Administrator
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Microsoft Excel: Getting Started with Dynamic Arrays in Excel

    ‎06-11-2019 03:00 AM

    Learn the basics of our brand-new Dynamic Arrays and how you can use them in your spreadsheets. For the last 30 years regular Excel formulas could only return a single value. With the advent of Dynamic Arrays, we have rebuilt the calc engine, allowing formulas to return multiple values and for those values to "spill" to neighboring cells. Join us to understand how you can leverage this powerful new feature! Please note this is an introductory 20-minute session on this new feature. We are also offering a 60-minute deep-dive session.

    Other resources: https://medius.studios.ms/video/asset/PPT/MBAS19-THR2010

    /watch?v=BsUTlhib4Tw

    /html/assets/mbas_other.svg

    THR2010

    Labels:
    • Labels:
    • L_Intermediate (200)
    • P_Excel
    • P_Office 365
    • PC_Other
    • PN_Joseph McDaid
    • ST_20-minute Theater
    Message 1 of 1
    248 Views
    0
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices